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 655: qa_performance_temp_pkg.purge_and_add_ids('QAGTXNB.POST_BACKGROUND_RESULTS', p_plan_txn_ids);

651: -- Add p_plan_txn_ds into temp table and rewrite the
652: -- query to select the id from it.
653: -- srhariha. Mon Apr 18 03:52:46 PDT 2005.
654:
655: qa_performance_temp_pkg.purge_and_add_ids('QAGTXNB.POST_BACKGROUND_RESULTS', p_plan_txn_ids);
656:
657: elements := result_to_array(p_context_values);
658: select_stmt :=
659: 'SELECT DISTINCT qpt.plan_id' ||

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

658: select_stmt :=
659: 'SELECT DISTINCT qpt.plan_id' ||
660: ' FROM qa_plan_transactions qpt' ||
661: ' WHERE qpt.plan_transaction_id IN ' ||
662: '( SELECT id FROM qa_performance_temp ' ||
663: ' WHERE key=''QAGTXNB.POST_BACKGROUND_RESULTS'' ) '||
664: ' AND qpt.enabled_flag = 1' ||
665: ' AND qpt.background_collection_flag = 1' ||
666: ' AND NOT EXISTS ' ||

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

782: -- Add p_plan_ids into temp table and rewrite the
783: -- query to select the id from it.
784: -- srhariha. Mon Apr 18 03:52:46 PDT 2005.
785:
786: qa_performance_temp_pkg.purge_and_add_ids('QAGTXNB.GET_PLAN_NAMES', p_plan_ids);
787:
788: s := 'SELECT name FROM qa_plans WHERE plan_id IN ' ||
789: '( SELECT id FROM qa_performance_temp ' ||
790: ' WHERE key=''QAGTXNB.GET_PLAN_NAMES'' ) ';

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

785:
786: qa_performance_temp_pkg.purge_and_add_ids('QAGTXNB.GET_PLAN_NAMES', p_plan_ids);
787:
788: s := 'SELECT name FROM qa_plans WHERE plan_id IN ' ||
789: '( SELECT id FROM qa_performance_temp ' ||
790: ' WHERE key=''QAGTXNB.GET_PLAN_NAMES'' ) ';
791:
792: OPEN c FOR s;
793: LOOP

Line 1037: ( SELECT id FROM qa_performance_temp

1033: CURSOR C2(c_collection_id NUMBER) IS
1034: SELECT DISTINCT qpt.plan_id
1035: FROM qa_plan_transactions qpt
1036: WHERE qpt.plan_transaction_id IN
1037: ( SELECT id FROM qa_performance_temp
1038: WHERE key='QAGTXNB.SSQR_POST_BACKGROUND_RESULTS' )
1039: AND qpt.enabled_flag = 1
1040: AND qpt.background_collection_flag = 1
1041: AND NOT EXISTS (SELECT 1

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

1056: BEGIN
1057:
1058: IF p_plan_txn_ids is NOT NULL then
1059:
1060: qa_performance_temp_pkg.purge_and_add_ids('QAGTXNB.SSQR_POST_BACKGROUND_RESULTS', p_plan_txn_ids);
1061:
1062: elements := result_to_array(p_context_values);
1063:
1064: -- Bug 4343758. OA Framework Integration.