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_DSS_DIMENSIONS_PKG dependencies on DUAL

Line 46: FROM dual

42: dummy NUMBER;
43: BEGIN
44: SELECT 1
45: INTO dummy
46: FROM dual
47: WHERE NOT EXISTS
48: (SELECT 1
49: FROM rg_dss_systems sys,
50: rg_dss_system_variables svr,

Line 71: FROM dual

67: dummy NUMBER;
68: BEGIN
69: SELECT 1
70: INTO dummy
71: FROM dual
72: WHERE NOT EXISTS
73: (SELECT 1
74: FROM rg_dss_dimensions
75: WHERE name = X_name

Line 93: FROM dual

89: dummy NUMBER;
90: BEGIN
91: SELECT 1
92: INTO dummy
93: FROM dual
94: WHERE NOT EXISTS
95: (SELECT 1
96: FROM rg_dss_dimensions
97: WHERE object_name = X_object_name

Line 116: FROM dual

112: dummy NUMBER;
113: BEGIN
114: SELECT 1
115: INTO dummy
116: FROM dual
117: WHERE NOT EXISTS
118: (SELECT 1
119: FROM rg_dss_dimensions
120: WHERE object_prefix = X_object_prefix

Line 148: FROM dual

144: dummy NUMBER;
145: BEGIN
146: SELECT 1
147: INTO dummy
148: FROM dual
149: WHERE NOT EXISTS
150: (SELECT 1
151: FROM rg_dss_var_dimensions
152: WHERE dimension_id = X_dimension_id

Line 171: FROM dual;

167: next_dimension_id NUMBER;
168: BEGIN
169: SELECT rg_dss_dimensions_s.nextval
170: INTO next_dimension_id
171: FROM dual;
172:
173: RETURN (next_dimension_id);
174: END get_new_id;
175: