APPS.QASLSP_TABLE_HANDLER_PKG dependencies on QA_SL_SP_RCV_CRITERIA

Line 23: CURSOR C1 IS SELECT rowid FROM qa_sl_sp_rcv_criteria

19: X_Created_By NUMBER,
20: X_Last_Update_Login NUMBER
21: ) IS
22:
23: CURSOR C1 IS SELECT rowid FROM qa_sl_sp_rcv_criteria
24: WHERE criteria_id = X_Criteria_id;
25:
26: CURSOR C2 IS SELECT qa_sl_sp_criteria_s.nextval FROM dual;
27:

Line 37: INSERT INTO QA_SL_SP_RCV_CRITERIA(

33: FETCH C2 INTO X_Criteria_id;
34: CLOSE C2;
35: end if;
36:
37: INSERT INTO QA_SL_SP_RCV_CRITERIA(
38: criteria_id,
39: organization_id,
40: vendor_id,
41: vendor_site_id,

Line 239: UPDATE QA_SL_SP_RCV_CRITERIA

235: ) IS
236:
237: BEGIN
238:
239: UPDATE QA_SL_SP_RCV_CRITERIA
240: SET
241: criteria_id = X_Criteria_id,
242: organization_id = X_Organization_id,
243: vendor_id = nvl(X_Vendor_id, -1),

Line 379: FROM QA_SL_SP_RCV_CRITERIA

375: ) IS
376:
377: CURSOR C IS
378: SELECT *
379: FROM QA_SL_SP_RCV_CRITERIA
380: WHERE rowid = X_Rowid
381: FOR UPDATE of criteria_id NOWAIT;
382:
383: Recinfo C%ROWTYPE;

Line 586: delete from QA_SL_SP_RCV_CRITERIA

582: PROCEDURE delete_sl_sp_rcv_criteria_row(X_Rowid VARCHAR2) IS
583:
584: BEGIN
585:
586: delete from QA_SL_SP_RCV_CRITERIA
587: where rowid = X_Rowid;
588:
589: if (SQL%NOTFOUND) then
590: Raise NO_DATA_FOUND;