[Home] [Help]
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
27: qp.organization_id = p_org_id AND
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
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
738: ) RETURN VARCHAR2 IS
739: TYPE ref_cursor IS REF CURSOR;
740: c ref_cursor;
741: s VARCHAR2(1000);
742: l_name qa_plans.name%TYPE;
743: l_names VARCHAR2(20000) DEFAULT NULL;
744: BEGIN
745:
746: -- Bug 4270911. CU2 SQL Literal fix. TD #22
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'' ) ';
756:
757: OPEN c FOR s;
1230: l_plans number_tab;
1231:
1232: -- Bug 5161719. SHKALYAN 13-Apr-2006
1233: -- this array is needed for storing parent plan names for the message
1234: TYPE plan_name_tab IS TABLE OF qa_plans.name%TYPE INDEX BY BINARY_INTEGER;
1235: l_plan_names plan_name_tab;
1236:
1237: l_occurrences number_tab;
1238:
1325: l_plans,
1326: l_plan_names,
1327: l_occurrences
1328: FROM QA_RESULTS QR,
1329: QA_PLANS QP
1330: WHERE QP.plan_id = QR.plan_id
1331: AND QR.collection_id = p_collection_id;
1332:
1333: -- Bug 4343758. OA Framework Integration project.