DBA Data[Home] [Help]

APPS.QA_PLANS_PUB dependencies on ALR_ACTIONS

Line 1826: FROM alr_actions

1822: column_wrap_flag,
1823: maximum_summary_message_width,
1824: body,
1825: version_number
1826: FROM alr_actions
1827: WHERE action_id = x
1828: AND application_id = 250;
1829:
1830: alra alert_cursor%ROWTYPE;

Line 1843: new_action_name alr_actions.name%TYPE;

1839:
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

Line 1921: alr_actions_s.nextval,

1917: IF qpca.action_id IN (10, 11, 12, 13) AND
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

Line 1946: INSERT INTO alr_actions (

1942:
1943: new_action_name := 'qa_' || l_action_name_seq;
1944: new_action_set_name := 'qa_' || l_action_set_name_seq;
1945:
1946: INSERT INTO alr_actions (
1947: application_id,
1948: action_id,
1949: name,
1950: alert_id,