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_REPORT_AXES_PKG dependencies on STANDARD

Line 158: FOR axis_rec IN ( select standard_axis_name,

154: dash VARCHAR2(30);
155: c_return VARCHAR2(1);
156: OfInterest VARCHAR2(10);
157: BEGIN
158: FOR axis_rec IN ( select standard_axis_name,
159: sat.standard_axis_id,
160: period_offset,
161: position,
162: display_format

Line 159: sat.standard_axis_id,

155: c_return VARCHAR2(1);
156: OfInterest VARCHAR2(10);
157: BEGIN
158: FOR axis_rec IN ( select standard_axis_name,
159: sat.standard_axis_id,
160: period_offset,
161: position,
162: display_format
163: from rg_report_axes col,

Line 164: rg_report_standard_axes_tl sat

160: period_offset,
161: position,
162: display_format
163: from rg_report_axes col,
164: rg_report_standard_axes_tl sat
165: where col.axis_set_id = X_column_set_id
166: and col.standard_axis_id = sat.standard_axis_id(+)
167: and sat.language(+) = userenv('LANG')
168: and col.position < 2000

Line 166: and col.standard_axis_id = sat.standard_axis_id(+)

162: display_format
163: from rg_report_axes col,
164: rg_report_standard_axes_tl sat
165: where col.axis_set_id = X_column_set_id
166: and col.standard_axis_id = sat.standard_axis_id(+)
167: and sat.language(+) = userenv('LANG')
168: and col.position < 2000
169: and col.display_flag = 'Y'
170: order by col.position asc ) LOOP

Line 184: axis_rec.standard_axis_name;

180: END IF;
181: END IF;
182: X_amount_type_line := RPAD(substr(X_amount_type_line, 1, axis_rec.position-2),
183: axis_rec.position-1, ' ') ||
184: axis_rec.standard_axis_name;
185: IF (axis_rec.period_offset IS NOT NULL) THEN
186: IF ((axis_rec.standard_axis_id >= 100) AND
187: (axis_rec.standard_axis_id < 104)) THEN
188: OfInterest := 'DOI';

Line 186: IF ((axis_rec.standard_axis_id >= 100) AND

182: X_amount_type_line := RPAD(substr(X_amount_type_line, 1, axis_rec.position-2),
183: axis_rec.position-1, ' ') ||
184: axis_rec.standard_axis_name;
185: IF (axis_rec.period_offset IS NOT NULL) THEN
186: IF ((axis_rec.standard_axis_id >= 100) AND
187: (axis_rec.standard_axis_id < 104)) THEN
188: OfInterest := 'DOI';
189: ELSE
190: OfInterest := 'POI';

Line 187: (axis_rec.standard_axis_id < 104)) THEN

183: axis_rec.position-1, ' ') ||
184: axis_rec.standard_axis_name;
185: IF (axis_rec.period_offset IS NOT NULL) THEN
186: IF ((axis_rec.standard_axis_id >= 100) AND
187: (axis_rec.standard_axis_id < 104)) THEN
188: OfInterest := 'DOI';
189: ELSE
190: OfInterest := 'POI';
191: END IF;

Line 226: X_standard_axis_id NUMBER ,

222: X_created_by NUMBER ,
223: X_axis_type VARCHAR2 ,
224: X_axis_name VARCHAR2 ,
225: X_amount_id NUMBER ,
226: X_standard_axis_id NUMBER ,
227: X_width NUMBER ,
228: X_position NUMBER ,
229: X_structure_id NUMBER ,
230: X_unit_of_measure_id VARCHAR2 ,

Line 304: standard_axis_id ,

300: created_by ,
301: axis_type ,
302: axis_name ,
303: amount_id ,
304: standard_axis_id ,
305: width ,
306: position ,
307: structure_id ,
308: unit_of_measure_id ,

Line 364: X_standard_axis_id ,

360: X_created_by ,
361: X_axis_type ,
362: X_axis_name ,
363: X_amount_id ,
364: X_standard_axis_id ,
365: X_width ,
366: X_position ,
367: X_structure_id ,
368: X_unit_of_measure_id ,

Line 429: X_standard_axis_id NUMBER ,

425: X_axis_seq NUMBER ,
426: X_axis_type VARCHAR2 ,
427: X_axis_name VARCHAR2 ,
428: X_amount_id NUMBER ,
429: X_standard_axis_id NUMBER ,
430: X_width NUMBER ,
431: X_position NUMBER ,
432: X_structure_id NUMBER ,
433: X_unit_of_measure_id VARCHAR2 ,

Line 513: AND ( (Recinfo.standard_axis_id = X_standard_axis_id)

509: AND (X_axis_name IS NULL)))
510: AND ( (Recinfo.amount_id = X_amount_id)
511: OR ( (Recinfo.amount_id IS NULL)
512: AND (X_amount_id IS NULL)))
513: AND ( (Recinfo.standard_axis_id = X_standard_axis_id)
514: OR ( (Recinfo.standard_axis_id IS NULL)
515: AND (X_standard_axis_id IS NULL)))
516: AND ( (Recinfo.width = X_width)
517: OR ( (Recinfo.width IS NULL)

Line 514: OR ( (Recinfo.standard_axis_id IS NULL)

510: AND ( (Recinfo.amount_id = X_amount_id)
511: OR ( (Recinfo.amount_id IS NULL)
512: AND (X_amount_id IS NULL)))
513: AND ( (Recinfo.standard_axis_id = X_standard_axis_id)
514: OR ( (Recinfo.standard_axis_id IS NULL)
515: AND (X_standard_axis_id IS NULL)))
516: AND ( (Recinfo.width = X_width)
517: OR ( (Recinfo.width IS NULL)
518: AND (X_width IS NULL)))

Line 515: AND (X_standard_axis_id IS NULL)))

511: OR ( (Recinfo.amount_id IS NULL)
512: AND (X_amount_id IS NULL)))
513: AND ( (Recinfo.standard_axis_id = X_standard_axis_id)
514: OR ( (Recinfo.standard_axis_id IS NULL)
515: AND (X_standard_axis_id IS NULL)))
516: AND ( (Recinfo.width = X_width)
517: OR ( (Recinfo.width IS NULL)
518: AND (X_width IS NULL)))
519: AND ( (Recinfo.position = X_position)

Line 672: X_standard_axis_id NUMBER ,

668: X_last_update_login NUMBER ,
669: X_axis_type VARCHAR2 ,
670: X_axis_name VARCHAR2 ,
671: X_amount_id NUMBER ,
672: X_standard_axis_id NUMBER ,
673: X_width NUMBER ,
674: X_position NUMBER ,
675: X_structure_id NUMBER ,
676: X_unit_of_measure_id VARCHAR2 ,

Line 759: standard_axis_id = X_standard_axis_id ,

755: last_update_login = X_last_update_login ,
756: axis_type = X_axis_type ,
757: axis_name = X_axis_name ,
758: amount_id = X_amount_id ,
759: standard_axis_id = X_standard_axis_id ,
760: width = X_width ,
761: position = X_position ,
762: structure_id = X_structure_id ,
763: unit_of_measure_id = X_unit_of_measure_id ,

Line 868: X_Standard_Axis_Id NUMBER,

864: X_Axis_Seq NUMBER,
865: X_Axis_Type VARCHAR2,
866: X_Axis_Name VARCHAR2,
867: X_Amount_Id NUMBER,
868: X_Standard_Axis_Id NUMBER,
869: X_Width NUMBER,
870: X_Position NUMBER,
871: X_Unit_Of_Measure_Id VARCHAR2,
872: X_Parameter_Num NUMBER,

Line 961: X_standard_axis_id => X_Standard_Axis_Id,

957: X_last_update_login => 0,
958: X_axis_type => X_Axis_Type,
959: X_axis_name => X_Axis_Name,
960: X_amount_id => X_Amount_Id,
961: X_standard_axis_id => X_Standard_Axis_Id,
962: X_width => X_Width,
963: X_position => X_Position,
964: X_structure_id => null,
965: X_unit_of_measure_id => X_Unit_Of_Measure_Id,

Line 1033: X_standard_axis_id => X_Standard_Axis_Id,

1029: X_created_by => user_id,
1030: X_axis_type => X_Axis_Type,
1031: X_axis_name => X_Axis_Name,
1032: X_amount_id => X_Amount_Id,
1033: X_standard_axis_id => X_Standard_Axis_Id,
1034: X_width => X_Width,
1035: X_position => X_Position,
1036: X_structure_id => null,
1037: X_unit_of_measure_id => X_Unit_Of_Measure_Id,