APPS.QLTCPPLB dependencies on ALR_ACTIONS

Line 129: FROM ALR_ACTIONS

125: COLUMN_WRAP_FLAG,
126: MAXIMUM_SUMMARY_MESSAGE_WIDTH,
127: BODY,
128: VERSION_NUMBER
129: FROM ALR_ACTIONS
130: WHERE APPLICATION_ID = 250
131: AND ACTION_ID = QPCA.ALR_ACTION_ID;
132:
133: ALRA C3%ROWTYPE;

Line 137: ALR_ACTIONS_S.NEXTVAL,

133: ALRA C3%ROWTYPE;
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

Line 529: INSERT INTO ALR_ACTIONS (

525: OPEN C3;
526: FETCH C3 INTO ALRA;
527:
528: IF NOT C3%NOTFOUND THEN
529: INSERT INTO ALR_ACTIONS (
530: APPLICATION_ID,
531: ACTION_ID,
532: NAME,
533: ALERT_ID,