APPS.QLTCPDFB dependencies on ALR_ACTIONS

Line 125: FROM ALR_ACTIONS

121: COLUMN_WRAP_FLAG,
122: MAXIMUM_SUMMARY_MESSAGE_WIDTH,
123: BODY,
124: VERSION_NUMBER
125: FROM ALR_ACTIONS
126: WHERE APPLICATION_ID = X_qa_app_id
127: AND ACTION_ID = QCA.ALR_ACTION_ID;
128:
129: ALRA C3%ROWTYPE;

Line 133: ALR_ACTIONS_S.NEXTVAL,

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

Line 222: -- Delete existing alr_actions

218: -- DEFAULT ACTIONS
219:
220: if (X_Copy_Actions = 1) then
221:
222: -- Delete existing alr_actions
223: -- Bug 3111310. Rewrite WHERE...EXIST query
224: -- to improve performance
225: -- ksoh Fri Aug 22 11:05:00 PST 2003
226: --

Line 227: DELETE FROM ALR_ACTIONS aa

223: -- Bug 3111310. Rewrite WHERE...EXIST query
224: -- to improve performance
225: -- ksoh Fri Aug 22 11:05:00 PST 2003
226: --
227: DELETE FROM ALR_ACTIONS aa
228: WHERE aa.application_id = X_qa_app_id
229: AND aa.alert_id = X_qa_alert_id
230: AND aa.action_id in
231: (SELECT qpcav.alr_action_id

Line 275: -- Insert alr_actions

271: and char_id = X_Char_Id);
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:

Line 393: INSERT INTO ALR_ACTIONS (

389: OPEN C3;
390: FETCH C3 INTO ALRA;
391:
392: IF NOT C3%NOTFOUND THEN
393: INSERT INTO ALR_ACTIONS (
394: APPLICATION_ID,
395: ACTION_ID,
396: NAME,
397: ALERT_ID,