APPS.RG_REPORT_AXES_PKG dependencies on RG_REPORT_AXES

Line 1: PACKAGE BODY RG_REPORT_AXES_PKG AS

1: PACKAGE BODY RG_REPORT_AXES_PKG AS
2: /* $Header: rgiraxeb.pls 120.9 2006/03/13 19:51:59 ticheng ship $ */
3: -- Name
4: -- rg_report_axes_pkg
5: -- Purpose

Line 4: -- rg_report_axes_pkg

1: PACKAGE BODY RG_REPORT_AXES_PKG AS
2: /* $Header: rgiraxeb.pls 120.9 2006/03/13 19:51:59 ticheng ship $ */
3: -- Name
4: -- rg_report_axes_pkg
5: -- Purpose
6: -- to include all sever side procedures and packages for table
7: -- rg_report_axes
8: -- Notes

Line 7: -- rg_report_axes

3: -- Name
4: -- rg_report_axes_pkg
5: -- Purpose
6: -- to include all sever side procedures and packages for table
7: -- rg_report_axes
8: -- Notes
9: --
10: -- History
11: -- 11/01/93 A Chen Created

Line 21: PROCEDURE select_row(recinfo IN OUT NOCOPY rg_report_axes%ROWTYPE) IS

17: -- None.
18: --
19: -- PUBLIC FUNCTIONS
20: --
21: PROCEDURE select_row(recinfo IN OUT NOCOPY rg_report_axes%ROWTYPE) IS
22: BEGIN
23: select * INTO recinfo
24: from rg_report_axes
25: where axis_set_id = recinfo.axis_set_id

Line 24: from rg_report_axes

20: --
21: PROCEDURE select_row(recinfo IN OUT NOCOPY rg_report_axes%ROWTYPE) IS
22: BEGIN
23: select * INTO recinfo
24: from rg_report_axes
25: where axis_set_id = recinfo.axis_set_id
26: and axis_seq = recinfo.axis_seq;
27: END select_row;
28:

Line 32: recinfo rg_report_axes%ROWTYPE;

28:
29: PROCEDURE select_columns(X_axis_set_id NUMBER,
30: X_axis_seq NUMBER,
31: X_name IN OUT NOCOPY VARCHAR2) IS
32: recinfo rg_report_axes%ROWTYPE;
33: BEGIN
34: recinfo.axis_set_id := X_axis_set_id;
35: recinfo.axis_seq := X_axis_seq;
36: select_row(recinfo);

Line 48: (select 1 from rg_report_axes

44: dummy NUMBER;
45: BEGIN
46: select 1 into dummy from dual
47: where not exists
48: (select 1 from rg_report_axes
49: where axis_seq = x_axis_seq
50: and axis_set_id = x_axis_set_id
51: and ((x_rowid IS NULL) OR (rowid <> x_rowid)));
52: RETURN (TRUE);

Line 127: from rg_report_axes

123: format_before_text,
124: format_after_text,
125: display_precision,
126: format_mask_width
127: from rg_report_axes
128: where axis_set_id = X_column_set_id
129: and position < 2000
130: and display_flag = 'Y'
131: order by position asc ) LOOP

Line 163: from rg_report_axes col,

159: sat.standard_axis_id,
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')

Line 275: CURSOR C IS SELECT rowid FROM rg_report_axes

271: X_attribute14 VARCHAR2 ,
272: X_attribute15 VARCHAR2 ,
273: X_element_id NUMBER
274: ) IS
275: CURSOR C IS SELECT rowid FROM rg_report_axes
276: WHERE axis_set_id = X_axis_set_id
277: AND axis_seq = X_axis_seq;
278: BEGIN
279: IF (NOT check_unique(X_rowid,

Line 292: INSERT INTO rg_report_axes

288: END IF;
289: APP_EXCEPTION.raise_exception;
290: END IF;
291:
292: INSERT INTO rg_report_axes
293: (application_id ,
294: axis_set_id ,
295: axis_seq ,
296: last_update_date ,

Line 480: FROM rg_report_axes

476: X_element_id NUMBER
477: ) IS
478: CURSOR C IS
479: SELECT *
480: FROM rg_report_axes
481: WHERE rowid = X_rowid
482: FOR UPDATE OF axis_seq NOWAIT;
483: Recinfo C%ROWTYPE;
484: BEGIN

Line 724: FROM rg_report_axes

720: ) IS
721: old_axis_seq NUMBER;
722: BEGIN
723: SELECT axis_seq INTO old_axis_seq
724: FROM rg_report_axes
725: WHERE rowid = X_rowid;
726:
727: IF (old_axis_seq <> X_axis_seq) THEN
728: UPDATE rg_report_axis_contents

Line 749: UPDATE rg_report_axes

745: WHERE axis_set_id = X_axis_set_id
746: AND axis_seq = old_axis_seq;
747: END IF;
748:
749: UPDATE rg_report_axes
750: SET application_id = X_application_id ,
751: axis_set_id = X_axis_set_id ,
752: axis_seq = X_axis_seq ,
753: last_update_date = X_last_update_date ,

Line 820: from rg_report_axes

816: X_axis_seq NUMBER;
817: BEGIN
818: select axis_set_id, axis_seq
819: into X_axis_set_id, X_axis_seq
820: from rg_report_axes
821: where rowid = X_rowid;
822:
823: rg_report_axis_contents_pkg.delete_rows(X_axis_set_id,
824: X_axis_seq);

Line 832: DELETE FROM rg_report_axes

828:
829: rg_report_exception_flags_pkg.delete_rows(X_axis_set_id,
830: X_axis_seq);
831:
832: DELETE FROM rg_report_axes
833: WHERE rowid = X_rowid;
834:
835: IF (SQL%NOTFOUND) THEN
836: RAISE NO_DATA_FOUND;

Line 856: delete from rg_report_axes

852:
853: rg_report_exception_flags_pkg.delete_rows(X_axis_set_id,
854: -1);
855:
856: delete from rg_report_axes
857: where axis_set_id = X_axis_set_id;
858:
859: END delete_rows;
860:

Line 937: FROM RG_REPORT_AXES

933:
934: /* Retrieve creation date from existing rows */
935: SELECT creation_date, last_updated_by, rowid
936: INTO v_creation_date, v_last_updated_by, v_rowid
937: FROM RG_REPORT_AXES
938: WHERE AXIS_SET_ID = X_axis_set_id
939: AND AXIS_SEQ = X_axis_seq;
940:
941: /* Do no overwrite if it has been customized */

Line 950: RG_REPORT_AXES_PKG.update_row(

946: /*
947: * Update only if force_edits is 'Y' or owner = 'SEED'
948: */
949: IF ( user_id = 1 or X_Force_Edits = 'Y' ) then
950: RG_REPORT_AXES_PKG.update_row(
951: X_rowid => v_rowid,
952: X_application_id => X_Application_Id,
953: X_axis_set_id => X_Axis_Set_Id,
954: X_axis_seq => X_Axis_Seq,

Line 1019: RG_REPORT_AXES_PKG.insert_row(

1015: (check_unique(v_rowid, X_Axis_Seq, X_Axis_Set_Id, 'R'))) THEN
1016: /*
1017: * If the row doesn't exist yet, call Insert_Row().
1018: */
1019: RG_REPORT_AXES_PKG.insert_row(
1020: X_rowid => v_rowid,
1021: X_application_id => X_Application_Id,
1022: X_axis_set_id => X_Axis_Set_Id,
1023: X_axis_set_type => 'C',

Line 1103: UPDATE RG_REPORT_AXES

1099: /*
1100: * Update only if force_edits is 'Y' or owner = 'SEED'
1101: */
1102: IF ( user_id = 1 or X_Force_Edits = 'Y' ) THEN
1103: UPDATE RG_REPORT_AXES
1104: SET
1105: axis_name = X_Axis_Name,
1106: description = X_Description,
1107: last_update_date = sysdate,

Line 1120: END RG_REPORT_AXES_PKG;

1116: END IF;
1117:
1118: END Translate_Row;
1119:
1120: END RG_REPORT_AXES_PKG;