APPS.QA_PLANS_PUB dependencies on ALR_ACTION_SETS

Line 1844: new_action_set_name alr_action_sets.name%TYPE;

1840: new_action_id NUMBER;
1841: new_action_set_id NUMBER;
1842: new_action_set_member_id NUMBER;
1843: new_action_name alr_actions.name%TYPE;
1844: new_action_set_name alr_action_sets.name%TYPE;
1845:
1846:
1847: BEGIN
1848:

Line 1922: alr_action_sets_s.nextval,

1918: qpca.alr_action_id IS NOT NULL THEN
1919:
1920: SELECT
1921: alr_actions_s.nextval,
1922: alr_action_sets_s.nextval,
1923: alr_action_set_members_s.nextval,
1924: qa_alr_action_name_s.nextval,
1925: qa_alr_action_set_name_s.nextval
1926: INTO

Line 2021: FROM alr_action_sets

2017:
2018: BEGIN
2019: SELECT nvl(max(sequence),0) + 1
2020: INTO l_action_set_seq
2021: FROM alr_action_sets
2022: WHERE application_id = 250 AND alert_id = 10177;
2023:
2024: EXCEPTION
2025: WHEN no_data_found THEN

Line 2029: INSERT INTO alr_action_sets (

2025: WHEN no_data_found THEN
2026: l_action_set_seq := 1;
2027: END;
2028:
2029: INSERT INTO alr_action_sets (
2030: application_id,
2031: action_set_id,
2032: name,
2033: alert_id,