APPS.QA_PLANS_PUB dependencies on QA_PLAN_CHAR_ACTION_TRIGGERS

Line 1636: FROM qa_plan_char_action_triggers

1632: low_value_other,
1633: high_value_other,
1634: low_value_other_id,
1635: high_value_other_id
1636: FROM qa_plan_char_action_triggers
1637: WHERE plan_id = p_copy_from_plan_id AND char_id NOT IN
1638: (SELECT char_id
1639: FROM qa_plan_chars
1640: WHERE plan_id = p_copy_to_plan_id)

Line 1721: SELECT qa_plan_char_action_triggers_s.nextval

1717: BEGIN
1718:
1719: FOR qpcat IN action_trigger_cursor LOOP
1720:
1721: SELECT qa_plan_char_action_triggers_s.nextval
1722: INTO l_qpcat_id
1723: FROM dual;
1724:
1725: INSERT INTO qa_plan_char_action_triggers (

Line 1725: INSERT INTO qa_plan_char_action_triggers (

1721: SELECT qa_plan_char_action_triggers_s.nextval
1722: INTO l_qpcat_id
1723: FROM dual;
1724:
1725: INSERT INTO qa_plan_char_action_triggers (
1726: plan_char_action_trigger_id,
1727: last_update_date,
1728: last_updated_by,
1729: creation_date,

Line 1770: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS

1766:
1767: IF p_copy_from_plan_id IN (1,2147483637) AND
1768: qpcat.low_value_other IN ('ACCEPT', 'REJECT') THEN
1769:
1770: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS
1771: SET low_value_other = (SELECT displayed_field
1772: FROM PO_LOOKUP_CODES
1773: WHERE lookup_type = 'ERT RESULTS ACTION'
1774: AND lookup_code = qpcat.low_value_other)

Line 2245: DELETE FROM qa_plan_char_action_triggers

2241: pcat_ids number_tab;
2242:
2243: BEGIN
2244:
2245: DELETE FROM qa_plan_char_action_triggers
2246: WHERE plan_id = p_plan_id AND char_id = p_element_id
2247: RETURNING plan_char_action_trigger_id BULK COLLECT INTO pcat_ids;
2248:
2249: IF pcat_ids.COUNT = 0 THEN

Line 2366: DELETE FROM qa_plan_char_action_triggers

2362:
2363: --
2364: -- Delete all triggers, collecting their primary keys
2365: --
2366: DELETE FROM qa_plan_char_action_triggers
2367: WHERE plan_id = p_plan_id
2368: RETURNING plan_char_action_trigger_id BULK COLLECT INTO pcat_ids;
2369:
2370: IF pcat_ids.COUNT = 0 THEN