Subversion Repositories DevTools

Rev

Rev 125 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 125 Rev 151
Line 38... Line 38...
38 
   ' Insert the correct date interval condition
 38 
   ' Insert the correct date interval condition
39 
   Select Case parInterval
 39 
   Select Case parInterval
40 
      Case 1
 40 
      Case 1
41 
         date_Interval_expression = " AND changed_package_versions.MODIFIED_STAMP > (ORA_SYSDATE - interval '7' day)"
 41 
         date_Interval_expression = " AND changed_package_versions.MODIFIED_STAMP > (ORA_SYSDATE - interval '7' day)"
42 
      Case 2
 42 
      Case 2
43 
         date_Interval_expression = " AND changed_package_versions.MODIFIED_STAMP > (ORA_SYSDATE - interval '1' month)"
 43 
         date_Interval_expression = " AND changed_package_versions.MODIFIED_STAMP > (ORA_SYSDATE - interval '30' day)"
44 
      Case 3
 44 
      Case 3
45 
         date_Interval_expression = " AND changed_package_versions.MODIFIED_STAMP > (ORA_SYSDATE - interval '3' month)"
 45 
         date_Interval_expression = " AND changed_package_versions.MODIFIED_STAMP > (ORA_SYSDATE - interval '90' day)"
46 
      Case Else
 46 
      Case Else
47 
         Call RaiseMsg(enum_MSG_ERROR, "Internal Error, date interval not specified.")
 47 
         Call RaiseMsg(enum_MSG_ERROR, "Internal Error, date interval not specified.")
48 
   End Select
 48 
   End Select
49 
 
 49 
 
50 
   ' For each package ID in a release
 50 
   ' For each package ID in a release