APPS.QA_PLANS_PUB dependencies on QA_PLAN_CHAR_ACTIONS

Line 1657: FROM qa_plan_char_actions

1653: alr_action_id,
1654: alr_action_set_id,
1655: assigned_char_id,
1656: assign_type
1657: FROM qa_plan_char_actions
1658: WHERE plan_char_action_trigger_id = x
1659: ORDER BY plan_char_action_id;
1660:
1661: -- Bug 3111310

Line 1780: SELECT qa_plan_char_actions_s.nextval

1776: END IF;
1777:
1778: FOR qpca IN action_cursor(qpcat.plan_char_action_trigger_id) LOOP
1779:
1780: SELECT qa_plan_char_actions_s.nextval
1781: INTO l_qpca_id
1782: FROM dual;
1783:
1784: --

Line 1990: INSERT INTO qa_plan_char_actions (

1986: CLOSE alert_cursor;
1987:
1988: END IF; -- the action id is 10, 11, 12, 13 (alert actions)
1989:
1990: INSERT INTO qa_plan_char_actions (
1991: plan_char_action_id,
1992: last_update_date,
1993: last_updated_by,
1994: creation_date,

Line 2254: DELETE FROM qa_plan_char_actions

2250: RETURN;
2251: END IF;
2252:
2253: FORALL i IN pcat_ids.FIRST .. pcat_ids.LAST
2254: DELETE FROM qa_plan_char_actions
2255: WHERE plan_char_action_trigger_id = pcat_ids(i)
2256: RETURNING plan_char_action_id BULK COLLECT INTO pca_ids;
2257:
2258: IF pca_ids.COUNT = 0 THEN

Line 2378: DELETE FROM qa_plan_char_actions

2374: --
2375: -- Now delete all children actions
2376: --
2377: FORALL i IN pcat_ids.FIRST .. pcat_ids.LAST
2378: DELETE FROM qa_plan_char_actions
2379: WHERE plan_char_action_trigger_id = pcat_ids(i)
2380: RETURNING plan_char_action_id BULK COLLECT INTO pca_ids;
2381:
2382: IF pca_ids.COUNT = 0 THEN