2033: qpca.action_id),
2034: qpca.assigned_char_id,
2035: qpca.assign_type);
2036:
2037: INSERT INTO qa_plan_char_action_outputs (
2038: plan_char_action_id,
2039: char_id,
2040: last_update_date,
2041: last_updated_by,
2051: sysdate,
2052: p_user_id,
2053: p_user_id,
2054: token_name
2055: FROM qa_plan_char_action_outputs
2056: WHERE plan_char_action_id = qpca.plan_char_action_id;
2057:
2058: END LOOP; -- action_cursor
2059:
2259: RETURN;
2260: END IF;
2261:
2262: FORALL i IN pca_ids.FIRST .. pca_ids.LAST
2263: DELETE FROM qa_plan_char_action_outputs
2264: WHERE plan_char_action_id = pca_ids(i);
2265: --
2266: -- ### Do we need to delete the alert records?
2267: --
2386: --
2387: -- Some actions have action outputs... delete them.
2388: --
2389: FORALL i IN pca_ids.FIRST .. pca_ids.LAST
2390: DELETE FROM qa_plan_char_action_outputs
2391: WHERE plan_char_action_id = pca_ids(i);
2392:
2393: --
2394: -- ### Do we need to delete the alert records?