[Home] [Help]
419: FETCH results_cur bulk collect INTO results_tab;
420: CLOSE results_cur;
421:
422: FOR cntr IN 1..results_tab.COUNT LOOP
423: UPDATE qa_pc_results_relationship
424: SET child_txn_header_id = results_tab(cntr).txn_header_id
425: WHERE child_plan_id = results_tab(cntr).plan_id
426: AND child_collection_id = results_tab(cntr).collection_id
427: AND child_occurrence = results_tab(cntr).occurrence;
454: CURSOR all_plan_cur IS
455: SELECT distinct qr.plan_id
456: FROM qa_results qr
457: WHERE qr.collection_id = p_collection_id AND
458: NOT EXISTS (SELECT 1 FROM qa_pc_results_relationship qprr
459: WHERE qprr.child_plan_id = qr.plan_id AND
460: qprr.child_collection_id = qr.collection_id AND
461: qprr.child_occurrence = qr.occurrence);
462:
620: -- grandchild.. records
621:
622: -- bug 14134055
623: -- Call the API to sync up the txn header ids in
624: -- qa_pc_results_relationship table
625: --
626: sync_child_txn_hdr_id(p_txn_header_id);
627:
628: -- Bug 3128040 rponnusa Thu Sep 4 05:52:20 PDT 2003
750: parent_plan_id,
751: parent_collection_id,
752: parent_occurrence,
753: level levels
754: FROM qa_pc_results_relationship r
755: START WITH r.parent_plan_id = p_plan_id AND
756: r.parent_collection_id = p_collection_id
757: CONNECT BY PRIOR r.child_occurrence = r.parent_occurrence
758: ORDER BY levels, parent_occurrence, child_occurrence;
766: -- bso Tue Mar 28 12:59:39 PST 2006
767: --
768:
769: -- Bug 3283794. Modified dde_cur to select from
770: -- qa_pc_results_relationship_v. rponnusa Thu Dec 18 21:28:55 PST 2003
771:
772: /* CURSOR dde_cur IS
773: SELECT 0 child_plan_id,
774: 0 child_collection_id,
787: parent_plan_id,
788: parent_collection_id,
789: parent_occurrence,
790: level levels
791: FROM qa_pc_results_relationship_v r
792: WHERE r.child_txn_header_id = p_txn_header_id
793: START WITH r.parent_plan_id = p_plan_id
794: CONNECT BY PRIOR r.child_occurrence = r.parent_occurrence
795: ORDER BY levels; */
794: CONNECT BY PRIOR r.child_occurrence = r.parent_occurrence
795: ORDER BY levels; */
796:
797: -- Bug 3578477. Above commented CURSOR is not compatible with Oracle 8i
798: -- To make it compatible removed the call to view qa_pc_results_relationship_v
799: -- and replaced it with qa_pc_results_relationship table and changed the
800: -- where condition of second select query.
801: -- saugupta Tue, 20 Apr 2004 04:09:30 -0700 PDT
802:
795: ORDER BY levels; */
796:
797: -- Bug 3578477. Above commented CURSOR is not compatible with Oracle 8i
798: -- To make it compatible removed the call to view qa_pc_results_relationship_v
799: -- and replaced it with qa_pc_results_relationship table and changed the
800: -- where condition of second select query.
801: -- saugupta Tue, 20 Apr 2004 04:09:30 -0700 PDT
802:
803: --
828: parent_plan_id,
829: parent_collection_id,
830: parent_occurrence,
831: level levels
832: FROM qa_pc_results_relationship r
833: WHERE p_txn_header_id =
834: (SELECT qr.txn_header_id
835: FROM qa_results qr
836: WHERE qr.plan_id = r.child_plan_id and
888: parent_collection_id,
889: parent_occurrence,
890: level levels,
891: child_txn_header_id
892: FROM qa_pc_results_relationship r
893: START WITH r.parent_plan_id = p_plan_id
894: CONNECT BY PRIOR r.child_occurrence = r.parent_occurrence)
895: WHERE child_txn_header_id = p_txn_header_id
896: ORDER BY levels, parent_occurrence, child_occurrence;
2584: CURSOR enabled_child_cur IS
2585: SELECT child_plan_id, child_collection_id, child_occurrence,
2586: parent_plan_id, parent_collection_id, parent_occurrence,
2587: level
2588: FROM qa_pc_results_relationship r
2589: WHERE EXISTS (
2590: SELECT 1
2591: FROM qa_results qr
2592: WHERE qr.plan_id = r.child_plan_id AND
2887: FROM qa_results qr
2888: WHERE qr.collection_id = p_collection_id
2889: AND NOT EXISTS
2890: (SELECT 1
2891: FROM qa_pc_results_relationship qprr
2892: WHERE qprr.child_plan_id = qr.plan_id
2893: AND qprr.child_collection_id = qr.collection_id
2894: AND qprr.child_occurrence = qr.occurrence);
2895: