DBA Data[Home] [Help]

APPS.RG_REPORT_DISPLAY_GROUPS_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_groups
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_group_id NUMBER) IS
24: dummy NUMBER;
25: BEGIN
26: select 1 into dummy from dual
27: where not exists
28: (select 1 from rg_report_displays
29: where row_group_id = X_report_display_group_id
30: or column_group_id = X_report_display_group_id);

Line 43: from dual;

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);
46: END get_unique_id;
47: