APPS.QA_ALERT_PKG dependencies on ALR_ACTION_SETS

Line 280: -- Create an alr_action_sets record.

276: END update_alr_actions;
277:
278:
279: --
280: -- Create an alr_action_sets record.
281: -- Return the created action_set_id and sequence into
282: -- x_action_set_id and x_sequence params.
283: --
284: -- Output variable: x_return_status will be

Line 288: PROCEDURE insert_alr_action_sets(

284: -- Output variable: x_return_status will be
285: -- fnd_api.g_ret_sts_success if successful
286: -- fnd_api.g_ret_sts_error if not
287: --
288: PROCEDURE insert_alr_action_sets(
289: p_application_id NUMBER,
290: p_alert_id NUMBER,
291: p_name VARCHAR2,
292: p_end_date_active DATE,

Line 313: FROM alr_action_sets

309:
310: BEGIN
311: SELECT nvl(max(sequence),0)+1
312: INTO l_sequence
313: FROM alr_action_sets
314: WHERE application_id = p_application_id AND
315: alert_id = p_alert_id;
316:
317: INSERT INTO alr_action_sets (

Line 317: INSERT INTO alr_action_sets (

313: FROM alr_action_sets
314: WHERE application_id = p_application_id AND
315: alert_id = p_alert_id;
316:
317: INSERT INTO alr_action_sets (
318: action_set_id,
319: application_id,
320: name,
321: alert_id,

Line 335: alr_action_sets_s.nextval,

331: last_update_date,
332: last_updated_by,
333: last_update_login)
334: VALUES (
335: alr_action_sets_s.nextval,
336: p_application_id,
337: p_name,
338: p_alert_id,
339: p_end_date_active,

Line 359: END insert_alr_action_sets;

355:
356: EXCEPTION WHEN OTHERS THEN
357: x_return_status := fnd_api.g_ret_sts_error;
358:
359: END insert_alr_action_sets;
360:
361:
362:
363: