APPS.QASLSET_TABLE_HANDLER_PKG dependencies on QA_SKIPLOT_PROCESSES

Line 19: CURSOR C1 IS SELECT rowid FROM qa_skiplot_processes

15: X_Created_By NUMBER,
16: X_Last_Update_Login NUMBER
17: ) IS
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:

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 32: INSERT INTO QA_SKIPLOT_PROCESSES(

28: FETCH C2 INTO X_Process_id;
29: CLOSE C2;
30: end if;
31:
32: INSERT INTO QA_SKIPLOT_PROCESSES(
33: process_id,
34: process_code,
35: description,
36: disqualification_lots,

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 246: UPDATE QA_SKIPLOT_PROCESSES

242: ppr_id NUMBER;
243:
244: BEGIN
245:
246: UPDATE QA_SKIPLOT_PROCESSES
247: SET
248: process_id = X_Process_id,
249: process_code = X_Process_Code,
250: description = X_Description,

Line 392: FROM QA_SKIPLOT_PROCESSES

388: ) IS
389:
390: CURSOR C IS
391: SELECT *
392: FROM QA_SKIPLOT_PROCESSES
393: WHERE rowid = X_Rowid
394: FOR UPDATE of process_id NOWAIT;
395:
396: Recinfo C%ROWTYPE;

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 627: delete from QA_SKIPLOT_PROCESSES

623: PROCEDURE delete_process_row(X_Rowid VARCHAR2) IS
624:
625: BEGIN
626:
627: delete from QA_SKIPLOT_PROCESSES
628: where rowid = X_Rowid;
629:
630: if (SQL%NOTFOUND) then
631: Raise NO_DATA_FOUND;