eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.QA_PLANS_PUB dependencies on QA_PLAN_TRANSACTIONS

Line 2211: FROM qa_plan_transactions

2207: transaction_number,
2208: mandatory_collection_flag,
2209: background_collection_flag,
2210: enabled_flag
2211: FROM qa_plan_transactions
2212: WHERE plan_id = p_copy_from_plan_id;
2213:
2214: l_plan_transaction_id NUMBER;
2215:

Line 2238: SELECT qa_plan_transactions_s.nextval

2234: BEGIN
2235:
2236: FOR qpt IN txn_cursor LOOP
2237:
2238: SELECT qa_plan_transactions_s.nextval
2239: INTO l_plan_transaction_id
2240: FROM dual;
2241:
2242: INSERT INTO qa_plan_transactions (

Line 2242: INSERT INTO qa_plan_transactions (

2238: SELECT qa_plan_transactions_s.nextval
2239: INTO l_plan_transaction_id
2240: FROM dual;
2241:
2242: INSERT INTO qa_plan_transactions (
2243: plan_transaction_id,
2244: last_update_date,
2245: last_updated_by,
2246: creation_date,

Line 2471: DELETE FROM qa_plan_transactions

2467: pt_ids number_tab;
2468:
2469: BEGIN
2470:
2471: DELETE FROM qa_plan_transactions
2472: WHERE plan_id = p_plan_id
2473: RETURNING plan_transaction_id BULK COLLECT INTO pt_ids;
2474:
2475: IF pt_ids.COUNT = 0 THEN