eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_PLANS_PUB dependencies on ALR_ACTION_SETS

Line 1714: new_action_set_name alr_action_sets.name%TYPE;

1710: new_action_id NUMBER;
1711: new_action_set_id NUMBER;
1712: new_action_set_member_id NUMBER;
1713: new_action_name alr_actions.name%TYPE;
1714: new_action_set_name alr_action_sets.name%TYPE;
1715:
1716:
1717: BEGIN
1718:

Line 1792: alr_action_sets_s.nextval,

1788: qpca.alr_action_id IS NOT NULL THEN
1789:
1790: SELECT
1791: alr_actions_s.nextval,
1792: alr_action_sets_s.nextval,
1793: alr_action_set_members_s.nextval,
1794: qa_alr_action_name_s.nextval,
1795: qa_alr_action_set_name_s.nextval
1796: INTO

Line 1891: FROM alr_action_sets

1887:
1888: BEGIN
1889: SELECT nvl(max(sequence),0) + 1
1890: INTO l_action_set_seq
1891: FROM alr_action_sets
1892: WHERE application_id = 250 AND alert_id = 10177;
1893:
1894: EXCEPTION
1895: WHEN no_data_found THEN

Line 1899: INSERT INTO alr_action_sets (

1895: WHEN no_data_found THEN
1896: l_action_set_seq := 1;
1897: END;
1898:
1899: INSERT INTO alr_action_sets (
1900: application_id,
1901: action_set_id,
1902: name,
1903: alert_id,