APPS.QASLSET_TABLE_HANDLER_PKG dependencies on QA_SKIPLOT_PROCESS_PLAN_RULES

Line 154: CURSOR C1 IS SELECT rowid FROM qa_skiplot_process_plan_rules

150: X_Last_Update_Login NUMBER
151: ) IS
152:
153:
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;

Line 170: INSERT INTO QA_SKIPLOT_PROCESS_PLAN_RULES(

166: CLOSE C2;
167: end if;
168:
169:
170: INSERT INTO QA_SKIPLOT_PROCESS_PLAN_RULES(
171: process_plan_rule_id,
172: process_plan_id,
173: rule_seq,
174: frequency_num,

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 272: UPDATE QA_SKIPLOT_PROCESS_PLAN_RULES

268:
269: LOOP
270: FETCH C into ppr_id;
271: EXIT WHEN C%NOTFOUND;
272: UPDATE QA_SKIPLOT_PROCESS_PLAN_RULES
273: SET
274: rounds = X_Qualification_Lots,
275: days_span = X_Qualification_Days,
276: last_update_date = X_Last_Update_Date,

Line 345: UPDATE QA_SKIPLOT_PROCESS_PLAN_RULES

341: ) IS
342:
343: BEGIN
344:
345: UPDATE QA_SKIPLOT_PROCESS_PLAN_RULES
346: SET
347: process_plan_rule_id = X_Process_Plan_Rule_id,
348: process_plan_id = X_Process_Plan_id,
349: rule_seq = X_Rule_Seq,

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 568: FROM QA_SKIPLOT_PROCESS_PLAN_RULES

564: ) IS
565:
566: CURSOR C IS
567: SELECT *
568: FROM QA_SKIPLOT_PROCESS_PLAN_RULES
569: WHERE rowid = X_Rowid
570: FOR UPDATE of process_plan_rule_id NOWAIT;
571:
572: Recinfo C%ROWTYPE;

Line 659: delete from QA_SKIPLOT_PROCESS_PLAN_RULES

655:
656: PROCEDURE delete_process_plan_rules_row(X_Rowid VARCHAR2) IS
657:
658: BEGIN
659: delete from QA_SKIPLOT_PROCESS_PLAN_RULES
660: where rowid = X_Rowid;
661:
662: if (SQL%NOTFOUND) then
663: Raise NO_DATA_FOUND;