APPS.QASLSP_TABLE_HANDLER_PKG dependencies on QA_SAMPLING_ASSOCIATION

Line 102: CURSOR C1 IS SELECT rowid FROM qa_sampling_association

98: X_Created_By NUMBER,
99: X_Last_Update_Login NUMBER
100: ) IS
101:
102: CURSOR C1 IS SELECT rowid FROM qa_sampling_association
103: WHERE criteria_id = X_Criteria_id and
104: sampling_plan_id = X_Sampling_Plan_id;
105:
106: BEGIN

Line 108: INSERT INTO QA_SAMPLING_ASSOCIATION(

104: sampling_plan_id = X_Sampling_Plan_id;
105:
106: BEGIN
107:
108: INSERT INTO QA_SAMPLING_ASSOCIATION(
109: criteria_id,
110: sampling_plan_id,
111: collection_plan_id,
112: wf_role_name,

Line 286: UPDATE QA_SAMPLING_ASSOCIATION

282: ) IS
283:
284: BEGIN
285:
286: UPDATE QA_SAMPLING_ASSOCIATION
287: SET
288: criteria_id = X_Criteria_id,
289: sampling_plan_id = X_Sampling_Plan_id,
290: collection_plan_id = nvl(X_Collection_Plan_id, -1),

Line 450: FROM QA_SAMPLING_ASSOCIATION

446: ) IS
447:
448: CURSOR C IS
449: SELECT *
450: FROM QA_SAMPLING_ASSOCIATION
451: WHERE rowid = X_Rowid
452: FOR UPDATE of criteria_id NOWAIT;
453:
454: Recinfo C%ROWTYPE;

Line 602: delete from QA_SAMPLING_ASSOCIATION

598:
599: PROCEDURE delete_sp_association_row(X_Rowid VARCHAR2) IS
600:
601: BEGIN
602: delete from QA_SAMPLING_ASSOCIATION
603: where rowid = X_Rowid;
604:
605: if (SQL%NOTFOUND) then
606: Raise NO_DATA_FOUND;