APPS.QLTCPPLB dependencies on ALR_ACTION_SETS

Line 138: ALR_ACTION_SETS_S.NEXTVAL,

134:
135: CURSOR CS3 IS
136: SELECT
137: ALR_ACTIONS_S.NEXTVAL,
138: ALR_ACTION_SETS_S.NEXTVAL,
139: ALR_ACTION_SET_MEMBERS_S.NEXTVAL,
140: QA_ALR_ACTION_NAME_S.NEXTVAL,
141: QA_ALR_ACTION_SET_NAME_S.NEXTVAL
142: FROM DUAL;

Line 602: FROM ALR_ACTION_SETS

598:
599: BEGIN
600: SELECT NVL(MAX(SEQUENCE),0)+1
601: INTO ACTION_SET_SEQUENCE
602: FROM ALR_ACTION_SETS
603: WHERE APPLICATION_ID = 250
604: AND ALERT_ID = 10177;
605:
606: EXCEPTION

Line 611: INSERT INTO ALR_ACTION_SETS (

607: WHEN NO_DATA_FOUND THEN
608: ACTION_SET_SEQUENCE := 1;
609: END;
610:
611: INSERT INTO ALR_ACTION_SETS (
612: APPLICATION_ID,
613: ACTION_SET_ID,
614: NAME,
615: ALERT_ID,