DBA Data[Home] [Help]

APPS.QA_PLANS_PUB dependencies on QA_PLAN_COLLECTION_TRIGGERS

Line 2101: FROM qa_plan_collection_triggers

2097: low_value,
2098: low_value_id,
2099: high_value,
2100: high_value_id
2101: FROM qa_plan_collection_triggers
2102: WHERE plan_transaction_id = x;
2103:
2104: BEGIN
2105:

Line 2139: INSERT INTO qa_plan_collection_triggers (

2135: qpt.enabled_flag);
2136:
2137: FOR qpct IN txn_trigger_cursor(qpt.plan_transaction_id) LOOP
2138:
2139: INSERT INTO qa_plan_collection_triggers (
2140: txn_trigger_id,
2141: last_update_date,
2142: last_updated_by,
2143: creation_date,

Line 2350: DELETE FROM qa_plan_collection_triggers

2346: RETURN;
2347: END IF;
2348:
2349: FORALL i IN pt_ids.FIRST .. pt_ids.LAST
2350: DELETE FROM qa_plan_collection_triggers
2351: WHERE plan_transaction_id = pt_ids(i);
2352:
2353: END delete_plan_transactions;
2354: