DBA Data[Home] [Help]

APPS.QA_PLANS_PUB dependencies on QA_PLAN_CHAR_ACTION_OUTPUTS

Line 2167: INSERT INTO qa_plan_char_action_outputs (

2163: qpca.action_id),
2164: qpca.assigned_char_id,
2165: qpca.assign_type);
2166:
2167: INSERT INTO qa_plan_char_action_outputs (
2168: plan_char_action_id,
2169: char_id,
2170: last_update_date,
2171: last_updated_by,

Line 2185: FROM qa_plan_char_action_outputs

2181: sysdate,
2182: p_user_id,
2183: p_user_id,
2184: token_name
2185: FROM qa_plan_char_action_outputs
2186: WHERE plan_char_action_id = qpca.plan_char_action_id;
2187:
2188: END LOOP; -- action_cursor
2189:

Line 2393: DELETE FROM qa_plan_char_action_outputs

2389: RETURN;
2390: END IF;
2391:
2392: FORALL i IN pca_ids.FIRST .. pca_ids.LAST
2393: DELETE FROM qa_plan_char_action_outputs
2394: WHERE plan_char_action_id = pca_ids(i);
2395: --
2396: -- ### Do we need to delete the alert records?
2397: --

Line 2520: DELETE FROM qa_plan_char_action_outputs

2516: --
2517: -- Some actions have action outputs... delete them.
2518: --
2519: FORALL i IN pca_ids.FIRST .. pca_ids.LAST
2520: DELETE FROM qa_plan_char_action_outputs
2521: WHERE plan_char_action_id = pca_ids(i);
2522:
2523: --
2524: -- ### Do we need to delete the alert records?