APPS.RG_REPORT_DISPLAYS_PKG dependencies on RG_REPORT_DISPLAYS

Line 1: PACKAGE BODY RG_REPORT_DISPLAYS_PKG AS

1: PACKAGE BODY RG_REPORT_DISPLAYS_PKG AS
2: /* $Header: rgirdspb.pls 120.2 2002/11/14 03:01:21 djogg ship $ */
3: --
4: -- PUBLIC FUNCTIONS
5: --

Line 14: (select 1 from rg_report_displays

10: dummy NUMBER;
11: BEGIN
12: select 1 into dummy from dual
13: where not exists
14: (select 1 from rg_report_displays
15: where report_display_set_id = nvl(X_report_display_set_id,-1)
16: and sequence = X_sequence
17: and ((X_rowid IS NULL) OR (rowid <> X_rowid)));
18: EXCEPTION

Line 28: select rg_report_displays_s.nextval

24:
25: FUNCTION get_unique_id RETURN NUMBER IS
26: next_id NUMBER;
27: BEGIN
28: select rg_report_displays_s.nextval
29: into next_id
30: from dual;
31:
32: RETURN (next_id);

Line 65: CURSOR C IS SELECT rowid FROM rg_report_displays

61: X_attribute12 VARCHAR2,
62: X_attribute13 VARCHAR2,
63: X_attribute14 VARCHAR2,
64: X_attribute15 VARCHAR2) IS
65: CURSOR C IS SELECT rowid FROM rg_report_displays
66: WHERE report_display_id = X_report_display_id;
67: BEGIN
68: INSERT INTO RG_REPORT_DISPLAYS
69: (report_display_id ,

Line 68: INSERT INTO RG_REPORT_DISPLAYS

64: X_attribute15 VARCHAR2) IS
65: CURSOR C IS SELECT rowid FROM rg_report_displays
66: WHERE report_display_id = X_report_display_id;
67: BEGIN
68: INSERT INTO RG_REPORT_DISPLAYS
69: (report_display_id ,
70: report_display_set_id ,
71: sequence ,
72: display_flag ,

Line 164: UPDATE RG_REPORT_DISPLAYS

160: X_attribute13 VARCHAR2,
161: X_attribute14 VARCHAR2,
162: X_attribute15 VARCHAR2) IS
163: BEGIN
164: UPDATE RG_REPORT_DISPLAYS
165: SET report_display_id = X_report_display_id ,
166: report_display_set_id = X_report_display_set_id ,
167: sequence = X_sequence ,
168: display_flag = X_display_flag ,

Line 224: FROM rg_report_displays

220: X_attribute14 VARCHAR2,
221: X_attribute15 VARCHAR2) IS
222: CURSOR C IS
223: SELECT *
224: FROM rg_report_displays
225: WHERE rowid = X_rowid
226: FOR UPDATE OF sequence NOWAIT;
227: Recinfo C%ROWTYPE;
228: BEGIN

Line 318: DELETE FROM rg_report_displays

314: END lock_row;
315:
316: PROCEDURE delete_row(X_rowid VARCHAR2) IS
317: BEGIN
318: DELETE FROM rg_report_displays
319: WHERE rowid = X_rowid;
320:
321: IF (SQL%NOTFOUND) THEN
322: RAISE NO_DATA_FOUND;

Line 326: END RG_REPORT_DISPLAYS_PKG;

322: RAISE NO_DATA_FOUND;
323: END IF;
324: END delete_row;
325:
326: END RG_REPORT_DISPLAYS_PKG;