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_CURR_DETAILS_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_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type
13: , p_old_CURR_DETAILS_rec IN QP_Currency_PUB.Curr_Details_Rec_Type :=
14: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
15: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_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_CURR_DETAILS_rec.attribute1,p_old_CURR_DETAILS_rec.attribute1)
33: THEN
34: l_index := l_index + 1;

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

458: QP_Currency_PUB.G_MISS_CURR_DETAILS_REC
459: , x_CURR_DETAILS_rec OUT NOCOPY /* file.sql.39 change */ QP_Currency_PUB.Curr_Details_Rec_Type
460: )
461: IS
462: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
463: BEGIN
464:
465: -- Load out NOCOPY record
466:

Line 747: IF l_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR THEN

743: IS
744: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type := p_CURR_DETAILS_rec;
745: BEGIN
746:
747: IF l_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
748: l_CURR_DETAILS_rec.attribute1 := p_old_CURR_DETAILS_rec.attribute1;
749: END IF;
750:
751: IF l_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 751: IF l_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

747: IF l_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
748: l_CURR_DETAILS_rec.attribute1 := p_old_CURR_DETAILS_rec.attribute1;
749: END IF;
750:
751: IF l_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
752: l_CURR_DETAILS_rec.attribute10 := p_old_CURR_DETAILS_rec.attribute10;
753: END IF;
754:
755: IF l_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 755: IF l_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

751: IF l_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
752: l_CURR_DETAILS_rec.attribute10 := p_old_CURR_DETAILS_rec.attribute10;
753: END IF;
754:
755: IF l_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
756: l_CURR_DETAILS_rec.attribute11 := p_old_CURR_DETAILS_rec.attribute11;
757: END IF;
758:
759: IF l_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 759: IF l_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

755: IF l_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
756: l_CURR_DETAILS_rec.attribute11 := p_old_CURR_DETAILS_rec.attribute11;
757: END IF;
758:
759: IF l_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
760: l_CURR_DETAILS_rec.attribute12 := p_old_CURR_DETAILS_rec.attribute12;
761: END IF;
762:
763: IF l_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 763: IF l_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

759: IF l_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
760: l_CURR_DETAILS_rec.attribute12 := p_old_CURR_DETAILS_rec.attribute12;
761: END IF;
762:
763: IF l_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
764: l_CURR_DETAILS_rec.attribute13 := p_old_CURR_DETAILS_rec.attribute13;
765: END IF;
766:
767: IF l_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 767: IF l_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

763: IF l_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
764: l_CURR_DETAILS_rec.attribute13 := p_old_CURR_DETAILS_rec.attribute13;
765: END IF;
766:
767: IF l_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
768: l_CURR_DETAILS_rec.attribute14 := p_old_CURR_DETAILS_rec.attribute14;
769: END IF;
770:
771: IF l_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 771: IF l_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

767: IF l_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
768: l_CURR_DETAILS_rec.attribute14 := p_old_CURR_DETAILS_rec.attribute14;
769: END IF;
770:
771: IF l_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
772: l_CURR_DETAILS_rec.attribute15 := p_old_CURR_DETAILS_rec.attribute15;
773: END IF;
774:
775: IF l_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 775: IF l_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

771: IF l_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
772: l_CURR_DETAILS_rec.attribute15 := p_old_CURR_DETAILS_rec.attribute15;
773: END IF;
774:
775: IF l_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
776: l_CURR_DETAILS_rec.attribute2 := p_old_CURR_DETAILS_rec.attribute2;
777: END IF;
778:
779: IF l_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 779: IF l_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

775: IF l_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
776: l_CURR_DETAILS_rec.attribute2 := p_old_CURR_DETAILS_rec.attribute2;
777: END IF;
778:
779: IF l_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
780: l_CURR_DETAILS_rec.attribute3 := p_old_CURR_DETAILS_rec.attribute3;
781: END IF;
782:
783: IF l_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 783: IF l_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

779: IF l_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
780: l_CURR_DETAILS_rec.attribute3 := p_old_CURR_DETAILS_rec.attribute3;
781: END IF;
782:
783: IF l_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
784: l_CURR_DETAILS_rec.attribute4 := p_old_CURR_DETAILS_rec.attribute4;
785: END IF;
786:
787: IF l_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 787: IF l_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

783: IF l_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
784: l_CURR_DETAILS_rec.attribute4 := p_old_CURR_DETAILS_rec.attribute4;
785: END IF;
786:
787: IF l_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
788: l_CURR_DETAILS_rec.attribute5 := p_old_CURR_DETAILS_rec.attribute5;
789: END IF;
790:
791: IF l_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 791: IF l_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

787: IF l_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
788: l_CURR_DETAILS_rec.attribute5 := p_old_CURR_DETAILS_rec.attribute5;
789: END IF;
790:
791: IF l_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
792: l_CURR_DETAILS_rec.attribute6 := p_old_CURR_DETAILS_rec.attribute6;
793: END IF;
794:
795: IF l_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 795: IF l_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

791: IF l_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
792: l_CURR_DETAILS_rec.attribute6 := p_old_CURR_DETAILS_rec.attribute6;
793: END IF;
794:
795: IF l_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
796: l_CURR_DETAILS_rec.attribute7 := p_old_CURR_DETAILS_rec.attribute7;
797: END IF;
798:
799: IF l_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 799: IF l_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

795: IF l_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
796: l_CURR_DETAILS_rec.attribute7 := p_old_CURR_DETAILS_rec.attribute7;
797: END IF;
798:
799: IF l_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
800: l_CURR_DETAILS_rec.attribute8 := p_old_CURR_DETAILS_rec.attribute8;
801: END IF;
802:
803: IF l_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 803: IF l_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

799: IF l_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
800: l_CURR_DETAILS_rec.attribute8 := p_old_CURR_DETAILS_rec.attribute8;
801: END IF;
802:
803: IF l_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
804: l_CURR_DETAILS_rec.attribute9 := p_old_CURR_DETAILS_rec.attribute9;
805: END IF;
806:
807: IF l_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR THEN

Line 807: IF l_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR THEN

803: IF l_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
804: l_CURR_DETAILS_rec.attribute9 := p_old_CURR_DETAILS_rec.attribute9;
805: END IF;
806:
807: IF l_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR THEN
808: l_CURR_DETAILS_rec.context := p_old_CURR_DETAILS_rec.context;
809: END IF;
810:
811: IF l_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE THEN

Line 811: IF l_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE THEN

807: IF l_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR THEN
808: l_CURR_DETAILS_rec.context := p_old_CURR_DETAILS_rec.context;
809: END IF;
810:
811: IF l_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE THEN
812: l_CURR_DETAILS_rec.conversion_date := p_old_CURR_DETAILS_rec.conversion_date;
813: END IF;
814:
815: IF l_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR THEN

Line 815: IF l_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR THEN

811: IF l_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE THEN
812: l_CURR_DETAILS_rec.conversion_date := p_old_CURR_DETAILS_rec.conversion_date;
813: END IF;
814:
815: IF l_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR THEN
816: l_CURR_DETAILS_rec.conversion_date_type := p_old_CURR_DETAILS_rec.conversion_date_type;
817: END IF;
818:
819: /*

Line 820: IF l_CURR_DETAILS_rec.conversion_method = FND_API.G_MISS_CHAR THEN

816: l_CURR_DETAILS_rec.conversion_date_type := p_old_CURR_DETAILS_rec.conversion_date_type;
817: END IF;
818:
819: /*
820: IF l_CURR_DETAILS_rec.conversion_method = FND_API.G_MISS_CHAR THEN
821: l_CURR_DETAILS_rec.conversion_method := p_old_CURR_DETAILS_rec.conversion_method;
822: END IF;
823: */
824:

Line 825: IF l_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR THEN

821: l_CURR_DETAILS_rec.conversion_method := p_old_CURR_DETAILS_rec.conversion_method;
822: END IF;
823: */
824:
825: IF l_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR THEN
826: l_CURR_DETAILS_rec.conversion_type := p_old_CURR_DETAILS_rec.conversion_type;
827: END IF;
828:
829: IF l_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM THEN

Line 829: IF l_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM THEN

825: IF l_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR THEN
826: l_CURR_DETAILS_rec.conversion_type := p_old_CURR_DETAILS_rec.conversion_type;
827: END IF;
828:
829: IF l_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM THEN
830: l_CURR_DETAILS_rec.created_by := p_old_CURR_DETAILS_rec.created_by;
831: END IF;
832:
833: IF l_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 833: IF l_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE THEN

829: IF l_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM THEN
830: l_CURR_DETAILS_rec.created_by := p_old_CURR_DETAILS_rec.created_by;
831: END IF;
832:
833: IF l_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE THEN
834: l_CURR_DETAILS_rec.creation_date := p_old_CURR_DETAILS_rec.creation_date;
835: END IF;
836:
837: IF l_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM THEN

Line 837: IF l_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM THEN

833: IF l_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE THEN
834: l_CURR_DETAILS_rec.creation_date := p_old_CURR_DETAILS_rec.creation_date;
835: END IF;
836:
837: IF l_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM THEN
838: l_CURR_DETAILS_rec.currency_detail_id := p_old_CURR_DETAILS_rec.currency_detail_id;
839: END IF;
840:
841: IF l_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM THEN

Line 841: IF l_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM THEN

837: IF l_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM THEN
838: l_CURR_DETAILS_rec.currency_detail_id := p_old_CURR_DETAILS_rec.currency_detail_id;
839: END IF;
840:
841: IF l_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM THEN
842: l_CURR_DETAILS_rec.currency_header_id := p_old_CURR_DETAILS_rec.currency_header_id;
843: END IF;
844:
845: IF l_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 845: IF l_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE THEN

841: IF l_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM THEN
842: l_CURR_DETAILS_rec.currency_header_id := p_old_CURR_DETAILS_rec.currency_header_id;
843: END IF;
844:
845: IF l_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE THEN
846: l_CURR_DETAILS_rec.end_date_active := p_old_CURR_DETAILS_rec.end_date_active;
847: END IF;
848:
849: IF l_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM THEN

Line 849: IF l_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM THEN

845: IF l_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE THEN
846: l_CURR_DETAILS_rec.end_date_active := p_old_CURR_DETAILS_rec.end_date_active;
847: END IF;
848:
849: IF l_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM THEN
850: l_CURR_DETAILS_rec.fixed_value := p_old_CURR_DETAILS_rec.fixed_value;
851: END IF;
852:
853: IF l_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 853: IF l_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

849: IF l_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM THEN
850: l_CURR_DETAILS_rec.fixed_value := p_old_CURR_DETAILS_rec.fixed_value;
851: END IF;
852:
853: IF l_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
854: l_CURR_DETAILS_rec.last_updated_by := p_old_CURR_DETAILS_rec.last_updated_by;
855: END IF;
856:
857: IF l_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 857: IF l_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE THEN

853: IF l_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
854: l_CURR_DETAILS_rec.last_updated_by := p_old_CURR_DETAILS_rec.last_updated_by;
855: END IF;
856:
857: IF l_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE THEN
858: l_CURR_DETAILS_rec.last_update_date := p_old_CURR_DETAILS_rec.last_update_date;
859: END IF;
860:
861: IF l_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 861: IF l_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM THEN

857: IF l_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE THEN
858: l_CURR_DETAILS_rec.last_update_date := p_old_CURR_DETAILS_rec.last_update_date;
859: END IF;
860:
861: IF l_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM THEN
862: l_CURR_DETAILS_rec.last_update_login := p_old_CURR_DETAILS_rec.last_update_login;
863: END IF;
864:
865: IF l_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM THEN

Line 865: IF l_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM THEN

861: IF l_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM THEN
862: l_CURR_DETAILS_rec.last_update_login := p_old_CURR_DETAILS_rec.last_update_login;
863: END IF;
864:
865: IF l_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM THEN
866: l_CURR_DETAILS_rec.markup_formula_id := p_old_CURR_DETAILS_rec.markup_formula_id;
867: END IF;
868:
869: IF l_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR THEN

Line 869: IF l_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR THEN

865: IF l_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM THEN
866: l_CURR_DETAILS_rec.markup_formula_id := p_old_CURR_DETAILS_rec.markup_formula_id;
867: END IF;
868:
869: IF l_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR THEN
870: l_CURR_DETAILS_rec.markup_operator := p_old_CURR_DETAILS_rec.markup_operator;
871: END IF;
872:
873: IF l_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM THEN

Line 873: IF l_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM THEN

869: IF l_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR THEN
870: l_CURR_DETAILS_rec.markup_operator := p_old_CURR_DETAILS_rec.markup_operator;
871: END IF;
872:
873: IF l_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM THEN
874: l_CURR_DETAILS_rec.markup_value := p_old_CURR_DETAILS_rec.markup_value;
875: END IF;
876:
877: IF l_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM THEN

Line 877: IF l_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM THEN

873: IF l_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM THEN
874: l_CURR_DETAILS_rec.markup_value := p_old_CURR_DETAILS_rec.markup_value;
875: END IF;
876:
877: IF l_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM THEN
878: l_CURR_DETAILS_rec.price_formula_id := p_old_CURR_DETAILS_rec.price_formula_id;
879: END IF;
880:
881: IF l_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 881: IF l_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM THEN

877: IF l_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM THEN
878: l_CURR_DETAILS_rec.price_formula_id := p_old_CURR_DETAILS_rec.price_formula_id;
879: END IF;
880:
881: IF l_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM THEN
882: l_CURR_DETAILS_rec.program_application_id := p_old_CURR_DETAILS_rec.program_application_id;
883: END IF;
884:
885: IF l_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM THEN

Line 885: IF l_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM THEN

881: IF l_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM THEN
882: l_CURR_DETAILS_rec.program_application_id := p_old_CURR_DETAILS_rec.program_application_id;
883: END IF;
884:
885: IF l_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM THEN
886: l_CURR_DETAILS_rec.program_id := p_old_CURR_DETAILS_rec.program_id;
887: END IF;
888:
889: IF l_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 889: IF l_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE THEN

885: IF l_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM THEN
886: l_CURR_DETAILS_rec.program_id := p_old_CURR_DETAILS_rec.program_id;
887: END IF;
888:
889: IF l_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE THEN
890: l_CURR_DETAILS_rec.program_update_date := p_old_CURR_DETAILS_rec.program_update_date;
891: END IF;
892:
893: IF l_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM THEN

Line 893: IF l_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM THEN

889: IF l_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE THEN
890: l_CURR_DETAILS_rec.program_update_date := p_old_CURR_DETAILS_rec.program_update_date;
891: END IF;
892:
893: IF l_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM THEN
894: l_CURR_DETAILS_rec.request_id := p_old_CURR_DETAILS_rec.request_id;
895: END IF;
896:
897: IF l_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM THEN

Line 897: IF l_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM THEN

893: IF l_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM THEN
894: l_CURR_DETAILS_rec.request_id := p_old_CURR_DETAILS_rec.request_id;
895: END IF;
896:
897: IF l_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM THEN
898: l_CURR_DETAILS_rec.rounding_factor := p_old_CURR_DETAILS_rec.rounding_factor;
899: END IF;
900:
901: IF l_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM THEN

Line 901: IF l_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM THEN

897: IF l_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM THEN
898: l_CURR_DETAILS_rec.rounding_factor := p_old_CURR_DETAILS_rec.rounding_factor;
899: END IF;
900:
901: IF l_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM THEN
902: l_CURR_DETAILS_rec.selling_rounding_factor := p_old_CURR_DETAILS_rec.selling_rounding_factor;
903: END IF;
904:
905: IF l_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 905: IF l_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE THEN

901: IF l_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM THEN
902: l_CURR_DETAILS_rec.selling_rounding_factor := p_old_CURR_DETAILS_rec.selling_rounding_factor;
903: END IF;
904:
905: IF l_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE THEN
906: l_CURR_DETAILS_rec.start_date_active := p_old_CURR_DETAILS_rec.start_date_active;
907: END IF;
908:
909: IF l_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR THEN

Line 909: IF l_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR THEN

905: IF l_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE THEN
906: l_CURR_DETAILS_rec.start_date_active := p_old_CURR_DETAILS_rec.start_date_active;
907: END IF;
908:
909: IF l_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR THEN
910: l_CURR_DETAILS_rec.to_currency_code := p_old_CURR_DETAILS_rec.to_currency_code;
911: END IF;
912:
913: IF l_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR THEN

Line 913: IF l_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR THEN

909: IF l_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR THEN
910: l_CURR_DETAILS_rec.to_currency_code := p_old_CURR_DETAILS_rec.to_currency_code;
911: END IF;
912:
913: IF l_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR THEN
914: l_CURR_DETAILS_rec.curr_attribute_type := p_old_CURR_DETAILS_rec.curr_attribute_type;
915: END IF;
916:
917: IF l_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR THEN

Line 917: IF l_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR THEN

913: IF l_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR THEN
914: l_CURR_DETAILS_rec.curr_attribute_type := p_old_CURR_DETAILS_rec.curr_attribute_type;
915: END IF;
916:
917: IF l_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR THEN
918: l_CURR_DETAILS_rec.curr_attribute_context := p_old_CURR_DETAILS_rec.curr_attribute_context;
919: END IF;
920:
921: IF l_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR THEN

Line 921: IF l_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR THEN

917: IF l_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR THEN
918: l_CURR_DETAILS_rec.curr_attribute_context := p_old_CURR_DETAILS_rec.curr_attribute_context;
919: END IF;
920:
921: IF l_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR THEN
922: l_CURR_DETAILS_rec.curr_attribute := p_old_CURR_DETAILS_rec.curr_attribute;
923: END IF;
924:
925: IF l_CURR_DETAILS_rec.curr_attribute_value = FND_API.G_MISS_CHAR THEN

Line 925: IF l_CURR_DETAILS_rec.curr_attribute_value = FND_API.G_MISS_CHAR THEN

921: IF l_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR THEN
922: l_CURR_DETAILS_rec.curr_attribute := p_old_CURR_DETAILS_rec.curr_attribute;
923: END IF;
924:
925: IF l_CURR_DETAILS_rec.curr_attribute_value = FND_API.G_MISS_CHAR THEN
926: l_CURR_DETAILS_rec.curr_attribute_value := p_old_CURR_DETAILS_rec.curr_attribute_value;
927: END IF;
928:
929: IF l_CURR_DETAILS_rec.precedence = FND_API.G_MISS_NUM THEN

Line 929: IF l_CURR_DETAILS_rec.precedence = FND_API.G_MISS_NUM THEN

925: IF l_CURR_DETAILS_rec.curr_attribute_value = FND_API.G_MISS_CHAR THEN
926: l_CURR_DETAILS_rec.curr_attribute_value := p_old_CURR_DETAILS_rec.curr_attribute_value;
927: END IF;
928:
929: IF l_CURR_DETAILS_rec.precedence = FND_API.G_MISS_NUM THEN
930: l_CURR_DETAILS_rec.precedence := p_old_CURR_DETAILS_rec.precedence;
931: END IF;
932:
933: RETURN l_CURR_DETAILS_rec;

Line 946: IF l_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR THEN

942: IS
943: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type := p_CURR_DETAILS_rec;
944: BEGIN
945:
946: IF l_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
947: l_CURR_DETAILS_rec.attribute1 := NULL;
948: END IF;
949:
950: IF l_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 950: IF l_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR THEN

946: IF l_CURR_DETAILS_rec.attribute1 = FND_API.G_MISS_CHAR THEN
947: l_CURR_DETAILS_rec.attribute1 := NULL;
948: END IF;
949:
950: IF l_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
951: l_CURR_DETAILS_rec.attribute10 := NULL;
952: END IF;
953:
954: IF l_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 954: IF l_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR THEN

950: IF l_CURR_DETAILS_rec.attribute10 = FND_API.G_MISS_CHAR THEN
951: l_CURR_DETAILS_rec.attribute10 := NULL;
952: END IF;
953:
954: IF l_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
955: l_CURR_DETAILS_rec.attribute11 := NULL;
956: END IF;
957:
958: IF l_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 958: IF l_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR THEN

954: IF l_CURR_DETAILS_rec.attribute11 = FND_API.G_MISS_CHAR THEN
955: l_CURR_DETAILS_rec.attribute11 := NULL;
956: END IF;
957:
958: IF l_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
959: l_CURR_DETAILS_rec.attribute12 := NULL;
960: END IF;
961:
962: IF l_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 962: IF l_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR THEN

958: IF l_CURR_DETAILS_rec.attribute12 = FND_API.G_MISS_CHAR THEN
959: l_CURR_DETAILS_rec.attribute12 := NULL;
960: END IF;
961:
962: IF l_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
963: l_CURR_DETAILS_rec.attribute13 := NULL;
964: END IF;
965:
966: IF l_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 966: IF l_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR THEN

962: IF l_CURR_DETAILS_rec.attribute13 = FND_API.G_MISS_CHAR THEN
963: l_CURR_DETAILS_rec.attribute13 := NULL;
964: END IF;
965:
966: IF l_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
967: l_CURR_DETAILS_rec.attribute14 := NULL;
968: END IF;
969:
970: IF l_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 970: IF l_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR THEN

966: IF l_CURR_DETAILS_rec.attribute14 = FND_API.G_MISS_CHAR THEN
967: l_CURR_DETAILS_rec.attribute14 := NULL;
968: END IF;
969:
970: IF l_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
971: l_CURR_DETAILS_rec.attribute15 := NULL;
972: END IF;
973:
974: IF l_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 974: IF l_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR THEN

970: IF l_CURR_DETAILS_rec.attribute15 = FND_API.G_MISS_CHAR THEN
971: l_CURR_DETAILS_rec.attribute15 := NULL;
972: END IF;
973:
974: IF l_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
975: l_CURR_DETAILS_rec.attribute2 := NULL;
976: END IF;
977:
978: IF l_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 978: IF l_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR THEN

974: IF l_CURR_DETAILS_rec.attribute2 = FND_API.G_MISS_CHAR THEN
975: l_CURR_DETAILS_rec.attribute2 := NULL;
976: END IF;
977:
978: IF l_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
979: l_CURR_DETAILS_rec.attribute3 := NULL;
980: END IF;
981:
982: IF l_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 982: IF l_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR THEN

978: IF l_CURR_DETAILS_rec.attribute3 = FND_API.G_MISS_CHAR THEN
979: l_CURR_DETAILS_rec.attribute3 := NULL;
980: END IF;
981:
982: IF l_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
983: l_CURR_DETAILS_rec.attribute4 := NULL;
984: END IF;
985:
986: IF l_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 986: IF l_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR THEN

982: IF l_CURR_DETAILS_rec.attribute4 = FND_API.G_MISS_CHAR THEN
983: l_CURR_DETAILS_rec.attribute4 := NULL;
984: END IF;
985:
986: IF l_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
987: l_CURR_DETAILS_rec.attribute5 := NULL;
988: END IF;
989:
990: IF l_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 990: IF l_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR THEN

986: IF l_CURR_DETAILS_rec.attribute5 = FND_API.G_MISS_CHAR THEN
987: l_CURR_DETAILS_rec.attribute5 := NULL;
988: END IF;
989:
990: IF l_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
991: l_CURR_DETAILS_rec.attribute6 := NULL;
992: END IF;
993:
994: IF l_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 994: IF l_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR THEN

990: IF l_CURR_DETAILS_rec.attribute6 = FND_API.G_MISS_CHAR THEN
991: l_CURR_DETAILS_rec.attribute6 := NULL;
992: END IF;
993:
994: IF l_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
995: l_CURR_DETAILS_rec.attribute7 := NULL;
996: END IF;
997:
998: IF l_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 998: IF l_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR THEN

994: IF l_CURR_DETAILS_rec.attribute7 = FND_API.G_MISS_CHAR THEN
995: l_CURR_DETAILS_rec.attribute7 := NULL;
996: END IF;
997:
998: IF l_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
999: l_CURR_DETAILS_rec.attribute8 := NULL;
1000: END IF;
1001:
1002: IF l_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1002: IF l_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR THEN

998: IF l_CURR_DETAILS_rec.attribute8 = FND_API.G_MISS_CHAR THEN
999: l_CURR_DETAILS_rec.attribute8 := NULL;
1000: END IF;
1001:
1002: IF l_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1003: l_CURR_DETAILS_rec.attribute9 := NULL;
1004: END IF;
1005:
1006: IF l_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR THEN

Line 1006: IF l_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR THEN

1002: IF l_CURR_DETAILS_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1003: l_CURR_DETAILS_rec.attribute9 := NULL;
1004: END IF;
1005:
1006: IF l_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR THEN
1007: l_CURR_DETAILS_rec.context := NULL;
1008: END IF;
1009:
1010: IF l_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE THEN

Line 1010: IF l_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE THEN

1006: IF l_CURR_DETAILS_rec.context = FND_API.G_MISS_CHAR THEN
1007: l_CURR_DETAILS_rec.context := NULL;
1008: END IF;
1009:
1010: IF l_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE THEN
1011: l_CURR_DETAILS_rec.conversion_date := NULL;
1012: END IF;
1013:
1014: IF l_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR THEN

Line 1014: IF l_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR THEN

1010: IF l_CURR_DETAILS_rec.conversion_date = FND_API.G_MISS_DATE THEN
1011: l_CURR_DETAILS_rec.conversion_date := NULL;
1012: END IF;
1013:
1014: IF l_CURR_DETAILS_rec.conversion_date_type = FND_API.G_MISS_CHAR THEN
1015: l_CURR_DETAILS_rec.conversion_date_type := NULL;
1016: END IF;
1017:
1018: /*

Line 1019: IF l_CURR_DETAILS_rec.conversion_method = FND_API.G_MISS_CHAR THEN

1015: l_CURR_DETAILS_rec.conversion_date_type := NULL;
1016: END IF;
1017:
1018: /*
1019: IF l_CURR_DETAILS_rec.conversion_method = FND_API.G_MISS_CHAR THEN
1020: l_CURR_DETAILS_rec.conversion_method := NULL;
1021: END IF;
1022: */
1023:

Line 1024: IF l_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR THEN

1020: l_CURR_DETAILS_rec.conversion_method := NULL;
1021: END IF;
1022: */
1023:
1024: IF l_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR THEN
1025: l_CURR_DETAILS_rec.conversion_type := NULL;
1026: END IF;
1027:
1028: IF l_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM THEN

Line 1028: IF l_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM THEN

1024: IF l_CURR_DETAILS_rec.conversion_type = FND_API.G_MISS_CHAR THEN
1025: l_CURR_DETAILS_rec.conversion_type := NULL;
1026: END IF;
1027:
1028: IF l_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM THEN
1029: l_CURR_DETAILS_rec.created_by := NULL;
1030: END IF;
1031:
1032: IF l_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 1032: IF l_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE THEN

1028: IF l_CURR_DETAILS_rec.created_by = FND_API.G_MISS_NUM THEN
1029: l_CURR_DETAILS_rec.created_by := NULL;
1030: END IF;
1031:
1032: IF l_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE THEN
1033: l_CURR_DETAILS_rec.creation_date := NULL;
1034: END IF;
1035:
1036: IF l_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM THEN

Line 1036: IF l_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM THEN

1032: IF l_CURR_DETAILS_rec.creation_date = FND_API.G_MISS_DATE THEN
1033: l_CURR_DETAILS_rec.creation_date := NULL;
1034: END IF;
1035:
1036: IF l_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM THEN
1037: l_CURR_DETAILS_rec.currency_detail_id := NULL;
1038: END IF;
1039:
1040: IF l_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM THEN

Line 1040: IF l_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM THEN

1036: IF l_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM THEN
1037: l_CURR_DETAILS_rec.currency_detail_id := NULL;
1038: END IF;
1039:
1040: IF l_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM THEN
1041: l_CURR_DETAILS_rec.currency_header_id := NULL;
1042: END IF;
1043:
1044: IF l_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE THEN

Line 1044: IF l_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE THEN

1040: IF l_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM THEN
1041: l_CURR_DETAILS_rec.currency_header_id := NULL;
1042: END IF;
1043:
1044: IF l_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE THEN
1045: l_CURR_DETAILS_rec.end_date_active := NULL;
1046: END IF;
1047:
1048: IF l_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM THEN

Line 1048: IF l_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM THEN

1044: IF l_CURR_DETAILS_rec.end_date_active = FND_API.G_MISS_DATE THEN
1045: l_CURR_DETAILS_rec.end_date_active := NULL;
1046: END IF;
1047:
1048: IF l_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM THEN
1049: l_CURR_DETAILS_rec.fixed_value := NULL;
1050: END IF;
1051:
1052: IF l_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 1052: IF l_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1048: IF l_CURR_DETAILS_rec.fixed_value = FND_API.G_MISS_NUM THEN
1049: l_CURR_DETAILS_rec.fixed_value := NULL;
1050: END IF;
1051:
1052: IF l_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1053: l_CURR_DETAILS_rec.last_updated_by := NULL;
1054: END IF;
1055:
1056: IF l_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 1056: IF l_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE THEN

1052: IF l_CURR_DETAILS_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1053: l_CURR_DETAILS_rec.last_updated_by := NULL;
1054: END IF;
1055:
1056: IF l_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE THEN
1057: l_CURR_DETAILS_rec.last_update_date := NULL;
1058: END IF;
1059:
1060: IF l_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 1060: IF l_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM THEN

1056: IF l_CURR_DETAILS_rec.last_update_date = FND_API.G_MISS_DATE THEN
1057: l_CURR_DETAILS_rec.last_update_date := NULL;
1058: END IF;
1059:
1060: IF l_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM THEN
1061: l_CURR_DETAILS_rec.last_update_login := NULL;
1062: END IF;
1063:
1064: IF l_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM THEN

Line 1064: IF l_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM THEN

1060: IF l_CURR_DETAILS_rec.last_update_login = FND_API.G_MISS_NUM THEN
1061: l_CURR_DETAILS_rec.last_update_login := NULL;
1062: END IF;
1063:
1064: IF l_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM THEN
1065: l_CURR_DETAILS_rec.markup_formula_id := NULL;
1066: END IF;
1067:
1068: IF l_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR THEN

Line 1068: IF l_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR THEN

1064: IF l_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM THEN
1065: l_CURR_DETAILS_rec.markup_formula_id := NULL;
1066: END IF;
1067:
1068: IF l_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR THEN
1069: l_CURR_DETAILS_rec.markup_operator := NULL;
1070: END IF;
1071:
1072: IF l_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM THEN

Line 1072: IF l_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM THEN

1068: IF l_CURR_DETAILS_rec.markup_operator = FND_API.G_MISS_CHAR THEN
1069: l_CURR_DETAILS_rec.markup_operator := NULL;
1070: END IF;
1071:
1072: IF l_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM THEN
1073: l_CURR_DETAILS_rec.markup_value := NULL;
1074: END IF;
1075:
1076: IF l_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM THEN

Line 1076: IF l_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM THEN

1072: IF l_CURR_DETAILS_rec.markup_value = FND_API.G_MISS_NUM THEN
1073: l_CURR_DETAILS_rec.markup_value := NULL;
1074: END IF;
1075:
1076: IF l_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM THEN
1077: l_CURR_DETAILS_rec.price_formula_id := NULL;
1078: END IF;
1079:
1080: IF l_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1080: IF l_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM THEN

1076: IF l_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM THEN
1077: l_CURR_DETAILS_rec.price_formula_id := NULL;
1078: END IF;
1079:
1080: IF l_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM THEN
1081: l_CURR_DETAILS_rec.program_application_id := NULL;
1082: END IF;
1083:
1084: IF l_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1084: IF l_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM THEN

1080: IF l_CURR_DETAILS_rec.program_application_id = FND_API.G_MISS_NUM THEN
1081: l_CURR_DETAILS_rec.program_application_id := NULL;
1082: END IF;
1083:
1084: IF l_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM THEN
1085: l_CURR_DETAILS_rec.program_id := NULL;
1086: END IF;
1087:
1088: IF l_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1088: IF l_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE THEN

1084: IF l_CURR_DETAILS_rec.program_id = FND_API.G_MISS_NUM THEN
1085: l_CURR_DETAILS_rec.program_id := NULL;
1086: END IF;
1087:
1088: IF l_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE THEN
1089: l_CURR_DETAILS_rec.program_update_date := NULL;
1090: END IF;
1091:
1092: IF l_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1092: IF l_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM THEN

1088: IF l_CURR_DETAILS_rec.program_update_date = FND_API.G_MISS_DATE THEN
1089: l_CURR_DETAILS_rec.program_update_date := NULL;
1090: END IF;
1091:
1092: IF l_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM THEN
1093: l_CURR_DETAILS_rec.request_id := NULL;
1094: END IF;
1095:
1096: IF l_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM THEN

Line 1096: IF l_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM THEN

1092: IF l_CURR_DETAILS_rec.request_id = FND_API.G_MISS_NUM THEN
1093: l_CURR_DETAILS_rec.request_id := NULL;
1094: END IF;
1095:
1096: IF l_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1097: l_CURR_DETAILS_rec.rounding_factor := NULL;
1098: END IF;
1099:
1100: IF l_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM THEN

Line 1100: IF l_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM THEN

1096: IF l_CURR_DETAILS_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1097: l_CURR_DETAILS_rec.rounding_factor := NULL;
1098: END IF;
1099:
1100: IF l_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM THEN
1101: l_CURR_DETAILS_rec.selling_rounding_factor := NULL;
1102: END IF;
1103:
1104: IF l_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE THEN

Line 1104: IF l_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE THEN

1100: IF l_CURR_DETAILS_rec.selling_rounding_factor = FND_API.G_MISS_NUM THEN
1101: l_CURR_DETAILS_rec.selling_rounding_factor := NULL;
1102: END IF;
1103:
1104: IF l_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE THEN
1105: l_CURR_DETAILS_rec.start_date_active := NULL;
1106: END IF;
1107:
1108: IF l_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR THEN

Line 1108: IF l_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR THEN

1104: IF l_CURR_DETAILS_rec.start_date_active = FND_API.G_MISS_DATE THEN
1105: l_CURR_DETAILS_rec.start_date_active := NULL;
1106: END IF;
1107:
1108: IF l_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR THEN
1109: l_CURR_DETAILS_rec.to_currency_code := NULL;
1110: END IF;
1111:
1112: IF l_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR THEN

Line 1112: IF l_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR THEN

1108: IF l_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR THEN
1109: l_CURR_DETAILS_rec.to_currency_code := NULL;
1110: END IF;
1111:
1112: IF l_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR THEN
1113: l_CURR_DETAILS_rec.curr_attribute_type := NULL;
1114: END IF;
1115:
1116: IF l_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR THEN

Line 1116: IF l_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR THEN

1112: IF l_CURR_DETAILS_rec.curr_attribute_type = FND_API.G_MISS_CHAR THEN
1113: l_CURR_DETAILS_rec.curr_attribute_type := NULL;
1114: END IF;
1115:
1116: IF l_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR THEN
1117: l_CURR_DETAILS_rec.curr_attribute_context := NULL;
1118: END IF;
1119:
1120: IF l_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR THEN

Line 1120: IF l_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR THEN

1116: IF l_CURR_DETAILS_rec.curr_attribute_context = FND_API.G_MISS_CHAR THEN
1117: l_CURR_DETAILS_rec.curr_attribute_context := NULL;
1118: END IF;
1119:
1120: IF l_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR THEN
1121: l_CURR_DETAILS_rec.curr_attribute := NULL;
1122: END IF;
1123:
1124: IF l_CURR_DETAILS_rec.curr_attribute_value = FND_API.G_MISS_CHAR THEN

Line 1124: IF l_CURR_DETAILS_rec.curr_attribute_value = FND_API.G_MISS_CHAR THEN

1120: IF l_CURR_DETAILS_rec.curr_attribute = FND_API.G_MISS_CHAR THEN
1121: l_CURR_DETAILS_rec.curr_attribute := NULL;
1122: END IF;
1123:
1124: IF l_CURR_DETAILS_rec.curr_attribute_value = FND_API.G_MISS_CHAR THEN
1125: l_CURR_DETAILS_rec.curr_attribute_value := NULL;
1126: END IF;
1127:
1128: IF l_CURR_DETAILS_rec.precedence = FND_API.G_MISS_NUM THEN

Line 1128: IF l_CURR_DETAILS_rec.precedence = FND_API.G_MISS_NUM THEN

1124: IF l_CURR_DETAILS_rec.curr_attribute_value = FND_API.G_MISS_CHAR THEN
1125: l_CURR_DETAILS_rec.curr_attribute_value := NULL;
1126: END IF;
1127:
1128: IF l_CURR_DETAILS_rec.precedence = FND_API.G_MISS_NUM THEN
1129: l_CURR_DETAILS_rec.precedence := NULL;
1130: END IF;
1131:
1132: RETURN l_CURR_DETAILS_rec;

Line 1206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1323: , 'Insert_Row'
1324: );
1325: END IF;
1326:
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1328:
1329: END Insert_Row;
1330:
1331: -- Procedure Delete_Row

Line 1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1351: , 'Delete_Row'
1352: );
1353: END IF;
1354:
1355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1356:
1357: END Delete_Row;
1358:
1359: -- Function Query_Row

Line 1379: FND_API.G_MISS_NUM

1375: --
1376:
1377: FUNCTION Query_Rows
1378: ( p_currency_detail_id IN NUMBER :=
1379: FND_API.G_MISS_NUM
1380: , p_currency_header_id IN NUMBER :=
1381: FND_API.G_MISS_NUM
1382: ) RETURN QP_Currency_PUB.Curr_Details_Tbl_Type
1383: IS

Line 1381: FND_API.G_MISS_NUM

1377: FUNCTION Query_Rows
1378: ( p_currency_detail_id IN NUMBER :=
1379: FND_API.G_MISS_NUM
1380: , p_currency_header_id IN NUMBER :=
1381: FND_API.G_MISS_NUM
1382: ) RETURN QP_Currency_PUB.Curr_Details_Tbl_Type
1383: IS
1384: l_CURR_DETAILS_rec QP_Currency_PUB.Curr_Details_Rec_Type;
1385: l_CURR_DETAILS_tbl QP_Currency_PUB.Curr_Details_Tbl_Type;

Line 1445: p_currency_detail_id <> FND_API.G_MISS_NUM)

1441:
1442: IF
1443: (p_currency_detail_id IS NOT NULL
1444: AND
1445: p_currency_detail_id <> FND_API.G_MISS_NUM)
1446: AND
1447: (p_currency_header_id IS NOT NULL
1448: AND
1449: p_currency_header_id <> FND_API.G_MISS_NUM)

Line 1449: p_currency_header_id <> FND_API.G_MISS_NUM)

1445: p_currency_detail_id <> FND_API.G_MISS_NUM)
1446: AND
1447: (p_currency_header_id IS NOT NULL
1448: AND
1449: p_currency_header_id <> FND_API.G_MISS_NUM)
1450: THEN
1451: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1452: THEN
1453: OE_MSG_PUB.Add_Exc_Msg

Line 1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1456: , 'Keys are mutually exclusive: currency_detail_id = '|| p_currency_detail_id || ', currency_header_id = '|| p_currency_header_id
1457: );
1458: END IF;
1459:
1460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1461:
1462: END IF;
1463:
1464:

Line 1526: p_currency_detail_id <> FND_API.G_MISS_NUM)

1522:
1523: IF
1524: (p_currency_detail_id IS NOT NULL
1525: AND
1526: p_currency_detail_id <> FND_API.G_MISS_NUM)
1527: AND
1528: (l_CURR_DETAILS_tbl.COUNT = 0)
1529: THEN
1530: RAISE NO_DATA_FOUND;

Line 1540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1536: RETURN l_CURR_DETAILS_tbl;
1537:
1538: EXCEPTION
1539:
1540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1541:
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543:
1544: WHEN OTHERS THEN

Line 1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1538: EXCEPTION
1539:
1540: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1541:
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543:
1544: WHEN OTHERS THEN
1545:
1546: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1550: , 'Query_Rows'
1551: );
1552: END IF;
1553:
1554: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1555:
1556: END Query_Rows;
1557:
1558: -- Procedure lock_Row

Line 1768: x_return_status := FND_API.G_RET_STS_SUCCESS;

1764: x_CURR_DETAILS_rec := l_CURR_DETAILS_rec;
1765:
1766: -- Set return status
1767:
1768: x_return_status := FND_API.G_RET_STS_SUCCESS;
1769: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1770:
1771: ELSE
1772:

Line 1769: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1765:
1766: -- Set return status
1767:
1768: x_return_status := FND_API.G_RET_STS_SUCCESS;
1769: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1770:
1771: ELSE
1772:
1773: -- Row has changed by another user.

Line 1775: x_return_status := FND_API.G_RET_STS_ERROR;

1771: ELSE
1772:
1773: -- Row has changed by another user.
1774:
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
1777:
1778: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1779: THEN

Line 1776: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;

1772:
1773: -- Row has changed by another user.
1774:
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
1777:
1778: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1779: THEN
1780:

Line 1792: x_return_status := FND_API.G_RET_STS_ERROR;

1788: EXCEPTION
1789:
1790: WHEN NO_DATA_FOUND THEN
1791:
1792: x_return_status := FND_API.G_RET_STS_ERROR;
1793: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
1794:
1795: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1796: THEN

Line 1793: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;

1789:
1790: WHEN NO_DATA_FOUND THEN
1791:
1792: x_return_status := FND_API.G_RET_STS_ERROR;
1793: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
1794:
1795: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1796: THEN
1797:

Line 1804: x_return_status := FND_API.G_RET_STS_ERROR;

1800:
1801: END IF;
1802: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1803:
1804: x_return_status := FND_API.G_RET_STS_ERROR;
1805: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
1806:
1807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1808: THEN

Line 1805: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;

1801: END IF;
1802: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1803:
1804: x_return_status := FND_API.G_RET_STS_ERROR;
1805: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
1806:
1807: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
1808: THEN
1809:

Line 1816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1812:
1813: END IF;
1814: WHEN OTHERS THEN
1815:
1816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1817: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1818:
1819: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1820: THEN

Line 1817: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1813: END IF;
1814: WHEN OTHERS THEN
1815:
1816: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1817: x_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1818:
1819: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1820: THEN
1821: OE_MSG_PUB.Add_Exc_Msg

Line 1841: p_CURR_DETAILS_rec.currency_detail_id <> FND_API.G_MISS_NUM AND

1837: l_CURR_DETAILS_val_rec QP_Currency_PUB.Curr_Details_Val_Rec_Type;
1838: BEGIN
1839:
1840: IF p_CURR_DETAILS_rec.currency_detail_id IS NOT NULL AND
1841: p_CURR_DETAILS_rec.currency_detail_id <> FND_API.G_MISS_NUM AND
1842: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_detail_id,
1843: p_old_CURR_DETAILS_rec.currency_detail_id)
1844: THEN
1845: l_CURR_DETAILS_val_rec.currency_detail := QP_Id_To_Value.Currency_Detail

Line 1851: p_CURR_DETAILS_rec.currency_header_id <> FND_API.G_MISS_NUM AND

1847: );
1848: END IF;
1849:
1850: IF p_CURR_DETAILS_rec.currency_header_id IS NOT NULL AND
1851: p_CURR_DETAILS_rec.currency_header_id <> FND_API.G_MISS_NUM AND
1852: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.currency_header_id,
1853: p_old_CURR_DETAILS_rec.currency_header_id)
1854: THEN
1855: l_CURR_DETAILS_val_rec.currency_header := QP_Id_To_Value.Currency_Header

Line 1861: p_CURR_DETAILS_rec.markup_formula_id <> FND_API.G_MISS_NUM AND

1857: );
1858: END IF;
1859:
1860: IF p_CURR_DETAILS_rec.markup_formula_id IS NOT NULL AND
1861: p_CURR_DETAILS_rec.markup_formula_id <> FND_API.G_MISS_NUM AND
1862: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.markup_formula_id,
1863: p_old_CURR_DETAILS_rec.markup_formula_id)
1864: THEN
1865: l_CURR_DETAILS_val_rec.markup_formula := QP_Id_To_Value.Markup_Formula

Line 1871: p_CURR_DETAILS_rec.price_formula_id <> FND_API.G_MISS_NUM AND

1867: );
1868: END IF;
1869:
1870: IF p_CURR_DETAILS_rec.price_formula_id IS NOT NULL AND
1871: p_CURR_DETAILS_rec.price_formula_id <> FND_API.G_MISS_NUM AND
1872: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.price_formula_id,
1873: p_old_CURR_DETAILS_rec.price_formula_id)
1874: THEN
1875: l_CURR_DETAILS_val_rec.price_formula := QP_Id_To_Value.Price_Formula

Line 1881: p_CURR_DETAILS_rec.to_currency_code <> FND_API.G_MISS_CHAR AND

1877: );
1878: END IF;
1879:
1880: IF p_CURR_DETAILS_rec.to_currency_code IS NOT NULL AND
1881: p_CURR_DETAILS_rec.to_currency_code <> FND_API.G_MISS_CHAR AND
1882: NOT QP_GLOBALS.Equal(p_CURR_DETAILS_rec.to_currency_code,
1883: p_old_CURR_DETAILS_rec.to_currency_code)
1884: THEN
1885: l_CURR_DETAILS_val_rec.to_currency := QP_Id_To_Value.To_Currency

Line 1906: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1902: BEGIN
1903:
1904: -- initialize return_status.
1905:
1906: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1907:
1908: -- initialize l_CURR_DETAILS_rec.
1909:
1910: l_CURR_DETAILS_rec := p_CURR_DETAILS_rec;

Line 1912: IF p_CURR_DETAILS_val_rec.currency_detail <> FND_API.G_MISS_CHAR

1908: -- initialize l_CURR_DETAILS_rec.
1909:
1910: l_CURR_DETAILS_rec := p_CURR_DETAILS_rec;
1911:
1912: IF p_CURR_DETAILS_val_rec.currency_detail <> FND_API.G_MISS_CHAR
1913: THEN
1914:
1915: IF p_CURR_DETAILS_rec.currency_detail_id <> FND_API.G_MISS_NUM THEN
1916:

Line 1915: IF p_CURR_DETAILS_rec.currency_detail_id <> FND_API.G_MISS_NUM THEN

1911:
1912: IF p_CURR_DETAILS_val_rec.currency_detail <> FND_API.G_MISS_CHAR
1913: THEN
1914:
1915: IF p_CURR_DETAILS_rec.currency_detail_id <> FND_API.G_MISS_NUM THEN
1916:
1917: l_CURR_DETAILS_rec.currency_detail_id := p_CURR_DETAILS_rec.currency_detail_id;
1918:
1919: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1934: IF l_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM THEN

1930: l_CURR_DETAILS_rec.currency_detail_id := QP_Value_To_Id.currency_detail
1931: ( p_currency_detail => p_CURR_DETAILS_val_rec.currency_detail
1932: );
1933:
1934: IF l_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM THEN
1935: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
1936: END IF;
1937:
1938: END IF;

Line 1935: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;

1931: ( p_currency_detail => p_CURR_DETAILS_val_rec.currency_detail
1932: );
1933:
1934: IF l_CURR_DETAILS_rec.currency_detail_id = FND_API.G_MISS_NUM THEN
1935: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
1936: END IF;
1937:
1938: END IF;
1939:

Line 1942: IF p_CURR_DETAILS_val_rec.currency_header <> FND_API.G_MISS_CHAR

1938: END IF;
1939:
1940: END IF;
1941:
1942: IF p_CURR_DETAILS_val_rec.currency_header <> FND_API.G_MISS_CHAR
1943: THEN
1944:
1945: IF p_CURR_DETAILS_rec.currency_header_id <> FND_API.G_MISS_NUM THEN
1946:

Line 1945: IF p_CURR_DETAILS_rec.currency_header_id <> FND_API.G_MISS_NUM THEN

1941:
1942: IF p_CURR_DETAILS_val_rec.currency_header <> FND_API.G_MISS_CHAR
1943: THEN
1944:
1945: IF p_CURR_DETAILS_rec.currency_header_id <> FND_API.G_MISS_NUM THEN
1946:
1947: l_CURR_DETAILS_rec.currency_header_id := p_CURR_DETAILS_rec.currency_header_id;
1948:
1949: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1964: IF l_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM THEN

1960: l_CURR_DETAILS_rec.currency_header_id := QP_Value_To_Id.currency_header
1961: ( p_currency_header => p_CURR_DETAILS_val_rec.currency_header
1962: );
1963:
1964: IF l_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM THEN
1965: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
1966: END IF;
1967:
1968: END IF;

Line 1965: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;

1961: ( p_currency_header => p_CURR_DETAILS_val_rec.currency_header
1962: );
1963:
1964: IF l_CURR_DETAILS_rec.currency_header_id = FND_API.G_MISS_NUM THEN
1965: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
1966: END IF;
1967:
1968: END IF;
1969:

Line 1972: IF p_CURR_DETAILS_val_rec.markup_formula <> FND_API.G_MISS_CHAR

1968: END IF;
1969:
1970: END IF;
1971:
1972: IF p_CURR_DETAILS_val_rec.markup_formula <> FND_API.G_MISS_CHAR
1973: THEN
1974:
1975: IF p_CURR_DETAILS_rec.markup_formula_id <> FND_API.G_MISS_NUM THEN
1976:

Line 1975: IF p_CURR_DETAILS_rec.markup_formula_id <> FND_API.G_MISS_NUM THEN

1971:
1972: IF p_CURR_DETAILS_val_rec.markup_formula <> FND_API.G_MISS_CHAR
1973: THEN
1974:
1975: IF p_CURR_DETAILS_rec.markup_formula_id <> FND_API.G_MISS_NUM THEN
1976:
1977: l_CURR_DETAILS_rec.markup_formula_id := p_CURR_DETAILS_rec.markup_formula_id;
1978:
1979: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 1994: IF l_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM THEN

1990: l_CURR_DETAILS_rec.markup_formula_id := QP_Value_To_Id.markup_formula
1991: ( p_markup_formula => p_CURR_DETAILS_val_rec.markup_formula
1992: );
1993:
1994: IF l_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM THEN
1995: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
1996: END IF;
1997:
1998: END IF;

Line 1995: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;

1991: ( p_markup_formula => p_CURR_DETAILS_val_rec.markup_formula
1992: );
1993:
1994: IF l_CURR_DETAILS_rec.markup_formula_id = FND_API.G_MISS_NUM THEN
1995: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
1996: END IF;
1997:
1998: END IF;
1999:

Line 2002: IF p_CURR_DETAILS_val_rec.price_formula <> FND_API.G_MISS_CHAR

1998: END IF;
1999:
2000: END IF;
2001:
2002: IF p_CURR_DETAILS_val_rec.price_formula <> FND_API.G_MISS_CHAR
2003: THEN
2004:
2005: IF p_CURR_DETAILS_rec.price_formula_id <> FND_API.G_MISS_NUM THEN
2006:

Line 2005: IF p_CURR_DETAILS_rec.price_formula_id <> FND_API.G_MISS_NUM THEN

2001:
2002: IF p_CURR_DETAILS_val_rec.price_formula <> FND_API.G_MISS_CHAR
2003: THEN
2004:
2005: IF p_CURR_DETAILS_rec.price_formula_id <> FND_API.G_MISS_NUM THEN
2006:
2007: l_CURR_DETAILS_rec.price_formula_id := p_CURR_DETAILS_rec.price_formula_id;
2008:
2009: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2024: IF l_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM THEN

2020: l_CURR_DETAILS_rec.price_formula_id := QP_Value_To_Id.price_formula
2021: ( p_price_formula => p_CURR_DETAILS_val_rec.price_formula
2022: );
2023:
2024: IF l_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM THEN
2025: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
2026: END IF;
2027:
2028: END IF;

Line 2025: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;

2021: ( p_price_formula => p_CURR_DETAILS_val_rec.price_formula
2022: );
2023:
2024: IF l_CURR_DETAILS_rec.price_formula_id = FND_API.G_MISS_NUM THEN
2025: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
2026: END IF;
2027:
2028: END IF;
2029:

Line 2032: IF p_CURR_DETAILS_val_rec.to_currency <> FND_API.G_MISS_CHAR

2028: END IF;
2029:
2030: END IF;
2031:
2032: IF p_CURR_DETAILS_val_rec.to_currency <> FND_API.G_MISS_CHAR
2033: THEN
2034:
2035: IF p_CURR_DETAILS_rec.to_currency_code <> FND_API.G_MISS_CHAR THEN
2036:

Line 2035: IF p_CURR_DETAILS_rec.to_currency_code <> FND_API.G_MISS_CHAR THEN

2031:
2032: IF p_CURR_DETAILS_val_rec.to_currency <> FND_API.G_MISS_CHAR
2033: THEN
2034:
2035: IF p_CURR_DETAILS_rec.to_currency_code <> FND_API.G_MISS_CHAR THEN
2036:
2037: l_CURR_DETAILS_rec.to_currency_code := p_CURR_DETAILS_rec.to_currency_code;
2038:
2039: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 2054: IF l_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR THEN

2050: l_CURR_DETAILS_rec.to_currency_code := QP_Value_To_Id.to_currency
2051: ( p_to_currency => p_CURR_DETAILS_val_rec.to_currency
2052: );
2053:
2054: IF l_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR THEN
2055: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
2056: END IF;
2057:
2058: END IF;

Line 2055: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;

2051: ( p_to_currency => p_CURR_DETAILS_val_rec.to_currency
2052: );
2053:
2054: IF l_CURR_DETAILS_rec.to_currency_code = FND_API.G_MISS_CHAR THEN
2055: l_CURR_DETAILS_rec.return_status := FND_API.G_RET_STS_ERROR;
2056: END IF;
2057:
2058: END IF;
2059: