[Home] [Help]
1762: low_value_other,
1763: high_value_other,
1764: low_value_other_id,
1765: high_value_other_id
1766: FROM qa_plan_char_action_triggers
1767: WHERE plan_id = p_copy_from_plan_id AND char_id NOT IN
1768: (SELECT char_id
1769: FROM qa_plan_chars
1770: WHERE plan_id = p_copy_to_plan_id)
1847: BEGIN
1848:
1849: FOR qpcat IN action_trigger_cursor LOOP
1850:
1851: SELECT qa_plan_char_action_triggers_s.nextval
1852: INTO l_qpcat_id
1853: FROM dual;
1854:
1855: INSERT INTO qa_plan_char_action_triggers (
1851: SELECT qa_plan_char_action_triggers_s.nextval
1852: INTO l_qpcat_id
1853: FROM dual;
1854:
1855: INSERT INTO qa_plan_char_action_triggers (
1856: plan_char_action_trigger_id,
1857: last_update_date,
1858: last_updated_by,
1859: creation_date,
1896:
1897: IF p_copy_from_plan_id IN (1,2147483637) AND
1898: qpcat.low_value_other IN ('ACCEPT', 'REJECT') THEN
1899:
1900: UPDATE QA_PLAN_CHAR_ACTION_TRIGGERS
1901: SET low_value_other = (SELECT displayed_field
1902: FROM PO_LOOKUP_CODES
1903: WHERE lookup_type = 'ERT RESULTS ACTION'
1904: AND lookup_code = qpcat.low_value_other)
2371: pcat_ids number_tab;
2372:
2373: BEGIN
2374:
2375: DELETE FROM qa_plan_char_action_triggers
2376: WHERE plan_id = p_plan_id AND char_id = p_element_id
2377: RETURNING plan_char_action_trigger_id BULK COLLECT INTO pcat_ids;
2378:
2379: IF pcat_ids.COUNT = 0 THEN
2492:
2493: --
2494: -- Delete all triggers, collecting their primary keys
2495: --
2496: DELETE FROM qa_plan_char_action_triggers
2497: WHERE plan_id = p_plan_id
2498: RETURNING plan_char_action_trigger_id BULK COLLECT INTO pcat_ids;
2499:
2500: IF pcat_ids.COUNT = 0 THEN