APPS.QASLSP_TABLE_HANDLER_PKG dependencies on QA_SKIPLOT_ASSOCIATION

Line 166: CURSOR C1 IS SELECT rowid FROM qa_skiplot_association

162: X_Created_By NUMBER,
163: X_Last_Update_Login NUMBER
164: ) IS
165:
166: CURSOR C1 IS SELECT rowid FROM qa_skiplot_association
167: WHERE criteria_id = X_Criteria_id and
168: process_id = X_Process_id;
169:
170: BEGIN

Line 172: INSERT INTO QA_SKIPLOT_ASSOCIATION(

168: process_id = X_Process_id;
169:
170: BEGIN
171:
172: INSERT INTO QA_SKIPLOT_ASSOCIATION(
173: criteria_id,
174: process_id,
175: effective_from,
176: effective_to,

Line 330: UPDATE QA_SKIPLOT_ASSOCIATION

326: ) IS
327:
328: BEGIN
329:
330: UPDATE QA_SKIPLOT_ASSOCIATION
331: SET
332: criteria_id = X_Criteria_id,
333: process_id = X_Process_id,
334: effective_from = X_SL_Effective_From,

Line 523: FROM QA_SKIPLOT_ASSOCIATION

519: ) IS
520:
521: CURSOR C IS
522: SELECT *
523: FROM QA_SKIPLOT_ASSOCIATION
524: WHERE rowid = X_Rowid
525: FOR UPDATE of criteria_id NOWAIT;
526:
527: Recinfo C%ROWTYPE;

Line 618: delete from QA_SKIPLOT_ASSOCIATION

614: PROCEDURE delete_sl_association_row(X_Rowid VARCHAR2) IS
615:
616: BEGIN
617:
618: delete from QA_SKIPLOT_ASSOCIATION
619: where rowid = X_Rowid;
620:
621: if (SQL%NOTFOUND) then
622: Raise NO_DATA_FOUND;