APPS.QASLSET_TABLE_HANDLER_PKG dependencies on QA_SKIPLOT_PROCESS_PLANS

Line 86: CURSOR C1 IS SELECT rowid FROM qa_skiplot_process_plans

82: X_Created_By NUMBER,
83: X_Last_Update_Login NUMBER
84: ) IS
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:

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 99: INSERT INTO QA_SKIPLOT_PROCESS_PLANS(

95: FETCH C2 INTO X_Process_Plan_id;
96: CLOSE C2;
97: end if;
98:
99: INSERT INTO QA_SKIPLOT_PROCESS_PLANS(
100: process_plan_id,
101: process_id,
102: plan_id,
103: alternate_plan_id,

Line 236: FROM QA_SKIPLOT_PROCESSES p, QA_SKIPLOT_PROCESS_PLANS pp, QA_SKIPLOT_PROCESS_PLAN_RULES ppr

232: ) IS
233:
234: CURSOR C IS
235: SELECT process_plan_rule_id
236: FROM QA_SKIPLOT_PROCESSES p, QA_SKIPLOT_PROCESS_PLANS pp, QA_SKIPLOT_PROCESS_PLAN_RULES ppr
237: WHERE p.process_id = X_Process_id
238: and p.process_id = pp.process_id
239: and pp.process_plan_id = ppr.process_plan_id
240: and ppr.rule_seq = 0;

Line 303: UPDATE QA_SKIPLOT_PROCESS_PLANS

299: ) IS
300:
301: BEGIN
302:
303: UPDATE QA_SKIPLOT_PROCESS_PLANS
304: SET
305: process_plan_id = X_Process_Plan_id,
306: process_id = X_Process_id,
307: plan_id = X_Plan_id,

Line 401: FROM QA_SKIPLOT_PROCESSES p, QA_SKIPLOT_PROCESS_PLANS pp, QA_SKIPLOT_PROCESS_PLAN_RULES ppr

397:
398:
399: CURSOR C1 IS
400: SELECT ppr.rounds qualification_lots, ppr.days_span qualification_days
401: FROM QA_SKIPLOT_PROCESSES p, QA_SKIPLOT_PROCESS_PLANS pp, QA_SKIPLOT_PROCESS_PLAN_RULES ppr
402: WHERE p.process_id = X_Process_id and p.process_id = pp.process_id and pp.process_plan_id = ppr.process_plan_id and ppr.rule_seq = 0
403: FOR UPDATE of ppr.process_plan_id, ppr.process_plan_rule_id NOWAIT;
404:
405: Recinfo1 C1%ROWTYPE;

Line 500: FROM QA_SKIPLOT_PROCESS_PLANS

496: ) IS
497:
498: CURSOR C IS
499: SELECT *
500: FROM QA_SKIPLOT_PROCESS_PLANS
501: WHERE rowid = X_Rowid
502: FOR UPDATE of process_plan_id NOWAIT;
503:
504: Recinfo C%ROWTYPE;

Line 643: delete from QA_SKIPLOT_PROCESS_PLANS

639: PROCEDURE delete_process_plans_row(X_Rowid VARCHAR2) IS
640:
641: BEGIN
642:
643: delete from QA_SKIPLOT_PROCESS_PLANS
644: where rowid = X_Rowid;
645:
646: if (SQL%NOTFOUND) then
647: Raise NO_DATA_FOUND;