APPS.RG_REPORT_DISPLAY_GROUPS_PKG dependencies on RG_REPORT_DISPLAY_GROUPS

Line 1: PACKAGE BODY RG_REPORT_DISPLAY_GROUPS_PKG AS

1: PACKAGE BODY RG_REPORT_DISPLAY_GROUPS_PKG AS
2: /* $Header: rgirdpgb.pls 120.2 2002/11/14 03:00:51 djogg ship $ */
3: --
4: -- PUBLIC FUNCTIONS
5: --

Line 13: (select 1 from rg_report_display_groups

9: dummy NUMBER;
10: BEGIN
11: select 1 into dummy from dual
12: where not exists
13: (select 1 from rg_report_display_groups
14: where name = X_name
15: and ((X_rowid IS NULL) OR (rowid <> X_rowid)));
16: EXCEPTION
17: WHEN NO_DATA_FOUND THEN

Line 41: select rg_report_display_groups_s.nextval

37:
38: FUNCTION get_unique_id RETURN NUMBER IS
39: next_id NUMBER;
40: BEGIN
41: select rg_report_display_groups_s.nextval
42: into next_id
43: from dual;
44:
45: RETURN (next_id);

Line 78: CURSOR C IS SELECT rowid FROM rg_report_display_groups

74: X_attribute12 VARCHAR2,
75: X_attribute13 VARCHAR2,
76: X_attribute14 VARCHAR2,
77: X_attribute15 VARCHAR2) IS
78: CURSOR C IS SELECT rowid FROM rg_report_display_groups
79: WHERE report_display_group_id = X_report_display_group_id;
80: BEGIN
81: INSERT INTO rg_report_display_groups
82: (report_display_group_id ,

Line 81: INSERT INTO rg_report_display_groups

77: X_attribute15 VARCHAR2) IS
78: CURSOR C IS SELECT rowid FROM rg_report_display_groups
79: WHERE report_display_group_id = X_report_display_group_id;
80: BEGIN
81: INSERT INTO rg_report_display_groups
82: (report_display_group_id ,
83: name ,
84: description ,
85: row_set_id ,

Line 175: FROM rg_report_display_groups

171: X_attribute14 VARCHAR2,
172: X_attribute15 VARCHAR2) IS
173: CURSOR C IS
174: SELECT *
175: FROM rg_report_display_groups
176: WHERE rowid = X_rowid
177: FOR UPDATE OF name NOWAIT;
178: Recinfo C%ROWTYPE;
179: BEGIN

Line 295: UPDATE rg_report_display_groups

291: X_attribute13 VARCHAR2,
292: X_attribute14 VARCHAR2,
293: X_attribute15 VARCHAR2) IS
294: BEGIN
295: UPDATE rg_report_display_groups
296: SET report_display_group_id = X_report_display_group_id ,
297: name = X_name ,
298: description = X_description ,
299: row_set_id = X_row_set_id ,

Line 331: DELETE FROM rg_report_display_groups

327: END update_row;
328:
329: PROCEDURE delete_row(X_rowid VARCHAR2) IS
330: BEGIN
331: DELETE FROM rg_report_display_groups
332: WHERE rowid = X_rowid;
333:
334: IF (SQL%NOTFOUND) THEN
335: RAISE NO_DATA_FOUND;

Line 339: END RG_REPORT_DISPLAY_GROUPS_PKG;

335: RAISE NO_DATA_FOUND;
336: END IF;
337: END delete_row;
338:
339: END RG_REPORT_DISPLAY_GROUPS_PKG;