APPS.QLTCPDFB dependencies on QA_PLAN_CHAR_ACTION_TRIGGERS

Line 54: SELECT QA_PLAN_CHAR_ACTION_TRIGGERS_S.NEXTVAL FROM DUAL;

50:
51: QCAT C1%ROWTYPE;
52:
53: CURSOR CS1 IS
54: SELECT QA_PLAN_CHAR_ACTION_TRIGGERS_S.NEXTVAL FROM DUAL;
55:
56: ACTION_TRIGGER_ID NUMBER;
57:
58: CURSOR C2 IS

Line 260: DELETE FROM qa_plan_char_action_triggers

256: AND CHAR_ID = X_CHAR_ID);
257:
258: -- Delete existing action triggers
259:
260: DELETE FROM qa_plan_char_action_triggers
261: WHERE plan_id = X_Plan_Id and
262: char_id = X_Char_Id;
263:
264: -- Delete existing qa_plan_char_actions

Line 269: FROM qa_plan_char_action_triggers

265:
266: DELETE FROM qa_plan_char_actions
267: WHERE plan_char_action_trigger_id IN
268: (SELECT plan_char_action_trigger_id
269: FROM qa_plan_char_action_triggers
270: WHERE plan_id = X_Plan_Id
271: and char_id = X_Char_Id);
272:
273: -- Insert new action triggers

Line 289: INSERT INTO QA_PLAN_CHAR_ACTION_TRIGGERS (

285: OPEN CS1;
286: FETCH CS1 INTO ACTION_TRIGGER_ID;
287: CLOSE CS1;
288:
289: INSERT INTO QA_PLAN_CHAR_ACTION_TRIGGERS (
290: PLAN_CHAR_ACTION_TRIGGER_ID,
291: LAST_UPDATE_DATE,
292: LAST_UPDATED_BY,
293: CREATION_DATE,