APPS.QA_ALERT_PKG dependencies on ALR_ACTION_SET_MEMBERS

Line 365: -- Create an alr_action_set_members record.

361:
362:
363:
364: --
365: -- Create an alr_action_set_members record.
366: -- Return the created action_set_member_id and sequence into
367: -- x_action_set_member_id and x_sequence params.
368: --
369: -- Output variable: x_return_status will be

Line 373: PROCEDURE insert_alr_action_set_members(

369: -- Output variable: x_return_status will be
370: -- fnd_api.g_ret_sts_success if successful
371: -- fnd_api.g_ret_sts_error if not
372: --
373: PROCEDURE insert_alr_action_set_members(
374: p_application_id NUMBER,
375: p_action_set_id NUMBER,
376: p_action_id NUMBER,
377: p_action_group_id NUMBER,

Line 398: FROM alr_action_set_members

394:
395: BEGIN
396: SELECT nvl(max(sequence),0) + 1
397: INTO l_sequence
398: FROM alr_action_set_members
399: WHERE application_id = 250 AND
400: alert_id = 10177 AND
401: action_set_id = p_action_set_id;
402:

Line 403: INSERT INTO alr_action_set_members (

399: WHERE application_id = 250 AND
400: alert_id = 10177 AND
401: action_set_id = p_action_set_id;
402:
403: INSERT INTO alr_action_set_members (
404: action_set_member_id,
405: application_id,
406: action_set_id,
407: action_id,

Line 422: alr_action_set_members_s.nextval,

418: last_update_date,
419: last_updated_by,
420: last_update_login)
421: VALUES (
422: alr_action_set_members_s.nextval,
423: p_application_id,
424: p_action_set_id,
425: p_action_id,
426: p_action_group_id,

Line 447: END insert_alr_action_set_members;

443:
444: EXCEPTION WHEN OTHERS THEN
445: x_return_status := fnd_api.g_ret_sts_error;
446:
447: END insert_alr_action_set_members;
448:
449:
450:
451: