APPS.QLTCPPLB dependencies on ALR_ACTIONS

Line 121: FROM ALR_ACTIONS

117: COLUMN_WRAP_FLAG,
118: MAXIMUM_SUMMARY_MESSAGE_WIDTH,
119: BODY,
120: VERSION_NUMBER
121: FROM ALR_ACTIONS
122: WHERE APPLICATION_ID = 250
123: AND ACTION_ID = QPCA.ALR_ACTION_ID;
124:
125: ALRA C3%ROWTYPE;

Line 129: ALR_ACTIONS_S.NEXTVAL,

125: ALRA C3%ROWTYPE;
126:
127: CURSOR CS3 IS
128: SELECT
129: ALR_ACTIONS_S.NEXTVAL,
130: ALR_ACTION_SETS_S.NEXTVAL,
131: ALR_ACTION_SET_MEMBERS_S.NEXTVAL,
132: QA_ALR_ACTION_NAME_S.NEXTVAL,
133: QA_ALR_ACTION_SET_NAME_S.NEXTVAL

Line 513: INSERT INTO ALR_ACTIONS (

509: OPEN C3;
510: FETCH C3 INTO ALRA;
511:
512: IF NOT C3%NOTFOUND THEN
513: INSERT INTO ALR_ACTIONS (
514: APPLICATION_ID,
515: ACTION_ID,
516: NAME,
517: ALERT_ID,