DBA Data[Home] [Help]

APPS.QASLSET_TABLE_HANDLER_PKG dependencies on DUAL

Line 22: CURSOR C2 IS SELECT qa_skiplot_processes_s.nextval FROM dual;

18:
19: CURSOR C1 IS SELECT rowid FROM qa_skiplot_processes
20: WHERE process_id = X_Process_id;
21:
22: CURSOR C2 IS SELECT qa_skiplot_processes_s.nextval FROM dual;
23:
24: BEGIN
25:
26: if (X_Process_id is NULL) then

Line 89: CURSOR C2 IS SELECT qa_skiplot_process_plans_s.nextval FROM dual;

85:
86: CURSOR C1 IS SELECT rowid FROM qa_skiplot_process_plans
87: WHERE process_plan_id = X_Process_Plan_id;
88:
89: CURSOR C2 IS SELECT qa_skiplot_process_plans_s.nextval FROM dual;
90:
91: BEGIN
92:
93: if (X_Process_Plan_id is NULL) then

Line 158: CURSOR C2 IS SELECT qa_skiplot_pp_rules_s.nextval FROM dual;

154: CURSOR C1 IS SELECT rowid FROM qa_skiplot_process_plan_rules
155: WHERE process_plan_id = X_Process_Plan_id and
156: rule_seq = X_Rule_Seq;
157:
158: CURSOR C2 IS SELECT qa_skiplot_pp_rules_s.nextval FROM dual;
159:
160:
161: BEGIN
162: