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

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

7: G_PRODUCT_UOM_CODE VARCHAR2(30);
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type
13: , p_old_PRICING_ATTR_rec IN QP_Price_List_PUB.Pricing_Attr_Rec_Type :=
14: QP_Price_List_PUB.G_MISS_PRICING_ATTR_REC
15: , x_PRICING_ATTR_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Pricing_Attr_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_PRICING_ATTR_rec.accumulate_flag,p_old_PRICING_ATTR_rec.accumulate_flag)
33: THEN
34: l_index := l_index + 1;

Line 452: p_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN

448:
449: x_PRICING_ATTR_rec := p_PRICING_ATTR_rec;
450:
451: IF p_PRICING_ATTR_rec.list_header_id IS NULL OR
452: p_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
453:
454: BEGIN
455: SELECT list_header_id
456: INTO l_list_header_id

Line 764: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN

760: IS
761: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type := p_PRICING_ATTR_rec;
762: BEGIN
763:
764: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
765: l_PRICING_ATTR_rec.accumulate_flag := p_old_PRICING_ATTR_rec.accumulate_flag;
766: END IF;
767:
768: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 768: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN

764: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
765: l_PRICING_ATTR_rec.accumulate_flag := p_old_PRICING_ATTR_rec.accumulate_flag;
766: END IF;
767:
768: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
769: l_PRICING_ATTR_rec.attribute1 := p_old_PRICING_ATTR_rec.attribute1;
770: END IF;
771:
772: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 772: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN

768: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
769: l_PRICING_ATTR_rec.attribute1 := p_old_PRICING_ATTR_rec.attribute1;
770: END IF;
771:
772: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
773: l_PRICING_ATTR_rec.attribute10 := p_old_PRICING_ATTR_rec.attribute10;
774: END IF;
775:
776: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 776: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN

772: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
773: l_PRICING_ATTR_rec.attribute10 := p_old_PRICING_ATTR_rec.attribute10;
774: END IF;
775:
776: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
777: l_PRICING_ATTR_rec.attribute11 := p_old_PRICING_ATTR_rec.attribute11;
778: END IF;
779:
780: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 780: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN

776: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
777: l_PRICING_ATTR_rec.attribute11 := p_old_PRICING_ATTR_rec.attribute11;
778: END IF;
779:
780: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
781: l_PRICING_ATTR_rec.attribute12 := p_old_PRICING_ATTR_rec.attribute12;
782: END IF;
783:
784: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 784: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN

780: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
781: l_PRICING_ATTR_rec.attribute12 := p_old_PRICING_ATTR_rec.attribute12;
782: END IF;
783:
784: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
785: l_PRICING_ATTR_rec.attribute13 := p_old_PRICING_ATTR_rec.attribute13;
786: END IF;
787:
788: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 788: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN

784: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
785: l_PRICING_ATTR_rec.attribute13 := p_old_PRICING_ATTR_rec.attribute13;
786: END IF;
787:
788: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
789: l_PRICING_ATTR_rec.attribute14 := p_old_PRICING_ATTR_rec.attribute14;
790: END IF;
791:
792: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 792: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN

788: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
789: l_PRICING_ATTR_rec.attribute14 := p_old_PRICING_ATTR_rec.attribute14;
790: END IF;
791:
792: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
793: l_PRICING_ATTR_rec.attribute15 := p_old_PRICING_ATTR_rec.attribute15;
794: END IF;
795:
796: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 796: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN

792: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
793: l_PRICING_ATTR_rec.attribute15 := p_old_PRICING_ATTR_rec.attribute15;
794: END IF;
795:
796: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
797: l_PRICING_ATTR_rec.attribute2 := p_old_PRICING_ATTR_rec.attribute2;
798: END IF;
799:
800: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 800: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN

796: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
797: l_PRICING_ATTR_rec.attribute2 := p_old_PRICING_ATTR_rec.attribute2;
798: END IF;
799:
800: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
801: l_PRICING_ATTR_rec.attribute3 := p_old_PRICING_ATTR_rec.attribute3;
802: END IF;
803:
804: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 804: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN

800: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
801: l_PRICING_ATTR_rec.attribute3 := p_old_PRICING_ATTR_rec.attribute3;
802: END IF;
803:
804: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
805: l_PRICING_ATTR_rec.attribute4 := p_old_PRICING_ATTR_rec.attribute4;
806: END IF;
807:
808: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 808: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN

804: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
805: l_PRICING_ATTR_rec.attribute4 := p_old_PRICING_ATTR_rec.attribute4;
806: END IF;
807:
808: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
809: l_PRICING_ATTR_rec.attribute5 := p_old_PRICING_ATTR_rec.attribute5;
810: END IF;
811:
812: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 812: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN

808: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
809: l_PRICING_ATTR_rec.attribute5 := p_old_PRICING_ATTR_rec.attribute5;
810: END IF;
811:
812: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
813: l_PRICING_ATTR_rec.attribute6 := p_old_PRICING_ATTR_rec.attribute6;
814: END IF;
815:
816: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 816: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN

812: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
813: l_PRICING_ATTR_rec.attribute6 := p_old_PRICING_ATTR_rec.attribute6;
814: END IF;
815:
816: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
817: l_PRICING_ATTR_rec.attribute7 := p_old_PRICING_ATTR_rec.attribute7;
818: END IF;
819:
820: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 820: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN

816: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
817: l_PRICING_ATTR_rec.attribute7 := p_old_PRICING_ATTR_rec.attribute7;
818: END IF;
819:
820: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
821: l_PRICING_ATTR_rec.attribute8 := p_old_PRICING_ATTR_rec.attribute8;
822: END IF;
823:
824: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 824: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN

820: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
821: l_PRICING_ATTR_rec.attribute8 := p_old_PRICING_ATTR_rec.attribute8;
822: END IF;
823:
824: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
825: l_PRICING_ATTR_rec.attribute9 := p_old_PRICING_ATTR_rec.attribute9;
826: END IF;
827:
828: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN

Line 828: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN

824: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
825: l_PRICING_ATTR_rec.attribute9 := p_old_PRICING_ATTR_rec.attribute9;
826: END IF;
827:
828: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
829: l_PRICING_ATTR_rec.attribute_grouping_no := p_old_PRICING_ATTR_rec.attribute_grouping_no;
830: END IF;
831:
832: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN

Line 832: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN

828: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
829: l_PRICING_ATTR_rec.attribute_grouping_no := p_old_PRICING_ATTR_rec.attribute_grouping_no;
830: END IF;
831:
832: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
833: l_PRICING_ATTR_rec.context := p_old_PRICING_ATTR_rec.context;
834: END IF;
835:
836: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN

Line 836: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN

832: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
833: l_PRICING_ATTR_rec.context := p_old_PRICING_ATTR_rec.context;
834: END IF;
835:
836: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
837: l_PRICING_ATTR_rec.created_by := p_old_PRICING_ATTR_rec.created_by;
838: END IF;
839:
840: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 840: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN

836: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
837: l_PRICING_ATTR_rec.created_by := p_old_PRICING_ATTR_rec.created_by;
838: END IF;
839:
840: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
841: l_PRICING_ATTR_rec.creation_date := p_old_PRICING_ATTR_rec.creation_date;
842: END IF;
843:
844: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

Line 844: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

840: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
841: l_PRICING_ATTR_rec.creation_date := p_old_PRICING_ATTR_rec.creation_date;
842: END IF;
843:
844: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
845: l_PRICING_ATTR_rec.excluder_flag := p_old_PRICING_ATTR_rec.excluder_flag;
846: END IF;
847:
848: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 848: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN

844: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
845: l_PRICING_ATTR_rec.excluder_flag := p_old_PRICING_ATTR_rec.excluder_flag;
846: END IF;
847:
848: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
849: l_PRICING_ATTR_rec.last_updated_by := p_old_PRICING_ATTR_rec.last_updated_by;
850: END IF;
851:
852: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 852: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN

848: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
849: l_PRICING_ATTR_rec.last_updated_by := p_old_PRICING_ATTR_rec.last_updated_by;
850: END IF;
851:
852: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
853: l_PRICING_ATTR_rec.last_update_date := p_old_PRICING_ATTR_rec.last_update_date;
854: END IF;
855:
856: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 856: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN

852: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
853: l_PRICING_ATTR_rec.last_update_date := p_old_PRICING_ATTR_rec.last_update_date;
854: END IF;
855:
856: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN
857: l_PRICING_ATTR_rec.last_update_login := p_old_PRICING_ATTR_rec.last_update_login;
858: END IF;
859:
860: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN

Line 860: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN

856: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN
857: l_PRICING_ATTR_rec.last_update_login := p_old_PRICING_ATTR_rec.last_update_login;
858: END IF;
859:
860: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
861: l_PRICING_ATTR_rec.list_line_id := p_old_PRICING_ATTR_rec.list_line_id;
862: END IF;
863:
864: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 864: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN

860: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
861: l_PRICING_ATTR_rec.list_line_id := p_old_PRICING_ATTR_rec.list_line_id;
862: END IF;
863:
864: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
865: l_PRICING_ATTR_rec.list_header_id := p_old_PRICING_ATTR_rec.list_header_id;
866: END IF;
867:
868: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN

Line 868: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN

864: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
865: l_PRICING_ATTR_rec.list_header_id := p_old_PRICING_ATTR_rec.list_header_id;
866: END IF;
867:
868: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
869: l_PRICING_ATTR_rec.pricing_phase_id := p_old_PRICING_ATTR_rec.pricing_phase_id;
870: END IF;
871:
872: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

Line 872: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

868: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
869: l_PRICING_ATTR_rec.pricing_phase_id := p_old_PRICING_ATTR_rec.pricing_phase_id;
870: END IF;
871:
872: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
873: l_PRICING_ATTR_rec.pricing_attribute := p_old_PRICING_ATTR_rec.pricing_attribute;
874: END IF;
875:
876: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

Line 876: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

872: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
873: l_PRICING_ATTR_rec.pricing_attribute := p_old_PRICING_ATTR_rec.pricing_attribute;
874: END IF;
875:
876: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
877: l_PRICING_ATTR_rec.pricing_attribute_context := p_old_PRICING_ATTR_rec.pricing_attribute_context;
878: END IF;
879:
880: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

Line 880: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

876: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
877: l_PRICING_ATTR_rec.pricing_attribute_context := p_old_PRICING_ATTR_rec.pricing_attribute_context;
878: END IF;
879:
880: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
881: l_PRICING_ATTR_rec.pricing_attribute_id := p_old_PRICING_ATTR_rec.pricing_attribute_id;
882: END IF;
883:
884: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN

Line 884: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN

880: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
881: l_PRICING_ATTR_rec.pricing_attribute_id := p_old_PRICING_ATTR_rec.pricing_attribute_id;
882: END IF;
883:
884: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
885: l_PRICING_ATTR_rec.pricing_attr_value_from := p_old_PRICING_ATTR_rec.pricing_attr_value_from;
886: END IF;
887:
888: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN

Line 888: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN

884: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
885: l_PRICING_ATTR_rec.pricing_attr_value_from := p_old_PRICING_ATTR_rec.pricing_attr_value_from;
886: END IF;
887:
888: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
889: l_PRICING_ATTR_rec.pricing_attr_value_to := p_old_PRICING_ATTR_rec.pricing_attr_value_to;
890: END IF;
891:
892: IF l_PRICING_ATTR_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN

Line 892: IF l_PRICING_ATTR_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN

888: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
889: l_PRICING_ATTR_rec.pricing_attr_value_to := p_old_PRICING_ATTR_rec.pricing_attr_value_to;
890: END IF;
891:
892: IF l_PRICING_ATTR_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
893: l_PRICING_ATTR_rec.from_rltd_modifier_id := p_old_PRICING_ATTR_rec.from_rltd_modifier_id;
894: END IF;
895:
896: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN

Line 896: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN

892: IF l_PRICING_ATTR_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
893: l_PRICING_ATTR_rec.from_rltd_modifier_id := p_old_PRICING_ATTR_rec.from_rltd_modifier_id;
894: END IF;
895:
896: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
897: l_PRICING_ATTR_rec.product_attribute := p_old_PRICING_ATTR_rec.product_attribute;
898: END IF;
899:
900: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN

Line 900: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN

896: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
897: l_PRICING_ATTR_rec.product_attribute := p_old_PRICING_ATTR_rec.product_attribute;
898: END IF;
899:
900: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
901: l_PRICING_ATTR_rec.product_attribute_context := p_old_PRICING_ATTR_rec.product_attribute_context;
902: END IF;
903:
904: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN

Line 904: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN

900: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
901: l_PRICING_ATTR_rec.product_attribute_context := p_old_PRICING_ATTR_rec.product_attribute_context;
902: END IF;
903:
904: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
905: l_PRICING_ATTR_rec.product_attr_value := p_old_PRICING_ATTR_rec.product_attr_value;
906: END IF;
907:
908: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN

Line 908: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN

904: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
905: l_PRICING_ATTR_rec.product_attr_value := p_old_PRICING_ATTR_rec.product_attr_value;
906: END IF;
907:
908: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
909: l_PRICING_ATTR_rec.product_uom_code := p_old_PRICING_ATTR_rec.product_uom_code;
910: END IF;
911:
912: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 912: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN

908: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
909: l_PRICING_ATTR_rec.product_uom_code := p_old_PRICING_ATTR_rec.product_uom_code;
910: END IF;
911:
912: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
913: l_PRICING_ATTR_rec.program_application_id := p_old_PRICING_ATTR_rec.program_application_id;
914: END IF;
915:
916: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN

Line 916: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN

912: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
913: l_PRICING_ATTR_rec.program_application_id := p_old_PRICING_ATTR_rec.program_application_id;
914: END IF;
915:
916: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
917: l_PRICING_ATTR_rec.program_id := p_old_PRICING_ATTR_rec.program_id;
918: END IF;
919:
920: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 920: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN

916: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
917: l_PRICING_ATTR_rec.program_id := p_old_PRICING_ATTR_rec.program_id;
918: END IF;
919:
920: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
921: l_PRICING_ATTR_rec.program_update_date := p_old_PRICING_ATTR_rec.program_update_date;
922: END IF;
923:
924: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN

Line 924: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN

920: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
921: l_PRICING_ATTR_rec.program_update_date := p_old_PRICING_ATTR_rec.program_update_date;
922: END IF;
923:
924: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
925: l_PRICING_ATTR_rec.request_id := p_old_PRICING_ATTR_rec.request_id;
926: END IF;
927:
928: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

Line 928: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

924: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
925: l_PRICING_ATTR_rec.request_id := p_old_PRICING_ATTR_rec.request_id;
926: END IF;
927:
928: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
929: l_PRICING_ATTR_rec.comparison_operator_code := p_old_PRICING_ATTR_rec.comparison_operator_code;
930: END IF;
931:
932: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN

Line 932: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN

928: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
929: l_PRICING_ATTR_rec.comparison_operator_code := p_old_PRICING_ATTR_rec.comparison_operator_code;
930: END IF;
931:
932: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
933: l_PRICING_ATTR_rec.pricing_attribute_datatype := p_old_PRICING_ATTR_rec.pricing_attribute_datatype;
934: END IF;
935:
936: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN

Line 936: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN

932: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
933: l_PRICING_ATTR_rec.pricing_attribute_datatype := p_old_PRICING_ATTR_rec.pricing_attribute_datatype;
934: END IF;
935:
936: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
937: l_PRICING_ATTR_rec.product_attribute_datatype := p_old_PRICING_ATTR_rec.product_attribute_datatype;
938: END IF;
939:
940: IF l_PRICING_ATTR_rec.qualification_ind = FND_API.G_MISS_NUM THEN

Line 940: IF l_PRICING_ATTR_rec.qualification_ind = FND_API.G_MISS_NUM THEN

936: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
937: l_PRICING_ATTR_rec.product_attribute_datatype := p_old_PRICING_ATTR_rec.product_attribute_datatype;
938: END IF;
939:
940: IF l_PRICING_ATTR_rec.qualification_ind = FND_API.G_MISS_NUM THEN
941: l_PRICING_ATTR_rec.qualification_ind := p_old_PRICING_ATTR_rec.qualification_ind;
942: END IF;
943:
944: RETURN l_PRICING_ATTR_rec;

Line 957: IF l_PRICING_ATTR_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN

953: IS
954: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type := p_PRICING_ATTR_rec;
955: BEGIN
956:
957: IF l_PRICING_ATTR_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
958: l_PRICING_ATTR_rec.from_rltd_modifier_id := NULL;
959: END IF;
960:
961: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN

Line 961: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN

957: IF l_PRICING_ATTR_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
958: l_PRICING_ATTR_rec.from_rltd_modifier_id := NULL;
959: END IF;
960:
961: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
962: l_PRICING_ATTR_rec.accumulate_flag := NULL;
963: END IF;
964:
965: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 965: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN

961: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
962: l_PRICING_ATTR_rec.accumulate_flag := NULL;
963: END IF;
964:
965: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
966: l_PRICING_ATTR_rec.attribute1 := NULL;
967: END IF;
968:
969: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 969: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN

965: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
966: l_PRICING_ATTR_rec.attribute1 := NULL;
967: END IF;
968:
969: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
970: l_PRICING_ATTR_rec.attribute10 := NULL;
971: END IF;
972:
973: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 973: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN

969: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
970: l_PRICING_ATTR_rec.attribute10 := NULL;
971: END IF;
972:
973: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
974: l_PRICING_ATTR_rec.attribute11 := NULL;
975: END IF;
976:
977: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 977: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN

973: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
974: l_PRICING_ATTR_rec.attribute11 := NULL;
975: END IF;
976:
977: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
978: l_PRICING_ATTR_rec.attribute12 := NULL;
979: END IF;
980:
981: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 981: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN

977: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
978: l_PRICING_ATTR_rec.attribute12 := NULL;
979: END IF;
980:
981: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
982: l_PRICING_ATTR_rec.attribute13 := NULL;
983: END IF;
984:
985: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 985: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN

981: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
982: l_PRICING_ATTR_rec.attribute13 := NULL;
983: END IF;
984:
985: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
986: l_PRICING_ATTR_rec.attribute14 := NULL;
987: END IF;
988:
989: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 989: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN

985: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
986: l_PRICING_ATTR_rec.attribute14 := NULL;
987: END IF;
988:
989: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
990: l_PRICING_ATTR_rec.attribute15 := NULL;
991: END IF;
992:
993: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 993: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN

989: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
990: l_PRICING_ATTR_rec.attribute15 := NULL;
991: END IF;
992:
993: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
994: l_PRICING_ATTR_rec.attribute2 := NULL;
995: END IF;
996:
997: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 997: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN

993: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
994: l_PRICING_ATTR_rec.attribute2 := NULL;
995: END IF;
996:
997: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
998: l_PRICING_ATTR_rec.attribute3 := NULL;
999: END IF;
1000:
1001: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 1001: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN

997: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
998: l_PRICING_ATTR_rec.attribute3 := NULL;
999: END IF;
1000:
1001: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1002: l_PRICING_ATTR_rec.attribute4 := NULL;
1003: END IF;
1004:
1005: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 1005: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1001: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1002: l_PRICING_ATTR_rec.attribute4 := NULL;
1003: END IF;
1004:
1005: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1006: l_PRICING_ATTR_rec.attribute5 := NULL;
1007: END IF;
1008:
1009: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 1009: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1005: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1006: l_PRICING_ATTR_rec.attribute5 := NULL;
1007: END IF;
1008:
1009: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1010: l_PRICING_ATTR_rec.attribute6 := NULL;
1011: END IF;
1012:
1013: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1013: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1009: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1010: l_PRICING_ATTR_rec.attribute6 := NULL;
1011: END IF;
1012:
1013: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1014: l_PRICING_ATTR_rec.attribute7 := NULL;
1015: END IF;
1016:
1017: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1017: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1013: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1014: l_PRICING_ATTR_rec.attribute7 := NULL;
1015: END IF;
1016:
1017: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1018: l_PRICING_ATTR_rec.attribute8 := NULL;
1019: END IF;
1020:
1021: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1021: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1017: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1018: l_PRICING_ATTR_rec.attribute8 := NULL;
1019: END IF;
1020:
1021: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1022: l_PRICING_ATTR_rec.attribute9 := NULL;
1023: END IF;
1024:
1025: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN

Line 1025: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN

1021: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1022: l_PRICING_ATTR_rec.attribute9 := NULL;
1023: END IF;
1024:
1025: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
1026: l_PRICING_ATTR_rec.attribute_grouping_no := NULL;
1027: END IF;
1028:
1029: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN

Line 1029: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN

1025: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
1026: l_PRICING_ATTR_rec.attribute_grouping_no := NULL;
1027: END IF;
1028:
1029: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
1030: l_PRICING_ATTR_rec.context := NULL;
1031: END IF;
1032:
1033: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN

Line 1033: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN

1029: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
1030: l_PRICING_ATTR_rec.context := NULL;
1031: END IF;
1032:
1033: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
1034: l_PRICING_ATTR_rec.created_by := NULL;
1035: END IF;
1036:
1037: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN

Line 1037: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN

1033: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
1034: l_PRICING_ATTR_rec.created_by := NULL;
1035: END IF;
1036:
1037: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
1038: l_PRICING_ATTR_rec.creation_date := NULL;
1039: END IF;
1040:
1041: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

Line 1041: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

1037: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
1038: l_PRICING_ATTR_rec.creation_date := NULL;
1039: END IF;
1040:
1041: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
1042: l_PRICING_ATTR_rec.excluder_flag := NULL;
1043: END IF;
1044:
1045: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN

Line 1045: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN

1041: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
1042: l_PRICING_ATTR_rec.excluder_flag := NULL;
1043: END IF;
1044:
1045: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1046: l_PRICING_ATTR_rec.last_updated_by := NULL;
1047: END IF;
1048:
1049: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN

Line 1049: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN

1045: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1046: l_PRICING_ATTR_rec.last_updated_by := NULL;
1047: END IF;
1048:
1049: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
1050: l_PRICING_ATTR_rec.last_update_date := NULL;
1051: END IF;
1052:
1053: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN

Line 1053: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN

1049: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
1050: l_PRICING_ATTR_rec.last_update_date := NULL;
1051: END IF;
1052:
1053: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN
1054: l_PRICING_ATTR_rec.last_update_login := NULL;
1055: END IF;
1056:
1057: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN

Line 1057: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN

1053: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN
1054: l_PRICING_ATTR_rec.last_update_login := NULL;
1055: END IF;
1056:
1057: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
1058: l_PRICING_ATTR_rec.list_line_id := NULL;
1059: END IF;
1060:
1061: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN

Line 1061: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN

1057: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
1058: l_PRICING_ATTR_rec.list_line_id := NULL;
1059: END IF;
1060:
1061: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
1062: l_PRICING_ATTR_rec.list_header_id := NULL;
1063: END IF;
1064:
1065: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN

Line 1065: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN

1061: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
1062: l_PRICING_ATTR_rec.list_header_id := NULL;
1063: END IF;
1064:
1065: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1066: l_PRICING_ATTR_rec.pricing_phase_id := NULL;
1067: END IF;
1068:
1069: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

Line 1069: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

1065: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1066: l_PRICING_ATTR_rec.pricing_phase_id := NULL;
1067: END IF;
1068:
1069: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
1070: l_PRICING_ATTR_rec.pricing_attribute := NULL;
1071: END IF;
1072:
1073: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

Line 1073: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

1069: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
1070: l_PRICING_ATTR_rec.pricing_attribute := NULL;
1071: END IF;
1072:
1073: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
1074: l_PRICING_ATTR_rec.pricing_attribute_context := NULL;
1075: END IF;
1076:
1077: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

Line 1077: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

1073: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
1074: l_PRICING_ATTR_rec.pricing_attribute_context := NULL;
1075: END IF;
1076:
1077: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
1078: l_PRICING_ATTR_rec.pricing_attribute_id := NULL;
1079: END IF;
1080:
1081: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN

Line 1081: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN

1077: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
1078: l_PRICING_ATTR_rec.pricing_attribute_id := NULL;
1079: END IF;
1080:
1081: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
1082: l_PRICING_ATTR_rec.pricing_attr_value_from := NULL;
1083: END IF;
1084:
1085: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN

Line 1085: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN

1081: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
1082: l_PRICING_ATTR_rec.pricing_attr_value_from := NULL;
1083: END IF;
1084:
1085: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
1086: l_PRICING_ATTR_rec.pricing_attr_value_to := NULL;
1087: END IF;
1088:
1089: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN

Line 1089: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN

1085: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
1086: l_PRICING_ATTR_rec.pricing_attr_value_to := NULL;
1087: END IF;
1088:
1089: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
1090: l_PRICING_ATTR_rec.product_attribute := NULL;
1091: END IF;
1092:
1093: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN

Line 1093: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN

1089: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
1090: l_PRICING_ATTR_rec.product_attribute := NULL;
1091: END IF;
1092:
1093: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
1094: l_PRICING_ATTR_rec.product_attribute_context := NULL;
1095: END IF;
1096:
1097: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN

Line 1097: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN

1093: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
1094: l_PRICING_ATTR_rec.product_attribute_context := NULL;
1095: END IF;
1096:
1097: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
1098: l_PRICING_ATTR_rec.product_attr_value := NULL;
1099: END IF;
1100:
1101: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN

Line 1101: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN

1097: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
1098: l_PRICING_ATTR_rec.product_attr_value := NULL;
1099: END IF;
1100:
1101: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
1102: l_PRICING_ATTR_rec.product_uom_code := NULL;
1103: END IF;
1104:
1105: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN

Line 1105: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN

1101: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
1102: l_PRICING_ATTR_rec.product_uom_code := NULL;
1103: END IF;
1104:
1105: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
1106: l_PRICING_ATTR_rec.program_application_id := NULL;
1107: END IF;
1108:
1109: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN

Line 1109: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN

1105: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
1106: l_PRICING_ATTR_rec.program_application_id := NULL;
1107: END IF;
1108:
1109: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
1110: l_PRICING_ATTR_rec.program_id := NULL;
1111: END IF;
1112:
1113: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN

Line 1113: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN

1109: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
1110: l_PRICING_ATTR_rec.program_id := NULL;
1111: END IF;
1112:
1113: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
1114: l_PRICING_ATTR_rec.program_update_date := NULL;
1115: END IF;
1116:
1117: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN

Line 1117: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN

1113: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
1114: l_PRICING_ATTR_rec.program_update_date := NULL;
1115: END IF;
1116:
1117: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
1118: l_PRICING_ATTR_rec.request_id := NULL;
1119: END IF;
1120:
1121: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

Line 1121: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

1117: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
1118: l_PRICING_ATTR_rec.request_id := NULL;
1119: END IF;
1120:
1121: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
1122: l_PRICING_ATTR_rec.comparison_operator_code := NULL;
1123: END IF;
1124:
1125: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN

Line 1125: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN

1121: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
1122: l_PRICING_ATTR_rec.comparison_operator_code := NULL;
1123: END IF;
1124:
1125: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
1126: l_PRICING_ATTR_rec.pricing_attribute_datatype := NULL;
1127: END IF;
1128:
1129: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN

Line 1129: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN

1125: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
1126: l_PRICING_ATTR_rec.pricing_attribute_datatype := NULL;
1127: END IF;
1128:
1129: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
1130: l_PRICING_ATTR_rec.product_attribute_datatype := NULL;
1131: END IF;
1132:
1133: IF l_PRICING_ATTR_rec.qualification_ind = FND_API.G_MISS_NUM THEN

Line 1133: IF l_PRICING_ATTR_rec.qualification_ind = FND_API.G_MISS_NUM THEN

1129: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
1130: l_PRICING_ATTR_rec.product_attribute_datatype := NULL;
1131: END IF;
1132:
1133: IF l_PRICING_ATTR_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1134: l_PRICING_ATTR_rec.qualification_ind := NULL;
1135: END IF;
1136:
1137: RETURN l_PRICING_ATTR_rec;

Line 1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1280: , 'Update_Row'
1281: );
1282: END IF;
1283:
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285:
1286: END Update_Row;
1287:
1288: -- Procedure Insert_Row

Line 1490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1486: , 'Insert_Row'
1487: );
1488: END IF;
1489:
1490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1491:
1492: END Insert_Row;
1493:
1494: -- Procedure Delete_Row

Line 1521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1517: , 'Delete_Row'
1518: );
1519: END IF;
1520:
1521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1522:
1523: END Delete_Row;
1524:
1525: -- Function Query_Row

Line 1545: FND_API.G_MISS_NUM

1541: --
1542:
1543: FUNCTION Query_Rows
1544: ( p_pricing_attribute_id IN NUMBER :=
1545: FND_API.G_MISS_NUM
1546: , p_list_line_id IN NUMBER :=
1547: FND_API.G_MISS_NUM
1548: ) RETURN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1549: IS

Line 1547: FND_API.G_MISS_NUM

1543: FUNCTION Query_Rows
1544: ( p_pricing_attribute_id IN NUMBER :=
1545: FND_API.G_MISS_NUM
1546: , p_list_line_id IN NUMBER :=
1547: FND_API.G_MISS_NUM
1548: ) RETURN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1549: IS
1550: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1551: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1611: p_pricing_attribute_id <> FND_API.G_MISS_NUM)

1607:
1608: IF
1609: (p_pricing_attribute_id IS NOT NULL
1610: AND
1611: p_pricing_attribute_id <> FND_API.G_MISS_NUM)
1612: AND
1613: (p_list_line_id IS NOT NULL
1614: AND
1615: p_list_line_id <> FND_API.G_MISS_NUM)

Line 1615: p_list_line_id <> FND_API.G_MISS_NUM)

1611: p_pricing_attribute_id <> FND_API.G_MISS_NUM)
1612: AND
1613: (p_list_line_id IS NOT NULL
1614: AND
1615: p_list_line_id <> FND_API.G_MISS_NUM)
1616: THEN
1617: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1618: THEN
1619: oe_msg_pub.Add_Exc_Msg

Line 1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1622: , 'Keys are mutually exclusive: pricing_attribute_id = '|| p_pricing_attribute_id || ', list_line_id = '|| p_list_line_id
1623: );
1624: END IF;
1625:
1626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1627:
1628: END IF;
1629:
1630:

Line 1693: p_pricing_attribute_id <> FND_API.G_MISS_NUM)

1689:
1690: IF
1691: (p_pricing_attribute_id IS NOT NULL
1692: AND
1693: p_pricing_attribute_id <> FND_API.G_MISS_NUM)
1694: AND
1695: (l_PRICING_ATTR_tbl.COUNT = 0)
1696: THEN
1697: RAISE NO_DATA_FOUND;

Line 1707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1703: RETURN l_PRICING_ATTR_tbl;
1704:
1705: EXCEPTION
1706:
1707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1708:
1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1710:
1711: WHEN OTHERS THEN

Line 1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1705: EXCEPTION
1706:
1707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1708:
1709: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1710:
1711: WHEN OTHERS THEN
1712:
1713: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

Line 1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1717: , 'Query_Rows'
1718: );
1719: END IF;
1720:
1721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1722:
1723: END Query_Rows;
1724:
1725: -- Procedure lock_Row

Line 1923: x_return_status := FND_API.G_RET_STS_SUCCESS;

1919: x_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
1920:
1921: -- Set return status
1922:
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1925:
1926: ELSE
1927:

Line 1924: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1920:
1921: -- Set return status
1922:
1923: x_return_status := FND_API.G_RET_STS_SUCCESS;
1924: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1925:
1926: ELSE
1927:
1928: -- Row has changed by another user.

Line 1930: x_return_status := FND_API.G_RET_STS_ERROR;

1926: ELSE
1927:
1928: -- Row has changed by another user.
1929:
1930: x_return_status := FND_API.G_RET_STS_ERROR;
1931: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
1932:
1933: --8594682 - Add debug messages for OE_LOCK error
1934: oe_debug_pub.ADD('-------------------Data compare in Price list line Attributes(database vs record)------------------');

Line 1931: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

1927:
1928: -- Row has changed by another user.
1929:
1930: x_return_status := FND_API.G_RET_STS_ERROR;
1931: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
1932:
1933: --8594682 - Add debug messages for OE_LOCK error
1934: oe_debug_pub.ADD('-------------------Data compare in Price list line Attributes(database vs record)------------------');
1935: oe_debug_pub.ADD('pricing_attribute_id :'||l_PRICING_ATTR_rec.pricing_attribute_id||':'||p_PRICING_ATTR_rec.pricing_attribute_id||':');

Line 1997: x_return_status := FND_API.G_RET_STS_ERROR;

1993: EXCEPTION
1994:
1995: WHEN NO_DATA_FOUND THEN
1996:
1997: x_return_status := FND_API.G_RET_STS_ERROR;
1998: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
1999:
2000: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2001: THEN

Line 1998: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

1994:
1995: WHEN NO_DATA_FOUND THEN
1996:
1997: x_return_status := FND_API.G_RET_STS_ERROR;
1998: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
1999:
2000: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2001: THEN
2002:

Line 2009: x_return_status := FND_API.G_RET_STS_ERROR;

2005:
2006: END IF;
2007: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2008:
2009: x_return_status := FND_API.G_RET_STS_ERROR;
2010: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2011:
2012: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2013: THEN

Line 2010: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2006: END IF;
2007: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2008:
2009: x_return_status := FND_API.G_RET_STS_ERROR;
2010: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2011:
2012: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
2013: THEN
2014:

Line 2021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2017:
2018: END IF;
2019: WHEN OTHERS THEN
2020:
2021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2022: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2023:
2024: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2025: THEN

Line 2022: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2018: END IF;
2019: WHEN OTHERS THEN
2020:
2021: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2022: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2023:
2024: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2025: THEN
2026: oe_msg_pub.Add_Exc_Msg

Line 2046: p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR AND

2042: l_PRICING_ATTR_val_rec QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
2043: BEGIN
2044:
2045: IF p_PRICING_ATTR_rec.accumulate_flag IS NOT NULL AND
2046: p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR AND
2047: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,
2048: p_old_PRICING_ATTR_rec.accumulate_flag)
2049: THEN
2050: l_PRICING_ATTR_val_rec.accumulate := QP_Id_To_Value.Accumulate

Line 2056: p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR AND

2052: );
2053: END IF;
2054:
2055: IF p_PRICING_ATTR_rec.excluder_flag IS NOT NULL AND
2056: p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR AND
2057: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
2058: p_old_PRICING_ATTR_rec.excluder_flag)
2059: THEN
2060: l_PRICING_ATTR_val_rec.excluder := QP_Id_To_Value.Excluder

Line 2066: p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM AND

2062: );
2063: END IF;
2064:
2065: IF p_PRICING_ATTR_rec.list_line_id IS NOT NULL AND
2066: p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM AND
2067: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,
2068: p_old_PRICING_ATTR_rec.list_line_id)
2069: THEN
2070: l_PRICING_ATTR_val_rec.list_line := QP_Id_To_Value.List_Line

Line 2076: p_PRICING_ATTR_rec.pricing_attribute_id <> FND_API.G_MISS_NUM AND

2072: );
2073: END IF;
2074:
2075: /* IF p_PRICING_ATTR_rec.pricing_attribute_id IS NOT NULL AND
2076: p_PRICING_ATTR_rec.pricing_attribute_id <> FND_API.G_MISS_NUM AND
2077: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
2078: p_old_PRICING_ATTR_rec.pricing_attribute_id)
2079: THEN
2080: l_PRICING_ATTR_val_rec.pricing_attribute := QP_Id_To_Value.Pricing_Attribute

Line 2086: p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR AND

2082: );
2083: END IF;
2084: */
2085: IF p_PRICING_ATTR_rec.product_uom_code IS NOT NULL AND
2086: p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR AND
2087: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
2088: p_old_PRICING_ATTR_rec.product_uom_code)
2089: THEN
2090: l_PRICING_ATTR_val_rec.product_uom := QP_Id_To_Value.Product_Uom

Line 2111: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;

2107: BEGIN
2108:
2109: -- initialize return_status.
2110:
2111: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2112:
2113: -- initialize l_PRICING_ATTR_rec.
2114:
2115: l_PRICING_ATTR_rec := p_PRICING_ATTR_rec;

Line 2117: IF p_PRICING_ATTR_val_rec.accumulate <> FND_API.G_MISS_CHAR

2113: -- initialize l_PRICING_ATTR_rec.
2114:
2115: l_PRICING_ATTR_rec := p_PRICING_ATTR_rec;
2116:
2117: IF p_PRICING_ATTR_val_rec.accumulate <> FND_API.G_MISS_CHAR
2118: THEN
2119:
2120: IF p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR THEN
2121:

Line 2120: IF p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR THEN

2116:
2117: IF p_PRICING_ATTR_val_rec.accumulate <> FND_API.G_MISS_CHAR
2118: THEN
2119:
2120: IF p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR THEN
2121:
2122: l_PRICING_ATTR_rec.accumulate_flag := p_PRICING_ATTR_rec.accumulate_flag;
2123:
2124: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2139: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN

2135: l_PRICING_ATTR_rec.accumulate_flag := QP_Value_To_Id.accumulate
2136: ( p_accumulate => p_PRICING_ATTR_val_rec.accumulate
2137: );
2138:
2139: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
2140: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2141: END IF;
2142:
2143: END IF;

Line 2140: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2136: ( p_accumulate => p_PRICING_ATTR_val_rec.accumulate
2137: );
2138:
2139: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
2140: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2141: END IF;
2142:
2143: END IF;
2144:

Line 2147: IF p_PRICING_ATTR_val_rec.excluder <> FND_API.G_MISS_CHAR

2143: END IF;
2144:
2145: END IF;
2146:
2147: IF p_PRICING_ATTR_val_rec.excluder <> FND_API.G_MISS_CHAR
2148: THEN
2149:
2150: IF p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
2151:

Line 2150: IF p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN

2146:
2147: IF p_PRICING_ATTR_val_rec.excluder <> FND_API.G_MISS_CHAR
2148: THEN
2149:
2150: IF p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
2151:
2152: l_PRICING_ATTR_rec.excluder_flag := p_PRICING_ATTR_rec.excluder_flag;
2153:
2154: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2169: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

2165: l_PRICING_ATTR_rec.excluder_flag := QP_Value_To_Id.excluder
2166: ( p_excluder => p_PRICING_ATTR_val_rec.excluder
2167: );
2168:
2169: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
2170: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2171: END IF;
2172:
2173: END IF;

Line 2170: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2166: ( p_excluder => p_PRICING_ATTR_val_rec.excluder
2167: );
2168:
2169: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
2170: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2171: END IF;
2172:
2173: END IF;
2174:

Line 2177: IF p_PRICING_ATTR_val_rec.list_line <> FND_API.G_MISS_CHAR

2173: END IF;
2174:
2175: END IF;
2176:
2177: IF p_PRICING_ATTR_val_rec.list_line <> FND_API.G_MISS_CHAR
2178: THEN
2179:
2180: IF p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2181:

Line 2180: IF p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM THEN

2176:
2177: IF p_PRICING_ATTR_val_rec.list_line <> FND_API.G_MISS_CHAR
2178: THEN
2179:
2180: IF p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2181:
2182: l_PRICING_ATTR_rec.list_line_id := p_PRICING_ATTR_rec.list_line_id;
2183:
2184: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2199: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN

2195: l_PRICING_ATTR_rec.list_line_id := QP_Value_To_Id.list_line
2196: ( p_list_line => p_PRICING_ATTR_val_rec.list_line
2197: );
2198:
2199: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
2200: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2201: END IF;
2202:
2203: END IF;

Line 2200: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2196: ( p_list_line => p_PRICING_ATTR_val_rec.list_line
2197: );
2198:
2199: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
2200: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2201: END IF;
2202:
2203: END IF;
2204:

Line 2212: IF p_PRICING_ATTR_val_rec.pricing_attribute_desc <> FND_API.G_MISS_CHAR

2208: Added code to perform value_to_id conversion for pricing_Attribute,
2209: pricing_Attr_value_from and pricing_attr_value_to columns.
2210: ****************************************************************************/
2211:
2212: IF p_PRICING_ATTR_val_rec.pricing_attribute_desc <> FND_API.G_MISS_CHAR
2213: THEN
2214:
2215: IF p_PRICING_ATTR_rec.pricing_attribute <> FND_API.G_MISS_CHAR THEN
2216:

Line 2215: IF p_PRICING_ATTR_rec.pricing_attribute <> FND_API.G_MISS_CHAR THEN

2211:
2212: IF p_PRICING_ATTR_val_rec.pricing_attribute_desc <> FND_API.G_MISS_CHAR
2213: THEN
2214:
2215: IF p_PRICING_ATTR_rec.pricing_attribute <> FND_API.G_MISS_CHAR THEN
2216:
2217: l_PRICING_ATTR_rec.pricing_attribute := p_PRICING_ATTR_rec.pricing_attribute;
2218:
2219: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2235: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

2231: ( p_pricing_attribute_desc => p_PRICING_ATTR_val_rec.pricing_attribute_desc,
2232: p_context => l_PRICING_ATTR_rec.pricing_attribute_context
2233: );
2234:
2235: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
2236: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2237: END IF;
2238:
2239: END IF;

Line 2236: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2232: p_context => l_PRICING_ATTR_rec.pricing_attribute_context
2233: );
2234:
2235: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
2236: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2237: END IF;
2238:
2239: END IF;
2240:

Line 2243: IF p_PRICING_ATTR_val_rec.pricing_attr_value_from_desc <> FND_API.G_MISS_CHAR

2239: END IF;
2240:
2241: END IF;
2242:
2243: IF p_PRICING_ATTR_val_rec.pricing_attr_value_from_desc <> FND_API.G_MISS_CHAR
2244: THEN
2245:
2246: IF p_PRICING_ATTR_rec.pricing_attr_value_from <> FND_API.G_MISS_CHAR THEN
2247:

Line 2246: IF p_PRICING_ATTR_rec.pricing_attr_value_from <> FND_API.G_MISS_CHAR THEN

2242:
2243: IF p_PRICING_ATTR_val_rec.pricing_attr_value_from_desc <> FND_API.G_MISS_CHAR
2244: THEN
2245:
2246: IF p_PRICING_ATTR_rec.pricing_attr_value_from <> FND_API.G_MISS_CHAR THEN
2247:
2248: l_PRICING_ATTR_rec.pricing_attr_value_from := p_PRICING_ATTR_rec.pricing_attr_value_from;
2249:
2250: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2267: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN

2263: p_context => l_PRICING_ATTR_rec.pricing_attribute_context,
2264: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2265: );
2266:
2267: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
2268: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2269: END IF;
2270:
2271: END IF;

Line 2268: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2264: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2265: );
2266:
2267: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
2268: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2269: END IF;
2270:
2271: END IF;
2272:

Line 2275: IF p_PRICING_ATTR_val_rec.pricing_attr_value_to_desc <> FND_API.G_MISS_CHAR

2271: END IF;
2272:
2273: END IF;
2274:
2275: IF p_PRICING_ATTR_val_rec.pricing_attr_value_to_desc <> FND_API.G_MISS_CHAR
2276: THEN
2277:
2278: IF p_PRICING_ATTR_rec.pricing_attr_value_to <> FND_API.G_MISS_CHAR THEN
2279:

Line 2278: IF p_PRICING_ATTR_rec.pricing_attr_value_to <> FND_API.G_MISS_CHAR THEN

2274:
2275: IF p_PRICING_ATTR_val_rec.pricing_attr_value_to_desc <> FND_API.G_MISS_CHAR
2276: THEN
2277:
2278: IF p_PRICING_ATTR_rec.pricing_attr_value_to <> FND_API.G_MISS_CHAR THEN
2279:
2280: l_PRICING_ATTR_rec.pricing_attr_value_to := p_PRICING_ATTR_rec.pricing_attr_value_to;
2281:
2282: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2299: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN

2295: p_context => l_PRICING_ATTR_rec.pricing_attribute_context,
2296: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2297: );
2298:
2299: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
2300: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2301: END IF;
2302:
2303: END IF;

Line 2300: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2296: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2297: );
2298:
2299: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
2300: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2301: END IF;
2302:
2303: END IF;
2304:

Line 2307: IF p_PRICING_ATTR_val_rec.product_uom <> FND_API.G_MISS_CHAR

2303: END IF;
2304:
2305: END IF;
2306:
2307: IF p_PRICING_ATTR_val_rec.product_uom <> FND_API.G_MISS_CHAR
2308: THEN
2309:
2310: IF p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR THEN
2311:

Line 2310: IF p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR THEN

2306:
2307: IF p_PRICING_ATTR_val_rec.product_uom <> FND_API.G_MISS_CHAR
2308: THEN
2309:
2310: IF p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR THEN
2311:
2312: l_PRICING_ATTR_rec.product_uom_code := p_PRICING_ATTR_rec.product_uom_code;
2313:
2314: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

Line 2329: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN

2325: l_PRICING_ATTR_rec.product_uom_code := QP_Value_To_Id.product_uom
2326: ( p_product_uom => p_PRICING_ATTR_val_rec.product_uom
2327: );
2328:
2329: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
2330: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2331: END IF;
2332:
2333: END IF;

Line 2330: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;

2326: ( p_product_uom => p_PRICING_ATTR_val_rec.product_uom
2327: );
2328:
2329: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
2330: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2331: END IF;
2332:
2333: END IF;
2334:

Line 2474: WHEN FND_API.G_EXC_ERROR THEN

2470: END IF; --- Java Engine Installed
2471:
2472:
2473: EXCEPTION
2474: WHEN FND_API.G_EXC_ERROR THEN
2475: RAISE;
2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2477: RAISE;
2478: WHEN OTHERS THEN

Line 2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2472:
2473: EXCEPTION
2474: WHEN FND_API.G_EXC_ERROR THEN
2475: RAISE;
2476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2477: RAISE;
2478: WHEN OTHERS THEN
2479: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2480: THEN

Line 2486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2482: ( G_PKG_NAME
2483: , 'Pre_Write_Process'
2484: );
2485: END IF;
2486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2487: END Pre_Write_Process;
2488:
2489: END QP_pll_pricing_attr_Util;