DBA Data[Home] [Help]

APPS.QA_PLANS_PUB dependencies on QA_PLAN_CHAR_ACTION_OUTPUTS

Line 2037: INSERT INTO qa_plan_char_action_outputs (

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,

Line 2055: FROM qa_plan_char_action_outputs

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:

Line 2263: DELETE FROM qa_plan_char_action_outputs

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

Line 2390: DELETE FROM qa_plan_char_action_outputs

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?