APPS.RG_REPORT_DISPLAY_SETS_PKG dependencies on DUAL

Line 11: select 1 into dummy from dual

7: PROCEDURE check_unique( X_rowid VARCHAR2,
8: X_name VARCHAR2 ) IS
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)));

Line 26: select 1 into dummy from dual

22:
23: PROCEDURE check_references(X_report_display_set_id NUMBER) IS
24: dummy NUMBER;
25: BEGIN
26: select 1 into dummy from dual
27: where not exists
28: (select 1 from rg_reports
29: where report_display_set_id = X_report_display_set_id);
30: EXCEPTION

Line 41: select 1 into dummy from dual

37: FUNCTION check_display_exists(X_report_display_set_id NUMBER)
38: RETURN BOOLEAN IS
39: dummy NUMBER;
40: BEGIN
41: select 1 into dummy from dual
42: where not exists
43: (select 1
44: from rg_report_displays
45: where report_display_set_id = X_report_display_set_id);

Line 62: select 1 into dummy from dual

58: BEGIN
59: -- check whether at least one of the display options of this display
60: -- set uses a row group which references the same row set as this
61: -- display set does.
62: select 1 into dummy from dual
63: where not exists
64: (select 1
65: from rg_report_displays dpo,
66: rg_report_display_groups dpg

Line 89: select 1 into dummy from dual

85: -- check if there is any report that uses this display set uses
86: -- the old row set and if any report that references a row set
87: -- other than the new row set
88: --
89: select 1 into dummy from dual
90: where not exists
91: (select 1
92: from rg_reports
93: where report_display_set_id = X_report_display_set_id

Line 115: select 1 into dummy from dual

111: -- set uses a column group which references the same column set as this
112: -- display set does. If so, column set
113: -- update is not allowed
114: --
115: select 1 into dummy from dual
116: where not exists
117: (select 1
118: from rg_report_displays dpo,
119: rg_report_display_groups dpg

Line 144: select 1 into dummy from dual

140: -- the old column set and if any report that references a column set
141: -- other than the new column set. If so,
142: -- column set update is not allowed
143: --
144: select 1 into dummy from dual
145: where not exists
146: (select 1
147: from rg_reports
148: where report_display_set_id = X_report_display_set_id

Line 164: from dual;

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);
167: END get_unique_id;
168: