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