DBA Data[Home] [Help]

APPS.QA_PLANS_PUB dependencies on QA_PLAN_COLLECTION_TRIGGERS

Line 2231: FROM qa_plan_collection_triggers

2227: low_value,
2228: low_value_id,
2229: high_value,
2230: high_value_id
2231: FROM qa_plan_collection_triggers
2232: WHERE plan_transaction_id = x;
2233:
2234: BEGIN
2235:

Line 2269: INSERT INTO qa_plan_collection_triggers (

2265: qpt.enabled_flag);
2266:
2267: FOR qpct IN txn_trigger_cursor(qpt.plan_transaction_id) LOOP
2268:
2269: INSERT INTO qa_plan_collection_triggers (
2270: txn_trigger_id,
2271: last_update_date,
2272: last_updated_by,
2273: creation_date,

Line 2480: DELETE FROM qa_plan_collection_triggers

2476: RETURN;
2477: END IF;
2478:
2479: FORALL i IN pt_ids.FIRST .. pt_ids.LAST
2480: DELETE FROM qa_plan_collection_triggers
2481: WHERE plan_transaction_id = pt_ids(i);
2482:
2483: END delete_plan_transactions;
2484: