[Home] [Help]
18: dummy BOOLEAN;
19:
20: CURSOR txn_plans IS
21: SELECT /*+ ordered use_nl(qp) */ qpt.plan_transaction_id
22: FROM qa_plan_transactions qpt,
23: qa_plans qp
24: WHERE qpt.transaction_number = p_txn_number AND
25: qpt.plan_id = qp.plan_id AND
26: qpt.enabled_flag = 1 AND
90:
91:
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' ||
379: collection plans.
380: */
381: FOR pt IN (
382: SELECT qpt.plan_transaction_id
383: FROM qa_plan_transactions qpt, qa_plans qp
384: WHERE qpt.transaction_number = p_txn_number
385: AND qpt.plan_id = qp.plan_id
386: AND qp.organization_id = p_org_id
387: AND trunc(sysdate) between
656:
657: elements := result_to_array(p_context_values);
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' ||
716:
717: CURSOR c1(txn_no number, org_id number, col_id number) is
718: SELECT DISTINCT qpt.plan_id plan_id,
719: qpt.plan_transaction_id plan_txn_id
720: FROM qa_plan_transactions qpt, qa_plans qp
721: WHERE qpt.transaction_number = txn_no
722: AND qpt.plan_id = qp.plan_id
723: AND qp.organization_id = org_id
724: AND trunc(sysdate) between
1031: FROM DUAL;
1032:
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