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_ACTIONS

Line 1696: FROM alr_actions

1692: column_wrap_flag,
1693: maximum_summary_message_width,
1694: body,
1695: version_number
1696: FROM alr_actions
1697: WHERE action_id = x
1698: AND application_id = 250;
1699:
1700: alra alert_cursor%ROWTYPE;

Line 1713: new_action_name alr_actions.name%TYPE;

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

Line 1791: alr_actions_s.nextval,

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

Line 1816: INSERT INTO alr_actions (

1812:
1813: new_action_name := 'qa_' || l_action_name_seq;
1814: new_action_set_name := 'qa_' || l_action_set_name_seq;
1815:
1816: INSERT INTO alr_actions (
1817: application_id,
1818: action_id,
1819: name,
1820: alert_id,