[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
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
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
773: ) RETURN VARCHAR2 IS
774: TYPE ref_cursor IS REF CURSOR;
775: c ref_cursor;
776: s VARCHAR2(1000);
777: l_name qa_plans.name%TYPE;
778: l_names VARCHAR2(20000) DEFAULT NULL;
779: BEGIN
780:
781: -- Bug 4270911. CU2 SQL Literal fix. TD #22
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'' ) ';
791:
792: OPEN c FOR s;
1268: l_plans number_tab;
1269:
1270: -- Bug 5161719. SHKALYAN 13-Apr-2006
1271: -- this array is needed for storing parent plan names for the message
1272: TYPE plan_name_tab IS TABLE OF qa_plans.name%TYPE INDEX BY BINARY_INTEGER;
1273: l_plan_names plan_name_tab;
1274:
1275: l_occurrences number_tab;
1276:
1363: l_plans,
1364: l_plan_names,
1365: l_occurrences
1366: FROM QA_RESULTS QR,
1367: QA_PLANS QP
1368: WHERE QP.plan_id = QR.plan_id
1369: AND QR.collection_id = p_collection_id;
1370:
1371: -- Bug 4343758. OA Framework Integration project.