APPS.QA_PLANS_PUB dependencies on QA_PLAN_TRANSACTIONS

Line 2081: FROM qa_plan_transactions

2077: transaction_number,
2078: mandatory_collection_flag,
2079: background_collection_flag,
2080: enabled_flag
2081: FROM qa_plan_transactions
2082: WHERE plan_id = p_copy_from_plan_id;
2083:
2084: l_plan_transaction_id NUMBER;
2085:

Line 2108: SELECT qa_plan_transactions_s.nextval

2104: BEGIN
2105:
2106: FOR qpt IN txn_cursor LOOP
2107:
2108: SELECT qa_plan_transactions_s.nextval
2109: INTO l_plan_transaction_id
2110: FROM dual;
2111:
2112: INSERT INTO qa_plan_transactions (

Line 2112: INSERT INTO qa_plan_transactions (

2108: SELECT qa_plan_transactions_s.nextval
2109: INTO l_plan_transaction_id
2110: FROM dual;
2111:
2112: INSERT INTO qa_plan_transactions (
2113: plan_transaction_id,
2114: last_update_date,
2115: last_updated_by,
2116: creation_date,

Line 2341: DELETE FROM qa_plan_transactions

2337: pt_ids number_tab;
2338:
2339: BEGIN
2340:
2341: DELETE FROM qa_plan_transactions
2342: WHERE plan_id = p_plan_id
2343: RETURNING plan_transaction_id BULK COLLECT INTO pt_ids;
2344:
2345: IF pt_ids.COUNT = 0 THEN