DBA Data[Home] [Help]

APPS.RG_REPORT_CONTENT_SETS_PKG dependencies on DUAL

Line 42: select 1 into dummy from dual

38: X_name VARCHAR2,
39: X_application_id NUMBER) IS
40: dummy NUMBER;
41: BEGIN
42: select 1 into dummy from dual
43: where not exists
44: (select 1 from rg_report_content_sets
45: where name = X_name
46: and application_id = X_application_id

Line 59: select 1 into dummy from dual

55: PROCEDURE check_references(X_content_set_id NUMBER) IS
56: object_name VARCHAR2(80);
57: dummy NUMBER;
58: BEGIN
59: select 1 into dummy from dual
60: where not exists
61: (select 1 from rg_reports
62: where content_set_id = X_content_set_id);
63: EXCEPTION

Line 75: from dual;

71: next_group_id NUMBER;
72: BEGIN
73: select rg_report_content_sets_s.nextval
74: into next_group_id
75: from dual;
76:
77: RETURN (next_group_id);
78: END get_nextval;
79: