APPS.RG_REPORT_AXIS_SETS_PKG dependencies on RG_REPORT_AXIS_SETS

Line 1: PACKAGE BODY RG_REPORT_AXIS_SETS_PKG AS

1: PACKAGE BODY RG_REPORT_AXIS_SETS_PKG AS
2: /* $Header: rgiraxsb.pls 120.9 2006/11/09 20:28:29 ticheng ship $ */
3: -- Name
4: -- rg_report_axis_sets_pkg
5: -- Purpose

Line 4: -- rg_report_axis_sets_pkg

1: PACKAGE BODY RG_REPORT_AXIS_SETS_PKG AS
2: /* $Header: rgiraxsb.pls 120.9 2006/11/09 20:28:29 ticheng ship $ */
3: -- Name
4: -- rg_report_axis_sets_pkg
5: -- Purpose
6: -- to include all server side procedures and packages for table
7: -- rg_report_axis_sets
8: -- Notes

Line 7: -- rg_report_axis_sets

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

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

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

Line 24: from rg_report_axis_sets

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

Line 30: recinfo rg_report_axis_sets%ROWTYPE;

26: END select_row;
27:
28: PROCEDURE select_columns(X_axis_set_id NUMBER,
29: X_name IN OUT NOCOPY VARCHAR2) IS
30: recinfo rg_report_axis_sets%ROWTYPE;
31: BEGIN
32: recinfo.axis_set_id := X_axis_set_id;
33: select_row(recinfo);
34: X_name := recinfo.name;

Line 41: UPDATE rg_report_axis_sets

37: PROCEDURE update_structure_info(X_axis_set_id NUMBER,
38: X_id_flex_code VARCHAR2,
39: X_structure_id NUMBER) IS
40: BEGIN
41: UPDATE rg_report_axis_sets
42: SET id_flex_code = X_id_flex_code,
43: structure_id = X_structure_id
44: WHERE axis_set_id = NVL( X_axis_set_id, -1);
45: END update_structure_info;

Line 55: (select 1 from rg_report_axis_sets

51: dummy NUMBER;
52: BEGIN
53: select 1 into dummy from dual
54: where not exists
55: (select 1 from rg_report_axis_sets
56: where name = X_name
57: and axis_set_type = X_axis_set_type
58: and application_id = X_application_id
59: and ((X_rowid IS NULL) OR (rowid <> X_rowid)));

Line 122: select rg_report_axis_sets_s.nextval

118:
119: FUNCTION get_nextval return number IS
120: next_group_id NUMBER;
121: BEGIN
122: select rg_report_axis_sets_s.nextval
123: into next_group_id
124: from dual;
125:
126: RETURN (next_group_id);

Line 168: CURSOR C IS SELECT rowid FROM rg_report_axis_sets

164: X_attribute13 VARCHAR2,
165: X_attribute14 VARCHAR2,
166: X_attribute15 VARCHAR2,
167: X_taxonomy_id NUMBER) IS
168: CURSOR C IS SELECT rowid FROM rg_report_axis_sets
169: WHERE axis_set_id = X_axis_set_id;
170: BEGIN
171: IF (NOT check_unique(X_rowid,
172: X_name,

Line 188: INSERT INTO rg_report_axis_sets

184: IF (X_axis_set_id IS NULL) THEN
185: X_axis_set_id := get_nextval;
186: END IF;
187:
188: INSERT INTO rg_report_axis_sets
189: (application_id ,
190: axis_set_id ,
191: name ,
192: axis_set_type ,

Line 300: FROM rg_report_axis_sets

296: X_attribute15 VARCHAR2,
297: X_taxonomy_id NUMBER) IS
298: CURSOR C IS
299: SELECT *
300: FROM rg_report_axis_sets
301: WHERE rowid = X_rowid
302: FOR UPDATE OF name NOWAIT;
303: Recinfo C%ROWTYPE;
304: BEGIN

Line 444: UPDATE rg_report_axis_sets

440: X_attribute14 VARCHAR2,
441: X_attribute15 VARCHAR2,
442: X_taxonomy_id NUMBER) IS
443: BEGIN
444: UPDATE rg_report_axis_sets
445: SET application_id = X_application_id ,
446: axis_set_id = X_axis_set_id ,
447: name = X_name ,
448: axis_set_type = X_axis_set_type ,

Line 489: DELETE FROM rg_report_axis_sets

485: X_axis_set_id NUMBER) IS
486: BEGIN
487: rg_report_axes_pkg.delete_rows(X_axis_set_id);
488:
489: DELETE FROM rg_report_axis_sets
490: WHERE rowid = X_rowid;
491:
492: IF (SQL%NOTFOUND) THEN
493: RAISE NO_DATA_FOUND;

Line 558: FROM RG_REPORT_AXIS_SETS

554: SELECT axis_set_id, creation_date, last_updated_by,
555: rowid, security_flag
556: INTO v_axis_set_id, v_creation_date, v_last_updated_by,
557: v_rowid, v_security_flag
558: FROM RG_REPORT_AXIS_SETS
559: WHERE SEEDED_NAME = X_Seeded_Name;
560:
561: /* Do not overwrite if it has been customized */
562: IF (v_last_updated_by <> 1) THEN

Line 570: RG_REPORT_AXIS_SETS_PKG.update_row(

566: /*
567: * Update only if force_edits is 'Y' or owner = 'SEED'
568: */
569: IF ( user_id = 1 OR X_Force_Edits = 'Y' ) THEN
570: RG_REPORT_AXIS_SETS_PKG.update_row(
571: X_rowid => v_rowid,
572: X_application_id => X_Application_Id,
573: X_axis_set_id => v_axis_set_id,
574: X_security_flag => v_security_flag,

Line 612: RG_REPORT_AXIS_SETS_PKG.insert_row(

608: WHEN NO_DATA_FOUND THEN
609: /*
610: * If the row doesn't exist yet, call Insert_Row().
611: */
612: RG_REPORT_AXIS_SETS_PKG.insert_row(
613: X_rowid => v_rowid,
614: X_application_id => X_Application_Id,
615: X_axis_set_id => v_axis_set_id,
616: X_security_flag => 'N',

Line 651: UPDATE RG_REPORT_AXIS_SETS

647: X_taxonomy_id => null);
648:
649: /* Bug 5648378: Make sure to also populate the seeded_name column
650: * for seeded data. */
651: UPDATE RG_REPORT_AXIS_SETS
652: SET SEEDED_NAME = X_Seeded_Name
653: WHERE rowid = v_rowid;
654: END;
655: END Load_Row;

Line 675: UPDATE RG_REPORT_AXIS_SETS

671: /*
672: * Update only if force_edits is 'Y' or owner = 'SEED'
673: */
674: IF ( user_id = 1 or X_Force_Edits = 'Y' ) THEN
675: UPDATE RG_REPORT_AXIS_SETS
676: SET
677: name = X_Name,
678: description = X_Description,
679: last_update_date = sysdate,

Line 694: END RG_REPORT_AXIS_SETS_PKG;

690: END IF;
691:
692: END Translate_Row;
693:
694: END RG_REPORT_AXIS_SETS_PKG;