APPS.QASPSET_TABLE_HANDLER_PKG dependencies on QA_SAMPLING_CUSTOM_RULES

Line 90: CURSOR C1 IS SELECT rowid FROM qa_sampling_custom_rules

86: X_Created_By NUMBER,
87: X_Last_Update_Login NUMBER
88: ) IS
89:
90: CURSOR C1 IS SELECT rowid FROM qa_sampling_custom_rules
91: WHERE rule_id = X_Rule_id;
92:
93: CURSOR C2 IS SELECT qa_sampling_rules_s.nextval FROM dual;
94:

Line 104: INSERT INTO QA_SAMPLING_CUSTOM_RULES(

100: FETCH C2 INTO X_Rule_id;
101: CLOSE C2;
102: end if;
103:
104: INSERT INTO QA_SAMPLING_CUSTOM_RULES(
105: rule_id,
106: sampling_plan_id,
107: min_lot_size,
108: max_lot_size,

Line 206: UPDATE QA_SAMPLING_CUSTOM_RULES

202: ) IS
203:
204: BEGIN
205:
206: UPDATE QA_SAMPLING_CUSTOM_RULES
207: SET
208: rule_id = X_Rule_id,
209: sampling_plan_id = X_Sampling_Plan_id,
210: min_lot_size = X_Min_Lot_Size,

Line 323: FROM QA_SAMPLING_CUSTOM_RULES

319: ) IS
320:
321: CURSOR C IS
322: SELECT *
323: FROM QA_SAMPLING_CUSTOM_RULES
324: WHERE rowid = X_Rowid
325: FOR UPDATE of rule_id NOWAIT;
326:
327: Recinfo C%ROWTYPE;

Line 392: delete from QA_SAMPLING_CUSTOM_RULES

388:
389: PROCEDURE delete_customized_rules_row(X_Rowid VARCHAR2) IS
390:
391: BEGIN
392: delete from QA_SAMPLING_CUSTOM_RULES
393: where rowid = X_Rowid;
394:
395: if (SQL%NOTFOUND) then
396: Raise NO_DATA_FOUND;