APPS.QA_TXN_GRP dependencies on QA_PERFORMANCE_TEMP

Line 89: qa_performance_temp_pkg.purge_and_add_ids('QAGTXNB.COMMIT_ALLOWED', p_plan_txn_ids);

85: -- Add p_plan_txn_ds into temp table and rewrite the
86: -- query to select the id from it.
87: -- srhariha. Mon Apr 18 03:52:46 PDT 2005.
88:
89: qa_performance_temp_pkg.purge_and_add_ids('QAGTXNB.COMMIT_ALLOWED', p_plan_txn_ids);
90:
91:
92: select_stmt :=
93: 'SELECT DISTINCT qpt.plan_id' ||

Line 96: '( SELECT id FROM qa_performance_temp ' ||

92: select_stmt :=
93: 'SELECT DISTINCT qpt.plan_id' ||
94: ' FROM qa_plan_transactions qpt' ||
95: ' WHERE qpt.plan_transaction_id IN ' ||
96: '( SELECT id FROM qa_performance_temp ' ||
97: ' WHERE key=''QAGTXNB.COMMIT_ALLOWED'' ) '||
98: ' AND qpt.enabled_flag = 1' ||
99: ' AND qpt.mandatory_collection_flag = 1' ||
100: ' AND qpt.background_collection_flag = 2' ||

Line 620: qa_performance_temp_pkg.purge_and_add_ids('QAGTXNB.POST_BACKGROUND_RESULTS', p_plan_txn_ids);

616: -- Add p_plan_txn_ds into temp table and rewrite the
617: -- query to select the id from it.
618: -- srhariha. Mon Apr 18 03:52:46 PDT 2005.
619:
620: qa_performance_temp_pkg.purge_and_add_ids('QAGTXNB.POST_BACKGROUND_RESULTS', p_plan_txn_ids);
621:
622: elements := result_to_array(p_context_values);
623: select_stmt :=
624: 'SELECT DISTINCT qpt.plan_id' ||

Line 627: '( SELECT id FROM qa_performance_temp ' ||

623: select_stmt :=
624: 'SELECT DISTINCT qpt.plan_id' ||
625: ' FROM qa_plan_transactions qpt' ||
626: ' WHERE qpt.plan_transaction_id IN ' ||
627: '( SELECT id FROM qa_performance_temp ' ||
628: ' WHERE key=''QAGTXNB.POST_BACKGROUND_RESULTS'' ) '||
629: ' AND qpt.enabled_flag = 1' ||
630: ' AND qpt.background_collection_flag = 1' ||
631: ' AND NOT EXISTS ' ||

Line 751: qa_performance_temp_pkg.purge_and_add_ids('QAGTXNB.GET_PLAN_NAMES', p_plan_ids);

747: -- Add p_plan_ids into temp table and rewrite the
748: -- query to select the id from it.
749: -- srhariha. Mon Apr 18 03:52:46 PDT 2005.
750:
751: qa_performance_temp_pkg.purge_and_add_ids('QAGTXNB.GET_PLAN_NAMES', p_plan_ids);
752:
753: s := 'SELECT name FROM qa_plans WHERE plan_id IN ' ||
754: '( SELECT id FROM qa_performance_temp ' ||
755: ' WHERE key=''QAGTXNB.GET_PLAN_NAMES'' ) ';

Line 754: '( SELECT id FROM qa_performance_temp ' ||

750:
751: qa_performance_temp_pkg.purge_and_add_ids('QAGTXNB.GET_PLAN_NAMES', p_plan_ids);
752:
753: s := 'SELECT name FROM qa_plans WHERE plan_id IN ' ||
754: '( SELECT id FROM qa_performance_temp ' ||
755: ' WHERE key=''QAGTXNB.GET_PLAN_NAMES'' ) ';
756:
757: OPEN c FOR s;
758: LOOP

Line 1002: ( SELECT id FROM qa_performance_temp

998: CURSOR C2(c_collection_id NUMBER) IS
999: SELECT DISTINCT qpt.plan_id
1000: FROM qa_plan_transactions qpt
1001: WHERE qpt.plan_transaction_id IN
1002: ( SELECT id FROM qa_performance_temp
1003: WHERE key='QAGTXNB.SSQR_POST_BACKGROUND_RESULTS' )
1004: AND qpt.enabled_flag = 1
1005: AND qpt.background_collection_flag = 1
1006: AND NOT EXISTS (SELECT 1

Line 1025: qa_performance_temp_pkg.purge_and_add_ids('QAGTXNB.SSQR_POST_BACKGROUND_RESULTS', p_plan_txn_ids);

1021: BEGIN
1022:
1023: IF p_plan_txn_ids is NOT NULL then
1024:
1025: qa_performance_temp_pkg.purge_and_add_ids('QAGTXNB.SSQR_POST_BACKGROUND_RESULTS', p_plan_txn_ids);
1026:
1027: elements := result_to_array(p_context_values);
1028:
1029: -- Bug 4343758. OA Framework Integration.