APPS.QLTCPDFB dependencies on QA_PLAN_CHAR_ACTIONS

Line 81: SELECT QA_PLAN_CHAR_ACTIONS_S.NEXTVAL FROM DUAL;

77:
78: QCA C2%ROWTYPE;
79:
80: CURSOR CS2 IS
81: SELECT QA_PLAN_CHAR_ACTIONS_S.NEXTVAL FROM DUAL;
82:
83: QPC_ACTION_ID NUMBER;
84:
85: -- Bug 3111310. Add app_id to WHERE clause of SQL

Line 232: FROM qa_plan_char_actions_v qpcav

228: WHERE aa.application_id = X_qa_app_id
229: AND aa.alert_id = X_qa_alert_id
230: AND aa.action_id in
231: (SELECT qpcav.alr_action_id
232: FROM qa_plan_char_actions_v qpcav
233: WHERE PLAN_ID = X_PLAN_ID
234: AND CHAR_ID = X_CHAR_ID);
235:
236: -- Delete existing alr_action_sets

Line 243: FROM qa_plan_char_actions_v qpcav

239: WHERE aas.application_id = X_qa_app_id
240: AND aas.alert_id = X_qa_alert_id
241: AND aas.action_set_id in
242: (SELECT qpcav.alr_action_set_id
243: FROM qa_plan_char_actions_v qpcav
244: WHERE PLAN_ID = X_PLAN_ID
245: AND CHAR_ID = X_CHAR_ID);
246:
247: -- Delete existing alr_action_set_members

Line 254: FROM qa_plan_char_actions_v qpcav

250: WHERE aasm.application_id = X_qa_app_id
251: AND aasm.alert_id = X_qa_alert_id
252: AND aasm.action_set_id in
253: (SELECT qpcav.alr_action_set_id
254: FROM qa_plan_char_actions_v qpcav
255: WHERE PLAN_ID = X_PLAN_ID
256: AND CHAR_ID = X_CHAR_ID);
257:
258: -- Delete existing action triggers

Line 264: -- Delete existing qa_plan_char_actions

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
265:
266: DELETE FROM qa_plan_char_actions
267: WHERE plan_char_action_trigger_id IN
268: (SELECT plan_char_action_trigger_id

Line 266: DELETE FROM qa_plan_char_actions

262: char_id = X_Char_Id;
263:
264: -- Delete existing qa_plan_char_actions
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

Line 274: -- Insert qa_plan_char_actions

270: WHERE plan_id = X_Plan_Id
271: and char_id = X_Char_Id);
272:
273: -- Insert new action triggers
274: -- Insert qa_plan_char_actions
275: -- Insert alr_actions
276: -- Insert alr_action_sets
277: -- Insert alr_action_set_members
278: -- Insert qa_plan_char_action_outputs

Line 345: INSERT INTO QA_PLAN_CHAR_ACTIONS (

341:
342: NEW_ACTION_NAME := 'QA_' || TO_CHAR(X_ACTION_NAME);
343: NEW_ACTION_SET_NAME := 'QA_' || TO_CHAR(X_ACTION_SET_NAME);
344:
345: INSERT INTO QA_PLAN_CHAR_ACTIONS (
346: PLAN_CHAR_ACTION_ID,
347: LAST_UPDATE_DATE,
348: LAST_UPDATED_BY,
349: CREATION_DATE,