APPS.QA_PLANS_PUB dependencies on QA_PLAN_CHAR_ACTIONS

Line 1787: FROM qa_plan_char_actions

1783: alr_action_id,
1784: alr_action_set_id,
1785: assigned_char_id,
1786: assign_type
1787: FROM qa_plan_char_actions
1788: WHERE plan_char_action_trigger_id = x
1789: ORDER BY plan_char_action_id;
1790:
1791: -- Bug 3111310

Line 1910: SELECT qa_plan_char_actions_s.nextval

1906: END IF;
1907:
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: --

Line 2120: INSERT INTO qa_plan_char_actions (

2116: CLOSE alert_cursor;
2117:
2118: END IF; -- the action id is 10, 11, 12, 13 (alert actions)
2119:
2120: INSERT INTO qa_plan_char_actions (
2121: plan_char_action_id,
2122: last_update_date,
2123: last_updated_by,
2124: creation_date,

Line 2384: DELETE FROM qa_plan_char_actions

2380: RETURN;
2381: END IF;
2382:
2383: FORALL i IN pcat_ids.FIRST .. pcat_ids.LAST
2384: DELETE FROM qa_plan_char_actions
2385: WHERE plan_char_action_trigger_id = pcat_ids(i)
2386: RETURNING plan_char_action_id BULK COLLECT INTO pca_ids;
2387:
2388: IF pca_ids.COUNT = 0 THEN

Line 2508: DELETE FROM qa_plan_char_actions

2504: --
2505: -- Now delete all children actions
2506: --
2507: FORALL i IN pcat_ids.FIRST .. pcat_ids.LAST
2508: DELETE FROM qa_plan_char_actions
2509: WHERE plan_char_action_trigger_id = pcat_ids(i)
2510: RETURNING plan_char_action_id BULK COLLECT INTO pca_ids;
2511:
2512: IF pca_ids.COUNT = 0 THEN