APPS.QLTCPDFB dependencies on ALR_ACTION_SET_MEMBERS

Line 135: ALR_ACTION_SET_MEMBERS_S.NEXTVAL,

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;
139:

Line 247: -- Delete existing alr_action_set_members

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
248:
249: DELETE FROM ALR_ACTION_SET_MEMBERS aasm
250: WHERE aasm.application_id = X_qa_app_id
251: AND aasm.alert_id = X_qa_alert_id

Line 249: DELETE FROM ALR_ACTION_SET_MEMBERS aasm

245: AND CHAR_ID = X_CHAR_ID);
246:
247: -- Delete existing alr_action_set_members
248:
249: DELETE FROM ALR_ACTION_SET_MEMBERS aasm
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

Line 277: -- Insert alr_action_set_members

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;
281: LOOP

Line 512: FROM ALR_ACTION_SET_MEMBERS

508:
509: BEGIN
510: SELECT NVL(MAX(SEQUENCE),0)+1
511: INTO ACTION_SET_MEMBERS_SEQUENCE
512: FROM ALR_ACTION_SET_MEMBERS
513: WHERE APPLICATION_ID = 250
514: AND ALERT_ID = 10177
515: AND ACTION_SET_ID = NEW_ACTION_SET_ID;
516: EXCEPTION

Line 521: INSERT INTO ALR_ACTION_SET_MEMBERS (

517: WHEN NO_DATA_FOUND THEN
518: ACTION_SET_MEMBERS_SEQUENCE := 1;
519: END;
520:
521: INSERT INTO ALR_ACTION_SET_MEMBERS (
522: APPLICATION_ID,
523: ACTION_SET_MEMBER_ID,
524: ACTION_SET_ID,
525: ACTION_ID,