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.QP_SOU_UTIL dependencies on FND_API

Line 11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM

7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type
13: , p_old_SOU_rec IN QP_Attr_Map_PUB.Sou_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_SOU_REC
15: , x_SOU_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Sou_Rec_Type

Line 30: IF p_attr_id = FND_API.G_MISS_NUM THEN

26:
27: -- If attr_id is missing compare old and new records and for
28: -- every changed attribute clear its dependent fields.
29:
30: IF p_attr_id = FND_API.G_MISS_NUM THEN
31:
32: IF NOT QP_GLOBALS.Equal(p_SOU_rec.attribute1,p_old_SOU_rec.attribute1)
33: THEN
34: l_index := l_index + 1;

Line 554: IF l_SOU_rec.attribute1 = FND_API.G_MISS_CHAR THEN

550: IS
551: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type := p_SOU_rec;
552: BEGIN
553:
554: IF l_SOU_rec.attribute1 = FND_API.G_MISS_CHAR THEN
555: l_SOU_rec.attribute1 := p_old_SOU_rec.attribute1;
556: END IF;
557:
558: IF l_SOU_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 558: IF l_SOU_rec.attribute10 = FND_API.G_MISS_CHAR THEN

554: IF l_SOU_rec.attribute1 = FND_API.G_MISS_CHAR THEN
555: l_SOU_rec.attribute1 := p_old_SOU_rec.attribute1;
556: END IF;
557:
558: IF l_SOU_rec.attribute10 = FND_API.G_MISS_CHAR THEN
559: l_SOU_rec.attribute10 := p_old_SOU_rec.attribute10;
560: END IF;
561:
562: IF l_SOU_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 562: IF l_SOU_rec.attribute11 = FND_API.G_MISS_CHAR THEN

558: IF l_SOU_rec.attribute10 = FND_API.G_MISS_CHAR THEN
559: l_SOU_rec.attribute10 := p_old_SOU_rec.attribute10;
560: END IF;
561:
562: IF l_SOU_rec.attribute11 = FND_API.G_MISS_CHAR THEN
563: l_SOU_rec.attribute11 := p_old_SOU_rec.attribute11;
564: END IF;
565:
566: IF l_SOU_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 566: IF l_SOU_rec.attribute12 = FND_API.G_MISS_CHAR THEN

562: IF l_SOU_rec.attribute11 = FND_API.G_MISS_CHAR THEN
563: l_SOU_rec.attribute11 := p_old_SOU_rec.attribute11;
564: END IF;
565:
566: IF l_SOU_rec.attribute12 = FND_API.G_MISS_CHAR THEN
567: l_SOU_rec.attribute12 := p_old_SOU_rec.attribute12;
568: END IF;
569:
570: IF l_SOU_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 570: IF l_SOU_rec.attribute13 = FND_API.G_MISS_CHAR THEN

566: IF l_SOU_rec.attribute12 = FND_API.G_MISS_CHAR THEN
567: l_SOU_rec.attribute12 := p_old_SOU_rec.attribute12;
568: END IF;
569:
570: IF l_SOU_rec.attribute13 = FND_API.G_MISS_CHAR THEN
571: l_SOU_rec.attribute13 := p_old_SOU_rec.attribute13;
572: END IF;
573:
574: IF l_SOU_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 574: IF l_SOU_rec.attribute14 = FND_API.G_MISS_CHAR THEN

570: IF l_SOU_rec.attribute13 = FND_API.G_MISS_CHAR THEN
571: l_SOU_rec.attribute13 := p_old_SOU_rec.attribute13;
572: END IF;
573:
574: IF l_SOU_rec.attribute14 = FND_API.G_MISS_CHAR THEN
575: l_SOU_rec.attribute14 := p_old_SOU_rec.attribute14;
576: END IF;
577:
578: IF l_SOU_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 578: IF l_SOU_rec.attribute15 = FND_API.G_MISS_CHAR THEN

574: IF l_SOU_rec.attribute14 = FND_API.G_MISS_CHAR THEN
575: l_SOU_rec.attribute14 := p_old_SOU_rec.attribute14;
576: END IF;
577:
578: IF l_SOU_rec.attribute15 = FND_API.G_MISS_CHAR THEN
579: l_SOU_rec.attribute15 := p_old_SOU_rec.attribute15;
580: END IF;
581:
582: IF l_SOU_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 582: IF l_SOU_rec.attribute2 = FND_API.G_MISS_CHAR THEN

578: IF l_SOU_rec.attribute15 = FND_API.G_MISS_CHAR THEN
579: l_SOU_rec.attribute15 := p_old_SOU_rec.attribute15;
580: END IF;
581:
582: IF l_SOU_rec.attribute2 = FND_API.G_MISS_CHAR THEN
583: l_SOU_rec.attribute2 := p_old_SOU_rec.attribute2;
584: END IF;
585:
586: IF l_SOU_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 586: IF l_SOU_rec.attribute3 = FND_API.G_MISS_CHAR THEN

582: IF l_SOU_rec.attribute2 = FND_API.G_MISS_CHAR THEN
583: l_SOU_rec.attribute2 := p_old_SOU_rec.attribute2;
584: END IF;
585:
586: IF l_SOU_rec.attribute3 = FND_API.G_MISS_CHAR THEN
587: l_SOU_rec.attribute3 := p_old_SOU_rec.attribute3;
588: END IF;
589:
590: IF l_SOU_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 590: IF l_SOU_rec.attribute4 = FND_API.G_MISS_CHAR THEN

586: IF l_SOU_rec.attribute3 = FND_API.G_MISS_CHAR THEN
587: l_SOU_rec.attribute3 := p_old_SOU_rec.attribute3;
588: END IF;
589:
590: IF l_SOU_rec.attribute4 = FND_API.G_MISS_CHAR THEN
591: l_SOU_rec.attribute4 := p_old_SOU_rec.attribute4;
592: END IF;
593:
594: IF l_SOU_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 594: IF l_SOU_rec.attribute5 = FND_API.G_MISS_CHAR THEN

590: IF l_SOU_rec.attribute4 = FND_API.G_MISS_CHAR THEN
591: l_SOU_rec.attribute4 := p_old_SOU_rec.attribute4;
592: END IF;
593:
594: IF l_SOU_rec.attribute5 = FND_API.G_MISS_CHAR THEN
595: l_SOU_rec.attribute5 := p_old_SOU_rec.attribute5;
596: END IF;
597:
598: IF l_SOU_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 598: IF l_SOU_rec.attribute6 = FND_API.G_MISS_CHAR THEN

594: IF l_SOU_rec.attribute5 = FND_API.G_MISS_CHAR THEN
595: l_SOU_rec.attribute5 := p_old_SOU_rec.attribute5;
596: END IF;
597:
598: IF l_SOU_rec.attribute6 = FND_API.G_MISS_CHAR THEN
599: l_SOU_rec.attribute6 := p_old_SOU_rec.attribute6;
600: END IF;
601:
602: IF l_SOU_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 602: IF l_SOU_rec.attribute7 = FND_API.G_MISS_CHAR THEN

598: IF l_SOU_rec.attribute6 = FND_API.G_MISS_CHAR THEN
599: l_SOU_rec.attribute6 := p_old_SOU_rec.attribute6;
600: END IF;
601:
602: IF l_SOU_rec.attribute7 = FND_API.G_MISS_CHAR THEN
603: l_SOU_rec.attribute7 := p_old_SOU_rec.attribute7;
604: END IF;
605:
606: IF l_SOU_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 606: IF l_SOU_rec.attribute8 = FND_API.G_MISS_CHAR THEN

602: IF l_SOU_rec.attribute7 = FND_API.G_MISS_CHAR THEN
603: l_SOU_rec.attribute7 := p_old_SOU_rec.attribute7;
604: END IF;
605:
606: IF l_SOU_rec.attribute8 = FND_API.G_MISS_CHAR THEN
607: l_SOU_rec.attribute8 := p_old_SOU_rec.attribute8;
608: END IF;
609:
610: IF l_SOU_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 610: IF l_SOU_rec.attribute9 = FND_API.G_MISS_CHAR THEN

606: IF l_SOU_rec.attribute8 = FND_API.G_MISS_CHAR THEN
607: l_SOU_rec.attribute8 := p_old_SOU_rec.attribute8;
608: END IF;
609:
610: IF l_SOU_rec.attribute9 = FND_API.G_MISS_CHAR THEN
611: l_SOU_rec.attribute9 := p_old_SOU_rec.attribute9;
612: END IF;
613:
614: IF l_SOU_rec.attribute_sourcing_id = FND_API.G_MISS_NUM THEN

Line 614: IF l_SOU_rec.attribute_sourcing_id = FND_API.G_MISS_NUM THEN

610: IF l_SOU_rec.attribute9 = FND_API.G_MISS_CHAR THEN
611: l_SOU_rec.attribute9 := p_old_SOU_rec.attribute9;
612: END IF;
613:
614: IF l_SOU_rec.attribute_sourcing_id = FND_API.G_MISS_NUM THEN
615: l_SOU_rec.attribute_sourcing_id := p_old_SOU_rec.attribute_sourcing_id;
616: END IF;
617:
618: IF l_SOU_rec.attribute_sourcing_level = FND_API.G_MISS_CHAR THEN

Line 618: IF l_SOU_rec.attribute_sourcing_level = FND_API.G_MISS_CHAR THEN

614: IF l_SOU_rec.attribute_sourcing_id = FND_API.G_MISS_NUM THEN
615: l_SOU_rec.attribute_sourcing_id := p_old_SOU_rec.attribute_sourcing_id;
616: END IF;
617:
618: IF l_SOU_rec.attribute_sourcing_level = FND_API.G_MISS_CHAR THEN
619: l_SOU_rec.attribute_sourcing_level := p_old_SOU_rec.attribute_sourcing_level;
620: END IF;
621:
622: IF l_SOU_rec.application_id = FND_API.G_MISS_NUM THEN

Line 622: IF l_SOU_rec.application_id = FND_API.G_MISS_NUM THEN

618: IF l_SOU_rec.attribute_sourcing_level = FND_API.G_MISS_CHAR THEN
619: l_SOU_rec.attribute_sourcing_level := p_old_SOU_rec.attribute_sourcing_level;
620: END IF;
621:
622: IF l_SOU_rec.application_id = FND_API.G_MISS_NUM THEN
623: l_SOU_rec.application_id := p_old_SOU_rec.application_id;
624: END IF;
625:
626: IF l_SOU_rec.context = FND_API.G_MISS_CHAR THEN

Line 626: IF l_SOU_rec.context = FND_API.G_MISS_CHAR THEN

622: IF l_SOU_rec.application_id = FND_API.G_MISS_NUM THEN
623: l_SOU_rec.application_id := p_old_SOU_rec.application_id;
624: END IF;
625:
626: IF l_SOU_rec.context = FND_API.G_MISS_CHAR THEN
627: l_SOU_rec.context := p_old_SOU_rec.context;
628: END IF;
629:
630: IF l_SOU_rec.created_by = FND_API.G_MISS_NUM THEN

Line 630: IF l_SOU_rec.created_by = FND_API.G_MISS_NUM THEN

626: IF l_SOU_rec.context = FND_API.G_MISS_CHAR THEN
627: l_SOU_rec.context := p_old_SOU_rec.context;
628: END IF;
629:
630: IF l_SOU_rec.created_by = FND_API.G_MISS_NUM THEN
631: l_SOU_rec.created_by := p_old_SOU_rec.created_by;
632: END IF;
633:
634: IF l_SOU_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 634: IF l_SOU_rec.creation_date = FND_API.G_MISS_DATE THEN

630: IF l_SOU_rec.created_by = FND_API.G_MISS_NUM THEN
631: l_SOU_rec.created_by := p_old_SOU_rec.created_by;
632: END IF;
633:
634: IF l_SOU_rec.creation_date = FND_API.G_MISS_DATE THEN
635: l_SOU_rec.creation_date := p_old_SOU_rec.creation_date;
636: END IF;
637:
638: IF l_SOU_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

Line 638: IF l_SOU_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

634: IF l_SOU_rec.creation_date = FND_API.G_MISS_DATE THEN
635: l_SOU_rec.creation_date := p_old_SOU_rec.creation_date;
636: END IF;
637:
638: IF l_SOU_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
639: l_SOU_rec.enabled_flag := p_old_SOU_rec.enabled_flag;
640: END IF;
641:
642: IF l_SOU_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 642: IF l_SOU_rec.last_updated_by = FND_API.G_MISS_NUM THEN

638: IF l_SOU_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
639: l_SOU_rec.enabled_flag := p_old_SOU_rec.enabled_flag;
640: END IF;
641:
642: IF l_SOU_rec.last_updated_by = FND_API.G_MISS_NUM THEN
643: l_SOU_rec.last_updated_by := p_old_SOU_rec.last_updated_by;
644: END IF;
645:
646: IF l_SOU_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 646: IF l_SOU_rec.last_update_date = FND_API.G_MISS_DATE THEN

642: IF l_SOU_rec.last_updated_by = FND_API.G_MISS_NUM THEN
643: l_SOU_rec.last_updated_by := p_old_SOU_rec.last_updated_by;
644: END IF;
645:
646: IF l_SOU_rec.last_update_date = FND_API.G_MISS_DATE THEN
647: l_SOU_rec.last_update_date := p_old_SOU_rec.last_update_date;
648: END IF;
649:
650: IF l_SOU_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 650: IF l_SOU_rec.last_update_login = FND_API.G_MISS_NUM THEN

646: IF l_SOU_rec.last_update_date = FND_API.G_MISS_DATE THEN
647: l_SOU_rec.last_update_date := p_old_SOU_rec.last_update_date;
648: END IF;
649:
650: IF l_SOU_rec.last_update_login = FND_API.G_MISS_NUM THEN
651: l_SOU_rec.last_update_login := p_old_SOU_rec.last_update_login;
652: END IF;
653:
654: IF l_SOU_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 654: IF l_SOU_rec.program_application_id = FND_API.G_MISS_NUM THEN

650: IF l_SOU_rec.last_update_login = FND_API.G_MISS_NUM THEN
651: l_SOU_rec.last_update_login := p_old_SOU_rec.last_update_login;
652: END IF;
653:
654: IF l_SOU_rec.program_application_id = FND_API.G_MISS_NUM THEN
655: l_SOU_rec.program_application_id := p_old_SOU_rec.program_application_id;
656: END IF;
657:
658: IF l_SOU_rec.program_id = FND_API.G_MISS_NUM THEN

Line 658: IF l_SOU_rec.program_id = FND_API.G_MISS_NUM THEN

654: IF l_SOU_rec.program_application_id = FND_API.G_MISS_NUM THEN
655: l_SOU_rec.program_application_id := p_old_SOU_rec.program_application_id;
656: END IF;
657:
658: IF l_SOU_rec.program_id = FND_API.G_MISS_NUM THEN
659: l_SOU_rec.program_id := p_old_SOU_rec.program_id;
660: END IF;
661:
662: IF l_SOU_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 662: IF l_SOU_rec.program_update_date = FND_API.G_MISS_DATE THEN

658: IF l_SOU_rec.program_id = FND_API.G_MISS_NUM THEN
659: l_SOU_rec.program_id := p_old_SOU_rec.program_id;
660: END IF;
661:
662: IF l_SOU_rec.program_update_date = FND_API.G_MISS_DATE THEN
663: l_SOU_rec.program_update_date := p_old_SOU_rec.program_update_date;
664: END IF;
665:
666: IF l_SOU_rec.request_type_code = FND_API.G_MISS_CHAR THEN

Line 666: IF l_SOU_rec.request_type_code = FND_API.G_MISS_CHAR THEN

662: IF l_SOU_rec.program_update_date = FND_API.G_MISS_DATE THEN
663: l_SOU_rec.program_update_date := p_old_SOU_rec.program_update_date;
664: END IF;
665:
666: IF l_SOU_rec.request_type_code = FND_API.G_MISS_CHAR THEN
667: l_SOU_rec.request_type_code := p_old_SOU_rec.request_type_code;
668: END IF;
669:
670: IF l_SOU_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

Line 670: IF l_SOU_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

666: IF l_SOU_rec.request_type_code = FND_API.G_MISS_CHAR THEN
667: l_SOU_rec.request_type_code := p_old_SOU_rec.request_type_code;
668: END IF;
669:
670: IF l_SOU_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
671: l_SOU_rec.seeded_flag := p_old_SOU_rec.seeded_flag;
672: END IF;
673:
674: IF l_SOU_rec.seeded_sourcing_type = FND_API.G_MISS_CHAR THEN

Line 674: IF l_SOU_rec.seeded_sourcing_type = FND_API.G_MISS_CHAR THEN

670: IF l_SOU_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
671: l_SOU_rec.seeded_flag := p_old_SOU_rec.seeded_flag;
672: END IF;
673:
674: IF l_SOU_rec.seeded_sourcing_type = FND_API.G_MISS_CHAR THEN
675: l_SOU_rec.seeded_sourcing_type := p_old_SOU_rec.seeded_sourcing_type;
676: END IF;
677:
678: IF l_SOU_rec.seeded_value_string = FND_API.G_MISS_CHAR THEN

Line 678: IF l_SOU_rec.seeded_value_string = FND_API.G_MISS_CHAR THEN

674: IF l_SOU_rec.seeded_sourcing_type = FND_API.G_MISS_CHAR THEN
675: l_SOU_rec.seeded_sourcing_type := p_old_SOU_rec.seeded_sourcing_type;
676: END IF;
677:
678: IF l_SOU_rec.seeded_value_string = FND_API.G_MISS_CHAR THEN
679: l_SOU_rec.seeded_value_string := p_old_SOU_rec.seeded_value_string;
680: END IF;
681:
682: IF l_SOU_rec.segment_id = FND_API.G_MISS_NUM THEN

Line 682: IF l_SOU_rec.segment_id = FND_API.G_MISS_NUM THEN

678: IF l_SOU_rec.seeded_value_string = FND_API.G_MISS_CHAR THEN
679: l_SOU_rec.seeded_value_string := p_old_SOU_rec.seeded_value_string;
680: END IF;
681:
682: IF l_SOU_rec.segment_id = FND_API.G_MISS_NUM THEN
683: l_SOU_rec.segment_id := p_old_SOU_rec.segment_id;
684: END IF;
685:
686: IF l_SOU_rec.user_sourcing_type = FND_API.G_MISS_CHAR THEN

Line 686: IF l_SOU_rec.user_sourcing_type = FND_API.G_MISS_CHAR THEN

682: IF l_SOU_rec.segment_id = FND_API.G_MISS_NUM THEN
683: l_SOU_rec.segment_id := p_old_SOU_rec.segment_id;
684: END IF;
685:
686: IF l_SOU_rec.user_sourcing_type = FND_API.G_MISS_CHAR THEN
687: l_SOU_rec.user_sourcing_type := p_old_SOU_rec.user_sourcing_type;
688: END IF;
689:
690: IF l_SOU_rec.user_value_string = FND_API.G_MISS_CHAR THEN

Line 690: IF l_SOU_rec.user_value_string = FND_API.G_MISS_CHAR THEN

686: IF l_SOU_rec.user_sourcing_type = FND_API.G_MISS_CHAR THEN
687: l_SOU_rec.user_sourcing_type := p_old_SOU_rec.user_sourcing_type;
688: END IF;
689:
690: IF l_SOU_rec.user_value_string = FND_API.G_MISS_CHAR THEN
691: l_SOU_rec.user_value_string := p_old_SOU_rec.user_value_string;
692: END IF;
693:
694: RETURN l_SOU_rec;

Line 707: IF l_SOU_rec.attribute1 = FND_API.G_MISS_CHAR THEN

703: IS
704: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type := p_SOU_rec;
705: BEGIN
706:
707: IF l_SOU_rec.attribute1 = FND_API.G_MISS_CHAR THEN
708: l_SOU_rec.attribute1 := NULL;
709: END IF;
710:
711: IF l_SOU_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 711: IF l_SOU_rec.attribute10 = FND_API.G_MISS_CHAR THEN

707: IF l_SOU_rec.attribute1 = FND_API.G_MISS_CHAR THEN
708: l_SOU_rec.attribute1 := NULL;
709: END IF;
710:
711: IF l_SOU_rec.attribute10 = FND_API.G_MISS_CHAR THEN
712: l_SOU_rec.attribute10 := NULL;
713: END IF;
714:
715: IF l_SOU_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 715: IF l_SOU_rec.attribute11 = FND_API.G_MISS_CHAR THEN

711: IF l_SOU_rec.attribute10 = FND_API.G_MISS_CHAR THEN
712: l_SOU_rec.attribute10 := NULL;
713: END IF;
714:
715: IF l_SOU_rec.attribute11 = FND_API.G_MISS_CHAR THEN
716: l_SOU_rec.attribute11 := NULL;
717: END IF;
718:
719: IF l_SOU_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 719: IF l_SOU_rec.attribute12 = FND_API.G_MISS_CHAR THEN

715: IF l_SOU_rec.attribute11 = FND_API.G_MISS_CHAR THEN
716: l_SOU_rec.attribute11 := NULL;
717: END IF;
718:
719: IF l_SOU_rec.attribute12 = FND_API.G_MISS_CHAR THEN
720: l_SOU_rec.attribute12 := NULL;
721: END IF;
722:
723: IF l_SOU_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 723: IF l_SOU_rec.attribute13 = FND_API.G_MISS_CHAR THEN

719: IF l_SOU_rec.attribute12 = FND_API.G_MISS_CHAR THEN
720: l_SOU_rec.attribute12 := NULL;
721: END IF;
722:
723: IF l_SOU_rec.attribute13 = FND_API.G_MISS_CHAR THEN
724: l_SOU_rec.attribute13 := NULL;
725: END IF;
726:
727: IF l_SOU_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 727: IF l_SOU_rec.attribute14 = FND_API.G_MISS_CHAR THEN

723: IF l_SOU_rec.attribute13 = FND_API.G_MISS_CHAR THEN
724: l_SOU_rec.attribute13 := NULL;
725: END IF;
726:
727: IF l_SOU_rec.attribute14 = FND_API.G_MISS_CHAR THEN
728: l_SOU_rec.attribute14 := NULL;
729: END IF;
730:
731: IF l_SOU_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 731: IF l_SOU_rec.attribute15 = FND_API.G_MISS_CHAR THEN

727: IF l_SOU_rec.attribute14 = FND_API.G_MISS_CHAR THEN
728: l_SOU_rec.attribute14 := NULL;
729: END IF;
730:
731: IF l_SOU_rec.attribute15 = FND_API.G_MISS_CHAR THEN
732: l_SOU_rec.attribute15 := NULL;
733: END IF;
734:
735: IF l_SOU_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 735: IF l_SOU_rec.attribute2 = FND_API.G_MISS_CHAR THEN

731: IF l_SOU_rec.attribute15 = FND_API.G_MISS_CHAR THEN
732: l_SOU_rec.attribute15 := NULL;
733: END IF;
734:
735: IF l_SOU_rec.attribute2 = FND_API.G_MISS_CHAR THEN
736: l_SOU_rec.attribute2 := NULL;
737: END IF;
738:
739: IF l_SOU_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 739: IF l_SOU_rec.attribute3 = FND_API.G_MISS_CHAR THEN

735: IF l_SOU_rec.attribute2 = FND_API.G_MISS_CHAR THEN
736: l_SOU_rec.attribute2 := NULL;
737: END IF;
738:
739: IF l_SOU_rec.attribute3 = FND_API.G_MISS_CHAR THEN
740: l_SOU_rec.attribute3 := NULL;
741: END IF;
742:
743: IF l_SOU_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 743: IF l_SOU_rec.attribute4 = FND_API.G_MISS_CHAR THEN

739: IF l_SOU_rec.attribute3 = FND_API.G_MISS_CHAR THEN
740: l_SOU_rec.attribute3 := NULL;
741: END IF;
742:
743: IF l_SOU_rec.attribute4 = FND_API.G_MISS_CHAR THEN
744: l_SOU_rec.attribute4 := NULL;
745: END IF;
746:
747: IF l_SOU_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 747: IF l_SOU_rec.attribute5 = FND_API.G_MISS_CHAR THEN

743: IF l_SOU_rec.attribute4 = FND_API.G_MISS_CHAR THEN
744: l_SOU_rec.attribute4 := NULL;
745: END IF;
746:
747: IF l_SOU_rec.attribute5 = FND_API.G_MISS_CHAR THEN
748: l_SOU_rec.attribute5 := NULL;
749: END IF;
750:
751: IF l_SOU_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 751: IF l_SOU_rec.attribute6 = FND_API.G_MISS_CHAR THEN

747: IF l_SOU_rec.attribute5 = FND_API.G_MISS_CHAR THEN
748: l_SOU_rec.attribute5 := NULL;
749: END IF;
750:
751: IF l_SOU_rec.attribute6 = FND_API.G_MISS_CHAR THEN
752: l_SOU_rec.attribute6 := NULL;
753: END IF;
754:
755: IF l_SOU_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 755: IF l_SOU_rec.attribute7 = FND_API.G_MISS_CHAR THEN

751: IF l_SOU_rec.attribute6 = FND_API.G_MISS_CHAR THEN
752: l_SOU_rec.attribute6 := NULL;
753: END IF;
754:
755: IF l_SOU_rec.attribute7 = FND_API.G_MISS_CHAR THEN
756: l_SOU_rec.attribute7 := NULL;
757: END IF;
758:
759: IF l_SOU_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 759: IF l_SOU_rec.attribute8 = FND_API.G_MISS_CHAR THEN

755: IF l_SOU_rec.attribute7 = FND_API.G_MISS_CHAR THEN
756: l_SOU_rec.attribute7 := NULL;
757: END IF;
758:
759: IF l_SOU_rec.attribute8 = FND_API.G_MISS_CHAR THEN
760: l_SOU_rec.attribute8 := NULL;
761: END IF;
762:
763: IF l_SOU_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 763: IF l_SOU_rec.attribute9 = FND_API.G_MISS_CHAR THEN

759: IF l_SOU_rec.attribute8 = FND_API.G_MISS_CHAR THEN
760: l_SOU_rec.attribute8 := NULL;
761: END IF;
762:
763: IF l_SOU_rec.attribute9 = FND_API.G_MISS_CHAR THEN
764: l_SOU_rec.attribute9 := NULL;
765: END IF;
766:
767: IF l_SOU_rec.attribute_sourcing_id = FND_API.G_MISS_NUM THEN

Line 767: IF l_SOU_rec.attribute_sourcing_id = FND_API.G_MISS_NUM THEN

763: IF l_SOU_rec.attribute9 = FND_API.G_MISS_CHAR THEN
764: l_SOU_rec.attribute9 := NULL;
765: END IF;
766:
767: IF l_SOU_rec.attribute_sourcing_id = FND_API.G_MISS_NUM THEN
768: l_SOU_rec.attribute_sourcing_id := NULL;
769: END IF;
770:
771: IF l_SOU_rec.attribute_sourcing_level = FND_API.G_MISS_CHAR THEN

Line 771: IF l_SOU_rec.attribute_sourcing_level = FND_API.G_MISS_CHAR THEN

767: IF l_SOU_rec.attribute_sourcing_id = FND_API.G_MISS_NUM THEN
768: l_SOU_rec.attribute_sourcing_id := NULL;
769: END IF;
770:
771: IF l_SOU_rec.attribute_sourcing_level = FND_API.G_MISS_CHAR THEN
772: l_SOU_rec.attribute_sourcing_level := NULL;
773: END IF;
774:
775: IF l_SOU_rec.application_id = FND_API.G_MISS_NUM THEN

Line 775: IF l_SOU_rec.application_id = FND_API.G_MISS_NUM THEN

771: IF l_SOU_rec.attribute_sourcing_level = FND_API.G_MISS_CHAR THEN
772: l_SOU_rec.attribute_sourcing_level := NULL;
773: END IF;
774:
775: IF l_SOU_rec.application_id = FND_API.G_MISS_NUM THEN
776: l_SOU_rec.application_id := NULL;
777: END IF;
778:
779: IF l_SOU_rec.context = FND_API.G_MISS_CHAR THEN

Line 779: IF l_SOU_rec.context = FND_API.G_MISS_CHAR THEN

775: IF l_SOU_rec.application_id = FND_API.G_MISS_NUM THEN
776: l_SOU_rec.application_id := NULL;
777: END IF;
778:
779: IF l_SOU_rec.context = FND_API.G_MISS_CHAR THEN
780: l_SOU_rec.context := NULL;
781: END IF;
782:
783: IF l_SOU_rec.created_by = FND_API.G_MISS_NUM THEN

Line 783: IF l_SOU_rec.created_by = FND_API.G_MISS_NUM THEN

779: IF l_SOU_rec.context = FND_API.G_MISS_CHAR THEN
780: l_SOU_rec.context := NULL;
781: END IF;
782:
783: IF l_SOU_rec.created_by = FND_API.G_MISS_NUM THEN
784: l_SOU_rec.created_by := NULL;
785: END IF;
786:
787: IF l_SOU_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 787: IF l_SOU_rec.creation_date = FND_API.G_MISS_DATE THEN

783: IF l_SOU_rec.created_by = FND_API.G_MISS_NUM THEN
784: l_SOU_rec.created_by := NULL;
785: END IF;
786:
787: IF l_SOU_rec.creation_date = FND_API.G_MISS_DATE THEN
788: l_SOU_rec.creation_date := NULL;
789: END IF;
790:
791: IF l_SOU_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

Line 791: IF l_SOU_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

787: IF l_SOU_rec.creation_date = FND_API.G_MISS_DATE THEN
788: l_SOU_rec.creation_date := NULL;
789: END IF;
790:
791: IF l_SOU_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
792: l_SOU_rec.enabled_flag := NULL;
793: END IF;
794:
795: IF l_SOU_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 795: IF l_SOU_rec.last_updated_by = FND_API.G_MISS_NUM THEN

791: IF l_SOU_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
792: l_SOU_rec.enabled_flag := NULL;
793: END IF;
794:
795: IF l_SOU_rec.last_updated_by = FND_API.G_MISS_NUM THEN
796: l_SOU_rec.last_updated_by := NULL;
797: END IF;
798:
799: IF l_SOU_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 799: IF l_SOU_rec.last_update_date = FND_API.G_MISS_DATE THEN

795: IF l_SOU_rec.last_updated_by = FND_API.G_MISS_NUM THEN
796: l_SOU_rec.last_updated_by := NULL;
797: END IF;
798:
799: IF l_SOU_rec.last_update_date = FND_API.G_MISS_DATE THEN
800: l_SOU_rec.last_update_date := NULL;
801: END IF;
802:
803: IF l_SOU_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 803: IF l_SOU_rec.last_update_login = FND_API.G_MISS_NUM THEN

799: IF l_SOU_rec.last_update_date = FND_API.G_MISS_DATE THEN
800: l_SOU_rec.last_update_date := NULL;
801: END IF;
802:
803: IF l_SOU_rec.last_update_login = FND_API.G_MISS_NUM THEN
804: l_SOU_rec.last_update_login := NULL;
805: END IF;
806:
807: IF l_SOU_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 807: IF l_SOU_rec.program_application_id = FND_API.G_MISS_NUM THEN

803: IF l_SOU_rec.last_update_login = FND_API.G_MISS_NUM THEN
804: l_SOU_rec.last_update_login := NULL;
805: END IF;
806:
807: IF l_SOU_rec.program_application_id = FND_API.G_MISS_NUM THEN
808: l_SOU_rec.program_application_id := NULL;
809: END IF;
810:
811: IF l_SOU_rec.program_id = FND_API.G_MISS_NUM THEN

Line 811: IF l_SOU_rec.program_id = FND_API.G_MISS_NUM THEN

807: IF l_SOU_rec.program_application_id = FND_API.G_MISS_NUM THEN
808: l_SOU_rec.program_application_id := NULL;
809: END IF;
810:
811: IF l_SOU_rec.program_id = FND_API.G_MISS_NUM THEN
812: l_SOU_rec.program_id := NULL;
813: END IF;
814:
815: IF l_SOU_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 815: IF l_SOU_rec.program_update_date = FND_API.G_MISS_DATE THEN

811: IF l_SOU_rec.program_id = FND_API.G_MISS_NUM THEN
812: l_SOU_rec.program_id := NULL;
813: END IF;
814:
815: IF l_SOU_rec.program_update_date = FND_API.G_MISS_DATE THEN
816: l_SOU_rec.program_update_date := NULL;
817: END IF;
818:
819: IF l_SOU_rec.request_type_code = FND_API.G_MISS_CHAR THEN

Line 819: IF l_SOU_rec.request_type_code = FND_API.G_MISS_CHAR THEN

815: IF l_SOU_rec.program_update_date = FND_API.G_MISS_DATE THEN
816: l_SOU_rec.program_update_date := NULL;
817: END IF;
818:
819: IF l_SOU_rec.request_type_code = FND_API.G_MISS_CHAR THEN
820: l_SOU_rec.request_type_code := NULL;
821: END IF;
822:
823: IF l_SOU_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

Line 823: IF l_SOU_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

819: IF l_SOU_rec.request_type_code = FND_API.G_MISS_CHAR THEN
820: l_SOU_rec.request_type_code := NULL;
821: END IF;
822:
823: IF l_SOU_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
824: l_SOU_rec.seeded_flag := NULL;
825: END IF;
826:
827: IF l_SOU_rec.seeded_sourcing_type = FND_API.G_MISS_CHAR THEN

Line 827: IF l_SOU_rec.seeded_sourcing_type = FND_API.G_MISS_CHAR THEN

823: IF l_SOU_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
824: l_SOU_rec.seeded_flag := NULL;
825: END IF;
826:
827: IF l_SOU_rec.seeded_sourcing_type = FND_API.G_MISS_CHAR THEN
828: l_SOU_rec.seeded_sourcing_type := NULL;
829: END IF;
830:
831: IF l_SOU_rec.seeded_value_string = FND_API.G_MISS_CHAR THEN

Line 831: IF l_SOU_rec.seeded_value_string = FND_API.G_MISS_CHAR THEN

827: IF l_SOU_rec.seeded_sourcing_type = FND_API.G_MISS_CHAR THEN
828: l_SOU_rec.seeded_sourcing_type := NULL;
829: END IF;
830:
831: IF l_SOU_rec.seeded_value_string = FND_API.G_MISS_CHAR THEN
832: l_SOU_rec.seeded_value_string := NULL;
833: END IF;
834:
835: IF l_SOU_rec.segment_id = FND_API.G_MISS_NUM THEN

Line 835: IF l_SOU_rec.segment_id = FND_API.G_MISS_NUM THEN

831: IF l_SOU_rec.seeded_value_string = FND_API.G_MISS_CHAR THEN
832: l_SOU_rec.seeded_value_string := NULL;
833: END IF;
834:
835: IF l_SOU_rec.segment_id = FND_API.G_MISS_NUM THEN
836: l_SOU_rec.segment_id := NULL;
837: END IF;
838:
839: IF l_SOU_rec.user_sourcing_type = FND_API.G_MISS_CHAR THEN

Line 839: IF l_SOU_rec.user_sourcing_type = FND_API.G_MISS_CHAR THEN

835: IF l_SOU_rec.segment_id = FND_API.G_MISS_NUM THEN
836: l_SOU_rec.segment_id := NULL;
837: END IF;
838:
839: IF l_SOU_rec.user_sourcing_type = FND_API.G_MISS_CHAR THEN
840: l_SOU_rec.user_sourcing_type := NULL;
841: END IF;
842:
843: IF l_SOU_rec.user_value_string = FND_API.G_MISS_CHAR THEN

Line 843: IF l_SOU_rec.user_value_string = FND_API.G_MISS_CHAR THEN

839: IF l_SOU_rec.user_sourcing_type = FND_API.G_MISS_CHAR THEN
840: l_SOU_rec.user_sourcing_type := NULL;
841: END IF;
842:
843: IF l_SOU_rec.user_value_string = FND_API.G_MISS_CHAR THEN
844: l_SOU_rec.user_value_string := NULL;
845: END IF;
846:
847: RETURN l_SOU_rec;

Line 910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

906: , 'Update_Row'
907: );
908: END IF;
909:
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911:
912: END Update_Row;
913:
914: -- Procedure Insert_Row

Line 1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1005: , 'Insert_Row'
1006: );
1007: END IF;
1008:
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010:
1011: END Insert_Row;
1012:
1013: -- Procedure Delete_Row

Line 1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1033: , 'Delete_Row'
1034: );
1035: END IF;
1036:
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038:
1039: END Delete_Row;
1040:
1041: -- Function Query_Row

Line 1061: FND_API.G_MISS_NUM

1057: --
1058:
1059: FUNCTION Query_Rows
1060: ( p_attribute_sourcing_id IN NUMBER :=
1061: FND_API.G_MISS_NUM
1062: , p_segment_pte_id IN NUMBER :=
1063: FND_API.G_MISS_NUM
1064: ) RETURN QP_Attr_Map_PUB.Sou_Tbl_Type
1065: IS

Line 1063: FND_API.G_MISS_NUM

1059: FUNCTION Query_Rows
1060: ( p_attribute_sourcing_id IN NUMBER :=
1061: FND_API.G_MISS_NUM
1062: , p_segment_pte_id IN NUMBER :=
1063: FND_API.G_MISS_NUM
1064: ) RETURN QP_Attr_Map_PUB.Sou_Tbl_Type
1065: IS
1066: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;
1067: l_SOU_tbl QP_Attr_Map_PUB.Sou_Tbl_Type;

Line 1116: p_attribute_sourcing_id <> FND_API.G_MISS_NUM)

1112:
1113: IF
1114: (p_attribute_sourcing_id IS NOT NULL
1115: AND
1116: p_attribute_sourcing_id <> FND_API.G_MISS_NUM)
1117: AND
1118: (p_segment_pte_id IS NOT NULL
1119: AND
1120: p_segment_pte_id <> FND_API.G_MISS_NUM)

Line 1120: p_segment_pte_id <> FND_API.G_MISS_NUM)

1116: p_attribute_sourcing_id <> FND_API.G_MISS_NUM)
1117: AND
1118: (p_segment_pte_id IS NOT NULL
1119: AND
1120: p_segment_pte_id <> FND_API.G_MISS_NUM)
1121: THEN
1122: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1123: THEN
1124: OE_MSG_PUB.Add_Exc_Msg

Line 1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1127: , 'Keys are mutually exclusive: attribute_sourcing_id = '|| p_attribute_sourcing_id || ', segment_pte_id = '|| p_segment_pte_id
1128: );
1129: END IF;
1130:
1131: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1132:
1133: END IF;
1134:
1135:

Line 1186: p_attribute_sourcing_id <> FND_API.G_MISS_NUM)

1182:
1183: IF
1184: (p_attribute_sourcing_id IS NOT NULL
1185: AND
1186: p_attribute_sourcing_id <> FND_API.G_MISS_NUM)
1187: AND
1188: (l_SOU_tbl.COUNT = 0)
1189: THEN
1190: RAISE NO_DATA_FOUND;

Line 1200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1196: RETURN l_SOU_tbl;
1197:
1198: EXCEPTION
1199:
1200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1201:
1202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1203:
1204: WHEN OTHERS THEN

Line 1202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1198: EXCEPTION
1199:
1200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1201:
1202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1203:
1204: WHEN OTHERS THEN
1205:
1206: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1210: , 'Query_Rows'
1211: );
1212: END IF;
1213:
1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1215:
1216: END Query_Rows;
1217:
1218: -- Procedure lock_Row

Line 1384: x_return_status := FND_API.G_RET_STS_SUCCESS;

1380: x_SOU_rec := l_SOU_rec;
1381:
1382: -- Set return status
1383:
1384: x_return_status := FND_API.G_RET_STS_SUCCESS;
1385: x_SOU_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1386:
1387: ELSE
1388:

Line 1385: x_SOU_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1381:
1382: -- Set return status
1383:
1384: x_return_status := FND_API.G_RET_STS_SUCCESS;
1385: x_SOU_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1386:
1387: ELSE
1388:
1389: -- Row has changed by another user.

Line 1391: x_return_status := FND_API.G_RET_STS_ERROR;

1387: ELSE
1388:
1389: -- Row has changed by another user.
1390:
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: x_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1393:
1394: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1395: THEN

Line 1392: x_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;

1388:
1389: -- Row has changed by another user.
1390:
1391: x_return_status := FND_API.G_RET_STS_ERROR;
1392: x_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1393:
1394: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1395: THEN
1396:

Line 1408: x_return_status := FND_API.G_RET_STS_ERROR;

1404: EXCEPTION
1405:
1406: WHEN NO_DATA_FOUND THEN
1407:
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: x_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1410:
1411: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1412: THEN

Line 1409: x_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;

1405:
1406: WHEN NO_DATA_FOUND THEN
1407:
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: x_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1410:
1411: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1412: THEN
1413:

Line 1420: x_return_status := FND_API.G_RET_STS_ERROR;

1416:
1417: END IF;
1418: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1419:
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: x_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1422:
1423: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1424: THEN

Line 1421: x_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;

1417: END IF;
1418: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1419:
1420: x_return_status := FND_API.G_RET_STS_ERROR;
1421: x_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1422:
1423: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1424: THEN
1425:

Line 1432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1428:
1429: END IF;
1430: WHEN OTHERS THEN
1431:
1432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1433: x_SOU_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434:
1435: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN

Line 1433: x_SOU_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1429: END IF;
1430: WHEN OTHERS THEN
1431:
1432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1433: x_SOU_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434:
1435: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: OE_MSG_PUB.Add_Exc_Msg

Line 1457: p_SOU_rec.attribute_sourcing_id <> FND_API.G_MISS_NUM AND

1453: l_SOU_val_rec QP_Attr_Map_PUB.Sou_Val_Rec_Type;
1454: BEGIN
1455:
1456: IF p_SOU_rec.attribute_sourcing_id IS NOT NULL AND
1457: p_SOU_rec.attribute_sourcing_id <> FND_API.G_MISS_NUM AND
1458: NOT QP_GLOBALS.Equal(p_SOU_rec.attribute_sourcing_id,
1459: p_old_SOU_rec.attribute_sourcing_id)
1460: THEN
1461: l_SOU_val_rec.attribute_sourcing := QP_Id_To_Value.Attribute_Sourcing

Line 1467: p_SOU_rec.enabled_flag <> FND_API.G_MISS_CHAR AND

1463: );
1464: END IF;
1465:
1466: IF p_SOU_rec.enabled_flag IS NOT NULL AND
1467: p_SOU_rec.enabled_flag <> FND_API.G_MISS_CHAR AND
1468: NOT QP_GLOBALS.Equal(p_SOU_rec.enabled_flag,
1469: p_old_SOU_rec.enabled_flag)
1470: THEN
1471: l_SOU_val_rec.enabled := QP_Id_To_Value.Enabled

Line 1477: p_SOU_rec.request_type_code <> FND_API.G_MISS_CHAR AND

1473: );
1474: END IF;
1475:
1476: IF p_SOU_rec.request_type_code IS NOT NULL AND
1477: p_SOU_rec.request_type_code <> FND_API.G_MISS_CHAR AND
1478: NOT QP_GLOBALS.Equal(p_SOU_rec.request_type_code,
1479: p_old_SOU_rec.request_type_code)
1480: THEN
1481: l_SOU_val_rec.request_type := QP_Id_To_Value.Request_Type

Line 1487: p_SOU_rec.seeded_flag <> FND_API.G_MISS_CHAR AND

1483: );
1484: END IF;
1485:
1486: IF p_SOU_rec.seeded_flag IS NOT NULL AND
1487: p_SOU_rec.seeded_flag <> FND_API.G_MISS_CHAR AND
1488: NOT QP_GLOBALS.Equal(p_SOU_rec.seeded_flag,
1489: p_old_SOU_rec.seeded_flag)
1490: THEN
1491: l_SOU_val_rec.seeded := QP_Id_To_Value.Seeded

Line 1497: p_SOU_rec.segment_id <> FND_API.G_MISS_NUM AND

1493: );
1494: END IF;
1495:
1496: IF p_SOU_rec.segment_id IS NOT NULL AND
1497: p_SOU_rec.segment_id <> FND_API.G_MISS_NUM AND
1498: NOT QP_GLOBALS.Equal(p_SOU_rec.segment_id,
1499: p_old_SOU_rec.segment_id)
1500: THEN
1501: l_SOU_val_rec.segment := QP_Id_To_Value.Segment

Line 1522: l_SOU_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1518: BEGIN
1519:
1520: -- initialize return_status.
1521:
1522: l_SOU_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1523:
1524: -- initialize l_SOU_rec.
1525:
1526: l_SOU_rec := p_SOU_rec;

Line 1528: IF p_SOU_val_rec.attribute_sourcing <> FND_API.G_MISS_CHAR

1524: -- initialize l_SOU_rec.
1525:
1526: l_SOU_rec := p_SOU_rec;
1527:
1528: IF p_SOU_val_rec.attribute_sourcing <> FND_API.G_MISS_CHAR
1529: THEN
1530:
1531: IF p_SOU_rec.attribute_sourcing_id <> FND_API.G_MISS_NUM THEN
1532:

Line 1531: IF p_SOU_rec.attribute_sourcing_id <> FND_API.G_MISS_NUM THEN

1527:
1528: IF p_SOU_val_rec.attribute_sourcing <> FND_API.G_MISS_CHAR
1529: THEN
1530:
1531: IF p_SOU_rec.attribute_sourcing_id <> FND_API.G_MISS_NUM THEN
1532:
1533: l_SOU_rec.attribute_sourcing_id := p_SOU_rec.attribute_sourcing_id;
1534:
1535: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1550: IF l_SOU_rec.attribute_sourcing_id = FND_API.G_MISS_NUM THEN

1546: l_SOU_rec.attribute_sourcing_id := QP_Value_To_Id.attribute_sourcing
1547: ( p_attribute_sourcing => p_SOU_val_rec.attribute_sourcing
1548: );
1549:
1550: IF l_SOU_rec.attribute_sourcing_id = FND_API.G_MISS_NUM THEN
1551: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1552: END IF;
1553:
1554: END IF;

Line 1551: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;

1547: ( p_attribute_sourcing => p_SOU_val_rec.attribute_sourcing
1548: );
1549:
1550: IF l_SOU_rec.attribute_sourcing_id = FND_API.G_MISS_NUM THEN
1551: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1552: END IF;
1553:
1554: END IF;
1555:

Line 1558: IF p_SOU_val_rec.enabled <> FND_API.G_MISS_CHAR

1554: END IF;
1555:
1556: END IF;
1557:
1558: IF p_SOU_val_rec.enabled <> FND_API.G_MISS_CHAR
1559: THEN
1560:
1561: IF p_SOU_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN
1562:

Line 1561: IF p_SOU_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN

1557:
1558: IF p_SOU_val_rec.enabled <> FND_API.G_MISS_CHAR
1559: THEN
1560:
1561: IF p_SOU_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN
1562:
1563: l_SOU_rec.enabled_flag := p_SOU_rec.enabled_flag;
1564:
1565: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1580: IF l_SOU_rec.enabled_flag = FND_API.G_MISS_CHAR THEN

1576: l_SOU_rec.enabled_flag := QP_Value_To_Id.enabled
1577: ( p_enabled => p_SOU_val_rec.enabled
1578: );
1579:
1580: IF l_SOU_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
1581: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1582: END IF;
1583:
1584: END IF;

Line 1581: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;

1577: ( p_enabled => p_SOU_val_rec.enabled
1578: );
1579:
1580: IF l_SOU_rec.enabled_flag = FND_API.G_MISS_CHAR THEN
1581: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1582: END IF;
1583:
1584: END IF;
1585:

Line 1588: IF p_SOU_val_rec.request_type <> FND_API.G_MISS_CHAR

1584: END IF;
1585:
1586: END IF;
1587:
1588: IF p_SOU_val_rec.request_type <> FND_API.G_MISS_CHAR
1589: THEN
1590:
1591: IF p_SOU_rec.request_type_code <> FND_API.G_MISS_CHAR THEN
1592:

Line 1591: IF p_SOU_rec.request_type_code <> FND_API.G_MISS_CHAR THEN

1587:
1588: IF p_SOU_val_rec.request_type <> FND_API.G_MISS_CHAR
1589: THEN
1590:
1591: IF p_SOU_rec.request_type_code <> FND_API.G_MISS_CHAR THEN
1592:
1593: l_SOU_rec.request_type_code := p_SOU_rec.request_type_code;
1594:
1595: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1610: IF l_SOU_rec.request_type_code = FND_API.G_MISS_CHAR THEN

1606: l_SOU_rec.request_type_code := QP_Value_To_Id.request_type
1607: ( p_request_type => p_SOU_val_rec.request_type
1608: );
1609:
1610: IF l_SOU_rec.request_type_code = FND_API.G_MISS_CHAR THEN
1611: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1612: END IF;
1613:
1614: END IF;

Line 1611: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;

1607: ( p_request_type => p_SOU_val_rec.request_type
1608: );
1609:
1610: IF l_SOU_rec.request_type_code = FND_API.G_MISS_CHAR THEN
1611: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1612: END IF;
1613:
1614: END IF;
1615:

Line 1618: IF p_SOU_val_rec.seeded <> FND_API.G_MISS_CHAR

1614: END IF;
1615:
1616: END IF;
1617:
1618: IF p_SOU_val_rec.seeded <> FND_API.G_MISS_CHAR
1619: THEN
1620:
1621: IF p_SOU_rec.seeded_flag <> FND_API.G_MISS_CHAR THEN
1622:

Line 1621: IF p_SOU_rec.seeded_flag <> FND_API.G_MISS_CHAR THEN

1617:
1618: IF p_SOU_val_rec.seeded <> FND_API.G_MISS_CHAR
1619: THEN
1620:
1621: IF p_SOU_rec.seeded_flag <> FND_API.G_MISS_CHAR THEN
1622:
1623: l_SOU_rec.seeded_flag := p_SOU_rec.seeded_flag;
1624:
1625: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1640: IF l_SOU_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

1636: l_SOU_rec.seeded_flag := QP_Value_To_Id.seeded
1637: ( p_seeded => p_SOU_val_rec.seeded
1638: );
1639:
1640: IF l_SOU_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
1641: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1642: END IF;
1643:
1644: END IF;

Line 1641: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;

1637: ( p_seeded => p_SOU_val_rec.seeded
1638: );
1639:
1640: IF l_SOU_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
1641: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1642: END IF;
1643:
1644: END IF;
1645:

Line 1648: IF p_SOU_val_rec.segment <> FND_API.G_MISS_CHAR

1644: END IF;
1645:
1646: END IF;
1647:
1648: IF p_SOU_val_rec.segment <> FND_API.G_MISS_CHAR
1649: THEN
1650:
1651: IF p_SOU_rec.segment_id <> FND_API.G_MISS_NUM THEN
1652:

Line 1651: IF p_SOU_rec.segment_id <> FND_API.G_MISS_NUM THEN

1647:
1648: IF p_SOU_val_rec.segment <> FND_API.G_MISS_CHAR
1649: THEN
1650:
1651: IF p_SOU_rec.segment_id <> FND_API.G_MISS_NUM THEN
1652:
1653: l_SOU_rec.segment_id := p_SOU_rec.segment_id;
1654:
1655: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1670: IF l_SOU_rec.segment_id = FND_API.G_MISS_NUM THEN

1666: l_SOU_rec.segment_id := QP_Value_To_Id.segment
1667: ( p_segment => p_SOU_val_rec.segment
1668: );
1669:
1670: IF l_SOU_rec.segment_id = FND_API.G_MISS_NUM THEN
1671: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1672: END IF;
1673:
1674: END IF;

Line 1671: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;

1667: ( p_segment => p_SOU_val_rec.segment
1668: );
1669:
1670: IF l_SOU_rec.segment_id = FND_API.G_MISS_NUM THEN
1671: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1672: END IF;
1673:
1674: END IF;
1675: