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 748: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN

744: IS
745: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type := p_PRICING_ATTR_rec;
746: BEGIN
747:
748: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
749: l_PRICING_ATTR_rec.accumulate_flag := p_old_PRICING_ATTR_rec.accumulate_flag;
750: END IF;
751:
752: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN

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

748: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
749: l_PRICING_ATTR_rec.accumulate_flag := p_old_PRICING_ATTR_rec.accumulate_flag;
750: END IF;
751:
752: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
753: l_PRICING_ATTR_rec.attribute1 := p_old_PRICING_ATTR_rec.attribute1;
754: END IF;
755:
756: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

752: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
753: l_PRICING_ATTR_rec.attribute1 := p_old_PRICING_ATTR_rec.attribute1;
754: END IF;
755:
756: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
757: l_PRICING_ATTR_rec.attribute10 := p_old_PRICING_ATTR_rec.attribute10;
758: END IF;
759:
760: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN

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

756: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
757: l_PRICING_ATTR_rec.attribute10 := p_old_PRICING_ATTR_rec.attribute10;
758: END IF;
759:
760: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
761: l_PRICING_ATTR_rec.attribute11 := p_old_PRICING_ATTR_rec.attribute11;
762: END IF;
763:
764: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN

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

760: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
761: l_PRICING_ATTR_rec.attribute11 := p_old_PRICING_ATTR_rec.attribute11;
762: END IF;
763:
764: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
765: l_PRICING_ATTR_rec.attribute12 := p_old_PRICING_ATTR_rec.attribute12;
766: END IF;
767:
768: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN

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

764: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
765: l_PRICING_ATTR_rec.attribute12 := p_old_PRICING_ATTR_rec.attribute12;
766: END IF;
767:
768: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
769: l_PRICING_ATTR_rec.attribute13 := p_old_PRICING_ATTR_rec.attribute13;
770: END IF;
771:
772: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN

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

768: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
769: l_PRICING_ATTR_rec.attribute13 := p_old_PRICING_ATTR_rec.attribute13;
770: END IF;
771:
772: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
773: l_PRICING_ATTR_rec.attribute14 := p_old_PRICING_ATTR_rec.attribute14;
774: END IF;
775:
776: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN

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

772: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
773: l_PRICING_ATTR_rec.attribute14 := p_old_PRICING_ATTR_rec.attribute14;
774: END IF;
775:
776: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
777: l_PRICING_ATTR_rec.attribute15 := p_old_PRICING_ATTR_rec.attribute15;
778: END IF;
779:
780: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN

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

776: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
777: l_PRICING_ATTR_rec.attribute15 := p_old_PRICING_ATTR_rec.attribute15;
778: END IF;
779:
780: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
781: l_PRICING_ATTR_rec.attribute2 := p_old_PRICING_ATTR_rec.attribute2;
782: END IF;
783:
784: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN

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

780: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
781: l_PRICING_ATTR_rec.attribute2 := p_old_PRICING_ATTR_rec.attribute2;
782: END IF;
783:
784: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
785: l_PRICING_ATTR_rec.attribute3 := p_old_PRICING_ATTR_rec.attribute3;
786: END IF;
787:
788: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN

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

784: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
785: l_PRICING_ATTR_rec.attribute3 := p_old_PRICING_ATTR_rec.attribute3;
786: END IF;
787:
788: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
789: l_PRICING_ATTR_rec.attribute4 := p_old_PRICING_ATTR_rec.attribute4;
790: END IF;
791:
792: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN

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

788: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
789: l_PRICING_ATTR_rec.attribute4 := p_old_PRICING_ATTR_rec.attribute4;
790: END IF;
791:
792: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
793: l_PRICING_ATTR_rec.attribute5 := p_old_PRICING_ATTR_rec.attribute5;
794: END IF;
795:
796: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN

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

792: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
793: l_PRICING_ATTR_rec.attribute5 := p_old_PRICING_ATTR_rec.attribute5;
794: END IF;
795:
796: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
797: l_PRICING_ATTR_rec.attribute6 := p_old_PRICING_ATTR_rec.attribute6;
798: END IF;
799:
800: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN

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

796: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
797: l_PRICING_ATTR_rec.attribute6 := p_old_PRICING_ATTR_rec.attribute6;
798: END IF;
799:
800: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
801: l_PRICING_ATTR_rec.attribute7 := p_old_PRICING_ATTR_rec.attribute7;
802: END IF;
803:
804: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN

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

800: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
801: l_PRICING_ATTR_rec.attribute7 := p_old_PRICING_ATTR_rec.attribute7;
802: END IF;
803:
804: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
805: l_PRICING_ATTR_rec.attribute8 := p_old_PRICING_ATTR_rec.attribute8;
806: END IF;
807:
808: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN

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

804: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
805: l_PRICING_ATTR_rec.attribute8 := p_old_PRICING_ATTR_rec.attribute8;
806: END IF;
807:
808: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
809: l_PRICING_ATTR_rec.attribute9 := p_old_PRICING_ATTR_rec.attribute9;
810: END IF;
811:
812: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN

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

808: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
809: l_PRICING_ATTR_rec.attribute9 := p_old_PRICING_ATTR_rec.attribute9;
810: END IF;
811:
812: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
813: l_PRICING_ATTR_rec.attribute_grouping_no := p_old_PRICING_ATTR_rec.attribute_grouping_no;
814: END IF;
815:
816: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN

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

812: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
813: l_PRICING_ATTR_rec.attribute_grouping_no := p_old_PRICING_ATTR_rec.attribute_grouping_no;
814: END IF;
815:
816: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
817: l_PRICING_ATTR_rec.context := p_old_PRICING_ATTR_rec.context;
818: END IF;
819:
820: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN

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

816: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
817: l_PRICING_ATTR_rec.context := p_old_PRICING_ATTR_rec.context;
818: END IF;
819:
820: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
821: l_PRICING_ATTR_rec.created_by := p_old_PRICING_ATTR_rec.created_by;
822: END IF;
823:
824: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN

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

820: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
821: l_PRICING_ATTR_rec.created_by := p_old_PRICING_ATTR_rec.created_by;
822: END IF;
823:
824: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
825: l_PRICING_ATTR_rec.creation_date := p_old_PRICING_ATTR_rec.creation_date;
826: END IF;
827:
828: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

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

824: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
825: l_PRICING_ATTR_rec.creation_date := p_old_PRICING_ATTR_rec.creation_date;
826: END IF;
827:
828: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
829: l_PRICING_ATTR_rec.excluder_flag := p_old_PRICING_ATTR_rec.excluder_flag;
830: END IF;
831:
832: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN

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

828: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
829: l_PRICING_ATTR_rec.excluder_flag := p_old_PRICING_ATTR_rec.excluder_flag;
830: END IF;
831:
832: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
833: l_PRICING_ATTR_rec.last_updated_by := p_old_PRICING_ATTR_rec.last_updated_by;
834: END IF;
835:
836: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN

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

832: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
833: l_PRICING_ATTR_rec.last_updated_by := p_old_PRICING_ATTR_rec.last_updated_by;
834: END IF;
835:
836: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
837: l_PRICING_ATTR_rec.last_update_date := p_old_PRICING_ATTR_rec.last_update_date;
838: END IF;
839:
840: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN

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

836: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
837: l_PRICING_ATTR_rec.last_update_date := p_old_PRICING_ATTR_rec.last_update_date;
838: END IF;
839:
840: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN
841: l_PRICING_ATTR_rec.last_update_login := p_old_PRICING_ATTR_rec.last_update_login;
842: END IF;
843:
844: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN

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

840: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN
841: l_PRICING_ATTR_rec.last_update_login := p_old_PRICING_ATTR_rec.last_update_login;
842: END IF;
843:
844: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
845: l_PRICING_ATTR_rec.list_line_id := p_old_PRICING_ATTR_rec.list_line_id;
846: END IF;
847:
848: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN

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

844: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
845: l_PRICING_ATTR_rec.list_line_id := p_old_PRICING_ATTR_rec.list_line_id;
846: END IF;
847:
848: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
849: l_PRICING_ATTR_rec.list_header_id := p_old_PRICING_ATTR_rec.list_header_id;
850: END IF;
851:
852: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN

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

848: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
849: l_PRICING_ATTR_rec.list_header_id := p_old_PRICING_ATTR_rec.list_header_id;
850: END IF;
851:
852: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
853: l_PRICING_ATTR_rec.pricing_phase_id := p_old_PRICING_ATTR_rec.pricing_phase_id;
854: END IF;
855:
856: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

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

852: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
853: l_PRICING_ATTR_rec.pricing_phase_id := p_old_PRICING_ATTR_rec.pricing_phase_id;
854: END IF;
855:
856: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
857: l_PRICING_ATTR_rec.pricing_attribute := p_old_PRICING_ATTR_rec.pricing_attribute;
858: END IF;
859:
860: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

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

856: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
857: l_PRICING_ATTR_rec.pricing_attribute := p_old_PRICING_ATTR_rec.pricing_attribute;
858: END IF;
859:
860: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
861: l_PRICING_ATTR_rec.pricing_attribute_context := p_old_PRICING_ATTR_rec.pricing_attribute_context;
862: END IF;
863:
864: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

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

860: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
861: l_PRICING_ATTR_rec.pricing_attribute_context := p_old_PRICING_ATTR_rec.pricing_attribute_context;
862: END IF;
863:
864: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
865: l_PRICING_ATTR_rec.pricing_attribute_id := p_old_PRICING_ATTR_rec.pricing_attribute_id;
866: END IF;
867:
868: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN

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

864: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
865: l_PRICING_ATTR_rec.pricing_attribute_id := p_old_PRICING_ATTR_rec.pricing_attribute_id;
866: END IF;
867:
868: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
869: l_PRICING_ATTR_rec.pricing_attr_value_from := p_old_PRICING_ATTR_rec.pricing_attr_value_from;
870: END IF;
871:
872: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN

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

868: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
869: l_PRICING_ATTR_rec.pricing_attr_value_from := p_old_PRICING_ATTR_rec.pricing_attr_value_from;
870: END IF;
871:
872: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
873: l_PRICING_ATTR_rec.pricing_attr_value_to := p_old_PRICING_ATTR_rec.pricing_attr_value_to;
874: END IF;
875:
876: IF l_PRICING_ATTR_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN

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

872: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
873: l_PRICING_ATTR_rec.pricing_attr_value_to := p_old_PRICING_ATTR_rec.pricing_attr_value_to;
874: END IF;
875:
876: IF l_PRICING_ATTR_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
877: l_PRICING_ATTR_rec.from_rltd_modifier_id := p_old_PRICING_ATTR_rec.from_rltd_modifier_id;
878: END IF;
879:
880: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN

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

876: IF l_PRICING_ATTR_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
877: l_PRICING_ATTR_rec.from_rltd_modifier_id := p_old_PRICING_ATTR_rec.from_rltd_modifier_id;
878: END IF;
879:
880: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
881: l_PRICING_ATTR_rec.product_attribute := p_old_PRICING_ATTR_rec.product_attribute;
882: END IF;
883:
884: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN

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

880: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
881: l_PRICING_ATTR_rec.product_attribute := p_old_PRICING_ATTR_rec.product_attribute;
882: END IF;
883:
884: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
885: l_PRICING_ATTR_rec.product_attribute_context := p_old_PRICING_ATTR_rec.product_attribute_context;
886: END IF;
887:
888: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN

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

884: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
885: l_PRICING_ATTR_rec.product_attribute_context := p_old_PRICING_ATTR_rec.product_attribute_context;
886: END IF;
887:
888: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
889: l_PRICING_ATTR_rec.product_attr_value := p_old_PRICING_ATTR_rec.product_attr_value;
890: END IF;
891:
892: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN

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

888: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
889: l_PRICING_ATTR_rec.product_attr_value := p_old_PRICING_ATTR_rec.product_attr_value;
890: END IF;
891:
892: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
893: l_PRICING_ATTR_rec.product_uom_code := p_old_PRICING_ATTR_rec.product_uom_code;
894: END IF;
895:
896: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN

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

892: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
893: l_PRICING_ATTR_rec.product_uom_code := p_old_PRICING_ATTR_rec.product_uom_code;
894: END IF;
895:
896: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
897: l_PRICING_ATTR_rec.program_application_id := p_old_PRICING_ATTR_rec.program_application_id;
898: END IF;
899:
900: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN

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

896: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
897: l_PRICING_ATTR_rec.program_application_id := p_old_PRICING_ATTR_rec.program_application_id;
898: END IF;
899:
900: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
901: l_PRICING_ATTR_rec.program_id := p_old_PRICING_ATTR_rec.program_id;
902: END IF;
903:
904: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN

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

900: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
901: l_PRICING_ATTR_rec.program_id := p_old_PRICING_ATTR_rec.program_id;
902: END IF;
903:
904: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
905: l_PRICING_ATTR_rec.program_update_date := p_old_PRICING_ATTR_rec.program_update_date;
906: END IF;
907:
908: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN

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

904: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
905: l_PRICING_ATTR_rec.program_update_date := p_old_PRICING_ATTR_rec.program_update_date;
906: END IF;
907:
908: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
909: l_PRICING_ATTR_rec.request_id := p_old_PRICING_ATTR_rec.request_id;
910: END IF;
911:
912: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

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

908: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
909: l_PRICING_ATTR_rec.request_id := p_old_PRICING_ATTR_rec.request_id;
910: END IF;
911:
912: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
913: l_PRICING_ATTR_rec.comparison_operator_code := p_old_PRICING_ATTR_rec.comparison_operator_code;
914: END IF;
915:
916: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN

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

912: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
913: l_PRICING_ATTR_rec.comparison_operator_code := p_old_PRICING_ATTR_rec.comparison_operator_code;
914: END IF;
915:
916: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
917: l_PRICING_ATTR_rec.pricing_attribute_datatype := p_old_PRICING_ATTR_rec.pricing_attribute_datatype;
918: END IF;
919:
920: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN

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

916: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
917: l_PRICING_ATTR_rec.pricing_attribute_datatype := p_old_PRICING_ATTR_rec.pricing_attribute_datatype;
918: END IF;
919:
920: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
921: l_PRICING_ATTR_rec.product_attribute_datatype := p_old_PRICING_ATTR_rec.product_attribute_datatype;
922: END IF;
923:
924: IF l_PRICING_ATTR_rec.qualification_ind = FND_API.G_MISS_NUM THEN

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

920: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
921: l_PRICING_ATTR_rec.product_attribute_datatype := p_old_PRICING_ATTR_rec.product_attribute_datatype;
922: END IF;
923:
924: IF l_PRICING_ATTR_rec.qualification_ind = FND_API.G_MISS_NUM THEN
925: l_PRICING_ATTR_rec.qualification_ind := p_old_PRICING_ATTR_rec.qualification_ind;
926: END IF;
927:
928: RETURN l_PRICING_ATTR_rec;

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

937: IS
938: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type := p_PRICING_ATTR_rec;
939: BEGIN
940:
941: IF l_PRICING_ATTR_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
942: l_PRICING_ATTR_rec.from_rltd_modifier_id := NULL;
943: END IF;
944:
945: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN

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

941: IF l_PRICING_ATTR_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
942: l_PRICING_ATTR_rec.from_rltd_modifier_id := NULL;
943: END IF;
944:
945: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
946: l_PRICING_ATTR_rec.accumulate_flag := NULL;
947: END IF;
948:
949: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN

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

945: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
946: l_PRICING_ATTR_rec.accumulate_flag := NULL;
947: END IF;
948:
949: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
950: l_PRICING_ATTR_rec.attribute1 := NULL;
951: END IF;
952:
953: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

949: IF l_PRICING_ATTR_rec.attribute1 = FND_API.G_MISS_CHAR THEN
950: l_PRICING_ATTR_rec.attribute1 := NULL;
951: END IF;
952:
953: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
954: l_PRICING_ATTR_rec.attribute10 := NULL;
955: END IF;
956:
957: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN

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

953: IF l_PRICING_ATTR_rec.attribute10 = FND_API.G_MISS_CHAR THEN
954: l_PRICING_ATTR_rec.attribute10 := NULL;
955: END IF;
956:
957: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
958: l_PRICING_ATTR_rec.attribute11 := NULL;
959: END IF;
960:
961: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN

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

957: IF l_PRICING_ATTR_rec.attribute11 = FND_API.G_MISS_CHAR THEN
958: l_PRICING_ATTR_rec.attribute11 := NULL;
959: END IF;
960:
961: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
962: l_PRICING_ATTR_rec.attribute12 := NULL;
963: END IF;
964:
965: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN

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

961: IF l_PRICING_ATTR_rec.attribute12 = FND_API.G_MISS_CHAR THEN
962: l_PRICING_ATTR_rec.attribute12 := NULL;
963: END IF;
964:
965: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
966: l_PRICING_ATTR_rec.attribute13 := NULL;
967: END IF;
968:
969: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN

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

965: IF l_PRICING_ATTR_rec.attribute13 = FND_API.G_MISS_CHAR THEN
966: l_PRICING_ATTR_rec.attribute13 := NULL;
967: END IF;
968:
969: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
970: l_PRICING_ATTR_rec.attribute14 := NULL;
971: END IF;
972:
973: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN

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

969: IF l_PRICING_ATTR_rec.attribute14 = FND_API.G_MISS_CHAR THEN
970: l_PRICING_ATTR_rec.attribute14 := NULL;
971: END IF;
972:
973: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
974: l_PRICING_ATTR_rec.attribute15 := NULL;
975: END IF;
976:
977: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN

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

973: IF l_PRICING_ATTR_rec.attribute15 = FND_API.G_MISS_CHAR THEN
974: l_PRICING_ATTR_rec.attribute15 := NULL;
975: END IF;
976:
977: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
978: l_PRICING_ATTR_rec.attribute2 := NULL;
979: END IF;
980:
981: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN

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

977: IF l_PRICING_ATTR_rec.attribute2 = FND_API.G_MISS_CHAR THEN
978: l_PRICING_ATTR_rec.attribute2 := NULL;
979: END IF;
980:
981: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
982: l_PRICING_ATTR_rec.attribute3 := NULL;
983: END IF;
984:
985: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN

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

981: IF l_PRICING_ATTR_rec.attribute3 = FND_API.G_MISS_CHAR THEN
982: l_PRICING_ATTR_rec.attribute3 := NULL;
983: END IF;
984:
985: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
986: l_PRICING_ATTR_rec.attribute4 := NULL;
987: END IF;
988:
989: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN

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

985: IF l_PRICING_ATTR_rec.attribute4 = FND_API.G_MISS_CHAR THEN
986: l_PRICING_ATTR_rec.attribute4 := NULL;
987: END IF;
988:
989: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
990: l_PRICING_ATTR_rec.attribute5 := NULL;
991: END IF;
992:
993: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN

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

989: IF l_PRICING_ATTR_rec.attribute5 = FND_API.G_MISS_CHAR THEN
990: l_PRICING_ATTR_rec.attribute5 := NULL;
991: END IF;
992:
993: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
994: l_PRICING_ATTR_rec.attribute6 := NULL;
995: END IF;
996:
997: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN

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

993: IF l_PRICING_ATTR_rec.attribute6 = FND_API.G_MISS_CHAR THEN
994: l_PRICING_ATTR_rec.attribute6 := NULL;
995: END IF;
996:
997: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
998: l_PRICING_ATTR_rec.attribute7 := NULL;
999: END IF;
1000:
1001: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN

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

997: IF l_PRICING_ATTR_rec.attribute7 = FND_API.G_MISS_CHAR THEN
998: l_PRICING_ATTR_rec.attribute7 := NULL;
999: END IF;
1000:
1001: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1002: l_PRICING_ATTR_rec.attribute8 := NULL;
1003: END IF;
1004:
1005: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN

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

1001: IF l_PRICING_ATTR_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1002: l_PRICING_ATTR_rec.attribute8 := NULL;
1003: END IF;
1004:
1005: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1006: l_PRICING_ATTR_rec.attribute9 := NULL;
1007: END IF;
1008:
1009: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN

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

1005: IF l_PRICING_ATTR_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1006: l_PRICING_ATTR_rec.attribute9 := NULL;
1007: END IF;
1008:
1009: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
1010: l_PRICING_ATTR_rec.attribute_grouping_no := NULL;
1011: END IF;
1012:
1013: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN

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

1009: IF l_PRICING_ATTR_rec.attribute_grouping_no = FND_API.G_MISS_NUM THEN
1010: l_PRICING_ATTR_rec.attribute_grouping_no := NULL;
1011: END IF;
1012:
1013: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
1014: l_PRICING_ATTR_rec.context := NULL;
1015: END IF;
1016:
1017: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN

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

1013: IF l_PRICING_ATTR_rec.context = FND_API.G_MISS_CHAR THEN
1014: l_PRICING_ATTR_rec.context := NULL;
1015: END IF;
1016:
1017: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
1018: l_PRICING_ATTR_rec.created_by := NULL;
1019: END IF;
1020:
1021: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN

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

1017: IF l_PRICING_ATTR_rec.created_by = FND_API.G_MISS_NUM THEN
1018: l_PRICING_ATTR_rec.created_by := NULL;
1019: END IF;
1020:
1021: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
1022: l_PRICING_ATTR_rec.creation_date := NULL;
1023: END IF;
1024:
1025: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN

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

1021: IF l_PRICING_ATTR_rec.creation_date = FND_API.G_MISS_DATE THEN
1022: l_PRICING_ATTR_rec.creation_date := NULL;
1023: END IF;
1024:
1025: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
1026: l_PRICING_ATTR_rec.excluder_flag := NULL;
1027: END IF;
1028:
1029: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN

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

1025: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
1026: l_PRICING_ATTR_rec.excluder_flag := NULL;
1027: END IF;
1028:
1029: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1030: l_PRICING_ATTR_rec.last_updated_by := NULL;
1031: END IF;
1032:
1033: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN

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

1029: IF l_PRICING_ATTR_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1030: l_PRICING_ATTR_rec.last_updated_by := NULL;
1031: END IF;
1032:
1033: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
1034: l_PRICING_ATTR_rec.last_update_date := NULL;
1035: END IF;
1036:
1037: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN

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

1033: IF l_PRICING_ATTR_rec.last_update_date = FND_API.G_MISS_DATE THEN
1034: l_PRICING_ATTR_rec.last_update_date := NULL;
1035: END IF;
1036:
1037: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN
1038: l_PRICING_ATTR_rec.last_update_login := NULL;
1039: END IF;
1040:
1041: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN

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

1037: IF l_PRICING_ATTR_rec.last_update_login = FND_API.G_MISS_NUM THEN
1038: l_PRICING_ATTR_rec.last_update_login := NULL;
1039: END IF;
1040:
1041: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
1042: l_PRICING_ATTR_rec.list_line_id := NULL;
1043: END IF;
1044:
1045: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN

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

1041: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
1042: l_PRICING_ATTR_rec.list_line_id := NULL;
1043: END IF;
1044:
1045: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
1046: l_PRICING_ATTR_rec.list_header_id := NULL;
1047: END IF;
1048:
1049: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN

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

1045: IF l_PRICING_ATTR_rec.list_header_id = FND_API.G_MISS_NUM THEN
1046: l_PRICING_ATTR_rec.list_header_id := NULL;
1047: END IF;
1048:
1049: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1050: l_PRICING_ATTR_rec.pricing_phase_id := NULL;
1051: END IF;
1052:
1053: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN

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

1049: IF l_PRICING_ATTR_rec.pricing_phase_id = FND_API.G_MISS_NUM THEN
1050: l_PRICING_ATTR_rec.pricing_phase_id := NULL;
1051: END IF;
1052:
1053: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
1054: l_PRICING_ATTR_rec.pricing_attribute := NULL;
1055: END IF;
1056:
1057: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN

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

1053: IF l_PRICING_ATTR_rec.pricing_attribute = FND_API.G_MISS_CHAR THEN
1054: l_PRICING_ATTR_rec.pricing_attribute := NULL;
1055: END IF;
1056:
1057: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
1058: l_PRICING_ATTR_rec.pricing_attribute_context := NULL;
1059: END IF;
1060:
1061: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN

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

1057: IF l_PRICING_ATTR_rec.pricing_attribute_context = FND_API.G_MISS_CHAR THEN
1058: l_PRICING_ATTR_rec.pricing_attribute_context := NULL;
1059: END IF;
1060:
1061: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
1062: l_PRICING_ATTR_rec.pricing_attribute_id := NULL;
1063: END IF;
1064:
1065: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN

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

1061: IF l_PRICING_ATTR_rec.pricing_attribute_id = FND_API.G_MISS_NUM THEN
1062: l_PRICING_ATTR_rec.pricing_attribute_id := NULL;
1063: END IF;
1064:
1065: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
1066: l_PRICING_ATTR_rec.pricing_attr_value_from := NULL;
1067: END IF;
1068:
1069: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN

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

1065: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
1066: l_PRICING_ATTR_rec.pricing_attr_value_from := NULL;
1067: END IF;
1068:
1069: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
1070: l_PRICING_ATTR_rec.pricing_attr_value_to := NULL;
1071: END IF;
1072:
1073: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN

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

1069: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
1070: l_PRICING_ATTR_rec.pricing_attr_value_to := NULL;
1071: END IF;
1072:
1073: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
1074: l_PRICING_ATTR_rec.product_attribute := NULL;
1075: END IF;
1076:
1077: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN

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

1073: IF l_PRICING_ATTR_rec.product_attribute = FND_API.G_MISS_CHAR THEN
1074: l_PRICING_ATTR_rec.product_attribute := NULL;
1075: END IF;
1076:
1077: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
1078: l_PRICING_ATTR_rec.product_attribute_context := NULL;
1079: END IF;
1080:
1081: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN

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

1077: IF l_PRICING_ATTR_rec.product_attribute_context = FND_API.G_MISS_CHAR THEN
1078: l_PRICING_ATTR_rec.product_attribute_context := NULL;
1079: END IF;
1080:
1081: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
1082: l_PRICING_ATTR_rec.product_attr_value := NULL;
1083: END IF;
1084:
1085: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN

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

1081: IF l_PRICING_ATTR_rec.product_attr_value = FND_API.G_MISS_CHAR THEN
1082: l_PRICING_ATTR_rec.product_attr_value := NULL;
1083: END IF;
1084:
1085: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
1086: l_PRICING_ATTR_rec.product_uom_code := NULL;
1087: END IF;
1088:
1089: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN

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

1085: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
1086: l_PRICING_ATTR_rec.product_uom_code := NULL;
1087: END IF;
1088:
1089: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
1090: l_PRICING_ATTR_rec.program_application_id := NULL;
1091: END IF;
1092:
1093: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN

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

1089: IF l_PRICING_ATTR_rec.program_application_id = FND_API.G_MISS_NUM THEN
1090: l_PRICING_ATTR_rec.program_application_id := NULL;
1091: END IF;
1092:
1093: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
1094: l_PRICING_ATTR_rec.program_id := NULL;
1095: END IF;
1096:
1097: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN

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

1093: IF l_PRICING_ATTR_rec.program_id = FND_API.G_MISS_NUM THEN
1094: l_PRICING_ATTR_rec.program_id := NULL;
1095: END IF;
1096:
1097: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
1098: l_PRICING_ATTR_rec.program_update_date := NULL;
1099: END IF;
1100:
1101: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN

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

1097: IF l_PRICING_ATTR_rec.program_update_date = FND_API.G_MISS_DATE THEN
1098: l_PRICING_ATTR_rec.program_update_date := NULL;
1099: END IF;
1100:
1101: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
1102: l_PRICING_ATTR_rec.request_id := NULL;
1103: END IF;
1104:
1105: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN

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

1101: IF l_PRICING_ATTR_rec.request_id = FND_API.G_MISS_NUM THEN
1102: l_PRICING_ATTR_rec.request_id := NULL;
1103: END IF;
1104:
1105: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
1106: l_PRICING_ATTR_rec.comparison_operator_code := NULL;
1107: END IF;
1108:
1109: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN

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

1105: IF l_PRICING_ATTR_rec.comparison_operator_code = FND_API.G_MISS_CHAR THEN
1106: l_PRICING_ATTR_rec.comparison_operator_code := NULL;
1107: END IF;
1108:
1109: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
1110: l_PRICING_ATTR_rec.pricing_attribute_datatype := NULL;
1111: END IF;
1112:
1113: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN

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

1109: IF l_PRICING_ATTR_rec.pricing_attribute_datatype = FND_API.G_MISS_CHAR THEN
1110: l_PRICING_ATTR_rec.pricing_attribute_datatype := NULL;
1111: END IF;
1112:
1113: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
1114: l_PRICING_ATTR_rec.product_attribute_datatype := NULL;
1115: END IF;
1116:
1117: IF l_PRICING_ATTR_rec.qualification_ind = FND_API.G_MISS_NUM THEN

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

1113: IF l_PRICING_ATTR_rec.product_attribute_datatype = FND_API.G_MISS_CHAR THEN
1114: l_PRICING_ATTR_rec.product_attribute_datatype := NULL;
1115: END IF;
1116:
1117: IF l_PRICING_ATTR_rec.qualification_ind = FND_API.G_MISS_NUM THEN
1118: l_PRICING_ATTR_rec.qualification_ind := NULL;
1119: END IF;
1120:
1121: RETURN l_PRICING_ATTR_rec;

Line 1268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1264: , 'Update_Row'
1265: );
1266: END IF;
1267:
1268: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1269:
1270: END Update_Row;
1271:
1272: -- Procedure Insert_Row

Line 1474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1470: , 'Insert_Row'
1471: );
1472: END IF;
1473:
1474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1475:
1476: END Insert_Row;
1477:
1478: -- Procedure Delete_Row

Line 1505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1501: , 'Delete_Row'
1502: );
1503: END IF;
1504:
1505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1506:
1507: END Delete_Row;
1508:
1509: -- Function Query_Row

Line 1529: FND_API.G_MISS_NUM

1525: --
1526:
1527: FUNCTION Query_Rows
1528: ( p_pricing_attribute_id IN NUMBER :=
1529: FND_API.G_MISS_NUM
1530: , p_list_line_id IN NUMBER :=
1531: FND_API.G_MISS_NUM
1532: ) RETURN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1533: IS

Line 1531: FND_API.G_MISS_NUM

1527: FUNCTION Query_Rows
1528: ( p_pricing_attribute_id IN NUMBER :=
1529: FND_API.G_MISS_NUM
1530: , p_list_line_id IN NUMBER :=
1531: FND_API.G_MISS_NUM
1532: ) RETURN QP_Price_List_PUB.Pricing_Attr_Tbl_Type
1533: IS
1534: l_PRICING_ATTR_rec QP_Price_List_PUB.Pricing_Attr_Rec_Type;
1535: l_PRICING_ATTR_tbl QP_Price_List_PUB.Pricing_Attr_Tbl_Type;

Line 1595: p_pricing_attribute_id <> FND_API.G_MISS_NUM)

1591:
1592: IF
1593: (p_pricing_attribute_id IS NOT NULL
1594: AND
1595: p_pricing_attribute_id <> FND_API.G_MISS_NUM)
1596: AND
1597: (p_list_line_id IS NOT NULL
1598: AND
1599: p_list_line_id <> FND_API.G_MISS_NUM)

Line 1599: p_list_line_id <> FND_API.G_MISS_NUM)

1595: p_pricing_attribute_id <> FND_API.G_MISS_NUM)
1596: AND
1597: (p_list_line_id IS NOT NULL
1598: AND
1599: p_list_line_id <> FND_API.G_MISS_NUM)
1600: THEN
1601: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1602: THEN
1603: oe_msg_pub.Add_Exc_Msg

Line 1610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1606: , 'Keys are mutually exclusive: pricing_attribute_id = '|| p_pricing_attribute_id || ', list_line_id = '|| p_list_line_id
1607: );
1608: END IF;
1609:
1610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1611:
1612: END IF;
1613:
1614:

Line 1677: p_pricing_attribute_id <> FND_API.G_MISS_NUM)

1673:
1674: IF
1675: (p_pricing_attribute_id IS NOT NULL
1676: AND
1677: p_pricing_attribute_id <> FND_API.G_MISS_NUM)
1678: AND
1679: (l_PRICING_ATTR_tbl.COUNT = 0)
1680: THEN
1681: RAISE NO_DATA_FOUND;

Line 1691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1687: RETURN l_PRICING_ATTR_tbl;
1688:
1689: EXCEPTION
1690:
1691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1692:
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694:
1695: WHEN OTHERS THEN

Line 1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1689: EXCEPTION
1690:
1691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1692:
1693: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1694:
1695: WHEN OTHERS THEN
1696:
1697: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)

Line 1705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1701: , 'Query_Rows'
1702: );
1703: END IF;
1704:
1705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1706:
1707: END Query_Rows;
1708:
1709: -- Procedure lock_Row

Line 1907: x_return_status := FND_API.G_RET_STS_SUCCESS;

1903: x_PRICING_ATTR_rec := l_PRICING_ATTR_rec;
1904:
1905: -- Set return status
1906:
1907: x_return_status := FND_API.G_RET_STS_SUCCESS;
1908: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1909:
1910: ELSE
1911:

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

1904:
1905: -- Set return status
1906:
1907: x_return_status := FND_API.G_RET_STS_SUCCESS;
1908: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1909:
1910: ELSE
1911:
1912: -- Row has changed by another user.

Line 1914: x_return_status := FND_API.G_RET_STS_ERROR;

1910: ELSE
1911:
1912: -- Row has changed by another user.
1913:
1914: x_return_status := FND_API.G_RET_STS_ERROR;
1915: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
1916:
1917: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1918: THEN

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

1911:
1912: -- Row has changed by another user.
1913:
1914: x_return_status := FND_API.G_RET_STS_ERROR;
1915: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
1916:
1917: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1918: THEN
1919:

Line 1931: x_return_status := FND_API.G_RET_STS_ERROR;

1927: EXCEPTION
1928:
1929: WHEN NO_DATA_FOUND THEN
1930:
1931: x_return_status := FND_API.G_RET_STS_ERROR;
1932: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
1933:
1934: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1935: THEN

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

1928:
1929: WHEN NO_DATA_FOUND THEN
1930:
1931: x_return_status := FND_API.G_RET_STS_ERROR;
1932: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
1933:
1934: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1935: THEN
1936:

Line 1943: x_return_status := FND_API.G_RET_STS_ERROR;

1939:
1940: END IF;
1941: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1942:
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
1945:
1946: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1947: THEN

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

1940: END IF;
1941: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1942:
1943: x_return_status := FND_API.G_RET_STS_ERROR;
1944: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
1945:
1946: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_ERROR)
1947: THEN
1948:

Line 1955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1951:
1952: END IF;
1953: WHEN OTHERS THEN
1954:
1955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1956: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1957:
1958: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1959: THEN

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

1952: END IF;
1953: WHEN OTHERS THEN
1954:
1955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1956: x_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1957:
1958: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1959: THEN
1960: oe_msg_pub.Add_Exc_Msg

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

1976: l_PRICING_ATTR_val_rec QP_Price_List_PUB.Pricing_Attr_Val_Rec_Type;
1977: BEGIN
1978:
1979: IF p_PRICING_ATTR_rec.accumulate_flag IS NOT NULL AND
1980: p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR AND
1981: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.accumulate_flag,
1982: p_old_PRICING_ATTR_rec.accumulate_flag)
1983: THEN
1984: l_PRICING_ATTR_val_rec.accumulate := QP_Id_To_Value.Accumulate

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

1986: );
1987: END IF;
1988:
1989: IF p_PRICING_ATTR_rec.excluder_flag IS NOT NULL AND
1990: p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR AND
1991: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.excluder_flag,
1992: p_old_PRICING_ATTR_rec.excluder_flag)
1993: THEN
1994: l_PRICING_ATTR_val_rec.excluder := QP_Id_To_Value.Excluder

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

1996: );
1997: END IF;
1998:
1999: IF p_PRICING_ATTR_rec.list_line_id IS NOT NULL AND
2000: p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM AND
2001: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.list_line_id,
2002: p_old_PRICING_ATTR_rec.list_line_id)
2003: THEN
2004: l_PRICING_ATTR_val_rec.list_line := QP_Id_To_Value.List_Line

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

2006: );
2007: END IF;
2008:
2009: /* IF p_PRICING_ATTR_rec.pricing_attribute_id IS NOT NULL AND
2010: p_PRICING_ATTR_rec.pricing_attribute_id <> FND_API.G_MISS_NUM AND
2011: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.pricing_attribute_id,
2012: p_old_PRICING_ATTR_rec.pricing_attribute_id)
2013: THEN
2014: l_PRICING_ATTR_val_rec.pricing_attribute := QP_Id_To_Value.Pricing_Attribute

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

2016: );
2017: END IF;
2018: */
2019: IF p_PRICING_ATTR_rec.product_uom_code IS NOT NULL AND
2020: p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR AND
2021: NOT QP_GLOBALS.Equal(p_PRICING_ATTR_rec.product_uom_code,
2022: p_old_PRICING_ATTR_rec.product_uom_code)
2023: THEN
2024: l_PRICING_ATTR_val_rec.product_uom := QP_Id_To_Value.Product_Uom

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

2041: BEGIN
2042:
2043: -- initialize return_status.
2044:
2045: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2046:
2047: -- initialize l_PRICING_ATTR_rec.
2048:
2049: l_PRICING_ATTR_rec := p_PRICING_ATTR_rec;

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

2047: -- initialize l_PRICING_ATTR_rec.
2048:
2049: l_PRICING_ATTR_rec := p_PRICING_ATTR_rec;
2050:
2051: IF p_PRICING_ATTR_val_rec.accumulate <> FND_API.G_MISS_CHAR
2052: THEN
2053:
2054: IF p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR THEN
2055:

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

2050:
2051: IF p_PRICING_ATTR_val_rec.accumulate <> FND_API.G_MISS_CHAR
2052: THEN
2053:
2054: IF p_PRICING_ATTR_rec.accumulate_flag <> FND_API.G_MISS_CHAR THEN
2055:
2056: l_PRICING_ATTR_rec.accumulate_flag := p_PRICING_ATTR_rec.accumulate_flag;
2057:
2058: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2069: l_PRICING_ATTR_rec.accumulate_flag := QP_Value_To_Id.accumulate
2070: ( p_accumulate => p_PRICING_ATTR_val_rec.accumulate
2071: );
2072:
2073: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
2074: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2075: END IF;
2076:
2077: END IF;

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

2070: ( p_accumulate => p_PRICING_ATTR_val_rec.accumulate
2071: );
2072:
2073: IF l_PRICING_ATTR_rec.accumulate_flag = FND_API.G_MISS_CHAR THEN
2074: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2075: END IF;
2076:
2077: END IF;
2078:

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

2077: END IF;
2078:
2079: END IF;
2080:
2081: IF p_PRICING_ATTR_val_rec.excluder <> FND_API.G_MISS_CHAR
2082: THEN
2083:
2084: IF p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
2085:

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

2080:
2081: IF p_PRICING_ATTR_val_rec.excluder <> FND_API.G_MISS_CHAR
2082: THEN
2083:
2084: IF p_PRICING_ATTR_rec.excluder_flag <> FND_API.G_MISS_CHAR THEN
2085:
2086: l_PRICING_ATTR_rec.excluder_flag := p_PRICING_ATTR_rec.excluder_flag;
2087:
2088: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2099: l_PRICING_ATTR_rec.excluder_flag := QP_Value_To_Id.excluder
2100: ( p_excluder => p_PRICING_ATTR_val_rec.excluder
2101: );
2102:
2103: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
2104: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2105: END IF;
2106:
2107: END IF;

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

2100: ( p_excluder => p_PRICING_ATTR_val_rec.excluder
2101: );
2102:
2103: IF l_PRICING_ATTR_rec.excluder_flag = FND_API.G_MISS_CHAR THEN
2104: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2105: END IF;
2106:
2107: END IF;
2108:

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

2107: END IF;
2108:
2109: END IF;
2110:
2111: IF p_PRICING_ATTR_val_rec.list_line <> FND_API.G_MISS_CHAR
2112: THEN
2113:
2114: IF p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2115:

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

2110:
2111: IF p_PRICING_ATTR_val_rec.list_line <> FND_API.G_MISS_CHAR
2112: THEN
2113:
2114: IF p_PRICING_ATTR_rec.list_line_id <> FND_API.G_MISS_NUM THEN
2115:
2116: l_PRICING_ATTR_rec.list_line_id := p_PRICING_ATTR_rec.list_line_id;
2117:
2118: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2129: l_PRICING_ATTR_rec.list_line_id := QP_Value_To_Id.list_line
2130: ( p_list_line => p_PRICING_ATTR_val_rec.list_line
2131: );
2132:
2133: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
2134: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2135: END IF;
2136:
2137: END IF;

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

2130: ( p_list_line => p_PRICING_ATTR_val_rec.list_line
2131: );
2132:
2133: IF l_PRICING_ATTR_rec.list_line_id = FND_API.G_MISS_NUM THEN
2134: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2135: END IF;
2136:
2137: END IF;
2138:

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

2142: Added code to perform value_to_id conversion for pricing_Attribute,
2143: pricing_Attr_value_from and pricing_attr_value_to columns.
2144: ****************************************************************************/
2145:
2146: IF p_PRICING_ATTR_val_rec.pricing_attribute_desc <> FND_API.G_MISS_CHAR
2147: THEN
2148:
2149: IF p_PRICING_ATTR_rec.pricing_attribute <> FND_API.G_MISS_CHAR THEN
2150:

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

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

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

2165: ( p_pricing_attribute_desc => p_PRICING_ATTR_val_rec.pricing_attribute_desc,
2166: p_context => l_PRICING_ATTR_rec.pricing_attribute_context
2167: );
2168:
2169: IF l_PRICING_ATTR_rec.pricing_attribute = 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_context => l_PRICING_ATTR_rec.pricing_attribute_context
2167: );
2168:
2169: IF l_PRICING_ATTR_rec.pricing_attribute = 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.pricing_attr_value_from_desc <> FND_API.G_MISS_CHAR

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

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

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

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

2197: p_context => l_PRICING_ATTR_rec.pricing_attribute_context,
2198: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2199: );
2200:
2201: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
2202: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2203: END IF;
2204:
2205: END IF;

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

2198: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2199: );
2200:
2201: IF l_PRICING_ATTR_rec.pricing_attr_value_from = FND_API.G_MISS_CHAR THEN
2202: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2203: END IF;
2204:
2205: END IF;
2206:

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

2205: END IF;
2206:
2207: END IF;
2208:
2209: IF p_PRICING_ATTR_val_rec.pricing_attr_value_to_desc <> FND_API.G_MISS_CHAR
2210: THEN
2211:
2212: IF p_PRICING_ATTR_rec.pricing_attr_value_to <> FND_API.G_MISS_CHAR THEN
2213:

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

2208:
2209: IF p_PRICING_ATTR_val_rec.pricing_attr_value_to_desc <> FND_API.G_MISS_CHAR
2210: THEN
2211:
2212: IF p_PRICING_ATTR_rec.pricing_attr_value_to <> FND_API.G_MISS_CHAR THEN
2213:
2214: l_PRICING_ATTR_rec.pricing_attr_value_to := p_PRICING_ATTR_rec.pricing_attr_value_to;
2215:
2216: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2229: p_context => l_PRICING_ATTR_rec.pricing_attribute_context,
2230: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2231: );
2232:
2233: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
2234: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2235: END IF;
2236:
2237: END IF;

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

2230: p_attribute => l_PRICING_ATTR_rec.pricing_attribute
2231: );
2232:
2233: IF l_PRICING_ATTR_rec.pricing_attr_value_to = FND_API.G_MISS_CHAR THEN
2234: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2235: END IF;
2236:
2237: END IF;
2238:

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

2237: END IF;
2238:
2239: END IF;
2240:
2241: IF p_PRICING_ATTR_val_rec.product_uom <> FND_API.G_MISS_CHAR
2242: THEN
2243:
2244: IF p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR THEN
2245:

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

2240:
2241: IF p_PRICING_ATTR_val_rec.product_uom <> FND_API.G_MISS_CHAR
2242: THEN
2243:
2244: IF p_PRICING_ATTR_rec.product_uom_code <> FND_API.G_MISS_CHAR THEN
2245:
2246: l_PRICING_ATTR_rec.product_uom_code := p_PRICING_ATTR_rec.product_uom_code;
2247:
2248: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_SUCCESS)

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

2259: l_PRICING_ATTR_rec.product_uom_code := QP_Value_To_Id.product_uom
2260: ( p_product_uom => p_PRICING_ATTR_val_rec.product_uom
2261: );
2262:
2263: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
2264: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2265: END IF;
2266:
2267: END IF;

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

2260: ( p_product_uom => p_PRICING_ATTR_val_rec.product_uom
2261: );
2262:
2263: IF l_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
2264: l_PRICING_ATTR_rec.return_status := FND_API.G_RET_STS_ERROR;
2265: END IF;
2266:
2267: END IF;
2268:

Line 2369: WHEN FND_API.G_EXC_ERROR THEN

2365: -- pattern
2366:
2367:
2368: EXCEPTION
2369: WHEN FND_API.G_EXC_ERROR THEN
2370: RAISE;
2371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2372: RAISE;
2373: WHEN OTHERS THEN

Line 2371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2367:
2368: EXCEPTION
2369: WHEN FND_API.G_EXC_ERROR THEN
2370: RAISE;
2371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2372: RAISE;
2373: WHEN OTHERS THEN
2374: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2375: THEN

Line 2381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2377: ( G_PKG_NAME
2378: , 'Pre_Write_Process'
2379: );
2380: END IF;
2381: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2382: END Pre_Write_Process;
2383:
2384: END QP_pll_pricing_attr_Util;