eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.RG_REPORTS_PKG dependencies on DUAL

Line 34: FROM dual;

30: new_sequence_number NUMBER;
31: BEGIN
32: SELECT rg_reports_s.nextval
33: INTO new_sequence_number
34: FROM dual;
35:
36: RETURN(new_sequence_number);
37: END get_report_id;
38:

Line 54: SELECT 1 INTO dummy FROM dual

50: RETURN BOOLEAN
51: IS
52: dummy NUMBER;
53: BEGIN
54: SELECT 1 INTO dummy FROM dual
55: WHERE NOT EXISTS
56: (SELECT 1
57: FROM rg_report_requests
58: WHERE report_id = cur_report_id

Line 82: SELECT 1 INTO dummy FROM dual

78: RETURN BOOLEAN
79: IS
80: dummy NUMBER;
81: BEGIN
82: SELECT 1 INTO dummy FROM dual
83: WHERE NOT EXISTS
84: (SELECT 1
85: FROM rg_report_requests
86: WHERE report_id = cur_report_id

Line 115: SELECT 1 INTO dummy FROM dual

111: RETURN BOOLEAN
112: IS
113: dummy NUMBER;
114: BEGIN
115: SELECT 1 INTO dummy FROM dual
116: WHERE NOT EXISTS
117: (SELECT 1
118: FROM rg_reports
119: WHERE report_id <> cur_report_id

Line 638: SELECT 1 INTO dummy FROM dual

634: RETURN BOOLEAN
635: IS
636: dummy NUMBER;
637: BEGIN
638: SELECT 1 INTO dummy FROM dual
639: WHERE NOT EXISTS
640: (SELECT 1
641: FROM rg_report_axes R_A,
642: rg_report_standard_axes_b S_A

Line 673: SELECT 1 INTO dummy FROM dual

669: RETURN BOOLEAN
670: IS
671: dummy NUMBER;
672: BEGIN
673: SELECT 1 INTO dummy FROM dual
674: WHERE NOT EXISTS
675: (SELECT 1
676: FROM rg_report_axes R_A,
677: rg_report_standard_axes_b S_A

Line 709: SELECT 1 INTO dummy FROM dual

705: RETURN BOOLEAN
706: IS
707: dummy NUMBER;
708: BEGIN
709: SELECT 1 INTO dummy FROM dual
710: WHERE NOT EXISTS
711: (SELECT 1
712: FROM rg_report_axes R_A
713: WHERE