[Home] [Help]
1076: IF l_to_plan_id = -1 THEN
1077: --
1078: -- Create a new plan header in qa_plans table.
1079: --
1080: SELECT qa_plans_s.nextval INTO l_to_plan_id FROM dual;
1081:
1082: l_plan_view := get_plan_view_name(l_plan_name);
1083: l_import_view := get_import_view_name(l_plan_name);
1084:
1186:
1187: --
1188: -- Bug 3926150. Commenting out copy_plan_elements because it
1189: -- is obsolete by copy_plan_elements_bulk. We don't want to
1190: -- dual maintain two codelines.
1191: -- bso Fri Dec 3 21:59:44 PST 2004
1192: --
1193: /*
1194: PROCEDURE copy_plan_elements(
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 (
1856: plan_char_action_trigger_id,
1857: last_update_date,
1908: FOR qpca IN action_cursor(qpcat.plan_char_action_trigger_id) LOOP
1909:
1910: SELECT qa_plan_char_actions_s.nextval
1911: INTO l_qpca_id
1912: FROM dual;
1913:
1914: --
1915: -- These are alert actions, generate new alert action IDs
1916: --
1928: new_action_set_id,
1929: new_action_set_member_id,
1930: l_action_name_seq,
1931: l_action_set_name_seq
1932: FROM dual;
1933:
1934: --
1935: -- Some action details are stored in Oracle Alert tables
1936: -- with alert ID 10177. Copy the header and recreate new
2236: FOR qpt IN txn_cursor LOOP
2237:
2238: SELECT qa_plan_transactions_s.nextval
2239: INTO l_plan_transaction_id
2240: FROM dual;
2241:
2242: INSERT INTO qa_plan_transactions (
2243: plan_transaction_id,
2244: last_update_date,
2740:
2741: l_plan_view := get_plan_view_name(l_plan_name);
2742: l_import_view := get_import_view_name(l_plan_name);
2743:
2744: SELECT qa_plans_s.nextval INTO x_plan_id FROM dual;
2745:
2746: --
2747: -- bug 9562325
2748: -- Added new parameters to set the DFF attributes