APPS.QP_PSG_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_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type
13: , p_old_PSG_rec IN QP_Attr_Map_PUB.Psg_Rec_Type :=
14: QP_Attr_Map_PUB.G_MISS_PSG_REC
15: , x_PSG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attr_Map_PUB.Psg_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_PSG_rec.attribute1,p_old_PSG_rec.attribute1)
33: THEN
34: l_index := l_index + 1;

Line 539: IF l_PSG_rec.attribute1 = FND_API.G_MISS_CHAR THEN

535: IS
536: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type := p_PSG_rec;
537: BEGIN
538:
539: IF l_PSG_rec.attribute1 = FND_API.G_MISS_CHAR THEN
540: l_PSG_rec.attribute1 := p_old_PSG_rec.attribute1;
541: END IF;
542:
543: IF l_PSG_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 543: IF l_PSG_rec.attribute10 = FND_API.G_MISS_CHAR THEN

539: IF l_PSG_rec.attribute1 = FND_API.G_MISS_CHAR THEN
540: l_PSG_rec.attribute1 := p_old_PSG_rec.attribute1;
541: END IF;
542:
543: IF l_PSG_rec.attribute10 = FND_API.G_MISS_CHAR THEN
544: l_PSG_rec.attribute10 := p_old_PSG_rec.attribute10;
545: END IF;
546:
547: IF l_PSG_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 547: IF l_PSG_rec.attribute11 = FND_API.G_MISS_CHAR THEN

543: IF l_PSG_rec.attribute10 = FND_API.G_MISS_CHAR THEN
544: l_PSG_rec.attribute10 := p_old_PSG_rec.attribute10;
545: END IF;
546:
547: IF l_PSG_rec.attribute11 = FND_API.G_MISS_CHAR THEN
548: l_PSG_rec.attribute11 := p_old_PSG_rec.attribute11;
549: END IF;
550:
551: IF l_PSG_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 551: IF l_PSG_rec.attribute12 = FND_API.G_MISS_CHAR THEN

547: IF l_PSG_rec.attribute11 = FND_API.G_MISS_CHAR THEN
548: l_PSG_rec.attribute11 := p_old_PSG_rec.attribute11;
549: END IF;
550:
551: IF l_PSG_rec.attribute12 = FND_API.G_MISS_CHAR THEN
552: l_PSG_rec.attribute12 := p_old_PSG_rec.attribute12;
553: END IF;
554:
555: IF l_PSG_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 555: IF l_PSG_rec.attribute13 = FND_API.G_MISS_CHAR THEN

551: IF l_PSG_rec.attribute12 = FND_API.G_MISS_CHAR THEN
552: l_PSG_rec.attribute12 := p_old_PSG_rec.attribute12;
553: END IF;
554:
555: IF l_PSG_rec.attribute13 = FND_API.G_MISS_CHAR THEN
556: l_PSG_rec.attribute13 := p_old_PSG_rec.attribute13;
557: END IF;
558:
559: IF l_PSG_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 559: IF l_PSG_rec.attribute14 = FND_API.G_MISS_CHAR THEN

555: IF l_PSG_rec.attribute13 = FND_API.G_MISS_CHAR THEN
556: l_PSG_rec.attribute13 := p_old_PSG_rec.attribute13;
557: END IF;
558:
559: IF l_PSG_rec.attribute14 = FND_API.G_MISS_CHAR THEN
560: l_PSG_rec.attribute14 := p_old_PSG_rec.attribute14;
561: END IF;
562:
563: IF l_PSG_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 563: IF l_PSG_rec.attribute15 = FND_API.G_MISS_CHAR THEN

559: IF l_PSG_rec.attribute14 = FND_API.G_MISS_CHAR THEN
560: l_PSG_rec.attribute14 := p_old_PSG_rec.attribute14;
561: END IF;
562:
563: IF l_PSG_rec.attribute15 = FND_API.G_MISS_CHAR THEN
564: l_PSG_rec.attribute15 := p_old_PSG_rec.attribute15;
565: END IF;
566:
567: IF l_PSG_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 567: IF l_PSG_rec.attribute2 = FND_API.G_MISS_CHAR THEN

563: IF l_PSG_rec.attribute15 = FND_API.G_MISS_CHAR THEN
564: l_PSG_rec.attribute15 := p_old_PSG_rec.attribute15;
565: END IF;
566:
567: IF l_PSG_rec.attribute2 = FND_API.G_MISS_CHAR THEN
568: l_PSG_rec.attribute2 := p_old_PSG_rec.attribute2;
569: END IF;
570:
571: IF l_PSG_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 571: IF l_PSG_rec.attribute3 = FND_API.G_MISS_CHAR THEN

567: IF l_PSG_rec.attribute2 = FND_API.G_MISS_CHAR THEN
568: l_PSG_rec.attribute2 := p_old_PSG_rec.attribute2;
569: END IF;
570:
571: IF l_PSG_rec.attribute3 = FND_API.G_MISS_CHAR THEN
572: l_PSG_rec.attribute3 := p_old_PSG_rec.attribute3;
573: END IF;
574:
575: IF l_PSG_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 575: IF l_PSG_rec.attribute4 = FND_API.G_MISS_CHAR THEN

571: IF l_PSG_rec.attribute3 = FND_API.G_MISS_CHAR THEN
572: l_PSG_rec.attribute3 := p_old_PSG_rec.attribute3;
573: END IF;
574:
575: IF l_PSG_rec.attribute4 = FND_API.G_MISS_CHAR THEN
576: l_PSG_rec.attribute4 := p_old_PSG_rec.attribute4;
577: END IF;
578:
579: IF l_PSG_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 579: IF l_PSG_rec.attribute5 = FND_API.G_MISS_CHAR THEN

575: IF l_PSG_rec.attribute4 = FND_API.G_MISS_CHAR THEN
576: l_PSG_rec.attribute4 := p_old_PSG_rec.attribute4;
577: END IF;
578:
579: IF l_PSG_rec.attribute5 = FND_API.G_MISS_CHAR THEN
580: l_PSG_rec.attribute5 := p_old_PSG_rec.attribute5;
581: END IF;
582:
583: IF l_PSG_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 583: IF l_PSG_rec.attribute6 = FND_API.G_MISS_CHAR THEN

579: IF l_PSG_rec.attribute5 = FND_API.G_MISS_CHAR THEN
580: l_PSG_rec.attribute5 := p_old_PSG_rec.attribute5;
581: END IF;
582:
583: IF l_PSG_rec.attribute6 = FND_API.G_MISS_CHAR THEN
584: l_PSG_rec.attribute6 := p_old_PSG_rec.attribute6;
585: END IF;
586:
587: IF l_PSG_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 587: IF l_PSG_rec.attribute7 = FND_API.G_MISS_CHAR THEN

583: IF l_PSG_rec.attribute6 = FND_API.G_MISS_CHAR THEN
584: l_PSG_rec.attribute6 := p_old_PSG_rec.attribute6;
585: END IF;
586:
587: IF l_PSG_rec.attribute7 = FND_API.G_MISS_CHAR THEN
588: l_PSG_rec.attribute7 := p_old_PSG_rec.attribute7;
589: END IF;
590:
591: IF l_PSG_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 591: IF l_PSG_rec.attribute8 = FND_API.G_MISS_CHAR THEN

587: IF l_PSG_rec.attribute7 = FND_API.G_MISS_CHAR THEN
588: l_PSG_rec.attribute7 := p_old_PSG_rec.attribute7;
589: END IF;
590:
591: IF l_PSG_rec.attribute8 = FND_API.G_MISS_CHAR THEN
592: l_PSG_rec.attribute8 := p_old_PSG_rec.attribute8;
593: END IF;
594:
595: IF l_PSG_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 595: IF l_PSG_rec.attribute9 = FND_API.G_MISS_CHAR THEN

591: IF l_PSG_rec.attribute8 = FND_API.G_MISS_CHAR THEN
592: l_PSG_rec.attribute8 := p_old_PSG_rec.attribute8;
593: END IF;
594:
595: IF l_PSG_rec.attribute9 = FND_API.G_MISS_CHAR THEN
596: l_PSG_rec.attribute9 := p_old_PSG_rec.attribute9;
597: END IF;
598:
599: IF l_PSG_rec.context = FND_API.G_MISS_CHAR THEN

Line 599: IF l_PSG_rec.context = FND_API.G_MISS_CHAR THEN

595: IF l_PSG_rec.attribute9 = FND_API.G_MISS_CHAR THEN
596: l_PSG_rec.attribute9 := p_old_PSG_rec.attribute9;
597: END IF;
598:
599: IF l_PSG_rec.context = FND_API.G_MISS_CHAR THEN
600: l_PSG_rec.context := p_old_PSG_rec.context;
601: END IF;
602:
603: IF l_PSG_rec.created_by = FND_API.G_MISS_NUM THEN

Line 603: IF l_PSG_rec.created_by = FND_API.G_MISS_NUM THEN

599: IF l_PSG_rec.context = FND_API.G_MISS_CHAR THEN
600: l_PSG_rec.context := p_old_PSG_rec.context;
601: END IF;
602:
603: IF l_PSG_rec.created_by = FND_API.G_MISS_NUM THEN
604: l_PSG_rec.created_by := p_old_PSG_rec.created_by;
605: END IF;
606:
607: IF l_PSG_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 607: IF l_PSG_rec.creation_date = FND_API.G_MISS_DATE THEN

603: IF l_PSG_rec.created_by = FND_API.G_MISS_NUM THEN
604: l_PSG_rec.created_by := p_old_PSG_rec.created_by;
605: END IF;
606:
607: IF l_PSG_rec.creation_date = FND_API.G_MISS_DATE THEN
608: l_PSG_rec.creation_date := p_old_PSG_rec.creation_date;
609: END IF;
610:
611: IF l_PSG_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 611: IF l_PSG_rec.last_updated_by = FND_API.G_MISS_NUM THEN

607: IF l_PSG_rec.creation_date = FND_API.G_MISS_DATE THEN
608: l_PSG_rec.creation_date := p_old_PSG_rec.creation_date;
609: END IF;
610:
611: IF l_PSG_rec.last_updated_by = FND_API.G_MISS_NUM THEN
612: l_PSG_rec.last_updated_by := p_old_PSG_rec.last_updated_by;
613: END IF;
614:
615: IF l_PSG_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 615: IF l_PSG_rec.last_update_date = FND_API.G_MISS_DATE THEN

611: IF l_PSG_rec.last_updated_by = FND_API.G_MISS_NUM THEN
612: l_PSG_rec.last_updated_by := p_old_PSG_rec.last_updated_by;
613: END IF;
614:
615: IF l_PSG_rec.last_update_date = FND_API.G_MISS_DATE THEN
616: l_PSG_rec.last_update_date := p_old_PSG_rec.last_update_date;
617: END IF;
618:
619: IF l_PSG_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 619: IF l_PSG_rec.last_update_login = FND_API.G_MISS_NUM THEN

615: IF l_PSG_rec.last_update_date = FND_API.G_MISS_DATE THEN
616: l_PSG_rec.last_update_date := p_old_PSG_rec.last_update_date;
617: END IF;
618:
619: IF l_PSG_rec.last_update_login = FND_API.G_MISS_NUM THEN
620: l_PSG_rec.last_update_login := p_old_PSG_rec.last_update_login;
621: END IF;
622:
623: IF l_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR THEN

Line 623: IF l_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR THEN

619: IF l_PSG_rec.last_update_login = FND_API.G_MISS_NUM THEN
620: l_PSG_rec.last_update_login := p_old_PSG_rec.last_update_login;
621: END IF;
622:
623: IF l_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR THEN
624: l_PSG_rec.limits_enabled := p_old_PSG_rec.limits_enabled;
625: END IF;
626:
627: IF l_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR THEN

Line 627: IF l_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR THEN

623: IF l_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR THEN
624: l_PSG_rec.limits_enabled := p_old_PSG_rec.limits_enabled;
625: END IF;
626:
627: IF l_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR THEN
628: l_PSG_rec.lov_enabled := p_old_PSG_rec.lov_enabled;
629: END IF;
630:
631: IF l_PSG_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 631: IF l_PSG_rec.program_application_id = FND_API.G_MISS_NUM THEN

627: IF l_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR THEN
628: l_PSG_rec.lov_enabled := p_old_PSG_rec.lov_enabled;
629: END IF;
630:
631: IF l_PSG_rec.program_application_id = FND_API.G_MISS_NUM THEN
632: l_PSG_rec.program_application_id := p_old_PSG_rec.program_application_id;
633: END IF;
634:
635: IF l_PSG_rec.program_id = FND_API.G_MISS_NUM THEN

Line 635: IF l_PSG_rec.program_id = FND_API.G_MISS_NUM THEN

631: IF l_PSG_rec.program_application_id = FND_API.G_MISS_NUM THEN
632: l_PSG_rec.program_application_id := p_old_PSG_rec.program_application_id;
633: END IF;
634:
635: IF l_PSG_rec.program_id = FND_API.G_MISS_NUM THEN
636: l_PSG_rec.program_id := p_old_PSG_rec.program_id;
637: END IF;
638:
639: IF l_PSG_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 639: IF l_PSG_rec.program_update_date = FND_API.G_MISS_DATE THEN

635: IF l_PSG_rec.program_id = FND_API.G_MISS_NUM THEN
636: l_PSG_rec.program_id := p_old_PSG_rec.program_id;
637: END IF;
638:
639: IF l_PSG_rec.program_update_date = FND_API.G_MISS_DATE THEN
640: l_PSG_rec.program_update_date := p_old_PSG_rec.program_update_date;
641: END IF;
642:
643: IF l_PSG_rec.pte_code = FND_API.G_MISS_CHAR THEN

Line 643: IF l_PSG_rec.pte_code = FND_API.G_MISS_CHAR THEN

639: IF l_PSG_rec.program_update_date = FND_API.G_MISS_DATE THEN
640: l_PSG_rec.program_update_date := p_old_PSG_rec.program_update_date;
641: END IF;
642:
643: IF l_PSG_rec.pte_code = FND_API.G_MISS_CHAR THEN
644: l_PSG_rec.pte_code := p_old_PSG_rec.pte_code;
645: END IF;
646:
647: IF l_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR THEN

Line 647: IF l_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR THEN

643: IF l_PSG_rec.pte_code = FND_API.G_MISS_CHAR THEN
644: l_PSG_rec.pte_code := p_old_PSG_rec.pte_code;
645: END IF;
646:
647: IF l_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR THEN
648: l_PSG_rec.seeded_sourcing_method := p_old_PSG_rec.seeded_sourcing_method;
649: END IF;
650:
651: IF l_PSG_rec.segment_id = FND_API.G_MISS_NUM THEN

Line 651: IF l_PSG_rec.segment_id = FND_API.G_MISS_NUM THEN

647: IF l_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR THEN
648: l_PSG_rec.seeded_sourcing_method := p_old_PSG_rec.seeded_sourcing_method;
649: END IF;
650:
651: IF l_PSG_rec.segment_id = FND_API.G_MISS_NUM THEN
652: l_PSG_rec.segment_id := p_old_PSG_rec.segment_id;
653: END IF;
654:
655: IF l_PSG_rec.segment_level = FND_API.G_MISS_CHAR THEN

Line 655: IF l_PSG_rec.segment_level = FND_API.G_MISS_CHAR THEN

651: IF l_PSG_rec.segment_id = FND_API.G_MISS_NUM THEN
652: l_PSG_rec.segment_id := p_old_PSG_rec.segment_id;
653: END IF;
654:
655: IF l_PSG_rec.segment_level = FND_API.G_MISS_CHAR THEN
656: l_PSG_rec.segment_level := p_old_PSG_rec.segment_level;
657: END IF;
658:
659: IF l_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM THEN

Line 659: IF l_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM THEN

655: IF l_PSG_rec.segment_level = FND_API.G_MISS_CHAR THEN
656: l_PSG_rec.segment_level := p_old_PSG_rec.segment_level;
657: END IF;
658:
659: IF l_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM THEN
660: l_PSG_rec.segment_pte_id := p_old_PSG_rec.segment_pte_id;
661: END IF;
662:
663: IF l_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR THEN

Line 663: IF l_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR THEN

659: IF l_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM THEN
660: l_PSG_rec.segment_pte_id := p_old_PSG_rec.segment_pte_id;
661: END IF;
662:
663: IF l_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR THEN
664: l_PSG_rec.sourcing_enabled := p_old_PSG_rec.sourcing_enabled;
665: END IF;
666:
667: IF l_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR THEN

Line 667: IF l_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR THEN

663: IF l_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR THEN
664: l_PSG_rec.sourcing_enabled := p_old_PSG_rec.sourcing_enabled;
665: END IF;
666:
667: IF l_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR THEN
668: l_PSG_rec.sourcing_status := p_old_PSG_rec.sourcing_status;
669: END IF;
670:
671: IF l_PSG_rec.user_sourcing_method = FND_API.G_MISS_CHAR THEN

Line 671: IF l_PSG_rec.user_sourcing_method = FND_API.G_MISS_CHAR THEN

667: IF l_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR THEN
668: l_PSG_rec.sourcing_status := p_old_PSG_rec.sourcing_status;
669: END IF;
670:
671: IF l_PSG_rec.user_sourcing_method = FND_API.G_MISS_CHAR THEN
672: l_PSG_rec.user_sourcing_method := p_old_PSG_rec.user_sourcing_method;
673: END IF;
674:
675: RETURN l_PSG_rec;

Line 688: IF l_PSG_rec.attribute1 = FND_API.G_MISS_CHAR THEN

684: IS
685: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type := p_PSG_rec;
686: BEGIN
687:
688: IF l_PSG_rec.attribute1 = FND_API.G_MISS_CHAR THEN
689: l_PSG_rec.attribute1 := NULL;
690: END IF;
691:
692: IF l_PSG_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 692: IF l_PSG_rec.attribute10 = FND_API.G_MISS_CHAR THEN

688: IF l_PSG_rec.attribute1 = FND_API.G_MISS_CHAR THEN
689: l_PSG_rec.attribute1 := NULL;
690: END IF;
691:
692: IF l_PSG_rec.attribute10 = FND_API.G_MISS_CHAR THEN
693: l_PSG_rec.attribute10 := NULL;
694: END IF;
695:
696: IF l_PSG_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 696: IF l_PSG_rec.attribute11 = FND_API.G_MISS_CHAR THEN

692: IF l_PSG_rec.attribute10 = FND_API.G_MISS_CHAR THEN
693: l_PSG_rec.attribute10 := NULL;
694: END IF;
695:
696: IF l_PSG_rec.attribute11 = FND_API.G_MISS_CHAR THEN
697: l_PSG_rec.attribute11 := NULL;
698: END IF;
699:
700: IF l_PSG_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 700: IF l_PSG_rec.attribute12 = FND_API.G_MISS_CHAR THEN

696: IF l_PSG_rec.attribute11 = FND_API.G_MISS_CHAR THEN
697: l_PSG_rec.attribute11 := NULL;
698: END IF;
699:
700: IF l_PSG_rec.attribute12 = FND_API.G_MISS_CHAR THEN
701: l_PSG_rec.attribute12 := NULL;
702: END IF;
703:
704: IF l_PSG_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 704: IF l_PSG_rec.attribute13 = FND_API.G_MISS_CHAR THEN

700: IF l_PSG_rec.attribute12 = FND_API.G_MISS_CHAR THEN
701: l_PSG_rec.attribute12 := NULL;
702: END IF;
703:
704: IF l_PSG_rec.attribute13 = FND_API.G_MISS_CHAR THEN
705: l_PSG_rec.attribute13 := NULL;
706: END IF;
707:
708: IF l_PSG_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 708: IF l_PSG_rec.attribute14 = FND_API.G_MISS_CHAR THEN

704: IF l_PSG_rec.attribute13 = FND_API.G_MISS_CHAR THEN
705: l_PSG_rec.attribute13 := NULL;
706: END IF;
707:
708: IF l_PSG_rec.attribute14 = FND_API.G_MISS_CHAR THEN
709: l_PSG_rec.attribute14 := NULL;
710: END IF;
711:
712: IF l_PSG_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 712: IF l_PSG_rec.attribute15 = FND_API.G_MISS_CHAR THEN

708: IF l_PSG_rec.attribute14 = FND_API.G_MISS_CHAR THEN
709: l_PSG_rec.attribute14 := NULL;
710: END IF;
711:
712: IF l_PSG_rec.attribute15 = FND_API.G_MISS_CHAR THEN
713: l_PSG_rec.attribute15 := NULL;
714: END IF;
715:
716: IF l_PSG_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 716: IF l_PSG_rec.attribute2 = FND_API.G_MISS_CHAR THEN

712: IF l_PSG_rec.attribute15 = FND_API.G_MISS_CHAR THEN
713: l_PSG_rec.attribute15 := NULL;
714: END IF;
715:
716: IF l_PSG_rec.attribute2 = FND_API.G_MISS_CHAR THEN
717: l_PSG_rec.attribute2 := NULL;
718: END IF;
719:
720: IF l_PSG_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 720: IF l_PSG_rec.attribute3 = FND_API.G_MISS_CHAR THEN

716: IF l_PSG_rec.attribute2 = FND_API.G_MISS_CHAR THEN
717: l_PSG_rec.attribute2 := NULL;
718: END IF;
719:
720: IF l_PSG_rec.attribute3 = FND_API.G_MISS_CHAR THEN
721: l_PSG_rec.attribute3 := NULL;
722: END IF;
723:
724: IF l_PSG_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 724: IF l_PSG_rec.attribute4 = FND_API.G_MISS_CHAR THEN

720: IF l_PSG_rec.attribute3 = FND_API.G_MISS_CHAR THEN
721: l_PSG_rec.attribute3 := NULL;
722: END IF;
723:
724: IF l_PSG_rec.attribute4 = FND_API.G_MISS_CHAR THEN
725: l_PSG_rec.attribute4 := NULL;
726: END IF;
727:
728: IF l_PSG_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 728: IF l_PSG_rec.attribute5 = FND_API.G_MISS_CHAR THEN

724: IF l_PSG_rec.attribute4 = FND_API.G_MISS_CHAR THEN
725: l_PSG_rec.attribute4 := NULL;
726: END IF;
727:
728: IF l_PSG_rec.attribute5 = FND_API.G_MISS_CHAR THEN
729: l_PSG_rec.attribute5 := NULL;
730: END IF;
731:
732: IF l_PSG_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 732: IF l_PSG_rec.attribute6 = FND_API.G_MISS_CHAR THEN

728: IF l_PSG_rec.attribute5 = FND_API.G_MISS_CHAR THEN
729: l_PSG_rec.attribute5 := NULL;
730: END IF;
731:
732: IF l_PSG_rec.attribute6 = FND_API.G_MISS_CHAR THEN
733: l_PSG_rec.attribute6 := NULL;
734: END IF;
735:
736: IF l_PSG_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 736: IF l_PSG_rec.attribute7 = FND_API.G_MISS_CHAR THEN

732: IF l_PSG_rec.attribute6 = FND_API.G_MISS_CHAR THEN
733: l_PSG_rec.attribute6 := NULL;
734: END IF;
735:
736: IF l_PSG_rec.attribute7 = FND_API.G_MISS_CHAR THEN
737: l_PSG_rec.attribute7 := NULL;
738: END IF;
739:
740: IF l_PSG_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 740: IF l_PSG_rec.attribute8 = FND_API.G_MISS_CHAR THEN

736: IF l_PSG_rec.attribute7 = FND_API.G_MISS_CHAR THEN
737: l_PSG_rec.attribute7 := NULL;
738: END IF;
739:
740: IF l_PSG_rec.attribute8 = FND_API.G_MISS_CHAR THEN
741: l_PSG_rec.attribute8 := NULL;
742: END IF;
743:
744: IF l_PSG_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 744: IF l_PSG_rec.attribute9 = FND_API.G_MISS_CHAR THEN

740: IF l_PSG_rec.attribute8 = FND_API.G_MISS_CHAR THEN
741: l_PSG_rec.attribute8 := NULL;
742: END IF;
743:
744: IF l_PSG_rec.attribute9 = FND_API.G_MISS_CHAR THEN
745: l_PSG_rec.attribute9 := NULL;
746: END IF;
747:
748: IF l_PSG_rec.context = FND_API.G_MISS_CHAR THEN

Line 748: IF l_PSG_rec.context = FND_API.G_MISS_CHAR THEN

744: IF l_PSG_rec.attribute9 = FND_API.G_MISS_CHAR THEN
745: l_PSG_rec.attribute9 := NULL;
746: END IF;
747:
748: IF l_PSG_rec.context = FND_API.G_MISS_CHAR THEN
749: l_PSG_rec.context := NULL;
750: END IF;
751:
752: IF l_PSG_rec.created_by = FND_API.G_MISS_NUM THEN

Line 752: IF l_PSG_rec.created_by = FND_API.G_MISS_NUM THEN

748: IF l_PSG_rec.context = FND_API.G_MISS_CHAR THEN
749: l_PSG_rec.context := NULL;
750: END IF;
751:
752: IF l_PSG_rec.created_by = FND_API.G_MISS_NUM THEN
753: l_PSG_rec.created_by := NULL;
754: END IF;
755:
756: IF l_PSG_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 756: IF l_PSG_rec.creation_date = FND_API.G_MISS_DATE THEN

752: IF l_PSG_rec.created_by = FND_API.G_MISS_NUM THEN
753: l_PSG_rec.created_by := NULL;
754: END IF;
755:
756: IF l_PSG_rec.creation_date = FND_API.G_MISS_DATE THEN
757: l_PSG_rec.creation_date := NULL;
758: END IF;
759:
760: IF l_PSG_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 760: IF l_PSG_rec.last_updated_by = FND_API.G_MISS_NUM THEN

756: IF l_PSG_rec.creation_date = FND_API.G_MISS_DATE THEN
757: l_PSG_rec.creation_date := NULL;
758: END IF;
759:
760: IF l_PSG_rec.last_updated_by = FND_API.G_MISS_NUM THEN
761: l_PSG_rec.last_updated_by := NULL;
762: END IF;
763:
764: IF l_PSG_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 764: IF l_PSG_rec.last_update_date = FND_API.G_MISS_DATE THEN

760: IF l_PSG_rec.last_updated_by = FND_API.G_MISS_NUM THEN
761: l_PSG_rec.last_updated_by := NULL;
762: END IF;
763:
764: IF l_PSG_rec.last_update_date = FND_API.G_MISS_DATE THEN
765: l_PSG_rec.last_update_date := NULL;
766: END IF;
767:
768: IF l_PSG_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 768: IF l_PSG_rec.last_update_login = FND_API.G_MISS_NUM THEN

764: IF l_PSG_rec.last_update_date = FND_API.G_MISS_DATE THEN
765: l_PSG_rec.last_update_date := NULL;
766: END IF;
767:
768: IF l_PSG_rec.last_update_login = FND_API.G_MISS_NUM THEN
769: l_PSG_rec.last_update_login := NULL;
770: END IF;
771:
772: IF l_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR THEN

Line 772: IF l_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR THEN

768: IF l_PSG_rec.last_update_login = FND_API.G_MISS_NUM THEN
769: l_PSG_rec.last_update_login := NULL;
770: END IF;
771:
772: IF l_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR THEN
773: l_PSG_rec.limits_enabled := NULL;
774: END IF;
775:
776: IF l_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR THEN

Line 776: IF l_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR THEN

772: IF l_PSG_rec.limits_enabled = FND_API.G_MISS_CHAR THEN
773: l_PSG_rec.limits_enabled := NULL;
774: END IF;
775:
776: IF l_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR THEN
777: l_PSG_rec.lov_enabled := NULL;
778: END IF;
779:
780: IF l_PSG_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 780: IF l_PSG_rec.program_application_id = FND_API.G_MISS_NUM THEN

776: IF l_PSG_rec.lov_enabled = FND_API.G_MISS_CHAR THEN
777: l_PSG_rec.lov_enabled := NULL;
778: END IF;
779:
780: IF l_PSG_rec.program_application_id = FND_API.G_MISS_NUM THEN
781: l_PSG_rec.program_application_id := NULL;
782: END IF;
783:
784: IF l_PSG_rec.program_id = FND_API.G_MISS_NUM THEN

Line 784: IF l_PSG_rec.program_id = FND_API.G_MISS_NUM THEN

780: IF l_PSG_rec.program_application_id = FND_API.G_MISS_NUM THEN
781: l_PSG_rec.program_application_id := NULL;
782: END IF;
783:
784: IF l_PSG_rec.program_id = FND_API.G_MISS_NUM THEN
785: l_PSG_rec.program_id := NULL;
786: END IF;
787:
788: IF l_PSG_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 788: IF l_PSG_rec.program_update_date = FND_API.G_MISS_DATE THEN

784: IF l_PSG_rec.program_id = FND_API.G_MISS_NUM THEN
785: l_PSG_rec.program_id := NULL;
786: END IF;
787:
788: IF l_PSG_rec.program_update_date = FND_API.G_MISS_DATE THEN
789: l_PSG_rec.program_update_date := NULL;
790: END IF;
791:
792: IF l_PSG_rec.pte_code = FND_API.G_MISS_CHAR THEN

Line 792: IF l_PSG_rec.pte_code = FND_API.G_MISS_CHAR THEN

788: IF l_PSG_rec.program_update_date = FND_API.G_MISS_DATE THEN
789: l_PSG_rec.program_update_date := NULL;
790: END IF;
791:
792: IF l_PSG_rec.pte_code = FND_API.G_MISS_CHAR THEN
793: l_PSG_rec.pte_code := NULL;
794: END IF;
795:
796: IF l_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR THEN

Line 796: IF l_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR THEN

792: IF l_PSG_rec.pte_code = FND_API.G_MISS_CHAR THEN
793: l_PSG_rec.pte_code := NULL;
794: END IF;
795:
796: IF l_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR THEN
797: l_PSG_rec.seeded_sourcing_method := NULL;
798: END IF;
799:
800: IF l_PSG_rec.segment_id = FND_API.G_MISS_NUM THEN

Line 800: IF l_PSG_rec.segment_id = FND_API.G_MISS_NUM THEN

796: IF l_PSG_rec.seeded_sourcing_method = FND_API.G_MISS_CHAR THEN
797: l_PSG_rec.seeded_sourcing_method := NULL;
798: END IF;
799:
800: IF l_PSG_rec.segment_id = FND_API.G_MISS_NUM THEN
801: l_PSG_rec.segment_id := NULL;
802: END IF;
803:
804: IF l_PSG_rec.segment_level = FND_API.G_MISS_CHAR THEN

Line 804: IF l_PSG_rec.segment_level = FND_API.G_MISS_CHAR THEN

800: IF l_PSG_rec.segment_id = FND_API.G_MISS_NUM THEN
801: l_PSG_rec.segment_id := NULL;
802: END IF;
803:
804: IF l_PSG_rec.segment_level = FND_API.G_MISS_CHAR THEN
805: l_PSG_rec.segment_level := NULL;
806: END IF;
807:
808: IF l_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM THEN

Line 808: IF l_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM THEN

804: IF l_PSG_rec.segment_level = FND_API.G_MISS_CHAR THEN
805: l_PSG_rec.segment_level := NULL;
806: END IF;
807:
808: IF l_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM THEN
809: l_PSG_rec.segment_pte_id := NULL;
810: END IF;
811:
812: IF l_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR THEN

Line 812: IF l_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR THEN

808: IF l_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM THEN
809: l_PSG_rec.segment_pte_id := NULL;
810: END IF;
811:
812: IF l_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR THEN
813: l_PSG_rec.sourcing_enabled := NULL;
814: END IF;
815:
816: IF l_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR THEN

Line 816: IF l_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR THEN

812: IF l_PSG_rec.sourcing_enabled = FND_API.G_MISS_CHAR THEN
813: l_PSG_rec.sourcing_enabled := NULL;
814: END IF;
815:
816: IF l_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR THEN
817: l_PSG_rec.sourcing_status := NULL;
818: END IF;
819:
820: IF l_PSG_rec.user_sourcing_method = FND_API.G_MISS_CHAR THEN

Line 820: IF l_PSG_rec.user_sourcing_method = FND_API.G_MISS_CHAR THEN

816: IF l_PSG_rec.sourcing_status = FND_API.G_MISS_CHAR THEN
817: l_PSG_rec.sourcing_status := NULL;
818: END IF;
819:
820: IF l_PSG_rec.user_sourcing_method = FND_API.G_MISS_CHAR THEN
821: l_PSG_rec.user_sourcing_method := NULL;
822: END IF;
823:
824: RETURN l_PSG_rec;

Line 886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

882: , 'Update_Row'
883: );
884: END IF;
885:
886: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
887:
888: END Update_Row;
889:
890: -- Procedure Insert_Row

Line 984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

980: , 'Insert_Row'
981: );
982: END IF;
983:
984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
985:
986: END Insert_Row;
987:
988: -- Procedure Delete_Row

Line 1012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1008: , 'Delete_Row'
1009: );
1010: END IF;
1011:
1012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1013:
1014: END Delete_Row;
1015:
1016: -- Function Query_Row

Line 1036: FND_API.G_MISS_NUM

1032: --
1033:
1034: FUNCTION Query_Rows
1035: ( p_segment_pte_id IN NUMBER :=
1036: FND_API.G_MISS_NUM
1037: , p_lookup_code IN VARCHAR2 :=
1038: FND_API.G_MISS_CHAR
1039: ) RETURN QP_Attr_Map_PUB.Psg_Tbl_Type
1040: IS

Line 1038: FND_API.G_MISS_CHAR

1034: FUNCTION Query_Rows
1035: ( p_segment_pte_id IN NUMBER :=
1036: FND_API.G_MISS_NUM
1037: , p_lookup_code IN VARCHAR2 :=
1038: FND_API.G_MISS_CHAR
1039: ) RETURN QP_Attr_Map_PUB.Psg_Tbl_Type
1040: IS
1041: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
1042: l_PSG_tbl QP_Attr_Map_PUB.Psg_Tbl_Type;

Line 1091: p_segment_pte_id <> FND_API.G_MISS_NUM)

1087:
1088: IF
1089: (p_segment_pte_id IS NOT NULL
1090: AND
1091: p_segment_pte_id <> FND_API.G_MISS_NUM)
1092: AND
1093: (p_lookup_code IS NOT NULL
1094: AND
1095: p_lookup_code <> FND_API.G_MISS_CHAR)

Line 1095: p_lookup_code <> FND_API.G_MISS_CHAR)

1091: p_segment_pte_id <> FND_API.G_MISS_NUM)
1092: AND
1093: (p_lookup_code IS NOT NULL
1094: AND
1095: p_lookup_code <> FND_API.G_MISS_CHAR)
1096: THEN
1097: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1098: THEN
1099: OE_MSG_PUB.Add_Exc_Msg

Line 1106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1102: , 'Keys are mutually exclusive: segment_pte_id = '|| p_segment_pte_id || ', lookup_code = '|| p_lookup_code
1103: );
1104: END IF;
1105:
1106: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1107:
1108: END IF;
1109:
1110:

Line 1160: p_segment_pte_id <> FND_API.G_MISS_NUM)

1156:
1157: IF
1158: (p_segment_pte_id IS NOT NULL
1159: AND
1160: p_segment_pte_id <> FND_API.G_MISS_NUM)
1161: AND
1162: (l_PSG_tbl.COUNT = 0)
1163: THEN
1164: RAISE NO_DATA_FOUND;

Line 1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1170: RETURN l_PSG_tbl;
1171:
1172: EXCEPTION
1173:
1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1175:
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177:
1178: WHEN OTHERS THEN

Line 1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1172: EXCEPTION
1173:
1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1175:
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1177:
1178: WHEN OTHERS THEN
1179:
1180: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1184: , 'Query_Rows'
1185: );
1186: END IF;
1187:
1188: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1189:
1190: END Query_Rows;
1191:
1192: -- Procedure lock_Row

Line 1354: x_return_status := FND_API.G_RET_STS_SUCCESS;

1350: x_PSG_rec := l_PSG_rec;
1351:
1352: -- Set return status
1353:
1354: x_return_status := FND_API.G_RET_STS_SUCCESS;
1355: x_PSG_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1356:
1357: ELSE
1358:

Line 1355: x_PSG_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1351:
1352: -- Set return status
1353:
1354: x_return_status := FND_API.G_RET_STS_SUCCESS;
1355: x_PSG_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1356:
1357: ELSE
1358:
1359: -- Row has changed by another user.

Line 1361: x_return_status := FND_API.G_RET_STS_ERROR;

1357: ELSE
1358:
1359: -- Row has changed by another user.
1360:
1361: x_return_status := FND_API.G_RET_STS_ERROR;
1362: x_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1363:
1364: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1365: THEN

Line 1362: x_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;

1358:
1359: -- Row has changed by another user.
1360:
1361: x_return_status := FND_API.G_RET_STS_ERROR;
1362: x_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1363:
1364: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1365: THEN
1366:

Line 1378: x_return_status := FND_API.G_RET_STS_ERROR;

1374: EXCEPTION
1375:
1376: WHEN NO_DATA_FOUND THEN
1377:
1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: x_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1380:
1381: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1382: THEN

Line 1379: x_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;

1375:
1376: WHEN NO_DATA_FOUND THEN
1377:
1378: x_return_status := FND_API.G_RET_STS_ERROR;
1379: x_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1380:
1381: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1382: THEN
1383:

Line 1390: x_return_status := FND_API.G_RET_STS_ERROR;

1386:
1387: END IF;
1388: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1389:
1390: x_return_status := FND_API.G_RET_STS_ERROR;
1391: x_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1392:
1393: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1394: THEN

Line 1391: x_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;

1387: END IF;
1388: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1389:
1390: x_return_status := FND_API.G_RET_STS_ERROR;
1391: x_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1392:
1393: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1394: THEN
1395:

Line 1402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1398:
1399: END IF;
1400: WHEN OTHERS THEN
1401:
1402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1403: x_PSG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404:
1405: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1406: THEN

Line 1403: x_PSG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1399: END IF;
1400: WHEN OTHERS THEN
1401:
1402: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1403: x_PSG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1404:
1405: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1406: THEN
1407: OE_MSG_PUB.Add_Exc_Msg

Line 1427: p_PSG_rec.pte_code <> FND_API.G_MISS_CHAR AND

1423: l_PSG_val_rec QP_Attr_Map_PUB.Psg_Val_Rec_Type;
1424: BEGIN
1425:
1426: IF p_PSG_rec.pte_code IS NOT NULL AND
1427: p_PSG_rec.pte_code <> FND_API.G_MISS_CHAR AND
1428: NOT QP_GLOBALS.Equal(p_PSG_rec.pte_code,
1429: p_old_PSG_rec.pte_code)
1430: THEN
1431: l_PSG_val_rec.pte := QP_Id_To_Value.Pte

Line 1437: p_PSG_rec.segment_id <> FND_API.G_MISS_NUM AND

1433: );
1434: END IF;
1435:
1436: IF p_PSG_rec.segment_id IS NOT NULL AND
1437: p_PSG_rec.segment_id <> FND_API.G_MISS_NUM AND
1438: NOT QP_GLOBALS.Equal(p_PSG_rec.segment_id,
1439: p_old_PSG_rec.segment_id)
1440: THEN
1441: l_PSG_val_rec.segment := QP_Id_To_Value.Segment

Line 1447: p_PSG_rec.segment_pte_id <> FND_API.G_MISS_NUM AND

1443: );
1444: END IF;
1445:
1446: IF p_PSG_rec.segment_pte_id IS NOT NULL AND
1447: p_PSG_rec.segment_pte_id <> FND_API.G_MISS_NUM AND
1448: NOT QP_GLOBALS.Equal(p_PSG_rec.segment_pte_id,
1449: p_old_PSG_rec.segment_pte_id)
1450: THEN
1451: l_PSG_val_rec.segment_pte := QP_Id_To_Value.Segment_Pte

Line 1472: l_PSG_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1468: BEGIN
1469:
1470: -- initialize return_status.
1471:
1472: l_PSG_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1473:
1474: -- initialize l_PSG_rec.
1475:
1476: l_PSG_rec := p_PSG_rec;

Line 1478: IF p_PSG_val_rec.pte <> FND_API.G_MISS_CHAR

1474: -- initialize l_PSG_rec.
1475:
1476: l_PSG_rec := p_PSG_rec;
1477:
1478: IF p_PSG_val_rec.pte <> FND_API.G_MISS_CHAR
1479: THEN
1480:
1481: IF p_PSG_rec.pte_code <> FND_API.G_MISS_CHAR THEN
1482:

Line 1481: IF p_PSG_rec.pte_code <> FND_API.G_MISS_CHAR THEN

1477:
1478: IF p_PSG_val_rec.pte <> FND_API.G_MISS_CHAR
1479: THEN
1480:
1481: IF p_PSG_rec.pte_code <> FND_API.G_MISS_CHAR THEN
1482:
1483: l_PSG_rec.pte_code := p_PSG_rec.pte_code;
1484:
1485: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1500: IF l_PSG_rec.pte_code = FND_API.G_MISS_CHAR THEN

1496: l_PSG_rec.pte_code := QP_Value_To_Id.pte
1497: ( p_pte => p_PSG_val_rec.pte
1498: );
1499:
1500: IF l_PSG_rec.pte_code = FND_API.G_MISS_CHAR THEN
1501: l_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1502: END IF;
1503:
1504: END IF;

Line 1501: l_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;

1497: ( p_pte => p_PSG_val_rec.pte
1498: );
1499:
1500: IF l_PSG_rec.pte_code = FND_API.G_MISS_CHAR THEN
1501: l_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1502: END IF;
1503:
1504: END IF;
1505:

Line 1508: IF p_PSG_val_rec.segment <> FND_API.G_MISS_CHAR

1504: END IF;
1505:
1506: END IF;
1507:
1508: IF p_PSG_val_rec.segment <> FND_API.G_MISS_CHAR
1509: THEN
1510:
1511: IF p_PSG_rec.segment_id <> FND_API.G_MISS_NUM THEN
1512:

Line 1511: IF p_PSG_rec.segment_id <> FND_API.G_MISS_NUM THEN

1507:
1508: IF p_PSG_val_rec.segment <> FND_API.G_MISS_CHAR
1509: THEN
1510:
1511: IF p_PSG_rec.segment_id <> FND_API.G_MISS_NUM THEN
1512:
1513: l_PSG_rec.segment_id := p_PSG_rec.segment_id;
1514:
1515: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1532: IF l_PSG_rec.segment_id = FND_API.G_MISS_NUM THEN

1528: --**);
1529: --** Added next line
1530: l_PSG_rec.segment_id := p_PSG_rec.segment_id;
1531:
1532: IF l_PSG_rec.segment_id = FND_API.G_MISS_NUM THEN
1533: l_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1534: END IF;
1535:
1536: END IF;

Line 1533: l_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;

1529: --** Added next line
1530: l_PSG_rec.segment_id := p_PSG_rec.segment_id;
1531:
1532: IF l_PSG_rec.segment_id = FND_API.G_MISS_NUM THEN
1533: l_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1534: END IF;
1535:
1536: END IF;
1537:

Line 1540: IF p_PSG_val_rec.segment_pte <> FND_API.G_MISS_CHAR

1536: END IF;
1537:
1538: END IF;
1539:
1540: IF p_PSG_val_rec.segment_pte <> FND_API.G_MISS_CHAR
1541: THEN
1542:
1543: IF p_PSG_rec.segment_pte_id <> FND_API.G_MISS_NUM THEN
1544:

Line 1543: IF p_PSG_rec.segment_pte_id <> FND_API.G_MISS_NUM THEN

1539:
1540: IF p_PSG_val_rec.segment_pte <> FND_API.G_MISS_CHAR
1541: THEN
1542:
1543: IF p_PSG_rec.segment_pte_id <> FND_API.G_MISS_NUM THEN
1544:
1545: l_PSG_rec.segment_pte_id := p_PSG_rec.segment_pte_id;
1546:
1547: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1562: IF l_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM THEN

1558: l_PSG_rec.segment_pte_id := QP_Value_To_Id.segment_pte
1559: ( p_segment_pte => p_PSG_val_rec.segment_pte
1560: );
1561:
1562: IF l_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM THEN
1563: l_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1564: END IF;
1565:
1566: END IF;

Line 1563: l_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;

1559: ( p_segment_pte => p_PSG_val_rec.segment_pte
1560: );
1561:
1562: IF l_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM THEN
1563: l_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1564: END IF;
1565:
1566: END IF;
1567: