DBA Data[Home] [Help]

APPS.RG_REPORT_AXIS_SETS_PKG dependencies on DUAL

Line 53: select 1 into dummy from dual

49: X_axis_set_type VARCHAR2,
50: X_application_id NUMBER) RETURN BOOLEAN IS
51: dummy NUMBER;
52: BEGIN
53: select 1 into dummy from dual
54: where not exists
55: (select 1 from rg_report_axis_sets
56: where name = X_name
57: and axis_set_type = X_axis_set_type

Line 74: SELECT 1 INTO dummy FROM sys.dual

70: dummy NUMBER;
71: BEGIN
72: IF (X_axis_set_type = 'R') THEN
73:
74: SELECT 1 INTO dummy FROM sys.dual
75: WHERE NOT EXISTS
76: ( SELECT 1
77: FROM rg_reports
78: WHERE row_set_id = X_axis_set_id

Line 91: SELECT 1 INTO dummy FROM sys.dual

87: );
88:
89: ELSE
90:
91: SELECT 1 INTO dummy FROM sys.dual
92: WHERE NOT EXISTS
93: ( SELECT 1
94: FROM rg_reports
95: WHERE column_set_id = X_axis_set_id

Line 124: from dual;

120: next_group_id NUMBER;
121: BEGIN
122: select rg_report_axis_sets_s.nextval
123: into next_group_id
124: from dual;
125:
126: RETURN (next_group_id);
127: END get_nextval;
128: