eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_AK_MAPPING_API dependencies on QA_SS_CONST

Line 20: AND transaction_number = qa_ss_const.ss_outside_processing_txn

16: CURSOR c IS
17: SELECT 1
18: FROM qa_plan_transactions
19: WHERE plan_id = p_plan_id
20: AND transaction_number = qa_ss_const.ss_outside_processing_txn
21: AND enabled_flag = 1;
22:
23: BEGIN
24:

Line 48: AND transaction_number = qa_ss_const.ss_shipments_txn

44: CURSOR c IS
45: SELECT 1
46: FROM qa_plan_transactions
47: WHERE plan_id = p_plan_id
48: AND transaction_number = qa_ss_const.ss_shipments_txn
49: AND enabled_flag = 1;
50:
51: BEGIN
52:

Line 77: qa_ss_const.sales_order)) THEN

73: -- by checking if sales order is a part of the plan
74: -- and enabled.
75:
76: IF (qa_plan_element_api.element_in_plan(p_plan_id,
77: qa_ss_const.sales_order)) THEN
78: RETURN TRUE;
79: ELSE
80: RETURN FALSE;
81: END IF;

Line 434: l_txn_number := qa_ss_const.ss_outside_processing_txn;

430: -- of them it should be text input. This distiction is made here.
431:
432:
433: IF (p_appendix = g_txn_osp_appendix) THEN
434: l_txn_number := qa_ss_const.ss_outside_processing_txn;
435:
436: ELSIF (p_appendix = g_txn_ship_appendix) THEN
437: l_txn_number := qa_ss_const.ss_shipments_txn;
438:

Line 437: l_txn_number := qa_ss_const.ss_shipments_txn;

433: IF (p_appendix = g_txn_osp_appendix) THEN
434: l_txn_number := qa_ss_const.ss_outside_processing_txn;
435:
436: ELSIF (p_appendix = g_txn_ship_appendix) THEN
437: l_txn_number := qa_ss_const.ss_shipments_txn;
438:
439: ELSIF (p_appendix = g_txn_work_appendix) THEN
440: l_txn_number := 31;
441:

Line 494: l_txn_number := qa_ss_const.ss_outside_processing_txn;

490: END IF;
491:
492: IF ( instr(p_appendix, g_osp_vqr_appendix) <> 0 ) THEN
493: -- appendix passed has 'QAVQROSP' in it
494: l_txn_number := qa_ss_const.ss_outside_processing_txn;
495:
496: ELSIF ( instr(p_appendix, g_ship_vqr_appendix) <> 0 ) THEN
497: -- appendix passed has 'QAVQRSHP' in it
498: l_txn_number := qa_ss_const.ss_shipments_txn;

Line 498: l_txn_number := qa_ss_const.ss_shipments_txn;

494: l_txn_number := qa_ss_const.ss_outside_processing_txn;
495:
496: ELSIF ( instr(p_appendix, g_ship_vqr_appendix) <> 0 ) THEN
497: -- appendix passed has 'QAVQRSHP' in it
498: l_txn_number := qa_ss_const.ss_shipments_txn;
499:
500: ELSIF ( instr(p_appendix, g_work_vqr_appendix) <> 0 ) THEN
501: -- appendix passed has 'QAVQRWORK' in it
502: l_txn_number := 31;

Line 600: IF p_char_id = qa_ss_const.item THEN

596: -- OUT table structure.
597:
598: x_parents.delete();
599:
600: IF p_char_id = qa_ss_const.item THEN
601: x_parents(1) := qa_ss_const.production_line;
602:
603: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
604: x_parents(1) := qa_ss_const.job_name;

Line 601: x_parents(1) := qa_ss_const.production_line;

597:
598: x_parents.delete();
599:
600: IF p_char_id = qa_ss_const.item THEN
601: x_parents(1) := qa_ss_const.production_line;
602:
603: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
604: x_parents(1) := qa_ss_const.job_name;
605: x_parents(2) := qa_ss_const.production_line;

Line 603: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN

599:
600: IF p_char_id = qa_ss_const.item THEN
601: x_parents(1) := qa_ss_const.production_line;
602:
603: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
604: x_parents(1) := qa_ss_const.job_name;
605: x_parents(2) := qa_ss_const.production_line;
606:
607: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN

Line 604: x_parents(1) := qa_ss_const.job_name;

600: IF p_char_id = qa_ss_const.item THEN
601: x_parents(1) := qa_ss_const.production_line;
602:
603: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
604: x_parents(1) := qa_ss_const.job_name;
605: x_parents(2) := qa_ss_const.production_line;
606:
607: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
608: x_parents(1) := qa_ss_const.job_name;

Line 605: x_parents(2) := qa_ss_const.production_line;

601: x_parents(1) := qa_ss_const.production_line;
602:
603: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
604: x_parents(1) := qa_ss_const.job_name;
605: x_parents(2) := qa_ss_const.production_line;
606:
607: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
608: x_parents(1) := qa_ss_const.job_name;
609: x_parents(2) := qa_ss_const.production_line;

Line 607: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN

603: ELSIF p_char_id = qa_ss_const.to_op_seq_num THEN
604: x_parents(1) := qa_ss_const.job_name;
605: x_parents(2) := qa_ss_const.production_line;
606:
607: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
608: x_parents(1) := qa_ss_const.job_name;
609: x_parents(2) := qa_ss_const.production_line;
610:
611: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN

Line 608: x_parents(1) := qa_ss_const.job_name;

604: x_parents(1) := qa_ss_const.job_name;
605: x_parents(2) := qa_ss_const.production_line;
606:
607: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
608: x_parents(1) := qa_ss_const.job_name;
609: x_parents(2) := qa_ss_const.production_line;
610:
611: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
612: x_parents(1) := qa_ss_const.to_op_seq_num;

Line 609: x_parents(2) := qa_ss_const.production_line;

605: x_parents(2) := qa_ss_const.production_line;
606:
607: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
608: x_parents(1) := qa_ss_const.job_name;
609: x_parents(2) := qa_ss_const.production_line;
610:
611: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
612: x_parents(1) := qa_ss_const.to_op_seq_num;
613:

Line 611: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN

607: ELSIF p_char_id = qa_ss_const.from_op_seq_num THEN
608: x_parents(1) := qa_ss_const.job_name;
609: x_parents(2) := qa_ss_const.production_line;
610:
611: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
612: x_parents(1) := qa_ss_const.to_op_seq_num;
613:
614: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
615: x_parents(1) := qa_ss_const.from_op_seq_num;

Line 612: x_parents(1) := qa_ss_const.to_op_seq_num;

608: x_parents(1) := qa_ss_const.job_name;
609: x_parents(2) := qa_ss_const.production_line;
610:
611: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
612: x_parents(1) := qa_ss_const.to_op_seq_num;
613:
614: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
615: x_parents(1) := qa_ss_const.from_op_seq_num;
616:

Line 614: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN

610:
611: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
612: x_parents(1) := qa_ss_const.to_op_seq_num;
613:
614: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
615: x_parents(1) := qa_ss_const.from_op_seq_num;
616:
617: ELSIF p_char_id = qa_ss_const.uom THEN
618:

Line 615: x_parents(1) := qa_ss_const.from_op_seq_num;

611: ELSIF p_char_id = qa_ss_const.to_intraoperation_step THEN
612: x_parents(1) := qa_ss_const.to_op_seq_num;
613:
614: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
615: x_parents(1) := qa_ss_const.from_op_seq_num;
616:
617: ELSIF p_char_id = qa_ss_const.uom THEN
618:
619: x_parents(1) := qa_ss_const.item;

Line 617: ELSIF p_char_id = qa_ss_const.uom THEN

613:
614: ELSIF p_char_id = qa_ss_const.from_intraoperation_step THEN
615: x_parents(1) := qa_ss_const.from_op_seq_num;
616:
617: ELSIF p_char_id = qa_ss_const.uom THEN
618:
619: x_parents(1) := qa_ss_const.item;
620: x_parents(2) := qa_ss_const.production_line;
621:

Line 619: x_parents(1) := qa_ss_const.item;

615: x_parents(1) := qa_ss_const.from_op_seq_num;
616:
617: ELSIF p_char_id = qa_ss_const.uom THEN
618:
619: x_parents(1) := qa_ss_const.item;
620: x_parents(2) := qa_ss_const.production_line;
621:
622: ELSIF p_char_id = qa_ss_const.revision THEN
623: x_parents(1) := qa_ss_const.item;

Line 620: x_parents(2) := qa_ss_const.production_line;

616:
617: ELSIF p_char_id = qa_ss_const.uom THEN
618:
619: x_parents(1) := qa_ss_const.item;
620: x_parents(2) := qa_ss_const.production_line;
621:
622: ELSIF p_char_id = qa_ss_const.revision THEN
623: x_parents(1) := qa_ss_const.item;
624: x_parents(2) := qa_ss_const.production_line;

Line 622: ELSIF p_char_id = qa_ss_const.revision THEN

618:
619: x_parents(1) := qa_ss_const.item;
620: x_parents(2) := qa_ss_const.production_line;
621:
622: ELSIF p_char_id = qa_ss_const.revision THEN
623: x_parents(1) := qa_ss_const.item;
624: x_parents(2) := qa_ss_const.production_line;
625:
626: ELSIF p_char_id = qa_ss_const.subinventory THEN

Line 623: x_parents(1) := qa_ss_const.item;

619: x_parents(1) := qa_ss_const.item;
620: x_parents(2) := qa_ss_const.production_line;
621:
622: ELSIF p_char_id = qa_ss_const.revision THEN
623: x_parents(1) := qa_ss_const.item;
624: x_parents(2) := qa_ss_const.production_line;
625:
626: ELSIF p_char_id = qa_ss_const.subinventory THEN
627: x_parents(1) := qa_ss_const.item;

Line 624: x_parents(2) := qa_ss_const.production_line;

620: x_parents(2) := qa_ss_const.production_line;
621:
622: ELSIF p_char_id = qa_ss_const.revision THEN
623: x_parents(1) := qa_ss_const.item;
624: x_parents(2) := qa_ss_const.production_line;
625:
626: ELSIF p_char_id = qa_ss_const.subinventory THEN
627: x_parents(1) := qa_ss_const.item;
628: x_parents(2) := qa_ss_const.production_line;

Line 626: ELSIF p_char_id = qa_ss_const.subinventory THEN

622: ELSIF p_char_id = qa_ss_const.revision THEN
623: x_parents(1) := qa_ss_const.item;
624: x_parents(2) := qa_ss_const.production_line;
625:
626: ELSIF p_char_id = qa_ss_const.subinventory THEN
627: x_parents(1) := qa_ss_const.item;
628: x_parents(2) := qa_ss_const.production_line;
629:
630: ELSIF p_char_id = qa_ss_const.locator THEN

Line 627: x_parents(1) := qa_ss_const.item;

623: x_parents(1) := qa_ss_const.item;
624: x_parents(2) := qa_ss_const.production_line;
625:
626: ELSIF p_char_id = qa_ss_const.subinventory THEN
627: x_parents(1) := qa_ss_const.item;
628: x_parents(2) := qa_ss_const.production_line;
629:
630: ELSIF p_char_id = qa_ss_const.locator THEN
631: x_parents(1) := qa_ss_const.subinventory;

Line 628: x_parents(2) := qa_ss_const.production_line;

624: x_parents(2) := qa_ss_const.production_line;
625:
626: ELSIF p_char_id = qa_ss_const.subinventory THEN
627: x_parents(1) := qa_ss_const.item;
628: x_parents(2) := qa_ss_const.production_line;
629:
630: ELSIF p_char_id = qa_ss_const.locator THEN
631: x_parents(1) := qa_ss_const.subinventory;
632: x_parents(2) := qa_ss_const.item;

Line 630: ELSIF p_char_id = qa_ss_const.locator THEN

626: ELSIF p_char_id = qa_ss_const.subinventory THEN
627: x_parents(1) := qa_ss_const.item;
628: x_parents(2) := qa_ss_const.production_line;
629:
630: ELSIF p_char_id = qa_ss_const.locator THEN
631: x_parents(1) := qa_ss_const.subinventory;
632: x_parents(2) := qa_ss_const.item;
633: x_parents(3) := qa_ss_const.production_line;
634:

Line 631: x_parents(1) := qa_ss_const.subinventory;

627: x_parents(1) := qa_ss_const.item;
628: x_parents(2) := qa_ss_const.production_line;
629:
630: ELSIF p_char_id = qa_ss_const.locator THEN
631: x_parents(1) := qa_ss_const.subinventory;
632: x_parents(2) := qa_ss_const.item;
633: x_parents(3) := qa_ss_const.production_line;
634:
635: ELSIF p_char_id = qa_ss_const.lot_number THEN

Line 632: x_parents(2) := qa_ss_const.item;

628: x_parents(2) := qa_ss_const.production_line;
629:
630: ELSIF p_char_id = qa_ss_const.locator THEN
631: x_parents(1) := qa_ss_const.subinventory;
632: x_parents(2) := qa_ss_const.item;
633: x_parents(3) := qa_ss_const.production_line;
634:
635: ELSIF p_char_id = qa_ss_const.lot_number THEN
636: x_parents(1) := qa_ss_const.item;

Line 633: x_parents(3) := qa_ss_const.production_line;

629:
630: ELSIF p_char_id = qa_ss_const.locator THEN
631: x_parents(1) := qa_ss_const.subinventory;
632: x_parents(2) := qa_ss_const.item;
633: x_parents(3) := qa_ss_const.production_line;
634:
635: ELSIF p_char_id = qa_ss_const.lot_number THEN
636: x_parents(1) := qa_ss_const.item;
637: x_parents(2) := qa_ss_const.production_line;

Line 635: ELSIF p_char_id = qa_ss_const.lot_number THEN

631: x_parents(1) := qa_ss_const.subinventory;
632: x_parents(2) := qa_ss_const.item;
633: x_parents(3) := qa_ss_const.production_line;
634:
635: ELSIF p_char_id = qa_ss_const.lot_number THEN
636: x_parents(1) := qa_ss_const.item;
637: x_parents(2) := qa_ss_const.production_line;
638:
639: ELSIF p_char_id = qa_ss_const.serial_number THEN

Line 636: x_parents(1) := qa_ss_const.item;

632: x_parents(2) := qa_ss_const.item;
633: x_parents(3) := qa_ss_const.production_line;
634:
635: ELSIF p_char_id = qa_ss_const.lot_number THEN
636: x_parents(1) := qa_ss_const.item;
637: x_parents(2) := qa_ss_const.production_line;
638:
639: ELSIF p_char_id = qa_ss_const.serial_number THEN
640: x_parents(1) := qa_ss_const.lot_number;

Line 637: x_parents(2) := qa_ss_const.production_line;

633: x_parents(3) := qa_ss_const.production_line;
634:
635: ELSIF p_char_id = qa_ss_const.lot_number THEN
636: x_parents(1) := qa_ss_const.item;
637: x_parents(2) := qa_ss_const.production_line;
638:
639: ELSIF p_char_id = qa_ss_const.serial_number THEN
640: x_parents(1) := qa_ss_const.lot_number;
641: x_parents(2) := qa_ss_const.item;

Line 639: ELSIF p_char_id = qa_ss_const.serial_number THEN

635: ELSIF p_char_id = qa_ss_const.lot_number THEN
636: x_parents(1) := qa_ss_const.item;
637: x_parents(2) := qa_ss_const.production_line;
638:
639: ELSIF p_char_id = qa_ss_const.serial_number THEN
640: x_parents(1) := qa_ss_const.lot_number;
641: x_parents(2) := qa_ss_const.item;
642: x_parents(3) := qa_ss_const.production_line;
643:

Line 640: x_parents(1) := qa_ss_const.lot_number;

636: x_parents(1) := qa_ss_const.item;
637: x_parents(2) := qa_ss_const.production_line;
638:
639: ELSIF p_char_id = qa_ss_const.serial_number THEN
640: x_parents(1) := qa_ss_const.lot_number;
641: x_parents(2) := qa_ss_const.item;
642: x_parents(3) := qa_ss_const.production_line;
643:
644: ELSIF p_char_id = qa_ss_const.comp_uom THEN

Line 641: x_parents(2) := qa_ss_const.item;

637: x_parents(2) := qa_ss_const.production_line;
638:
639: ELSIF p_char_id = qa_ss_const.serial_number THEN
640: x_parents(1) := qa_ss_const.lot_number;
641: x_parents(2) := qa_ss_const.item;
642: x_parents(3) := qa_ss_const.production_line;
643:
644: ELSIF p_char_id = qa_ss_const.comp_uom THEN
645: x_parents(1) := qa_ss_const.comp_item;

Line 642: x_parents(3) := qa_ss_const.production_line;

638:
639: ELSIF p_char_id = qa_ss_const.serial_number THEN
640: x_parents(1) := qa_ss_const.lot_number;
641: x_parents(2) := qa_ss_const.item;
642: x_parents(3) := qa_ss_const.production_line;
643:
644: ELSIF p_char_id = qa_ss_const.comp_uom THEN
645: x_parents(1) := qa_ss_const.comp_item;
646:

Line 644: ELSIF p_char_id = qa_ss_const.comp_uom THEN

640: x_parents(1) := qa_ss_const.lot_number;
641: x_parents(2) := qa_ss_const.item;
642: x_parents(3) := qa_ss_const.production_line;
643:
644: ELSIF p_char_id = qa_ss_const.comp_uom THEN
645: x_parents(1) := qa_ss_const.comp_item;
646:
647: ELSIF p_char_id = qa_ss_const.comp_revision THEN
648: x_parents(1) := qa_ss_const.comp_item;

Line 645: x_parents(1) := qa_ss_const.comp_item;

641: x_parents(2) := qa_ss_const.item;
642: x_parents(3) := qa_ss_const.production_line;
643:
644: ELSIF p_char_id = qa_ss_const.comp_uom THEN
645: x_parents(1) := qa_ss_const.comp_item;
646:
647: ELSIF p_char_id = qa_ss_const.comp_revision THEN
648: x_parents(1) := qa_ss_const.comp_item;
649:

Line 647: ELSIF p_char_id = qa_ss_const.comp_revision THEN

643:
644: ELSIF p_char_id = qa_ss_const.comp_uom THEN
645: x_parents(1) := qa_ss_const.comp_item;
646:
647: ELSIF p_char_id = qa_ss_const.comp_revision THEN
648: x_parents(1) := qa_ss_const.comp_item;
649:
650: ELSIF p_char_id = qa_ss_const.po_line_num THEN
651: x_parents(1) := qa_ss_const.po_number;

Line 648: x_parents(1) := qa_ss_const.comp_item;

644: ELSIF p_char_id = qa_ss_const.comp_uom THEN
645: x_parents(1) := qa_ss_const.comp_item;
646:
647: ELSIF p_char_id = qa_ss_const.comp_revision THEN
648: x_parents(1) := qa_ss_const.comp_item;
649:
650: ELSIF p_char_id = qa_ss_const.po_line_num THEN
651: x_parents(1) := qa_ss_const.po_number;
652:

Line 650: ELSIF p_char_id = qa_ss_const.po_line_num THEN

646:
647: ELSIF p_char_id = qa_ss_const.comp_revision THEN
648: x_parents(1) := qa_ss_const.comp_item;
649:
650: ELSIF p_char_id = qa_ss_const.po_line_num THEN
651: x_parents(1) := qa_ss_const.po_number;
652:
653: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
654: x_parents(1) := qa_ss_const.po_line_num;

Line 651: x_parents(1) := qa_ss_const.po_number;

647: ELSIF p_char_id = qa_ss_const.comp_revision THEN
648: x_parents(1) := qa_ss_const.comp_item;
649:
650: ELSIF p_char_id = qa_ss_const.po_line_num THEN
651: x_parents(1) := qa_ss_const.po_number;
652:
653: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
654: x_parents(1) := qa_ss_const.po_line_num;
655: x_parents(2) := qa_ss_const.po_number;

Line 653: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN

649:
650: ELSIF p_char_id = qa_ss_const.po_line_num THEN
651: x_parents(1) := qa_ss_const.po_number;
652:
653: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
654: x_parents(1) := qa_ss_const.po_line_num;
655: x_parents(2) := qa_ss_const.po_number;
656:
657: ELSIF p_char_id = qa_ss_const.po_release_num THEN

Line 654: x_parents(1) := qa_ss_const.po_line_num;

650: ELSIF p_char_id = qa_ss_const.po_line_num THEN
651: x_parents(1) := qa_ss_const.po_number;
652:
653: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
654: x_parents(1) := qa_ss_const.po_line_num;
655: x_parents(2) := qa_ss_const.po_number;
656:
657: ELSIF p_char_id = qa_ss_const.po_release_num THEN
658: x_parents(1) := qa_ss_const.po_number;

Line 655: x_parents(2) := qa_ss_const.po_number;

651: x_parents(1) := qa_ss_const.po_number;
652:
653: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
654: x_parents(1) := qa_ss_const.po_line_num;
655: x_parents(2) := qa_ss_const.po_number;
656:
657: ELSIF p_char_id = qa_ss_const.po_release_num THEN
658: x_parents(1) := qa_ss_const.po_number;
659:

Line 657: ELSIF p_char_id = qa_ss_const.po_release_num THEN

653: ELSIF p_char_id = qa_ss_const.po_shipment_num THEN
654: x_parents(1) := qa_ss_const.po_line_num;
655: x_parents(2) := qa_ss_const.po_number;
656:
657: ELSIF p_char_id = qa_ss_const.po_release_num THEN
658: x_parents(1) := qa_ss_const.po_number;
659:
660: ELSIF p_char_id = qa_ss_const.order_line THEN
661: x_parents(1) := qa_ss_const.sales_order;

Line 658: x_parents(1) := qa_ss_const.po_number;

654: x_parents(1) := qa_ss_const.po_line_num;
655: x_parents(2) := qa_ss_const.po_number;
656:
657: ELSIF p_char_id = qa_ss_const.po_release_num THEN
658: x_parents(1) := qa_ss_const.po_number;
659:
660: ELSIF p_char_id = qa_ss_const.order_line THEN
661: x_parents(1) := qa_ss_const.sales_order;
662:

Line 660: ELSIF p_char_id = qa_ss_const.order_line THEN

656:
657: ELSIF p_char_id = qa_ss_const.po_release_num THEN
658: x_parents(1) := qa_ss_const.po_number;
659:
660: ELSIF p_char_id = qa_ss_const.order_line THEN
661: x_parents(1) := qa_ss_const.sales_order;
662:
663: ELSIF p_char_id = qa_ss_const.task_number THEN
664: x_parents(1) := qa_ss_const.project_number;

Line 661: x_parents(1) := qa_ss_const.sales_order;

657: ELSIF p_char_id = qa_ss_const.po_release_num THEN
658: x_parents(1) := qa_ss_const.po_number;
659:
660: ELSIF p_char_id = qa_ss_const.order_line THEN
661: x_parents(1) := qa_ss_const.sales_order;
662:
663: ELSIF p_char_id = qa_ss_const.task_number THEN
664: x_parents(1) := qa_ss_const.project_number;
665:

Line 663: ELSIF p_char_id = qa_ss_const.task_number THEN

659:
660: ELSIF p_char_id = qa_ss_const.order_line THEN
661: x_parents(1) := qa_ss_const.sales_order;
662:
663: ELSIF p_char_id = qa_ss_const.task_number THEN
664: x_parents(1) := qa_ss_const.project_number;
665:
666: --dgupta: Start R12 EAM Integration. Bug 4345492
667: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN

Line 664: x_parents(1) := qa_ss_const.project_number;

660: ELSIF p_char_id = qa_ss_const.order_line THEN
661: x_parents(1) := qa_ss_const.sales_order;
662:
663: ELSIF p_char_id = qa_ss_const.task_number THEN
664: x_parents(1) := qa_ss_const.project_number;
665:
666: --dgupta: Start R12 EAM Integration. Bug 4345492
667: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
668: x_parents(1) := qa_ss_const.asset_group;

Line 667: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN

663: ELSIF p_char_id = qa_ss_const.task_number THEN
664: x_parents(1) := qa_ss_const.project_number;
665:
666: --dgupta: Start R12 EAM Integration. Bug 4345492
667: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
668: x_parents(1) := qa_ss_const.asset_group;
669: x_parents(2) := qa_ss_const.asset_number;
670:
671: ELSIF p_char_id = qa_ss_const.asset_number THEN

Line 668: x_parents(1) := qa_ss_const.asset_group;

664: x_parents(1) := qa_ss_const.project_number;
665:
666: --dgupta: Start R12 EAM Integration. Bug 4345492
667: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
668: x_parents(1) := qa_ss_const.asset_group;
669: x_parents(2) := qa_ss_const.asset_number;
670:
671: ELSIF p_char_id = qa_ss_const.asset_number THEN
672: x_parents(1) := qa_ss_const.asset_group;

Line 669: x_parents(2) := qa_ss_const.asset_number;

665:
666: --dgupta: Start R12 EAM Integration. Bug 4345492
667: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
668: x_parents(1) := qa_ss_const.asset_group;
669: x_parents(2) := qa_ss_const.asset_number;
670:
671: ELSIF p_char_id = qa_ss_const.asset_number THEN
672: x_parents(1) := qa_ss_const.asset_group;
673: x_parents(2) := qa_ss_const.asset_instance_number;

Line 671: ELSIF p_char_id = qa_ss_const.asset_number THEN

667: ELSIF p_char_id = qa_ss_const.asset_instance_number THEN
668: x_parents(1) := qa_ss_const.asset_group;
669: x_parents(2) := qa_ss_const.asset_number;
670:
671: ELSIF p_char_id = qa_ss_const.asset_number THEN
672: x_parents(1) := qa_ss_const.asset_group;
673: x_parents(2) := qa_ss_const.asset_instance_number;
674: --dgupta: End R12 EAM Integration. Bug 4345492
675:

Line 672: x_parents(1) := qa_ss_const.asset_group;

668: x_parents(1) := qa_ss_const.asset_group;
669: x_parents(2) := qa_ss_const.asset_number;
670:
671: ELSIF p_char_id = qa_ss_const.asset_number THEN
672: x_parents(1) := qa_ss_const.asset_group;
673: x_parents(2) := qa_ss_const.asset_instance_number;
674: --dgupta: End R12 EAM Integration. Bug 4345492
675:
676: END IF;

Line 673: x_parents(2) := qa_ss_const.asset_instance_number;

669: x_parents(2) := qa_ss_const.asset_number;
670:
671: ELSIF p_char_id = qa_ss_const.asset_number THEN
672: x_parents(1) := qa_ss_const.asset_group;
673: x_parents(2) := qa_ss_const.asset_instance_number;
674: --dgupta: End R12 EAM Integration. Bug 4345492
675:
676: END IF;
677: