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_SEG_UTIL dependencies on FND_API

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

58: )*/
59: end;
60: --
61: PROCEDURE Clear_Dependent_Attr
62: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
63: , p_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type
64: , p_old_SEG_rec IN QP_Attributes_PUB.Seg_Rec_Type :=
65: QP_Attributes_PUB.G_MISS_SEG_REC
66: , x_SEG_rec OUT NOCOPY /* file.sql.39 change */ QP_Attributes_PUB.Seg_Rec_Type

Line 81: IF p_attr_id = FND_API.G_MISS_NUM THEN

77:
78: -- If attr_id is missing compare old and new records and for
79: -- every changed attribute clear its dependent fields.
80:
81: IF p_attr_id = FND_API.G_MISS_NUM THEN
82:
83: IF NOT QP_GLOBALS.Equal(p_SEG_rec.attribute1,p_old_SEG_rec.attribute1)
84: THEN
85: l_index := l_index + 1;

Line 717: IF l_SEG_rec.attribute1 = FND_API.G_MISS_CHAR THEN

713: IS
714: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type := p_SEG_rec;
715: BEGIN
716:
717: IF l_SEG_rec.attribute1 = FND_API.G_MISS_CHAR THEN
718: l_SEG_rec.attribute1 := p_old_SEG_rec.attribute1;
719: END IF;
720:
721: IF l_SEG_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 721: IF l_SEG_rec.attribute10 = FND_API.G_MISS_CHAR THEN

717: IF l_SEG_rec.attribute1 = FND_API.G_MISS_CHAR THEN
718: l_SEG_rec.attribute1 := p_old_SEG_rec.attribute1;
719: END IF;
720:
721: IF l_SEG_rec.attribute10 = FND_API.G_MISS_CHAR THEN
722: l_SEG_rec.attribute10 := p_old_SEG_rec.attribute10;
723: END IF;
724:
725: IF l_SEG_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 725: IF l_SEG_rec.attribute11 = FND_API.G_MISS_CHAR THEN

721: IF l_SEG_rec.attribute10 = FND_API.G_MISS_CHAR THEN
722: l_SEG_rec.attribute10 := p_old_SEG_rec.attribute10;
723: END IF;
724:
725: IF l_SEG_rec.attribute11 = FND_API.G_MISS_CHAR THEN
726: l_SEG_rec.attribute11 := p_old_SEG_rec.attribute11;
727: END IF;
728:
729: IF l_SEG_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 729: IF l_SEG_rec.attribute12 = FND_API.G_MISS_CHAR THEN

725: IF l_SEG_rec.attribute11 = FND_API.G_MISS_CHAR THEN
726: l_SEG_rec.attribute11 := p_old_SEG_rec.attribute11;
727: END IF;
728:
729: IF l_SEG_rec.attribute12 = FND_API.G_MISS_CHAR THEN
730: l_SEG_rec.attribute12 := p_old_SEG_rec.attribute12;
731: END IF;
732:
733: IF l_SEG_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 733: IF l_SEG_rec.attribute13 = FND_API.G_MISS_CHAR THEN

729: IF l_SEG_rec.attribute12 = FND_API.G_MISS_CHAR THEN
730: l_SEG_rec.attribute12 := p_old_SEG_rec.attribute12;
731: END IF;
732:
733: IF l_SEG_rec.attribute13 = FND_API.G_MISS_CHAR THEN
734: l_SEG_rec.attribute13 := p_old_SEG_rec.attribute13;
735: END IF;
736:
737: IF l_SEG_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 737: IF l_SEG_rec.attribute14 = FND_API.G_MISS_CHAR THEN

733: IF l_SEG_rec.attribute13 = FND_API.G_MISS_CHAR THEN
734: l_SEG_rec.attribute13 := p_old_SEG_rec.attribute13;
735: END IF;
736:
737: IF l_SEG_rec.attribute14 = FND_API.G_MISS_CHAR THEN
738: l_SEG_rec.attribute14 := p_old_SEG_rec.attribute14;
739: END IF;
740:
741: IF l_SEG_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 741: IF l_SEG_rec.attribute15 = FND_API.G_MISS_CHAR THEN

737: IF l_SEG_rec.attribute14 = FND_API.G_MISS_CHAR THEN
738: l_SEG_rec.attribute14 := p_old_SEG_rec.attribute14;
739: END IF;
740:
741: IF l_SEG_rec.attribute15 = FND_API.G_MISS_CHAR THEN
742: l_SEG_rec.attribute15 := p_old_SEG_rec.attribute15;
743: END IF;
744:
745: IF l_SEG_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 745: IF l_SEG_rec.attribute2 = FND_API.G_MISS_CHAR THEN

741: IF l_SEG_rec.attribute15 = FND_API.G_MISS_CHAR THEN
742: l_SEG_rec.attribute15 := p_old_SEG_rec.attribute15;
743: END IF;
744:
745: IF l_SEG_rec.attribute2 = FND_API.G_MISS_CHAR THEN
746: l_SEG_rec.attribute2 := p_old_SEG_rec.attribute2;
747: END IF;
748:
749: IF l_SEG_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 749: IF l_SEG_rec.attribute3 = FND_API.G_MISS_CHAR THEN

745: IF l_SEG_rec.attribute2 = FND_API.G_MISS_CHAR THEN
746: l_SEG_rec.attribute2 := p_old_SEG_rec.attribute2;
747: END IF;
748:
749: IF l_SEG_rec.attribute3 = FND_API.G_MISS_CHAR THEN
750: l_SEG_rec.attribute3 := p_old_SEG_rec.attribute3;
751: END IF;
752:
753: IF l_SEG_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 753: IF l_SEG_rec.attribute4 = FND_API.G_MISS_CHAR THEN

749: IF l_SEG_rec.attribute3 = FND_API.G_MISS_CHAR THEN
750: l_SEG_rec.attribute3 := p_old_SEG_rec.attribute3;
751: END IF;
752:
753: IF l_SEG_rec.attribute4 = FND_API.G_MISS_CHAR THEN
754: l_SEG_rec.attribute4 := p_old_SEG_rec.attribute4;
755: END IF;
756:
757: IF l_SEG_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 757: IF l_SEG_rec.attribute5 = FND_API.G_MISS_CHAR THEN

753: IF l_SEG_rec.attribute4 = FND_API.G_MISS_CHAR THEN
754: l_SEG_rec.attribute4 := p_old_SEG_rec.attribute4;
755: END IF;
756:
757: IF l_SEG_rec.attribute5 = FND_API.G_MISS_CHAR THEN
758: l_SEG_rec.attribute5 := p_old_SEG_rec.attribute5;
759: END IF;
760:
761: IF l_SEG_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 761: IF l_SEG_rec.attribute6 = FND_API.G_MISS_CHAR THEN

757: IF l_SEG_rec.attribute5 = FND_API.G_MISS_CHAR THEN
758: l_SEG_rec.attribute5 := p_old_SEG_rec.attribute5;
759: END IF;
760:
761: IF l_SEG_rec.attribute6 = FND_API.G_MISS_CHAR THEN
762: l_SEG_rec.attribute6 := p_old_SEG_rec.attribute6;
763: END IF;
764:
765: IF l_SEG_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 765: IF l_SEG_rec.attribute7 = FND_API.G_MISS_CHAR THEN

761: IF l_SEG_rec.attribute6 = FND_API.G_MISS_CHAR THEN
762: l_SEG_rec.attribute6 := p_old_SEG_rec.attribute6;
763: END IF;
764:
765: IF l_SEG_rec.attribute7 = FND_API.G_MISS_CHAR THEN
766: l_SEG_rec.attribute7 := p_old_SEG_rec.attribute7;
767: END IF;
768:
769: IF l_SEG_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 769: IF l_SEG_rec.attribute8 = FND_API.G_MISS_CHAR THEN

765: IF l_SEG_rec.attribute7 = FND_API.G_MISS_CHAR THEN
766: l_SEG_rec.attribute7 := p_old_SEG_rec.attribute7;
767: END IF;
768:
769: IF l_SEG_rec.attribute8 = FND_API.G_MISS_CHAR THEN
770: l_SEG_rec.attribute8 := p_old_SEG_rec.attribute8;
771: END IF;
772:
773: IF l_SEG_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 773: IF l_SEG_rec.attribute9 = FND_API.G_MISS_CHAR THEN

769: IF l_SEG_rec.attribute8 = FND_API.G_MISS_CHAR THEN
770: l_SEG_rec.attribute8 := p_old_SEG_rec.attribute8;
771: END IF;
772:
773: IF l_SEG_rec.attribute9 = FND_API.G_MISS_CHAR THEN
774: l_SEG_rec.attribute9 := p_old_SEG_rec.attribute9;
775: END IF;
776:
777: IF l_SEG_rec.availability_in_basic = FND_API.G_MISS_CHAR THEN

Line 777: IF l_SEG_rec.availability_in_basic = FND_API.G_MISS_CHAR THEN

773: IF l_SEG_rec.attribute9 = FND_API.G_MISS_CHAR THEN
774: l_SEG_rec.attribute9 := p_old_SEG_rec.attribute9;
775: END IF;
776:
777: IF l_SEG_rec.availability_in_basic = FND_API.G_MISS_CHAR THEN
778: l_SEG_rec.availability_in_basic := p_old_SEG_rec.availability_in_basic;
779: END IF;
780:
781: IF l_SEG_rec.context = FND_API.G_MISS_CHAR THEN

Line 781: IF l_SEG_rec.context = FND_API.G_MISS_CHAR THEN

777: IF l_SEG_rec.availability_in_basic = FND_API.G_MISS_CHAR THEN
778: l_SEG_rec.availability_in_basic := p_old_SEG_rec.availability_in_basic;
779: END IF;
780:
781: IF l_SEG_rec.context = FND_API.G_MISS_CHAR THEN
782: l_SEG_rec.context := p_old_SEG_rec.context;
783: END IF;
784:
785: IF l_SEG_rec.created_by = FND_API.G_MISS_NUM THEN

Line 785: IF l_SEG_rec.created_by = FND_API.G_MISS_NUM THEN

781: IF l_SEG_rec.context = FND_API.G_MISS_CHAR THEN
782: l_SEG_rec.context := p_old_SEG_rec.context;
783: END IF;
784:
785: IF l_SEG_rec.created_by = FND_API.G_MISS_NUM THEN
786: l_SEG_rec.created_by := p_old_SEG_rec.created_by;
787: END IF;
788:
789: IF l_SEG_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 789: IF l_SEG_rec.creation_date = FND_API.G_MISS_DATE THEN

785: IF l_SEG_rec.created_by = FND_API.G_MISS_NUM THEN
786: l_SEG_rec.created_by := p_old_SEG_rec.created_by;
787: END IF;
788:
789: IF l_SEG_rec.creation_date = FND_API.G_MISS_DATE THEN
790: l_SEG_rec.creation_date := p_old_SEG_rec.creation_date;
791: END IF;
792:
793: IF l_SEG_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 793: IF l_SEG_rec.last_updated_by = FND_API.G_MISS_NUM THEN

789: IF l_SEG_rec.creation_date = FND_API.G_MISS_DATE THEN
790: l_SEG_rec.creation_date := p_old_SEG_rec.creation_date;
791: END IF;
792:
793: IF l_SEG_rec.last_updated_by = FND_API.G_MISS_NUM THEN
794: l_SEG_rec.last_updated_by := p_old_SEG_rec.last_updated_by;
795: END IF;
796:
797: IF l_SEG_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 797: IF l_SEG_rec.last_update_date = FND_API.G_MISS_DATE THEN

793: IF l_SEG_rec.last_updated_by = FND_API.G_MISS_NUM THEN
794: l_SEG_rec.last_updated_by := p_old_SEG_rec.last_updated_by;
795: END IF;
796:
797: IF l_SEG_rec.last_update_date = FND_API.G_MISS_DATE THEN
798: l_SEG_rec.last_update_date := p_old_SEG_rec.last_update_date;
799: END IF;
800:
801: IF l_SEG_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 801: IF l_SEG_rec.last_update_login = FND_API.G_MISS_NUM THEN

797: IF l_SEG_rec.last_update_date = FND_API.G_MISS_DATE THEN
798: l_SEG_rec.last_update_date := p_old_SEG_rec.last_update_date;
799: END IF;
800:
801: IF l_SEG_rec.last_update_login = FND_API.G_MISS_NUM THEN
802: l_SEG_rec.last_update_login := p_old_SEG_rec.last_update_login;
803: END IF;
804:
805: IF l_SEG_rec.prc_context_id = FND_API.G_MISS_NUM THEN

Line 805: IF l_SEG_rec.prc_context_id = FND_API.G_MISS_NUM THEN

801: IF l_SEG_rec.last_update_login = FND_API.G_MISS_NUM THEN
802: l_SEG_rec.last_update_login := p_old_SEG_rec.last_update_login;
803: END IF;
804:
805: IF l_SEG_rec.prc_context_id = FND_API.G_MISS_NUM THEN
806: l_SEG_rec.prc_context_id := p_old_SEG_rec.prc_context_id;
807: END IF;
808:
809: IF l_SEG_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 809: IF l_SEG_rec.program_application_id = FND_API.G_MISS_NUM THEN

805: IF l_SEG_rec.prc_context_id = FND_API.G_MISS_NUM THEN
806: l_SEG_rec.prc_context_id := p_old_SEG_rec.prc_context_id;
807: END IF;
808:
809: IF l_SEG_rec.program_application_id = FND_API.G_MISS_NUM THEN
810: l_SEG_rec.program_application_id := p_old_SEG_rec.program_application_id;
811: END IF;
812:
813: IF l_SEG_rec.program_id = FND_API.G_MISS_NUM THEN

Line 813: IF l_SEG_rec.program_id = FND_API.G_MISS_NUM THEN

809: IF l_SEG_rec.program_application_id = FND_API.G_MISS_NUM THEN
810: l_SEG_rec.program_application_id := p_old_SEG_rec.program_application_id;
811: END IF;
812:
813: IF l_SEG_rec.program_id = FND_API.G_MISS_NUM THEN
814: l_SEG_rec.program_id := p_old_SEG_rec.program_id;
815: END IF;
816:
817: IF l_SEG_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 817: IF l_SEG_rec.program_update_date = FND_API.G_MISS_DATE THEN

813: IF l_SEG_rec.program_id = FND_API.G_MISS_NUM THEN
814: l_SEG_rec.program_id := p_old_SEG_rec.program_id;
815: END IF;
816:
817: IF l_SEG_rec.program_update_date = FND_API.G_MISS_DATE THEN
818: l_SEG_rec.program_update_date := p_old_SEG_rec.program_update_date;
819: END IF;
820:
821: IF l_SEG_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

Line 821: IF l_SEG_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

817: IF l_SEG_rec.program_update_date = FND_API.G_MISS_DATE THEN
818: l_SEG_rec.program_update_date := p_old_SEG_rec.program_update_date;
819: END IF;
820:
821: IF l_SEG_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
822: l_SEG_rec.seeded_flag := p_old_SEG_rec.seeded_flag;
823: END IF;
824:
825: IF l_SEG_rec.seeded_format_type = FND_API.G_MISS_CHAR THEN

Line 825: IF l_SEG_rec.seeded_format_type = FND_API.G_MISS_CHAR THEN

821: IF l_SEG_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
822: l_SEG_rec.seeded_flag := p_old_SEG_rec.seeded_flag;
823: END IF;
824:
825: IF l_SEG_rec.seeded_format_type = FND_API.G_MISS_CHAR THEN
826: l_SEG_rec.seeded_format_type := p_old_SEG_rec.seeded_format_type;
827: END IF;
828:
829: IF l_SEG_rec.seeded_precedence = FND_API.G_MISS_NUM THEN

Line 829: IF l_SEG_rec.seeded_precedence = FND_API.G_MISS_NUM THEN

825: IF l_SEG_rec.seeded_format_type = FND_API.G_MISS_CHAR THEN
826: l_SEG_rec.seeded_format_type := p_old_SEG_rec.seeded_format_type;
827: END IF;
828:
829: IF l_SEG_rec.seeded_precedence = FND_API.G_MISS_NUM THEN
830: l_SEG_rec.seeded_precedence := p_old_SEG_rec.seeded_precedence;
831: END IF;
832:
833: IF l_SEG_rec.seeded_segment_name = FND_API.G_MISS_CHAR THEN

Line 833: IF l_SEG_rec.seeded_segment_name = FND_API.G_MISS_CHAR THEN

829: IF l_SEG_rec.seeded_precedence = FND_API.G_MISS_NUM THEN
830: l_SEG_rec.seeded_precedence := p_old_SEG_rec.seeded_precedence;
831: END IF;
832:
833: IF l_SEG_rec.seeded_segment_name = FND_API.G_MISS_CHAR THEN
834: l_SEG_rec.seeded_segment_name := p_old_SEG_rec.seeded_segment_name;
835: END IF;
836:
837: IF l_SEG_rec.seeded_description = FND_API.G_MISS_CHAR THEN

Line 837: IF l_SEG_rec.seeded_description = FND_API.G_MISS_CHAR THEN

833: IF l_SEG_rec.seeded_segment_name = FND_API.G_MISS_CHAR THEN
834: l_SEG_rec.seeded_segment_name := p_old_SEG_rec.seeded_segment_name;
835: END IF;
836:
837: IF l_SEG_rec.seeded_description = FND_API.G_MISS_CHAR THEN
838: l_SEG_rec.seeded_description := p_old_SEG_rec.seeded_description;
839: END IF;
840:
841: IF l_SEG_rec.user_description = FND_API.G_MISS_CHAR THEN

Line 841: IF l_SEG_rec.user_description = FND_API.G_MISS_CHAR THEN

837: IF l_SEG_rec.seeded_description = FND_API.G_MISS_CHAR THEN
838: l_SEG_rec.seeded_description := p_old_SEG_rec.seeded_description;
839: END IF;
840:
841: IF l_SEG_rec.user_description = FND_API.G_MISS_CHAR THEN
842: l_SEG_rec.user_description := p_old_SEG_rec.user_description;
843: END IF;
844:
845: IF l_SEG_rec.seeded_valueset_id = FND_API.G_MISS_NUM THEN

Line 845: IF l_SEG_rec.seeded_valueset_id = FND_API.G_MISS_NUM THEN

841: IF l_SEG_rec.user_description = FND_API.G_MISS_CHAR THEN
842: l_SEG_rec.user_description := p_old_SEG_rec.user_description;
843: END IF;
844:
845: IF l_SEG_rec.seeded_valueset_id = FND_API.G_MISS_NUM THEN
846: l_SEG_rec.seeded_valueset_id := p_old_SEG_rec.seeded_valueset_id;
847: END IF;
848:
849: IF l_SEG_rec.segment_code = FND_API.G_MISS_CHAR THEN

Line 849: IF l_SEG_rec.segment_code = FND_API.G_MISS_CHAR THEN

845: IF l_SEG_rec.seeded_valueset_id = FND_API.G_MISS_NUM THEN
846: l_SEG_rec.seeded_valueset_id := p_old_SEG_rec.seeded_valueset_id;
847: END IF;
848:
849: IF l_SEG_rec.segment_code = FND_API.G_MISS_CHAR THEN
850: l_SEG_rec.segment_code := p_old_SEG_rec.segment_code;
851: END IF;
852:
853: IF l_SEG_rec.segment_id = FND_API.G_MISS_NUM THEN

Line 853: IF l_SEG_rec.segment_id = FND_API.G_MISS_NUM THEN

849: IF l_SEG_rec.segment_code = FND_API.G_MISS_CHAR THEN
850: l_SEG_rec.segment_code := p_old_SEG_rec.segment_code;
851: END IF;
852:
853: IF l_SEG_rec.segment_id = FND_API.G_MISS_NUM THEN
854: l_SEG_rec.segment_id := p_old_SEG_rec.segment_id;
855: END IF;
856:
857: IF l_SEG_rec.application_id = FND_API.G_MISS_NUM THEN

Line 857: IF l_SEG_rec.application_id = FND_API.G_MISS_NUM THEN

853: IF l_SEG_rec.segment_id = FND_API.G_MISS_NUM THEN
854: l_SEG_rec.segment_id := p_old_SEG_rec.segment_id;
855: END IF;
856:
857: IF l_SEG_rec.application_id = FND_API.G_MISS_NUM THEN
858: l_SEG_rec.application_id := p_old_SEG_rec.application_id;
859: END IF;
860:
861: IF l_SEG_rec.segment_mapping_column = FND_API.G_MISS_CHAR THEN

Line 861: IF l_SEG_rec.segment_mapping_column = FND_API.G_MISS_CHAR THEN

857: IF l_SEG_rec.application_id = FND_API.G_MISS_NUM THEN
858: l_SEG_rec.application_id := p_old_SEG_rec.application_id;
859: END IF;
860:
861: IF l_SEG_rec.segment_mapping_column = FND_API.G_MISS_CHAR THEN
862: l_SEG_rec.segment_mapping_column := p_old_SEG_rec.segment_mapping_column;
863: END IF;
864:
865: IF l_SEG_rec.user_format_type = FND_API.G_MISS_CHAR THEN

Line 865: IF l_SEG_rec.user_format_type = FND_API.G_MISS_CHAR THEN

861: IF l_SEG_rec.segment_mapping_column = FND_API.G_MISS_CHAR THEN
862: l_SEG_rec.segment_mapping_column := p_old_SEG_rec.segment_mapping_column;
863: END IF;
864:
865: IF l_SEG_rec.user_format_type = FND_API.G_MISS_CHAR THEN
866: l_SEG_rec.user_format_type := p_old_SEG_rec.user_format_type;
867: END IF;
868:
869: IF l_SEG_rec.user_precedence = FND_API.G_MISS_NUM THEN

Line 869: IF l_SEG_rec.user_precedence = FND_API.G_MISS_NUM THEN

865: IF l_SEG_rec.user_format_type = FND_API.G_MISS_CHAR THEN
866: l_SEG_rec.user_format_type := p_old_SEG_rec.user_format_type;
867: END IF;
868:
869: IF l_SEG_rec.user_precedence = FND_API.G_MISS_NUM THEN
870: l_SEG_rec.user_precedence := p_old_SEG_rec.user_precedence;
871: END IF;
872:
873: IF l_SEG_rec.user_segment_name = FND_API.G_MISS_CHAR THEN

Line 873: IF l_SEG_rec.user_segment_name = FND_API.G_MISS_CHAR THEN

869: IF l_SEG_rec.user_precedence = FND_API.G_MISS_NUM THEN
870: l_SEG_rec.user_precedence := p_old_SEG_rec.user_precedence;
871: END IF;
872:
873: IF l_SEG_rec.user_segment_name = FND_API.G_MISS_CHAR THEN
874: l_SEG_rec.user_segment_name := p_old_SEG_rec.user_segment_name;
875: END IF;
876:
877: IF l_SEG_rec.user_valueset_id = FND_API.G_MISS_NUM THEN

Line 877: IF l_SEG_rec.user_valueset_id = FND_API.G_MISS_NUM THEN

873: IF l_SEG_rec.user_segment_name = FND_API.G_MISS_CHAR THEN
874: l_SEG_rec.user_segment_name := p_old_SEG_rec.user_segment_name;
875: END IF;
876:
877: IF l_SEG_rec.user_valueset_id = FND_API.G_MISS_NUM THEN
878: l_SEG_rec.user_valueset_id := p_old_SEG_rec.user_valueset_id;
879: END IF;
880:
881: IF l_SEG_rec.required_flag = FND_API.G_MISS_CHAR THEN

Line 881: IF l_SEG_rec.required_flag = FND_API.G_MISS_CHAR THEN

877: IF l_SEG_rec.user_valueset_id = FND_API.G_MISS_NUM THEN
878: l_SEG_rec.user_valueset_id := p_old_SEG_rec.user_valueset_id;
879: END IF;
880:
881: IF l_SEG_rec.required_flag = FND_API.G_MISS_CHAR THEN
882: l_SEG_rec.required_flag := p_old_SEG_rec.required_flag;
883: END IF;
884: -- Added for TCA
885: IF l_SEG_rec.party_hierarchy_enabled_flag = FND_API.G_MISS_CHAR THEN

Line 885: IF l_SEG_rec.party_hierarchy_enabled_flag = FND_API.G_MISS_CHAR THEN

881: IF l_SEG_rec.required_flag = FND_API.G_MISS_CHAR THEN
882: l_SEG_rec.required_flag := p_old_SEG_rec.required_flag;
883: END IF;
884: -- Added for TCA
885: IF l_SEG_rec.party_hierarchy_enabled_flag = FND_API.G_MISS_CHAR THEN
886: l_SEG_rec.party_hierarchy_enabled_flag := p_old_SEG_rec.party_hierarchy_enabled_flag;
887: END IF;
888: RETURN l_SEG_rec;
889:

Line 901: IF l_SEG_rec.attribute1 = FND_API.G_MISS_CHAR THEN

897: IS
898: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type := p_SEG_rec;
899: BEGIN
900:
901: IF l_SEG_rec.attribute1 = FND_API.G_MISS_CHAR THEN
902: l_SEG_rec.attribute1 := NULL;
903: END IF;
904:
905: IF l_SEG_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 905: IF l_SEG_rec.attribute10 = FND_API.G_MISS_CHAR THEN

901: IF l_SEG_rec.attribute1 = FND_API.G_MISS_CHAR THEN
902: l_SEG_rec.attribute1 := NULL;
903: END IF;
904:
905: IF l_SEG_rec.attribute10 = FND_API.G_MISS_CHAR THEN
906: l_SEG_rec.attribute10 := NULL;
907: END IF;
908:
909: IF l_SEG_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 909: IF l_SEG_rec.attribute11 = FND_API.G_MISS_CHAR THEN

905: IF l_SEG_rec.attribute10 = FND_API.G_MISS_CHAR THEN
906: l_SEG_rec.attribute10 := NULL;
907: END IF;
908:
909: IF l_SEG_rec.attribute11 = FND_API.G_MISS_CHAR THEN
910: l_SEG_rec.attribute11 := NULL;
911: END IF;
912:
913: IF l_SEG_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 913: IF l_SEG_rec.attribute12 = FND_API.G_MISS_CHAR THEN

909: IF l_SEG_rec.attribute11 = FND_API.G_MISS_CHAR THEN
910: l_SEG_rec.attribute11 := NULL;
911: END IF;
912:
913: IF l_SEG_rec.attribute12 = FND_API.G_MISS_CHAR THEN
914: l_SEG_rec.attribute12 := NULL;
915: END IF;
916:
917: IF l_SEG_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 917: IF l_SEG_rec.attribute13 = FND_API.G_MISS_CHAR THEN

913: IF l_SEG_rec.attribute12 = FND_API.G_MISS_CHAR THEN
914: l_SEG_rec.attribute12 := NULL;
915: END IF;
916:
917: IF l_SEG_rec.attribute13 = FND_API.G_MISS_CHAR THEN
918: l_SEG_rec.attribute13 := NULL;
919: END IF;
920:
921: IF l_SEG_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 921: IF l_SEG_rec.attribute14 = FND_API.G_MISS_CHAR THEN

917: IF l_SEG_rec.attribute13 = FND_API.G_MISS_CHAR THEN
918: l_SEG_rec.attribute13 := NULL;
919: END IF;
920:
921: IF l_SEG_rec.attribute14 = FND_API.G_MISS_CHAR THEN
922: l_SEG_rec.attribute14 := NULL;
923: END IF;
924:
925: IF l_SEG_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 925: IF l_SEG_rec.attribute15 = FND_API.G_MISS_CHAR THEN

921: IF l_SEG_rec.attribute14 = FND_API.G_MISS_CHAR THEN
922: l_SEG_rec.attribute14 := NULL;
923: END IF;
924:
925: IF l_SEG_rec.attribute15 = FND_API.G_MISS_CHAR THEN
926: l_SEG_rec.attribute15 := NULL;
927: END IF;
928:
929: IF l_SEG_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 929: IF l_SEG_rec.attribute2 = FND_API.G_MISS_CHAR THEN

925: IF l_SEG_rec.attribute15 = FND_API.G_MISS_CHAR THEN
926: l_SEG_rec.attribute15 := NULL;
927: END IF;
928:
929: IF l_SEG_rec.attribute2 = FND_API.G_MISS_CHAR THEN
930: l_SEG_rec.attribute2 := NULL;
931: END IF;
932:
933: IF l_SEG_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 933: IF l_SEG_rec.attribute3 = FND_API.G_MISS_CHAR THEN

929: IF l_SEG_rec.attribute2 = FND_API.G_MISS_CHAR THEN
930: l_SEG_rec.attribute2 := NULL;
931: END IF;
932:
933: IF l_SEG_rec.attribute3 = FND_API.G_MISS_CHAR THEN
934: l_SEG_rec.attribute3 := NULL;
935: END IF;
936:
937: IF l_SEG_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 937: IF l_SEG_rec.attribute4 = FND_API.G_MISS_CHAR THEN

933: IF l_SEG_rec.attribute3 = FND_API.G_MISS_CHAR THEN
934: l_SEG_rec.attribute3 := NULL;
935: END IF;
936:
937: IF l_SEG_rec.attribute4 = FND_API.G_MISS_CHAR THEN
938: l_SEG_rec.attribute4 := NULL;
939: END IF;
940:
941: IF l_SEG_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 941: IF l_SEG_rec.attribute5 = FND_API.G_MISS_CHAR THEN

937: IF l_SEG_rec.attribute4 = FND_API.G_MISS_CHAR THEN
938: l_SEG_rec.attribute4 := NULL;
939: END IF;
940:
941: IF l_SEG_rec.attribute5 = FND_API.G_MISS_CHAR THEN
942: l_SEG_rec.attribute5 := NULL;
943: END IF;
944:
945: IF l_SEG_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 945: IF l_SEG_rec.attribute6 = FND_API.G_MISS_CHAR THEN

941: IF l_SEG_rec.attribute5 = FND_API.G_MISS_CHAR THEN
942: l_SEG_rec.attribute5 := NULL;
943: END IF;
944:
945: IF l_SEG_rec.attribute6 = FND_API.G_MISS_CHAR THEN
946: l_SEG_rec.attribute6 := NULL;
947: END IF;
948:
949: IF l_SEG_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 949: IF l_SEG_rec.attribute7 = FND_API.G_MISS_CHAR THEN

945: IF l_SEG_rec.attribute6 = FND_API.G_MISS_CHAR THEN
946: l_SEG_rec.attribute6 := NULL;
947: END IF;
948:
949: IF l_SEG_rec.attribute7 = FND_API.G_MISS_CHAR THEN
950: l_SEG_rec.attribute7 := NULL;
951: END IF;
952:
953: IF l_SEG_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 953: IF l_SEG_rec.attribute8 = FND_API.G_MISS_CHAR THEN

949: IF l_SEG_rec.attribute7 = FND_API.G_MISS_CHAR THEN
950: l_SEG_rec.attribute7 := NULL;
951: END IF;
952:
953: IF l_SEG_rec.attribute8 = FND_API.G_MISS_CHAR THEN
954: l_SEG_rec.attribute8 := NULL;
955: END IF;
956:
957: IF l_SEG_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 957: IF l_SEG_rec.attribute9 = FND_API.G_MISS_CHAR THEN

953: IF l_SEG_rec.attribute8 = FND_API.G_MISS_CHAR THEN
954: l_SEG_rec.attribute8 := NULL;
955: END IF;
956:
957: IF l_SEG_rec.attribute9 = FND_API.G_MISS_CHAR THEN
958: l_SEG_rec.attribute9 := NULL;
959: END IF;
960:
961: IF l_SEG_rec.availability_in_basic = FND_API.G_MISS_CHAR THEN

Line 961: IF l_SEG_rec.availability_in_basic = FND_API.G_MISS_CHAR THEN

957: IF l_SEG_rec.attribute9 = FND_API.G_MISS_CHAR THEN
958: l_SEG_rec.attribute9 := NULL;
959: END IF;
960:
961: IF l_SEG_rec.availability_in_basic = FND_API.G_MISS_CHAR THEN
962: l_SEG_rec.availability_in_basic := NULL;
963: END IF;
964:
965: IF l_SEG_rec.context = FND_API.G_MISS_CHAR THEN

Line 965: IF l_SEG_rec.context = FND_API.G_MISS_CHAR THEN

961: IF l_SEG_rec.availability_in_basic = FND_API.G_MISS_CHAR THEN
962: l_SEG_rec.availability_in_basic := NULL;
963: END IF;
964:
965: IF l_SEG_rec.context = FND_API.G_MISS_CHAR THEN
966: l_SEG_rec.context := NULL;
967: END IF;
968:
969: IF l_SEG_rec.created_by = FND_API.G_MISS_NUM THEN

Line 969: IF l_SEG_rec.created_by = FND_API.G_MISS_NUM THEN

965: IF l_SEG_rec.context = FND_API.G_MISS_CHAR THEN
966: l_SEG_rec.context := NULL;
967: END IF;
968:
969: IF l_SEG_rec.created_by = FND_API.G_MISS_NUM THEN
970: l_SEG_rec.created_by := NULL;
971: END IF;
972:
973: IF l_SEG_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 973: IF l_SEG_rec.creation_date = FND_API.G_MISS_DATE THEN

969: IF l_SEG_rec.created_by = FND_API.G_MISS_NUM THEN
970: l_SEG_rec.created_by := NULL;
971: END IF;
972:
973: IF l_SEG_rec.creation_date = FND_API.G_MISS_DATE THEN
974: l_SEG_rec.creation_date := NULL;
975: END IF;
976:
977: IF l_SEG_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 977: IF l_SEG_rec.last_updated_by = FND_API.G_MISS_NUM THEN

973: IF l_SEG_rec.creation_date = FND_API.G_MISS_DATE THEN
974: l_SEG_rec.creation_date := NULL;
975: END IF;
976:
977: IF l_SEG_rec.last_updated_by = FND_API.G_MISS_NUM THEN
978: l_SEG_rec.last_updated_by := NULL;
979: END IF;
980:
981: IF l_SEG_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 981: IF l_SEG_rec.last_update_date = FND_API.G_MISS_DATE THEN

977: IF l_SEG_rec.last_updated_by = FND_API.G_MISS_NUM THEN
978: l_SEG_rec.last_updated_by := NULL;
979: END IF;
980:
981: IF l_SEG_rec.last_update_date = FND_API.G_MISS_DATE THEN
982: l_SEG_rec.last_update_date := NULL;
983: END IF;
984:
985: IF l_SEG_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 985: IF l_SEG_rec.last_update_login = FND_API.G_MISS_NUM THEN

981: IF l_SEG_rec.last_update_date = FND_API.G_MISS_DATE THEN
982: l_SEG_rec.last_update_date := NULL;
983: END IF;
984:
985: IF l_SEG_rec.last_update_login = FND_API.G_MISS_NUM THEN
986: l_SEG_rec.last_update_login := NULL;
987: END IF;
988:
989: IF l_SEG_rec.prc_context_id = FND_API.G_MISS_NUM THEN

Line 989: IF l_SEG_rec.prc_context_id = FND_API.G_MISS_NUM THEN

985: IF l_SEG_rec.last_update_login = FND_API.G_MISS_NUM THEN
986: l_SEG_rec.last_update_login := NULL;
987: END IF;
988:
989: IF l_SEG_rec.prc_context_id = FND_API.G_MISS_NUM THEN
990: l_SEG_rec.prc_context_id := NULL;
991: END IF;
992:
993: IF l_SEG_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 993: IF l_SEG_rec.program_application_id = FND_API.G_MISS_NUM THEN

989: IF l_SEG_rec.prc_context_id = FND_API.G_MISS_NUM THEN
990: l_SEG_rec.prc_context_id := NULL;
991: END IF;
992:
993: IF l_SEG_rec.program_application_id = FND_API.G_MISS_NUM THEN
994: l_SEG_rec.program_application_id := NULL;
995: END IF;
996:
997: IF l_SEG_rec.program_id = FND_API.G_MISS_NUM THEN

Line 997: IF l_SEG_rec.program_id = FND_API.G_MISS_NUM THEN

993: IF l_SEG_rec.program_application_id = FND_API.G_MISS_NUM THEN
994: l_SEG_rec.program_application_id := NULL;
995: END IF;
996:
997: IF l_SEG_rec.program_id = FND_API.G_MISS_NUM THEN
998: l_SEG_rec.program_id := NULL;
999: END IF;
1000:
1001: IF l_SEG_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1001: IF l_SEG_rec.program_update_date = FND_API.G_MISS_DATE THEN

997: IF l_SEG_rec.program_id = FND_API.G_MISS_NUM THEN
998: l_SEG_rec.program_id := NULL;
999: END IF;
1000:
1001: IF l_SEG_rec.program_update_date = FND_API.G_MISS_DATE THEN
1002: l_SEG_rec.program_update_date := NULL;
1003: END IF;
1004:
1005: IF l_SEG_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

Line 1005: IF l_SEG_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

1001: IF l_SEG_rec.program_update_date = FND_API.G_MISS_DATE THEN
1002: l_SEG_rec.program_update_date := NULL;
1003: END IF;
1004:
1005: IF l_SEG_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
1006: l_SEG_rec.seeded_flag := NULL;
1007: END IF;
1008:
1009: IF l_SEG_rec.seeded_format_type = FND_API.G_MISS_CHAR THEN

Line 1009: IF l_SEG_rec.seeded_format_type = FND_API.G_MISS_CHAR THEN

1005: IF l_SEG_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
1006: l_SEG_rec.seeded_flag := NULL;
1007: END IF;
1008:
1009: IF l_SEG_rec.seeded_format_type = FND_API.G_MISS_CHAR THEN
1010: l_SEG_rec.seeded_format_type := NULL;
1011: END IF;
1012:
1013: IF l_SEG_rec.seeded_precedence = FND_API.G_MISS_NUM THEN

Line 1013: IF l_SEG_rec.seeded_precedence = FND_API.G_MISS_NUM THEN

1009: IF l_SEG_rec.seeded_format_type = FND_API.G_MISS_CHAR THEN
1010: l_SEG_rec.seeded_format_type := NULL;
1011: END IF;
1012:
1013: IF l_SEG_rec.seeded_precedence = FND_API.G_MISS_NUM THEN
1014: l_SEG_rec.seeded_precedence := NULL;
1015: END IF;
1016:
1017: IF l_SEG_rec.seeded_segment_name = FND_API.G_MISS_CHAR THEN

Line 1017: IF l_SEG_rec.seeded_segment_name = FND_API.G_MISS_CHAR THEN

1013: IF l_SEG_rec.seeded_precedence = FND_API.G_MISS_NUM THEN
1014: l_SEG_rec.seeded_precedence := NULL;
1015: END IF;
1016:
1017: IF l_SEG_rec.seeded_segment_name = FND_API.G_MISS_CHAR THEN
1018: l_SEG_rec.seeded_segment_name := NULL;
1019: END IF;
1020:
1021: IF l_SEG_rec.seeded_description = FND_API.G_MISS_CHAR THEN

Line 1021: IF l_SEG_rec.seeded_description = FND_API.G_MISS_CHAR THEN

1017: IF l_SEG_rec.seeded_segment_name = FND_API.G_MISS_CHAR THEN
1018: l_SEG_rec.seeded_segment_name := NULL;
1019: END IF;
1020:
1021: IF l_SEG_rec.seeded_description = FND_API.G_MISS_CHAR THEN
1022: l_SEG_rec.seeded_description := NULL;
1023: END IF;
1024:
1025: IF l_SEG_rec.user_description = FND_API.G_MISS_CHAR THEN

Line 1025: IF l_SEG_rec.user_description = FND_API.G_MISS_CHAR THEN

1021: IF l_SEG_rec.seeded_description = FND_API.G_MISS_CHAR THEN
1022: l_SEG_rec.seeded_description := NULL;
1023: END IF;
1024:
1025: IF l_SEG_rec.user_description = FND_API.G_MISS_CHAR THEN
1026: l_SEG_rec.user_description := NULL;
1027: END IF;
1028:
1029: IF l_SEG_rec.seeded_valueset_id = FND_API.G_MISS_NUM THEN

Line 1029: IF l_SEG_rec.seeded_valueset_id = FND_API.G_MISS_NUM THEN

1025: IF l_SEG_rec.user_description = FND_API.G_MISS_CHAR THEN
1026: l_SEG_rec.user_description := NULL;
1027: END IF;
1028:
1029: IF l_SEG_rec.seeded_valueset_id = FND_API.G_MISS_NUM THEN
1030: l_SEG_rec.seeded_valueset_id := NULL;
1031: END IF;
1032:
1033: IF l_SEG_rec.segment_code = FND_API.G_MISS_CHAR THEN

Line 1033: IF l_SEG_rec.segment_code = FND_API.G_MISS_CHAR THEN

1029: IF l_SEG_rec.seeded_valueset_id = FND_API.G_MISS_NUM THEN
1030: l_SEG_rec.seeded_valueset_id := NULL;
1031: END IF;
1032:
1033: IF l_SEG_rec.segment_code = FND_API.G_MISS_CHAR THEN
1034: l_SEG_rec.segment_code := NULL;
1035: END IF;
1036:
1037: IF l_SEG_rec.segment_id = FND_API.G_MISS_NUM THEN

Line 1037: IF l_SEG_rec.segment_id = FND_API.G_MISS_NUM THEN

1033: IF l_SEG_rec.segment_code = FND_API.G_MISS_CHAR THEN
1034: l_SEG_rec.segment_code := NULL;
1035: END IF;
1036:
1037: IF l_SEG_rec.segment_id = FND_API.G_MISS_NUM THEN
1038: l_SEG_rec.segment_id := NULL;
1039: END IF;
1040:
1041: IF l_SEG_rec.application_id = FND_API.G_MISS_NUM THEN

Line 1041: IF l_SEG_rec.application_id = FND_API.G_MISS_NUM THEN

1037: IF l_SEG_rec.segment_id = FND_API.G_MISS_NUM THEN
1038: l_SEG_rec.segment_id := NULL;
1039: END IF;
1040:
1041: IF l_SEG_rec.application_id = FND_API.G_MISS_NUM THEN
1042: l_SEG_rec.application_id := NULL;
1043: END IF;
1044:
1045: IF l_SEG_rec.segment_mapping_column = FND_API.G_MISS_CHAR THEN

Line 1045: IF l_SEG_rec.segment_mapping_column = FND_API.G_MISS_CHAR THEN

1041: IF l_SEG_rec.application_id = FND_API.G_MISS_NUM THEN
1042: l_SEG_rec.application_id := NULL;
1043: END IF;
1044:
1045: IF l_SEG_rec.segment_mapping_column = FND_API.G_MISS_CHAR THEN
1046: l_SEG_rec.segment_mapping_column := NULL;
1047: END IF;
1048:
1049: IF l_SEG_rec.user_format_type = FND_API.G_MISS_CHAR THEN

Line 1049: IF l_SEG_rec.user_format_type = FND_API.G_MISS_CHAR THEN

1045: IF l_SEG_rec.segment_mapping_column = FND_API.G_MISS_CHAR THEN
1046: l_SEG_rec.segment_mapping_column := NULL;
1047: END IF;
1048:
1049: IF l_SEG_rec.user_format_type = FND_API.G_MISS_CHAR THEN
1050: l_SEG_rec.user_format_type := NULL;
1051: END IF;
1052:
1053: IF l_SEG_rec.user_precedence = FND_API.G_MISS_NUM THEN

Line 1053: IF l_SEG_rec.user_precedence = FND_API.G_MISS_NUM THEN

1049: IF l_SEG_rec.user_format_type = FND_API.G_MISS_CHAR THEN
1050: l_SEG_rec.user_format_type := NULL;
1051: END IF;
1052:
1053: IF l_SEG_rec.user_precedence = FND_API.G_MISS_NUM THEN
1054: l_SEG_rec.user_precedence := NULL;
1055: END IF;
1056:
1057: IF l_SEG_rec.user_segment_name = FND_API.G_MISS_CHAR THEN

Line 1057: IF l_SEG_rec.user_segment_name = FND_API.G_MISS_CHAR THEN

1053: IF l_SEG_rec.user_precedence = FND_API.G_MISS_NUM THEN
1054: l_SEG_rec.user_precedence := NULL;
1055: END IF;
1056:
1057: IF l_SEG_rec.user_segment_name = FND_API.G_MISS_CHAR THEN
1058: l_SEG_rec.user_segment_name := NULL;
1059: END IF;
1060:
1061: IF l_SEG_rec.user_valueset_id = FND_API.G_MISS_NUM THEN

Line 1061: IF l_SEG_rec.user_valueset_id = FND_API.G_MISS_NUM THEN

1057: IF l_SEG_rec.user_segment_name = FND_API.G_MISS_CHAR THEN
1058: l_SEG_rec.user_segment_name := NULL;
1059: END IF;
1060:
1061: IF l_SEG_rec.user_valueset_id = FND_API.G_MISS_NUM THEN
1062: l_SEG_rec.user_valueset_id := NULL;
1063: END IF;
1064:
1065: IF l_SEG_rec.required_flag = FND_API.G_MISS_CHAR THEN

Line 1065: IF l_SEG_rec.required_flag = FND_API.G_MISS_CHAR THEN

1061: IF l_SEG_rec.user_valueset_id = FND_API.G_MISS_NUM THEN
1062: l_SEG_rec.user_valueset_id := NULL;
1063: END IF;
1064:
1065: IF l_SEG_rec.required_flag = FND_API.G_MISS_CHAR THEN
1066: l_SEG_rec.required_flag := NULL;
1067: END IF;
1068: -- Added for TCA
1069: IF l_SEG_rec.party_hierarchy_enabled_flag = FND_API.G_MISS_CHAR THEN

Line 1069: IF l_SEG_rec.party_hierarchy_enabled_flag = FND_API.G_MISS_CHAR THEN

1065: IF l_SEG_rec.required_flag = FND_API.G_MISS_CHAR THEN
1066: l_SEG_rec.required_flag := NULL;
1067: END IF;
1068: -- Added for TCA
1069: IF l_SEG_rec.party_hierarchy_enabled_flag = FND_API.G_MISS_CHAR THEN
1070: l_SEG_rec.party_hierarchy_enabled_flag:= NULL;
1071: END IF;
1072:
1073: RETURN l_SEG_rec;

Line 1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1201: , 'Update_Row'
1202: );
1203: END IF;
1204:
1205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1206:
1207: END Update_Row;
1208:
1209: -- Procedure Insert_Row

Line 1220: --l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1216: l_prc_context_type varchar2(30);
1217: l_prc_context_code varchar2(30);
1218: req_id number;
1219: attr_in_ff_exists varchar2(1);
1220: --l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1221: BEGIN
1222: select prc_context_type,
1223: prc_context_code
1224: into l_prc_context_type,

Line 1240: --l_return_status := FND_API.G_RET_STS_ERROR;

1236: descriptive_flex_context_code = l_prc_context_code and
1237: end_user_column_name = p_SEG_rec.segment_code and
1238: rownum = 1;
1239:
1240: --l_return_status := FND_API.G_RET_STS_ERROR;
1241: FND_MESSAGE.SET_NAME('QP','QP_ATTR_EXISTS_IN_FF');
1242: --FND_MESSAGE.SET_TOKEN('PTE_CODE', l_pte_code);
1243: OE_MSG_PUB.Add;
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1240: --l_return_status := FND_API.G_RET_STS_ERROR;
1241: FND_MESSAGE.SET_NAME('QP','QP_ATTR_EXISTS_IN_FF');
1242: --FND_MESSAGE.SET_TOKEN('PTE_CODE', l_pte_code);
1243: OE_MSG_PUB.Add;
1244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1245: exception
1246: when no_data_found then
1247: null;
1248: end;

Line 1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1421: , 'Insert_Row'
1422: );
1423: END IF;
1424:
1425: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1426:
1427: END Insert_Row;
1428:
1429: -- Procedure Delete_Row

Line 1486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1482: , 'Delete_Row'
1483: );
1484: END IF;
1485:
1486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1487:
1488: END Delete_Row;
1489:
1490: -- Function Query_Row

Line 1510: FND_API.G_MISS_NUM

1506: --
1507:
1508: FUNCTION Query_Rows
1509: ( p_segment_id IN NUMBER :=
1510: FND_API.G_MISS_NUM
1511: , p_prc_context_id IN NUMBER :=
1512: FND_API.G_MISS_NUM
1513: ) RETURN QP_Attributes_PUB.Seg_Tbl_Type
1514: IS

Line 1512: FND_API.G_MISS_NUM

1508: FUNCTION Query_Rows
1509: ( p_segment_id IN NUMBER :=
1510: FND_API.G_MISS_NUM
1511: , p_prc_context_id IN NUMBER :=
1512: FND_API.G_MISS_NUM
1513: ) RETURN QP_Attributes_PUB.Seg_Tbl_Type
1514: IS
1515: l_SEG_rec QP_Attributes_PUB.Seg_Rec_Type;
1516: l_SEG_tbl QP_Attributes_PUB.Seg_Tbl_Type;

Line 1573: p_segment_id <> FND_API.G_MISS_NUM)

1569:
1570: IF
1571: (p_segment_id IS NOT NULL
1572: AND
1573: p_segment_id <> FND_API.G_MISS_NUM)
1574: AND
1575: (p_prc_context_id IS NOT NULL
1576: AND
1577: p_prc_context_id <> FND_API.G_MISS_NUM)

Line 1577: p_prc_context_id <> FND_API.G_MISS_NUM)

1573: p_segment_id <> FND_API.G_MISS_NUM)
1574: AND
1575: (p_prc_context_id IS NOT NULL
1576: AND
1577: p_prc_context_id <> FND_API.G_MISS_NUM)
1578: THEN
1579: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1580: THEN
1581: OE_MSG_PUB.Add_Exc_Msg

Line 1588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1584: , 'Keys are mutually exclusive: segment_id = '|| p_segment_id || ', prc_context_id = '|| p_prc_context_id
1585: );
1586: END IF;
1587:
1588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1589:
1590: END IF;
1591:
1592:

Line 1651: p_segment_id <> FND_API.G_MISS_NUM)

1647:
1648: IF
1649: (p_segment_id IS NOT NULL
1650: AND
1651: p_segment_id <> FND_API.G_MISS_NUM)
1652: AND
1653: (l_SEG_tbl.COUNT = 0)
1654: THEN
1655: RAISE NO_DATA_FOUND;

Line 1665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1661: RETURN l_SEG_tbl;
1662:
1663: EXCEPTION
1664:
1665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1666:
1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1668:
1669: WHEN OTHERS THEN

Line 1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1663: EXCEPTION
1664:
1665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1666:
1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1668:
1669: WHEN OTHERS THEN
1670:
1671: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1675: , 'Query_Rows'
1676: );
1677: END IF;
1678:
1679: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1680:
1681: END Query_Rows;
1682:
1683: -- Procedure lock_Row

Line 1882: x_return_status := FND_API.G_RET_STS_SUCCESS;

1878: x_SEG_rec := l_SEG_rec;
1879:
1880: -- Set return status
1881:
1882: x_return_status := FND_API.G_RET_STS_SUCCESS;
1883: x_SEG_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1884:
1885: ELSE
1886:

Line 1883: x_SEG_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1879:
1880: -- Set return status
1881:
1882: x_return_status := FND_API.G_RET_STS_SUCCESS;
1883: x_SEG_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1884:
1885: ELSE
1886:
1887: -- Row has changed by another user.

Line 1889: x_return_status := FND_API.G_RET_STS_ERROR;

1885: ELSE
1886:
1887: -- Row has changed by another user.
1888:
1889: x_return_status := FND_API.G_RET_STS_ERROR;
1890: x_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
1891:
1892: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1893: THEN

Line 1890: x_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;

1886:
1887: -- Row has changed by another user.
1888:
1889: x_return_status := FND_API.G_RET_STS_ERROR;
1890: x_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
1891:
1892: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1893: THEN
1894:

Line 1906: x_return_status := FND_API.G_RET_STS_ERROR;

1902: EXCEPTION
1903:
1904: WHEN NO_DATA_FOUND THEN
1905:
1906: x_return_status := FND_API.G_RET_STS_ERROR;
1907: x_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
1908:
1909: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1910: THEN

Line 1907: x_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;

1903:
1904: WHEN NO_DATA_FOUND THEN
1905:
1906: x_return_status := FND_API.G_RET_STS_ERROR;
1907: x_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
1908:
1909: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1910: THEN
1911:

Line 1918: x_return_status := FND_API.G_RET_STS_ERROR;

1914:
1915: END IF;
1916: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1917:
1918: x_return_status := FND_API.G_RET_STS_ERROR;
1919: x_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
1920:
1921: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1922: THEN

Line 1919: x_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;

1915: END IF;
1916: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1917:
1918: x_return_status := FND_API.G_RET_STS_ERROR;
1919: x_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
1920:
1921: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1922: THEN
1923:

Line 1930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1926:
1927: END IF;
1928: WHEN OTHERS THEN
1929:
1930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1931: x_SEG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1932:
1933: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1934: THEN

Line 1931: x_SEG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1927: END IF;
1928: WHEN OTHERS THEN
1929:
1930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1931: x_SEG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1932:
1933: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1934: THEN
1935: OE_MSG_PUB.Add_Exc_Msg

Line 1955: p_SEG_rec.prc_context_id <> FND_API.G_MISS_NUM AND

1951: l_SEG_val_rec QP_Attributes_PUB.Seg_Val_Rec_Type;
1952: BEGIN
1953:
1954: IF p_SEG_rec.prc_context_id IS NOT NULL AND
1955: p_SEG_rec.prc_context_id <> FND_API.G_MISS_NUM AND
1956: NOT QP_GLOBALS.Equal(p_SEG_rec.prc_context_id,
1957: p_old_SEG_rec.prc_context_id)
1958: THEN
1959: l_SEG_val_rec.prc_context := QP_Id_To_Value.Prc_Context

Line 1965: p_SEG_rec.seeded_flag <> FND_API.G_MISS_CHAR AND

1961: );
1962: END IF;
1963:
1964: IF p_SEG_rec.seeded_flag IS NOT NULL AND
1965: p_SEG_rec.seeded_flag <> FND_API.G_MISS_CHAR AND
1966: NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_flag,
1967: p_old_SEG_rec.seeded_flag)
1968: THEN
1969: l_SEG_val_rec.seeded := QP_Id_To_Value.Seeded

Line 1975: p_SEG_rec.seeded_valueset_id <> FND_API.G_MISS_NUM AND

1971: );
1972: END IF;
1973:
1974: IF p_SEG_rec.seeded_valueset_id IS NOT NULL AND
1975: p_SEG_rec.seeded_valueset_id <> FND_API.G_MISS_NUM AND
1976: NOT QP_GLOBALS.Equal(p_SEG_rec.seeded_valueset_id,
1977: p_old_SEG_rec.seeded_valueset_id)
1978: THEN
1979: l_SEG_val_rec.seeded_valueset := QP_Id_To_Value.Seeded_Valueset

Line 1985: p_SEG_rec.segment_id <> FND_API.G_MISS_NUM AND

1981: );
1982: END IF;
1983:
1984: IF p_SEG_rec.segment_id IS NOT NULL AND
1985: p_SEG_rec.segment_id <> FND_API.G_MISS_NUM AND
1986: NOT QP_GLOBALS.Equal(p_SEG_rec.segment_id,
1987: p_old_SEG_rec.segment_id)
1988: THEN
1989: l_SEG_val_rec.segment := QP_Id_To_Value.Segment

Line 1995: p_SEG_rec.user_valueset_id <> FND_API.G_MISS_NUM AND

1991: );
1992: END IF;
1993:
1994: IF p_SEG_rec.user_valueset_id IS NOT NULL AND
1995: p_SEG_rec.user_valueset_id <> FND_API.G_MISS_NUM AND
1996: NOT QP_GLOBALS.Equal(p_SEG_rec.user_valueset_id,
1997: p_old_SEG_rec.user_valueset_id)
1998: THEN
1999: l_SEG_val_rec.user_valueset := QP_Id_To_Value.User_Valueset

Line 2020: l_SEG_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2016: BEGIN
2017:
2018: -- initialize return_status.
2019:
2020: l_SEG_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2021:
2022: -- initialize l_SEG_rec.
2023:
2024: l_SEG_rec := p_SEG_rec;

Line 2026: IF p_SEG_val_rec.prc_context <> FND_API.G_MISS_CHAR

2022: -- initialize l_SEG_rec.
2023:
2024: l_SEG_rec := p_SEG_rec;
2025:
2026: IF p_SEG_val_rec.prc_context <> FND_API.G_MISS_CHAR
2027: THEN
2028:
2029: IF p_SEG_rec.prc_context_id <> FND_API.G_MISS_NUM THEN
2030:

Line 2029: IF p_SEG_rec.prc_context_id <> FND_API.G_MISS_NUM THEN

2025:
2026: IF p_SEG_val_rec.prc_context <> FND_API.G_MISS_CHAR
2027: THEN
2028:
2029: IF p_SEG_rec.prc_context_id <> FND_API.G_MISS_NUM THEN
2030:
2031: l_SEG_rec.prc_context_id := p_SEG_rec.prc_context_id;
2032:
2033: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2048: IF l_SEG_rec.prc_context_id = FND_API.G_MISS_NUM THEN

2044: l_SEG_rec.prc_context_id := QP_Value_To_Id.prc_context
2045: ( p_prc_context => p_SEG_val_rec.prc_context
2046: );
2047:
2048: IF l_SEG_rec.prc_context_id = FND_API.G_MISS_NUM THEN
2049: l_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
2050: END IF;
2051:
2052: END IF;

Line 2049: l_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;

2045: ( p_prc_context => p_SEG_val_rec.prc_context
2046: );
2047:
2048: IF l_SEG_rec.prc_context_id = FND_API.G_MISS_NUM THEN
2049: l_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
2050: END IF;
2051:
2052: END IF;
2053:

Line 2056: IF p_SEG_val_rec.seeded <> FND_API.G_MISS_CHAR

2052: END IF;
2053:
2054: END IF;
2055:
2056: IF p_SEG_val_rec.seeded <> FND_API.G_MISS_CHAR
2057: THEN
2058:
2059: IF p_SEG_rec.seeded_flag <> FND_API.G_MISS_CHAR THEN
2060:

Line 2059: IF p_SEG_rec.seeded_flag <> FND_API.G_MISS_CHAR THEN

2055:
2056: IF p_SEG_val_rec.seeded <> FND_API.G_MISS_CHAR
2057: THEN
2058:
2059: IF p_SEG_rec.seeded_flag <> FND_API.G_MISS_CHAR THEN
2060:
2061: l_SEG_rec.seeded_flag := p_SEG_rec.seeded_flag;
2062:
2063: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2078: IF l_SEG_rec.seeded_flag = FND_API.G_MISS_CHAR THEN

2074: l_SEG_rec.seeded_flag := QP_Value_To_Id.seeded
2075: ( p_seeded => p_SEG_val_rec.seeded
2076: );
2077:
2078: IF l_SEG_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
2079: l_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
2080: END IF;
2081:
2082: END IF;

Line 2079: l_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;

2075: ( p_seeded => p_SEG_val_rec.seeded
2076: );
2077:
2078: IF l_SEG_rec.seeded_flag = FND_API.G_MISS_CHAR THEN
2079: l_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
2080: END IF;
2081:
2082: END IF;
2083:

Line 2086: IF p_SEG_val_rec.seeded_valueset <> FND_API.G_MISS_CHAR

2082: END IF;
2083:
2084: END IF;
2085:
2086: IF p_SEG_val_rec.seeded_valueset <> FND_API.G_MISS_CHAR
2087: THEN
2088:
2089: IF p_SEG_rec.seeded_valueset_id <> FND_API.G_MISS_NUM THEN
2090:

Line 2089: IF p_SEG_rec.seeded_valueset_id <> FND_API.G_MISS_NUM THEN

2085:
2086: IF p_SEG_val_rec.seeded_valueset <> FND_API.G_MISS_CHAR
2087: THEN
2088:
2089: IF p_SEG_rec.seeded_valueset_id <> FND_API.G_MISS_NUM THEN
2090:
2091: l_SEG_rec.seeded_valueset_id := p_SEG_rec.seeded_valueset_id;
2092:
2093: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2108: IF l_SEG_rec.seeded_valueset_id = FND_API.G_MISS_NUM THEN

2104: l_SEG_rec.seeded_valueset_id := QP_Value_To_Id.seeded_valueset
2105: ( p_seeded_valueset => p_SEG_val_rec.seeded_valueset
2106: );
2107:
2108: IF l_SEG_rec.seeded_valueset_id = FND_API.G_MISS_NUM THEN
2109: l_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
2110: END IF;
2111:
2112: END IF;

Line 2109: l_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;

2105: ( p_seeded_valueset => p_SEG_val_rec.seeded_valueset
2106: );
2107:
2108: IF l_SEG_rec.seeded_valueset_id = FND_API.G_MISS_NUM THEN
2109: l_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
2110: END IF;
2111:
2112: END IF;
2113:

Line 2116: IF p_SEG_val_rec.segment <> FND_API.G_MISS_CHAR

2112: END IF;
2113:
2114: END IF;
2115:
2116: IF p_SEG_val_rec.segment <> FND_API.G_MISS_CHAR
2117: THEN
2118:
2119: IF p_SEG_rec.segment_id <> FND_API.G_MISS_NUM THEN
2120:

Line 2119: IF p_SEG_rec.segment_id <> FND_API.G_MISS_NUM THEN

2115:
2116: IF p_SEG_val_rec.segment <> FND_API.G_MISS_CHAR
2117: THEN
2118:
2119: IF p_SEG_rec.segment_id <> FND_API.G_MISS_NUM THEN
2120:
2121: l_SEG_rec.segment_id := p_SEG_rec.segment_id;
2122:
2123: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2138: IF l_SEG_rec.segment_id = FND_API.G_MISS_NUM THEN

2134: l_SEG_rec.segment_id := QP_Value_To_Id.segment
2135: ( p_segment => p_SEG_val_rec.segment
2136: );
2137:
2138: IF l_SEG_rec.segment_id = FND_API.G_MISS_NUM THEN
2139: l_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
2140: END IF;
2141:
2142: END IF;

Line 2139: l_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;

2135: ( p_segment => p_SEG_val_rec.segment
2136: );
2137:
2138: IF l_SEG_rec.segment_id = FND_API.G_MISS_NUM THEN
2139: l_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
2140: END IF;
2141:
2142: END IF;
2143:

Line 2146: IF p_SEG_val_rec.user_valueset <> FND_API.G_MISS_CHAR

2142: END IF;
2143:
2144: END IF;
2145:
2146: IF p_SEG_val_rec.user_valueset <> FND_API.G_MISS_CHAR
2147: THEN
2148:
2149: IF p_SEG_rec.user_valueset_id <> FND_API.G_MISS_NUM THEN
2150:

Line 2149: IF p_SEG_rec.user_valueset_id <> FND_API.G_MISS_NUM THEN

2145:
2146: IF p_SEG_val_rec.user_valueset <> FND_API.G_MISS_CHAR
2147: THEN
2148:
2149: IF p_SEG_rec.user_valueset_id <> FND_API.G_MISS_NUM THEN
2150:
2151: l_SEG_rec.user_valueset_id := p_SEG_rec.user_valueset_id;
2152:
2153: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2168: IF l_SEG_rec.user_valueset_id = FND_API.G_MISS_NUM THEN

2164: l_SEG_rec.user_valueset_id := QP_Value_To_Id.user_valueset
2165: ( p_user_valueset => p_SEG_val_rec.user_valueset
2166: );
2167:
2168: IF l_SEG_rec.user_valueset_id = FND_API.G_MISS_NUM THEN
2169: l_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
2170: END IF;
2171:
2172: END IF;

Line 2169: l_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;

2165: ( p_user_valueset => p_SEG_val_rec.user_valueset
2166: );
2167:
2168: IF l_SEG_rec.user_valueset_id = FND_API.G_MISS_NUM THEN
2169: l_SEG_rec.return_status := FND_API.G_RET_STS_ERROR;
2170: END IF;
2171:
2172: END IF;
2173: