APPS.RG_REPORT_DISPLAY_SETS_PKG dependencies on RG_REPORT_DISPLAY_SETS

Line 1: PACKAGE BODY RG_REPORT_DISPLAY_SETS_PKG AS

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

Line 13: (select 1 from rg_report_display_sets

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

Line 162: select rg_report_display_sets_s.nextval

158:
159: FUNCTION get_unique_id RETURN NUMBER IS
160: next_id NUMBER;
161: BEGIN
162: select rg_report_display_sets_s.nextval
163: into next_id
164: from dual;
165:
166: RETURN (next_id);

Line 197: CURSOR C IS SELECT rowid FROM rg_report_display_sets

193: X_attribute12 VARCHAR2,
194: X_attribute13 VARCHAR2,
195: X_attribute14 VARCHAR2,
196: X_attribute15 VARCHAR2) IS
197: CURSOR C IS SELECT rowid FROM rg_report_display_sets
198: WHERE report_display_set_id = X_report_display_set_id;
199: BEGIN
200: INSERT INTO rg_report_display_sets
201: (report_display_set_id ,

Line 200: INSERT INTO rg_report_display_sets

196: X_attribute15 VARCHAR2) IS
197: CURSOR C IS SELECT rowid FROM rg_report_display_sets
198: WHERE report_display_set_id = X_report_display_set_id;
199: BEGIN
200: INSERT INTO rg_report_display_sets
201: (report_display_set_id ,
202: name ,
203: description ,
204: row_set_id ,

Line 288: FROM rg_report_display_sets

284: X_attribute14 VARCHAR2,
285: X_attribute15 VARCHAR2) IS
286: CURSOR C IS
287: SELECT *
288: FROM rg_report_display_sets
289: WHERE rowid = X_rowid
290: FOR UPDATE OF name NOWAIT;
291: Recinfo C%ROWTYPE;
292: BEGIN

Line 400: UPDATE rg_report_display_sets

396: X_attribute13 VARCHAR2,
397: X_attribute14 VARCHAR2,
398: X_attribute15 VARCHAR2) IS
399: BEGIN
400: UPDATE rg_report_display_sets
401: SET report_display_set_id = X_report_display_set_id ,
402: name = X_name ,
403: description = X_description ,
404: row_set_id = X_row_set_id ,

Line 434: DELETE FROM rg_report_display_sets

430: END update_row;
431:
432: PROCEDURE delete_row(X_rowid VARCHAR2) IS
433: BEGIN
434: DELETE FROM rg_report_display_sets
435: WHERE rowid = X_rowid;
436:
437: IF (SQL%NOTFOUND) THEN
438: RAISE NO_DATA_FOUND;

Line 442: END RG_REPORT_DISPLAY_SETS_PKG;

438: RAISE NO_DATA_FOUND;
439: END IF;
440: END delete_row;
441:
442: END RG_REPORT_DISPLAY_SETS_PKG;