[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' ||
344: collection plans.
345: */
346: FOR pt IN (
347: SELECT qpt.plan_transaction_id
348: FROM qa_plan_transactions qpt, qa_plans qp
349: WHERE qpt.transaction_number = p_txn_number
350: AND qpt.plan_id = qp.plan_id
351: AND qp.organization_id = p_org_id
352: AND trunc(sysdate) between
621:
622: elements := result_to_array(p_context_values);
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' ||
681:
682: CURSOR c1(txn_no number, org_id number, col_id number) is
683: SELECT DISTINCT qpt.plan_id plan_id,
684: qpt.plan_transaction_id plan_txn_id
685: FROM qa_plan_transactions qpt, qa_plans qp
686: WHERE qpt.transaction_number = txn_no
687: AND qpt.plan_id = qp.plan_id
688: AND qp.organization_id = org_id
689: AND trunc(sysdate) between
996: FROM DUAL;
997:
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