APPS.QLTCPDFB dependencies on ALR_ACTION_SETS

Line 134: ALR_ACTION_SETS_S.NEXTVAL,

130:
131: CURSOR CS3 IS
132: SELECT
133: ALR_ACTIONS_S.NEXTVAL,
134: ALR_ACTION_SETS_S.NEXTVAL,
135: ALR_ACTION_SET_MEMBERS_S.NEXTVAL,
136: QA_ALR_ACTION_NAME_S.NEXTVAL,
137: QA_ALR_ACTION_SET_NAME_S.NEXTVAL
138: FROM DUAL;

Line 236: -- Delete existing alr_action_sets

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
237:
238: DELETE FROM ALR_ACTION_SETS aas
239: WHERE aas.application_id = X_qa_app_id
240: AND aas.alert_id = X_qa_alert_id

Line 238: DELETE FROM ALR_ACTION_SETS aas

234: AND CHAR_ID = X_CHAR_ID);
235:
236: -- Delete existing alr_action_sets
237:
238: DELETE FROM ALR_ACTION_SETS aas
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

Line 276: -- Insert alr_action_sets

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
279:
280: OPEN C1;

Line 466: FROM ALR_ACTION_SETS

462:
463: BEGIN
464: SELECT NVL(MAX(SEQUENCE),0)+1
465: INTO ACTION_SET_SEQUENCE
466: FROM ALR_ACTION_SETS
467: WHERE APPLICATION_ID = 250
468: AND ALERT_ID = 10177;
469:
470: EXCEPTION

Line 475: INSERT INTO ALR_ACTION_SETS (

471: WHEN NO_DATA_FOUND THEN
472: ACTION_SET_SEQUENCE := 1;
473: END;
474:
475: INSERT INTO ALR_ACTION_SETS (
476: APPLICATION_ID,
477: ACTION_SET_ID,
478: NAME,
479: ALERT_ID,