DBA Data[Home] [Help]

APPS.QA_TXN_GRP dependencies on QA_PERFORMANCE_TEMP_PKG

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 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 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 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.