7:
8: -- Procedure Clear_Dependent_Attr
9:
10: PROCEDURE Clear_Dependent_Attr
11: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
12: , p_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type
13: , p_old_PRICE_LIST_LINE_rec IN OE_Price_List_PUB.Price_List_Line_Rec_Type :=
14: OE_Price_List_PUB.G_MISS_PRICE_LIST_LINE_REC
15: , x_PRICE_LIST_LINE_rec OUT NOCOPY /* file.sql.39 change */ OE_Price_List_PUB.Price_List_Line_Rec_Type
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 OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.attribute1,p_old_PRICE_LIST_LINE_rec.attribute1)
33: THEN
34: l_index := l_index + 1;
583: THEN
584: -- Validate descriptive flexfield.
585:
586: IF NOT OE_Validate_Attr.Desc_Flex( 'PRICE_LIST_LINE' ) THEN
587: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
588: END IF;
589:
590: END IF;
591:
667:
668: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.comments,p_old_Price_List_Line_rec.comments)
669: THEN
670: IF NOT OE_Validate_Attr.Comments(p_Price_List_Line_rec.comments) THEN
671: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
672: END IF;
673: END IF;
674:
675: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.context,p_old_Price_List_Line_rec.context)
679:
680: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.created_by,p_old_Price_List_Line_rec.created_by)
681: THEN
682: IF NOT OE_Validate_Attr.Created_By(p_Price_List_Line_rec.created_by) THEN
683: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
684: END IF;
685: END IF;
686:
687: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.creation_date,p_old_Price_List_Line_rec.creation_date)
687: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.creation_date,p_old_Price_List_Line_rec.creation_date)
688: THEN
689: IF NOT OE_Validate_Attr.Creation_Date(p_Price_List_Line_rec.creation_date)
690: THEN
691: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
692: END IF;
693: END IF;
694:
695: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.customer_item_id,p_old_Price_List_Line_rec.customer_item_id)
695: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.customer_item_id,p_old_Price_List_Line_rec.customer_item_id)
696: THEN
697: IF NOT OE_Validate_Attr.Customer_Item(p_Price_List_Line_rec.customer_item_id)
698: THEN
699: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
700: END IF;
701: END IF;
702:
703: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.end_date_active,p_old_Price_List_Line_rec.end_date_active)
702:
703: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.end_date_active,p_old_Price_List_Line_rec.end_date_active)
704: THEN
705: IF NOT OE_Validate_Attr.End_Date_Active(p_Price_List_Line_rec.end_date_active) THEN
706: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
707:
708: ELSIF NOT OE_Validate_Attr.Start_Date_End_Date(
709: p_Price_List_Line_rec.start_date_active,
710: p_Price_List_Line_rec.end_date_active) THEN
707:
708: ELSIF NOT OE_Validate_Attr.Start_Date_End_Date(
709: p_Price_List_Line_rec.start_date_active,
710: p_Price_List_Line_rec.end_date_active) THEN
711: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
712:
713: END IF;
714: END IF;
715:
715:
716: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.inventory_item_id,p_old_Price_List_Line_rec.inventory_item_id)
717: THEN
718: IF NOT OE_Validate_Attr.Inventory_Item(p_Price_List_Line_rec.inventory_item_id) THEN
719: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
720: END IF;
721: END IF;
722:
723: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.last_updated_by,p_old_Price_List_Line_rec.last_updated_by)
723: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.last_updated_by,p_old_Price_List_Line_rec.last_updated_by)
724: THEN
725: IF NOT OE_Validate_Attr.Last_Updated_By(p_Price_List_Line_rec.last_updated_by)
726: THEN
727: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
728: END IF;
729: END IF;
730:
731: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.last_update_date,p_old_Price_List_Line_rec.last_update_date)
730:
731: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.last_update_date,p_old_Price_List_Line_rec.last_update_date)
732: THEN
733: IF NOT OE_Validate_Attr.Last_Update_Date(p_Price_List_Line_rec.last_update_date) THEN
734: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
735: END IF;
736: END IF;
737:
738: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.last_update_login,p_old_Price_List_Line_rec.last_update_login)
737:
738: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.last_update_login,p_old_Price_List_Line_rec.last_update_login)
739: THEN
740: IF NOT OE_Validate_Attr.Last_Update_Login(p_Price_List_Line_rec.last_update_login) THEN
741: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
742: END IF;
743: END IF;
744:
745: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.list_price,p_old_Price_List_Line_rec.list_price)
744:
745: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.list_price,p_old_Price_List_Line_rec.list_price)
746: THEN
747: IF NOT OE_Validate_Attr.List_Price(p_Price_List_Line_rec.list_price) THEN
748: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
749: END IF;
750: END IF;
751:
752: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.method_code,p_old_Price_List_Line_rec.method_code)
751:
752: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.method_code,p_old_Price_List_Line_rec.method_code)
753: THEN
754: IF NOT OE_Validate_Attr.Method(p_Price_List_Line_rec.method_code) THEN
755: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
756: END IF;
757: END IF;
758:
759: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.price_list_id,p_old_Price_List_Line_rec.price_list_id)
759: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.price_list_id,p_old_Price_List_Line_rec.price_list_id)
760: THEN
761: IF NOT OE_Validate_Attr.Price_List(p_Price_List_Line_rec.price_list_id)
762: THEN
763: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
764: END IF;
765: END IF;
766:
767: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.price_list_line_id,p_old_Price_List_Line_rec.price_list_line_id)
766:
767: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.price_list_line_id,p_old_Price_List_Line_rec.price_list_line_id)
768: THEN
769: IF NOT OE_Validate_Attr.Price_List_Line(p_Price_List_Line_rec.price_list_line_id) THEN
770: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
771: END IF;
772: END IF;
773:
774: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute1,p_old_Price_List_Line_rec.pricing_attribute1)
773:
774: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute1,p_old_Price_List_Line_rec.pricing_attribute1)
775: THEN
776: IF NOT OE_Validate_Attr.Pricing_Attribute1(p_Price_List_Line_rec.pricing_attribute1) THEN
777: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
778: END IF;
779: END IF;
780:
781: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute10,p_old_Price_List_Line_rec.pricing_attribute10)
781: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute10,p_old_Price_List_Line_rec.pricing_attribute10)
782: THEN
783: IF NOT OE_Validate_Attr.Pricing_Attribute10(p_Price_List_Line_rec.pricing_attribute10)
784: THEN
785: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
786: END IF;
787: END IF;
788:
789: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute11,p_old_Price_List_Line_rec.pricing_attribute11)
789: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute11,p_old_Price_List_Line_rec.pricing_attribute11)
790: THEN
791: IF NOT OE_Validate_Attr.Pricing_Attribute11(p_Price_List_Line_rec.pricing_attribute11)
792: THEN
793: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
794: END IF;
795: END IF;
796:
797: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute12,p_old_Price_List_Line_rec.pricing_attribute12)
797: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute12,p_old_Price_List_Line_rec.pricing_attribute12)
798: THEN
799: IF NOT OE_Validate_Attr.Pricing_Attribute12(p_Price_List_Line_rec.pricing_attribute12)
800: THEN
801: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
802: END IF;
803: END IF;
804:
805: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute13,p_old_Price_List_Line_rec.pricing_attribute13)
805: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute13,p_old_Price_List_Line_rec.pricing_attribute13)
806: THEN
807: IF NOT OE_Validate_Attr.Pricing_Attribute13(p_Price_List_Line_rec.pricing_attribute13)
808: THEN
809: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
810: END IF;
811: END IF;
812:
813: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute14,p_old_Price_List_Line_rec.pricing_attribute14)
813: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute14,p_old_Price_List_Line_rec.pricing_attribute14)
814: THEN
815: IF NOT OE_Validate_Attr.Pricing_Attribute14(p_Price_List_Line_rec.pricing_attribute14)
816: THEN
817: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
818: END IF;
819: END IF;
820:
821: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute15,p_old_Price_List_Line_rec.pricing_attribute15)
821: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute15,p_old_Price_List_Line_rec.pricing_attribute15)
822: THEN
823: IF NOT OE_Validate_Attr.Pricing_Attribute15(p_Price_List_Line_rec.pricing_attribute15)
824: THEN
825: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
826: END IF;
827: END IF;
828:
829: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute2,p_old_Price_List_Line_rec.pricing_attribute2)
829: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute2,p_old_Price_List_Line_rec.pricing_attribute2)
830: THEN
831: IF NOT OE_Validate_Attr.Pricing_Attribute2(p_Price_List_Line_rec.pricing_attribute2)
832: THEN
833: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
834: END IF;
835: END IF;
836:
837: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute3,p_old_Price_List_Line_rec.pricing_attribute3)
837: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute3,p_old_Price_List_Line_rec.pricing_attribute3)
838: THEN
839: IF NOT OE_Validate_Attr.Pricing_Attribute3(p_Price_List_Line_rec.pricing_attribute3)
840: THEN
841: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
842: END IF;
843: END IF;
844:
845: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute4,p_old_Price_List_Line_rec.pricing_attribute4)
845: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute4,p_old_Price_List_Line_rec.pricing_attribute4)
846: THEN
847: IF NOT OE_Validate_Attr.Pricing_Attribute4(p_Price_List_Line_rec.pricing_attribute4)
848: THEN
849: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
850: END IF;
851: END IF;
852:
853: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute5,p_old_Price_List_Line_rec.pricing_attribute5)
853: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute5,p_old_Price_List_Line_rec.pricing_attribute5)
854: THEN
855: IF NOT OE_Validate_Attr.Pricing_Attribute5(p_Price_List_Line_rec.pricing_attribute5)
856: THEN
857: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
858: END IF;
859: END IF;
860:
861: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute6,p_old_Price_List_Line_rec.pricing_attribute6)
861: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute6,p_old_Price_List_Line_rec.pricing_attribute6)
862: THEN
863: IF NOT OE_Validate_Attr.Pricing_Attribute6(p_Price_List_Line_rec.pricing_attribute6)
864: THEN
865: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
866: END IF;
867: END IF;
868:
869: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute7,p_old_Price_List_Line_rec.pricing_attribute7)
869: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute7,p_old_Price_List_Line_rec.pricing_attribute7)
870: THEN
871: IF NOT OE_Validate_Attr.Pricing_Attribute7(p_Price_List_Line_rec.pricing_attribute7)
872: THEN
873: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
874: END IF;
875: END IF;
876:
877: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute8,p_old_Price_List_Line_rec.pricing_attribute8)
877: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute8,p_old_Price_List_Line_rec.pricing_attribute8)
878: THEN
879: IF NOT OE_Validate_Attr.Pricing_Attribute8(p_Price_List_Line_rec.pricing_attribute8)
880: THEN
881: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
882: END IF;
883: END IF;
884:
885: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute9,p_old_Price_List_Line_rec.pricing_attribute9)
885: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_attribute9,p_old_Price_List_Line_rec.pricing_attribute9)
886: THEN
887: IF NOT OE_Validate_Attr.Pricing_Attribute9(p_Price_List_Line_rec.pricing_attribute9)
888: THEN
889: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
890: END IF;
891: END IF;
892:
893: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_context,p_old_Price_List_Line_rec.pricing_context)
892:
893: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_context,p_old_Price_List_Line_rec.pricing_context)
894: THEN
895: IF NOT OE_Validate_Attr.Pricing_Context(p_Price_List_Line_rec.pricing_context) THEN
896: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
897: END IF;
898: END IF;
899:
900: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_rule_id,p_old_Price_List_Line_rec.pricing_rule_id)
900: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.pricing_rule_id,p_old_Price_List_Line_rec.pricing_rule_id)
901: THEN
902: IF NOT OE_Validate_Attr.Pricing_Rule(p_Price_List_Line_rec.pricing_rule_id)
903: THEN
904: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
905: END IF;
906: END IF;
907:
908: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.program_application_id,p_old_Price_List_Line_rec.program_application_id)
907:
908: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.program_application_id,p_old_Price_List_Line_rec.program_application_id)
909: THEN
910: IF NOT OE_Validate_Attr.Program_Application(p_Price_List_Line_rec.program_application_id) THEN
911: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
912: END IF;
913: END IF;
914:
915: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.program_id,p_old_Price_List_Line_rec.program_id)
914:
915: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.program_id,p_old_Price_List_Line_rec.program_id)
916: THEN
917: IF NOT OE_Validate_Attr.Program(p_Price_List_Line_rec.program_id) THEN
918: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
919: END IF;
920: END IF;
921:
922: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.program_update_date,p_old_Price_List_Line_rec.program_update_date)
921:
922: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.program_update_date,p_old_Price_List_Line_rec.program_update_date)
923: THEN
924: IF NOT OE_Validate_Attr.Program_Update_Date(p_Price_List_Line_rec.program_update_date) THEN
925: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
926: END IF;
927: END IF;
928:
929: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.reprice_flag,p_old_Price_List_Line_rec.reprice_flag)
928:
929: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.reprice_flag,p_old_Price_List_Line_rec.reprice_flag)
930: THEN
931: IF NOT OE_Validate_Attr.Reprice(p_Price_List_Line_rec.reprice_flag) THEN
932: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
933: END IF;
934: END IF;
935:
936: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.request_id,p_old_Price_List_Line_rec.request_id)
935:
936: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.request_id,p_old_Price_List_Line_rec.request_id)
937: THEN
938: IF NOT OE_Validate_Attr.Request(p_Price_List_Line_rec.request_id) THEN
939: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
940: END IF;
941: END IF;
942:
943: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.revision,p_old_Price_List_Line_rec.revision)
942:
943: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.revision,p_old_Price_List_Line_rec.revision)
944: THEN
945: IF NOT OE_Validate_Attr.Revision(p_Price_List_Line_rec.revision) THEN
946: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
947: END IF;
948: END IF;
949:
950: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.revision_date,p_old_Price_List_Line_rec.revision_date)
949:
950: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.revision_date,p_old_Price_List_Line_rec.revision_date)
951: THEN
952: IF NOT OE_Validate_Attr.Revision_Date(p_Price_List_Line_rec.revision_date) THEN
953: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
954: END IF;
955: END IF;
956:
957: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.revision_reason_code,p_old_Price_List_Line_rec.revision_reason_code)
956:
957: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.revision_reason_code,p_old_Price_List_Line_rec.revision_reason_code)
958: THEN
959: IF NOT OE_Validate_Attr.Revision_Reason(p_Price_List_Line_rec.revision_reason_code) THEN
960: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
961: END IF;
962: END IF;
963:
964: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.start_date_active,p_old_Price_List_Line_rec.start_date_active)
963:
964: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.start_date_active,p_old_Price_List_Line_rec.start_date_active)
965: THEN
966: IF NOT OE_Validate_Attr.Start_Date_Active(p_Price_List_Line_rec.start_date_active) THEN
967: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
968:
969: ELSIF NOT OE_Validate_Attr.Start_Date_End_Date(
970: p_Price_List_Line_rec.start_date_active,
971: p_Price_List_Line_rec.end_date_active) THEN
968:
969: ELSIF NOT OE_Validate_Attr.Start_Date_End_Date(
970: p_Price_List_Line_rec.start_date_active,
971: p_Price_List_Line_rec.end_date_active) THEN
972: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
973:
974: END IF;
975: END IF;
976:
976:
977: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.unit_code,p_old_Price_List_Line_rec.unit_code)
978: THEN
979: IF NOT OE_Validate_Attr.Unit(p_Price_List_Line_rec.unit_code) THEN
980: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
981: END IF;
982: END IF;
983:
984: IF NOT OE_GLOBALS.Equal(p_Price_List_Line_rec.primary,p_old_Price_List_Line_rec.primary)
1025:
1026: END IF;
1027:
1028:
1029: x_Price_List_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
1030:
1031: END IF;
1032:
1033:
1050: IS
1051: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1052: BEGIN
1053:
1054: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1055: l_PRICE_LIST_LINE_rec.attribute1 := p_old_PRICE_LIST_LINE_rec.attribute1;
1056: END IF;
1057:
1058: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1054: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1055: l_PRICE_LIST_LINE_rec.attribute1 := p_old_PRICE_LIST_LINE_rec.attribute1;
1056: END IF;
1057:
1058: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1059: l_PRICE_LIST_LINE_rec.attribute10 := p_old_PRICE_LIST_LINE_rec.attribute10;
1060: END IF;
1061:
1062: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1058: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1059: l_PRICE_LIST_LINE_rec.attribute10 := p_old_PRICE_LIST_LINE_rec.attribute10;
1060: END IF;
1061:
1062: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1063: l_PRICE_LIST_LINE_rec.attribute11 := p_old_PRICE_LIST_LINE_rec.attribute11;
1064: END IF;
1065:
1066: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1062: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1063: l_PRICE_LIST_LINE_rec.attribute11 := p_old_PRICE_LIST_LINE_rec.attribute11;
1064: END IF;
1065:
1066: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1067: l_PRICE_LIST_LINE_rec.attribute12 := p_old_PRICE_LIST_LINE_rec.attribute12;
1068: END IF;
1069:
1070: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1066: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1067: l_PRICE_LIST_LINE_rec.attribute12 := p_old_PRICE_LIST_LINE_rec.attribute12;
1068: END IF;
1069:
1070: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1071: l_PRICE_LIST_LINE_rec.attribute13 := p_old_PRICE_LIST_LINE_rec.attribute13;
1072: END IF;
1073:
1074: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1070: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1071: l_PRICE_LIST_LINE_rec.attribute13 := p_old_PRICE_LIST_LINE_rec.attribute13;
1072: END IF;
1073:
1074: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1075: l_PRICE_LIST_LINE_rec.attribute14 := p_old_PRICE_LIST_LINE_rec.attribute14;
1076: END IF;
1077:
1078: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1074: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1075: l_PRICE_LIST_LINE_rec.attribute14 := p_old_PRICE_LIST_LINE_rec.attribute14;
1076: END IF;
1077:
1078: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1079: l_PRICE_LIST_LINE_rec.attribute15 := p_old_PRICE_LIST_LINE_rec.attribute15;
1080: END IF;
1081:
1082: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1078: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1079: l_PRICE_LIST_LINE_rec.attribute15 := p_old_PRICE_LIST_LINE_rec.attribute15;
1080: END IF;
1081:
1082: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1083: l_PRICE_LIST_LINE_rec.attribute2 := p_old_PRICE_LIST_LINE_rec.attribute2;
1084: END IF;
1085:
1086: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1082: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1083: l_PRICE_LIST_LINE_rec.attribute2 := p_old_PRICE_LIST_LINE_rec.attribute2;
1084: END IF;
1085:
1086: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1087: l_PRICE_LIST_LINE_rec.attribute3 := p_old_PRICE_LIST_LINE_rec.attribute3;
1088: END IF;
1089:
1090: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1086: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1087: l_PRICE_LIST_LINE_rec.attribute3 := p_old_PRICE_LIST_LINE_rec.attribute3;
1088: END IF;
1089:
1090: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1091: l_PRICE_LIST_LINE_rec.attribute4 := p_old_PRICE_LIST_LINE_rec.attribute4;
1092: END IF;
1093:
1094: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1090: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1091: l_PRICE_LIST_LINE_rec.attribute4 := p_old_PRICE_LIST_LINE_rec.attribute4;
1092: END IF;
1093:
1094: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1095: l_PRICE_LIST_LINE_rec.attribute5 := p_old_PRICE_LIST_LINE_rec.attribute5;
1096: END IF;
1097:
1098: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1094: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1095: l_PRICE_LIST_LINE_rec.attribute5 := p_old_PRICE_LIST_LINE_rec.attribute5;
1096: END IF;
1097:
1098: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1099: l_PRICE_LIST_LINE_rec.attribute6 := p_old_PRICE_LIST_LINE_rec.attribute6;
1100: END IF;
1101:
1102: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1098: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1099: l_PRICE_LIST_LINE_rec.attribute6 := p_old_PRICE_LIST_LINE_rec.attribute6;
1100: END IF;
1101:
1102: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1103: l_PRICE_LIST_LINE_rec.attribute7 := p_old_PRICE_LIST_LINE_rec.attribute7;
1104: END IF;
1105:
1106: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1102: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1103: l_PRICE_LIST_LINE_rec.attribute7 := p_old_PRICE_LIST_LINE_rec.attribute7;
1104: END IF;
1105:
1106: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1107: l_PRICE_LIST_LINE_rec.attribute8 := p_old_PRICE_LIST_LINE_rec.attribute8;
1108: END IF;
1109:
1110: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1106: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1107: l_PRICE_LIST_LINE_rec.attribute8 := p_old_PRICE_LIST_LINE_rec.attribute8;
1108: END IF;
1109:
1110: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1111: l_PRICE_LIST_LINE_rec.attribute9 := p_old_PRICE_LIST_LINE_rec.attribute9;
1112: END IF;
1113:
1114: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1110: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1111: l_PRICE_LIST_LINE_rec.attribute9 := p_old_PRICE_LIST_LINE_rec.attribute9;
1112: END IF;
1113:
1114: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1115: l_PRICE_LIST_LINE_rec.comments := p_old_PRICE_LIST_LINE_rec.comments;
1116: END IF;
1117:
1118: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1114: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1115: l_PRICE_LIST_LINE_rec.comments := p_old_PRICE_LIST_LINE_rec.comments;
1116: END IF;
1117:
1118: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1119: l_PRICE_LIST_LINE_rec.context := p_old_PRICE_LIST_LINE_rec.context;
1120: END IF;
1121:
1122: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1118: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1119: l_PRICE_LIST_LINE_rec.context := p_old_PRICE_LIST_LINE_rec.context;
1120: END IF;
1121:
1122: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1123: l_PRICE_LIST_LINE_rec.created_by := p_old_PRICE_LIST_LINE_rec.created_by;
1124: END IF;
1125:
1126: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1122: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1123: l_PRICE_LIST_LINE_rec.created_by := p_old_PRICE_LIST_LINE_rec.created_by;
1124: END IF;
1125:
1126: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1127: l_PRICE_LIST_LINE_rec.creation_date := p_old_PRICE_LIST_LINE_rec.creation_date;
1128: END IF;
1129:
1130: IF l_PRICE_LIST_LINE_rec.customer_item_id = FND_API.G_MISS_NUM THEN
1126: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1127: l_PRICE_LIST_LINE_rec.creation_date := p_old_PRICE_LIST_LINE_rec.creation_date;
1128: END IF;
1129:
1130: IF l_PRICE_LIST_LINE_rec.customer_item_id = FND_API.G_MISS_NUM THEN
1131: l_PRICE_LIST_LINE_rec.customer_item_id := p_old_PRICE_LIST_LINE_rec.customer_item_id;
1132: END IF;
1133:
1134: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1130: IF l_PRICE_LIST_LINE_rec.customer_item_id = FND_API.G_MISS_NUM THEN
1131: l_PRICE_LIST_LINE_rec.customer_item_id := p_old_PRICE_LIST_LINE_rec.customer_item_id;
1132: END IF;
1133:
1134: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1135: l_PRICE_LIST_LINE_rec.end_date_active := p_old_PRICE_LIST_LINE_rec.end_date_active;
1136: END IF;
1137:
1138: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1134: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1135: l_PRICE_LIST_LINE_rec.end_date_active := p_old_PRICE_LIST_LINE_rec.end_date_active;
1136: END IF;
1137:
1138: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1139: l_PRICE_LIST_LINE_rec.inventory_item_id := p_old_PRICE_LIST_LINE_rec.inventory_item_id;
1140: END IF;
1141:
1142: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1138: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1139: l_PRICE_LIST_LINE_rec.inventory_item_id := p_old_PRICE_LIST_LINE_rec.inventory_item_id;
1140: END IF;
1141:
1142: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1143: l_PRICE_LIST_LINE_rec.last_updated_by := p_old_PRICE_LIST_LINE_rec.last_updated_by;
1144: END IF;
1145:
1146: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1142: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1143: l_PRICE_LIST_LINE_rec.last_updated_by := p_old_PRICE_LIST_LINE_rec.last_updated_by;
1144: END IF;
1145:
1146: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1147: l_PRICE_LIST_LINE_rec.last_update_date := p_old_PRICE_LIST_LINE_rec.last_update_date;
1148: END IF;
1149:
1150: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1146: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1147: l_PRICE_LIST_LINE_rec.last_update_date := p_old_PRICE_LIST_LINE_rec.last_update_date;
1148: END IF;
1149:
1150: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1151: l_PRICE_LIST_LINE_rec.last_update_login := p_old_PRICE_LIST_LINE_rec.last_update_login;
1152: END IF;
1153:
1154: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1150: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1151: l_PRICE_LIST_LINE_rec.last_update_login := p_old_PRICE_LIST_LINE_rec.last_update_login;
1152: END IF;
1153:
1154: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1155: l_PRICE_LIST_LINE_rec.list_price := p_old_PRICE_LIST_LINE_rec.list_price;
1156: END IF;
1157:
1158: IF l_PRICE_LIST_LINE_rec.method_code = FND_API.G_MISS_CHAR THEN
1154: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1155: l_PRICE_LIST_LINE_rec.list_price := p_old_PRICE_LIST_LINE_rec.list_price;
1156: END IF;
1157:
1158: IF l_PRICE_LIST_LINE_rec.method_code = FND_API.G_MISS_CHAR THEN
1159: l_PRICE_LIST_LINE_rec.method_code := p_old_PRICE_LIST_LINE_rec.method_code;
1160: END IF;
1161:
1162: IF l_PRICE_LIST_LINE_rec.price_list_id = FND_API.G_MISS_NUM THEN
1158: IF l_PRICE_LIST_LINE_rec.method_code = FND_API.G_MISS_CHAR THEN
1159: l_PRICE_LIST_LINE_rec.method_code := p_old_PRICE_LIST_LINE_rec.method_code;
1160: END IF;
1161:
1162: IF l_PRICE_LIST_LINE_rec.price_list_id = FND_API.G_MISS_NUM THEN
1163: l_PRICE_LIST_LINE_rec.price_list_id := p_old_PRICE_LIST_LINE_rec.price_list_id;
1164: END IF;
1165:
1166: IF l_PRICE_LIST_LINE_rec.price_list_line_id = FND_API.G_MISS_NUM THEN
1162: IF l_PRICE_LIST_LINE_rec.price_list_id = FND_API.G_MISS_NUM THEN
1163: l_PRICE_LIST_LINE_rec.price_list_id := p_old_PRICE_LIST_LINE_rec.price_list_id;
1164: END IF;
1165:
1166: IF l_PRICE_LIST_LINE_rec.price_list_line_id = FND_API.G_MISS_NUM THEN
1167: l_PRICE_LIST_LINE_rec.price_list_line_id := p_old_PRICE_LIST_LINE_rec.price_list_line_id;
1168: END IF;
1169:
1170: IF l_PRICE_LIST_LINE_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
1166: IF l_PRICE_LIST_LINE_rec.price_list_line_id = FND_API.G_MISS_NUM THEN
1167: l_PRICE_LIST_LINE_rec.price_list_line_id := p_old_PRICE_LIST_LINE_rec.price_list_line_id;
1168: END IF;
1169:
1170: IF l_PRICE_LIST_LINE_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
1171: l_PRICE_LIST_LINE_rec.pricing_attribute1 := p_old_PRICE_LIST_LINE_rec.pricing_attribute1;
1172: END IF;
1173:
1174: IF l_PRICE_LIST_LINE_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
1170: IF l_PRICE_LIST_LINE_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
1171: l_PRICE_LIST_LINE_rec.pricing_attribute1 := p_old_PRICE_LIST_LINE_rec.pricing_attribute1;
1172: END IF;
1173:
1174: IF l_PRICE_LIST_LINE_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
1175: l_PRICE_LIST_LINE_rec.pricing_attribute10 := p_old_PRICE_LIST_LINE_rec.pricing_attribute10;
1176: END IF;
1177:
1178: IF l_PRICE_LIST_LINE_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
1174: IF l_PRICE_LIST_LINE_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
1175: l_PRICE_LIST_LINE_rec.pricing_attribute10 := p_old_PRICE_LIST_LINE_rec.pricing_attribute10;
1176: END IF;
1177:
1178: IF l_PRICE_LIST_LINE_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
1179: l_PRICE_LIST_LINE_rec.pricing_attribute11 := p_old_PRICE_LIST_LINE_rec.pricing_attribute11;
1180: END IF;
1181:
1182: IF l_PRICE_LIST_LINE_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
1178: IF l_PRICE_LIST_LINE_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
1179: l_PRICE_LIST_LINE_rec.pricing_attribute11 := p_old_PRICE_LIST_LINE_rec.pricing_attribute11;
1180: END IF;
1181:
1182: IF l_PRICE_LIST_LINE_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
1183: l_PRICE_LIST_LINE_rec.pricing_attribute12 := p_old_PRICE_LIST_LINE_rec.pricing_attribute12;
1184: END IF;
1185:
1186: IF l_PRICE_LIST_LINE_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
1182: IF l_PRICE_LIST_LINE_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
1183: l_PRICE_LIST_LINE_rec.pricing_attribute12 := p_old_PRICE_LIST_LINE_rec.pricing_attribute12;
1184: END IF;
1185:
1186: IF l_PRICE_LIST_LINE_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
1187: l_PRICE_LIST_LINE_rec.pricing_attribute13 := p_old_PRICE_LIST_LINE_rec.pricing_attribute13;
1188: END IF;
1189:
1190: IF l_PRICE_LIST_LINE_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
1186: IF l_PRICE_LIST_LINE_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
1187: l_PRICE_LIST_LINE_rec.pricing_attribute13 := p_old_PRICE_LIST_LINE_rec.pricing_attribute13;
1188: END IF;
1189:
1190: IF l_PRICE_LIST_LINE_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
1191: l_PRICE_LIST_LINE_rec.pricing_attribute14 := p_old_PRICE_LIST_LINE_rec.pricing_attribute14;
1192: END IF;
1193:
1194: IF l_PRICE_LIST_LINE_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
1190: IF l_PRICE_LIST_LINE_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
1191: l_PRICE_LIST_LINE_rec.pricing_attribute14 := p_old_PRICE_LIST_LINE_rec.pricing_attribute14;
1192: END IF;
1193:
1194: IF l_PRICE_LIST_LINE_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
1195: l_PRICE_LIST_LINE_rec.pricing_attribute15 := p_old_PRICE_LIST_LINE_rec.pricing_attribute15;
1196: END IF;
1197:
1198: IF l_PRICE_LIST_LINE_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
1194: IF l_PRICE_LIST_LINE_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
1195: l_PRICE_LIST_LINE_rec.pricing_attribute15 := p_old_PRICE_LIST_LINE_rec.pricing_attribute15;
1196: END IF;
1197:
1198: IF l_PRICE_LIST_LINE_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
1199: l_PRICE_LIST_LINE_rec.pricing_attribute2 := p_old_PRICE_LIST_LINE_rec.pricing_attribute2;
1200: END IF;
1201:
1202: IF l_PRICE_LIST_LINE_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
1198: IF l_PRICE_LIST_LINE_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
1199: l_PRICE_LIST_LINE_rec.pricing_attribute2 := p_old_PRICE_LIST_LINE_rec.pricing_attribute2;
1200: END IF;
1201:
1202: IF l_PRICE_LIST_LINE_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
1203: l_PRICE_LIST_LINE_rec.pricing_attribute3 := p_old_PRICE_LIST_LINE_rec.pricing_attribute3;
1204: END IF;
1205:
1206: IF l_PRICE_LIST_LINE_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
1202: IF l_PRICE_LIST_LINE_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
1203: l_PRICE_LIST_LINE_rec.pricing_attribute3 := p_old_PRICE_LIST_LINE_rec.pricing_attribute3;
1204: END IF;
1205:
1206: IF l_PRICE_LIST_LINE_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
1207: l_PRICE_LIST_LINE_rec.pricing_attribute4 := p_old_PRICE_LIST_LINE_rec.pricing_attribute4;
1208: END IF;
1209:
1210: IF l_PRICE_LIST_LINE_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
1206: IF l_PRICE_LIST_LINE_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
1207: l_PRICE_LIST_LINE_rec.pricing_attribute4 := p_old_PRICE_LIST_LINE_rec.pricing_attribute4;
1208: END IF;
1209:
1210: IF l_PRICE_LIST_LINE_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
1211: l_PRICE_LIST_LINE_rec.pricing_attribute5 := p_old_PRICE_LIST_LINE_rec.pricing_attribute5;
1212: END IF;
1213:
1214: IF l_PRICE_LIST_LINE_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
1210: IF l_PRICE_LIST_LINE_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
1211: l_PRICE_LIST_LINE_rec.pricing_attribute5 := p_old_PRICE_LIST_LINE_rec.pricing_attribute5;
1212: END IF;
1213:
1214: IF l_PRICE_LIST_LINE_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
1215: l_PRICE_LIST_LINE_rec.pricing_attribute6 := p_old_PRICE_LIST_LINE_rec.pricing_attribute6;
1216: END IF;
1217:
1218: IF l_PRICE_LIST_LINE_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
1214: IF l_PRICE_LIST_LINE_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
1215: l_PRICE_LIST_LINE_rec.pricing_attribute6 := p_old_PRICE_LIST_LINE_rec.pricing_attribute6;
1216: END IF;
1217:
1218: IF l_PRICE_LIST_LINE_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
1219: l_PRICE_LIST_LINE_rec.pricing_attribute7 := p_old_PRICE_LIST_LINE_rec.pricing_attribute7;
1220: END IF;
1221:
1222: IF l_PRICE_LIST_LINE_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
1218: IF l_PRICE_LIST_LINE_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
1219: l_PRICE_LIST_LINE_rec.pricing_attribute7 := p_old_PRICE_LIST_LINE_rec.pricing_attribute7;
1220: END IF;
1221:
1222: IF l_PRICE_LIST_LINE_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
1223: l_PRICE_LIST_LINE_rec.pricing_attribute8 := p_old_PRICE_LIST_LINE_rec.pricing_attribute8;
1224: END IF;
1225:
1226: IF l_PRICE_LIST_LINE_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
1222: IF l_PRICE_LIST_LINE_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
1223: l_PRICE_LIST_LINE_rec.pricing_attribute8 := p_old_PRICE_LIST_LINE_rec.pricing_attribute8;
1224: END IF;
1225:
1226: IF l_PRICE_LIST_LINE_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
1227: l_PRICE_LIST_LINE_rec.pricing_attribute9 := p_old_PRICE_LIST_LINE_rec.pricing_attribute9;
1228: END IF;
1229:
1230: IF l_PRICE_LIST_LINE_rec.pricing_context = FND_API.G_MISS_CHAR THEN
1226: IF l_PRICE_LIST_LINE_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
1227: l_PRICE_LIST_LINE_rec.pricing_attribute9 := p_old_PRICE_LIST_LINE_rec.pricing_attribute9;
1228: END IF;
1229:
1230: IF l_PRICE_LIST_LINE_rec.pricing_context = FND_API.G_MISS_CHAR THEN
1231: l_PRICE_LIST_LINE_rec.pricing_context := p_old_PRICE_LIST_LINE_rec.pricing_context;
1232: END IF;
1233:
1234: IF l_PRICE_LIST_LINE_rec.pricing_rule_id = FND_API.G_MISS_NUM THEN
1230: IF l_PRICE_LIST_LINE_rec.pricing_context = FND_API.G_MISS_CHAR THEN
1231: l_PRICE_LIST_LINE_rec.pricing_context := p_old_PRICE_LIST_LINE_rec.pricing_context;
1232: END IF;
1233:
1234: IF l_PRICE_LIST_LINE_rec.pricing_rule_id = FND_API.G_MISS_NUM THEN
1235: l_PRICE_LIST_LINE_rec.pricing_rule_id := p_old_PRICE_LIST_LINE_rec.pricing_rule_id;
1236: END IF;
1237:
1238: IF l_PRICE_LIST_LINE_rec.primary = FND_API.G_MISS_CHAR THEN
1234: IF l_PRICE_LIST_LINE_rec.pricing_rule_id = FND_API.G_MISS_NUM THEN
1235: l_PRICE_LIST_LINE_rec.pricing_rule_id := p_old_PRICE_LIST_LINE_rec.pricing_rule_id;
1236: END IF;
1237:
1238: IF l_PRICE_LIST_LINE_rec.primary = FND_API.G_MISS_CHAR THEN
1239: l_PRICE_LIST_LINE_rec.primary := p_old_PRICE_LIST_LINE_rec.primary;
1240: END IF;
1241:
1242: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1238: IF l_PRICE_LIST_LINE_rec.primary = FND_API.G_MISS_CHAR THEN
1239: l_PRICE_LIST_LINE_rec.primary := p_old_PRICE_LIST_LINE_rec.primary;
1240: END IF;
1241:
1242: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1243: l_PRICE_LIST_LINE_rec.program_application_id := p_old_PRICE_LIST_LINE_rec.program_application_id;
1244: END IF;
1245:
1246: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1242: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1243: l_PRICE_LIST_LINE_rec.program_application_id := p_old_PRICE_LIST_LINE_rec.program_application_id;
1244: END IF;
1245:
1246: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1247: l_PRICE_LIST_LINE_rec.program_id := p_old_PRICE_LIST_LINE_rec.program_id;
1248: END IF;
1249:
1250: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1246: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1247: l_PRICE_LIST_LINE_rec.program_id := p_old_PRICE_LIST_LINE_rec.program_id;
1248: END IF;
1249:
1250: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1251: l_PRICE_LIST_LINE_rec.program_update_date := p_old_PRICE_LIST_LINE_rec.program_update_date;
1252: END IF;
1253:
1254: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1250: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1251: l_PRICE_LIST_LINE_rec.program_update_date := p_old_PRICE_LIST_LINE_rec.program_update_date;
1252: END IF;
1253:
1254: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1255: l_PRICE_LIST_LINE_rec.reprice_flag := p_old_PRICE_LIST_LINE_rec.reprice_flag;
1256: END IF;
1257:
1258: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1254: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1255: l_PRICE_LIST_LINE_rec.reprice_flag := p_old_PRICE_LIST_LINE_rec.reprice_flag;
1256: END IF;
1257:
1258: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1259: l_PRICE_LIST_LINE_rec.request_id := p_old_PRICE_LIST_LINE_rec.request_id;
1260: END IF;
1261:
1262: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1258: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1259: l_PRICE_LIST_LINE_rec.request_id := p_old_PRICE_LIST_LINE_rec.request_id;
1260: END IF;
1261:
1262: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1263: l_PRICE_LIST_LINE_rec.revision := p_old_PRICE_LIST_LINE_rec.revision;
1264: END IF;
1265:
1266: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1262: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1263: l_PRICE_LIST_LINE_rec.revision := p_old_PRICE_LIST_LINE_rec.revision;
1264: END IF;
1265:
1266: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1267: l_PRICE_LIST_LINE_rec.revision_date := p_old_PRICE_LIST_LINE_rec.revision_date;
1268: END IF;
1269:
1270: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1266: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1267: l_PRICE_LIST_LINE_rec.revision_date := p_old_PRICE_LIST_LINE_rec.revision_date;
1268: END IF;
1269:
1270: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1271: l_PRICE_LIST_LINE_rec.revision_reason_code := p_old_PRICE_LIST_LINE_rec.revision_reason_code;
1272: END IF;
1273:
1274: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1270: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1271: l_PRICE_LIST_LINE_rec.revision_reason_code := p_old_PRICE_LIST_LINE_rec.revision_reason_code;
1272: END IF;
1273:
1274: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1275: l_PRICE_LIST_LINE_rec.start_date_active := p_old_PRICE_LIST_LINE_rec.start_date_active;
1276: END IF;
1277:
1278: IF l_PRICE_LIST_LINE_rec.unit_code = FND_API.G_MISS_CHAR THEN
1274: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1275: l_PRICE_LIST_LINE_rec.start_date_active := p_old_PRICE_LIST_LINE_rec.start_date_active;
1276: END IF;
1277:
1278: IF l_PRICE_LIST_LINE_rec.unit_code = FND_API.G_MISS_CHAR THEN
1279: l_PRICE_LIST_LINE_rec.unit_code := p_old_PRICE_LIST_LINE_rec.unit_code;
1280: END IF;
1281:
1282: RETURN l_PRICE_LIST_LINE_rec;
1291: IS
1292: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type := p_PRICE_LIST_LINE_rec;
1293: BEGIN
1294:
1295: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1296: l_PRICE_LIST_LINE_rec.attribute1 := NULL;
1297: END IF;
1298:
1299: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1295: IF l_PRICE_LIST_LINE_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1296: l_PRICE_LIST_LINE_rec.attribute1 := NULL;
1297: END IF;
1298:
1299: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1300: l_PRICE_LIST_LINE_rec.attribute10 := NULL;
1301: END IF;
1302:
1303: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1299: IF l_PRICE_LIST_LINE_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1300: l_PRICE_LIST_LINE_rec.attribute10 := NULL;
1301: END IF;
1302:
1303: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1304: l_PRICE_LIST_LINE_rec.attribute11 := NULL;
1305: END IF;
1306:
1307: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1303: IF l_PRICE_LIST_LINE_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1304: l_PRICE_LIST_LINE_rec.attribute11 := NULL;
1305: END IF;
1306:
1307: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1308: l_PRICE_LIST_LINE_rec.attribute12 := NULL;
1309: END IF;
1310:
1311: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1307: IF l_PRICE_LIST_LINE_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1308: l_PRICE_LIST_LINE_rec.attribute12 := NULL;
1309: END IF;
1310:
1311: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1312: l_PRICE_LIST_LINE_rec.attribute13 := NULL;
1313: END IF;
1314:
1315: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1311: IF l_PRICE_LIST_LINE_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1312: l_PRICE_LIST_LINE_rec.attribute13 := NULL;
1313: END IF;
1314:
1315: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1316: l_PRICE_LIST_LINE_rec.attribute14 := NULL;
1317: END IF;
1318:
1319: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1315: IF l_PRICE_LIST_LINE_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1316: l_PRICE_LIST_LINE_rec.attribute14 := NULL;
1317: END IF;
1318:
1319: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1320: l_PRICE_LIST_LINE_rec.attribute15 := NULL;
1321: END IF;
1322:
1323: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1319: IF l_PRICE_LIST_LINE_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1320: l_PRICE_LIST_LINE_rec.attribute15 := NULL;
1321: END IF;
1322:
1323: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1324: l_PRICE_LIST_LINE_rec.attribute2 := NULL;
1325: END IF;
1326:
1327: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1323: IF l_PRICE_LIST_LINE_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1324: l_PRICE_LIST_LINE_rec.attribute2 := NULL;
1325: END IF;
1326:
1327: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1328: l_PRICE_LIST_LINE_rec.attribute3 := NULL;
1329: END IF;
1330:
1331: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1327: IF l_PRICE_LIST_LINE_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1328: l_PRICE_LIST_LINE_rec.attribute3 := NULL;
1329: END IF;
1330:
1331: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1332: l_PRICE_LIST_LINE_rec.attribute4 := NULL;
1333: END IF;
1334:
1335: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1331: IF l_PRICE_LIST_LINE_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1332: l_PRICE_LIST_LINE_rec.attribute4 := NULL;
1333: END IF;
1334:
1335: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1336: l_PRICE_LIST_LINE_rec.attribute5 := NULL;
1337: END IF;
1338:
1339: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1335: IF l_PRICE_LIST_LINE_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1336: l_PRICE_LIST_LINE_rec.attribute5 := NULL;
1337: END IF;
1338:
1339: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1340: l_PRICE_LIST_LINE_rec.attribute6 := NULL;
1341: END IF;
1342:
1343: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1339: IF l_PRICE_LIST_LINE_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1340: l_PRICE_LIST_LINE_rec.attribute6 := NULL;
1341: END IF;
1342:
1343: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1344: l_PRICE_LIST_LINE_rec.attribute7 := NULL;
1345: END IF;
1346:
1347: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1343: IF l_PRICE_LIST_LINE_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1344: l_PRICE_LIST_LINE_rec.attribute7 := NULL;
1345: END IF;
1346:
1347: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1348: l_PRICE_LIST_LINE_rec.attribute8 := NULL;
1349: END IF;
1350:
1351: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1347: IF l_PRICE_LIST_LINE_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1348: l_PRICE_LIST_LINE_rec.attribute8 := NULL;
1349: END IF;
1350:
1351: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1352: l_PRICE_LIST_LINE_rec.attribute9 := NULL;
1353: END IF;
1354:
1355: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1351: IF l_PRICE_LIST_LINE_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1352: l_PRICE_LIST_LINE_rec.attribute9 := NULL;
1353: END IF;
1354:
1355: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1356: l_PRICE_LIST_LINE_rec.comments := NULL;
1357: END IF;
1358:
1359: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1355: IF l_PRICE_LIST_LINE_rec.comments = FND_API.G_MISS_CHAR THEN
1356: l_PRICE_LIST_LINE_rec.comments := NULL;
1357: END IF;
1358:
1359: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1360: l_PRICE_LIST_LINE_rec.context := NULL;
1361: END IF;
1362:
1363: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1359: IF l_PRICE_LIST_LINE_rec.context = FND_API.G_MISS_CHAR THEN
1360: l_PRICE_LIST_LINE_rec.context := NULL;
1361: END IF;
1362:
1363: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1364: l_PRICE_LIST_LINE_rec.created_by := NULL;
1365: END IF;
1366:
1367: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1363: IF l_PRICE_LIST_LINE_rec.created_by = FND_API.G_MISS_NUM THEN
1364: l_PRICE_LIST_LINE_rec.created_by := NULL;
1365: END IF;
1366:
1367: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1368: l_PRICE_LIST_LINE_rec.creation_date := NULL;
1369: END IF;
1370:
1371: IF l_PRICE_LIST_LINE_rec.customer_item_id = FND_API.G_MISS_NUM THEN
1367: IF l_PRICE_LIST_LINE_rec.creation_date = FND_API.G_MISS_DATE THEN
1368: l_PRICE_LIST_LINE_rec.creation_date := NULL;
1369: END IF;
1370:
1371: IF l_PRICE_LIST_LINE_rec.customer_item_id = FND_API.G_MISS_NUM THEN
1372: l_PRICE_LIST_LINE_rec.customer_item_id := NULL;
1373: END IF;
1374:
1375: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1371: IF l_PRICE_LIST_LINE_rec.customer_item_id = FND_API.G_MISS_NUM THEN
1372: l_PRICE_LIST_LINE_rec.customer_item_id := NULL;
1373: END IF;
1374:
1375: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1376: l_PRICE_LIST_LINE_rec.end_date_active := NULL;
1377: END IF;
1378:
1379: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1375: IF l_PRICE_LIST_LINE_rec.end_date_active = FND_API.G_MISS_DATE THEN
1376: l_PRICE_LIST_LINE_rec.end_date_active := NULL;
1377: END IF;
1378:
1379: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1380: l_PRICE_LIST_LINE_rec.inventory_item_id := NULL;
1381: END IF;
1382:
1383: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1379: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
1380: l_PRICE_LIST_LINE_rec.inventory_item_id := NULL;
1381: END IF;
1382:
1383: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1384: l_PRICE_LIST_LINE_rec.last_updated_by := NULL;
1385: END IF;
1386:
1387: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1383: IF l_PRICE_LIST_LINE_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1384: l_PRICE_LIST_LINE_rec.last_updated_by := NULL;
1385: END IF;
1386:
1387: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1388: l_PRICE_LIST_LINE_rec.last_update_date := NULL;
1389: END IF;
1390:
1391: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1387: IF l_PRICE_LIST_LINE_rec.last_update_date = FND_API.G_MISS_DATE THEN
1388: l_PRICE_LIST_LINE_rec.last_update_date := NULL;
1389: END IF;
1390:
1391: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1392: l_PRICE_LIST_LINE_rec.last_update_login := NULL;
1393: END IF;
1394:
1395: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1391: IF l_PRICE_LIST_LINE_rec.last_update_login = FND_API.G_MISS_NUM THEN
1392: l_PRICE_LIST_LINE_rec.last_update_login := NULL;
1393: END IF;
1394:
1395: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1396: l_PRICE_LIST_LINE_rec.list_price := NULL;
1397: END IF;
1398:
1399: IF l_PRICE_LIST_LINE_rec.method_code = FND_API.G_MISS_CHAR THEN
1395: IF l_PRICE_LIST_LINE_rec.list_price = FND_API.G_MISS_NUM THEN
1396: l_PRICE_LIST_LINE_rec.list_price := NULL;
1397: END IF;
1398:
1399: IF l_PRICE_LIST_LINE_rec.method_code = FND_API.G_MISS_CHAR THEN
1400: l_PRICE_LIST_LINE_rec.method_code := NULL;
1401: END IF;
1402:
1403: IF l_PRICE_LIST_LINE_rec.price_list_id = FND_API.G_MISS_NUM THEN
1399: IF l_PRICE_LIST_LINE_rec.method_code = FND_API.G_MISS_CHAR THEN
1400: l_PRICE_LIST_LINE_rec.method_code := NULL;
1401: END IF;
1402:
1403: IF l_PRICE_LIST_LINE_rec.price_list_id = FND_API.G_MISS_NUM THEN
1404: l_PRICE_LIST_LINE_rec.price_list_id := NULL;
1405: END IF;
1406:
1407: IF l_PRICE_LIST_LINE_rec.price_list_line_id = FND_API.G_MISS_NUM THEN
1403: IF l_PRICE_LIST_LINE_rec.price_list_id = FND_API.G_MISS_NUM THEN
1404: l_PRICE_LIST_LINE_rec.price_list_id := NULL;
1405: END IF;
1406:
1407: IF l_PRICE_LIST_LINE_rec.price_list_line_id = FND_API.G_MISS_NUM THEN
1408: l_PRICE_LIST_LINE_rec.price_list_line_id := NULL;
1409: END IF;
1410:
1411: IF l_PRICE_LIST_LINE_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
1407: IF l_PRICE_LIST_LINE_rec.price_list_line_id = FND_API.G_MISS_NUM THEN
1408: l_PRICE_LIST_LINE_rec.price_list_line_id := NULL;
1409: END IF;
1410:
1411: IF l_PRICE_LIST_LINE_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
1412: l_PRICE_LIST_LINE_rec.pricing_attribute1 := NULL;
1413: END IF;
1414:
1415: IF l_PRICE_LIST_LINE_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
1411: IF l_PRICE_LIST_LINE_rec.pricing_attribute1 = FND_API.G_MISS_CHAR THEN
1412: l_PRICE_LIST_LINE_rec.pricing_attribute1 := NULL;
1413: END IF;
1414:
1415: IF l_PRICE_LIST_LINE_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
1416: l_PRICE_LIST_LINE_rec.pricing_attribute10 := NULL;
1417: END IF;
1418:
1419: IF l_PRICE_LIST_LINE_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
1415: IF l_PRICE_LIST_LINE_rec.pricing_attribute10 = FND_API.G_MISS_CHAR THEN
1416: l_PRICE_LIST_LINE_rec.pricing_attribute10 := NULL;
1417: END IF;
1418:
1419: IF l_PRICE_LIST_LINE_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
1420: l_PRICE_LIST_LINE_rec.pricing_attribute11 := NULL;
1421: END IF;
1422:
1423: IF l_PRICE_LIST_LINE_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
1419: IF l_PRICE_LIST_LINE_rec.pricing_attribute11 = FND_API.G_MISS_CHAR THEN
1420: l_PRICE_LIST_LINE_rec.pricing_attribute11 := NULL;
1421: END IF;
1422:
1423: IF l_PRICE_LIST_LINE_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
1424: l_PRICE_LIST_LINE_rec.pricing_attribute12 := NULL;
1425: END IF;
1426:
1427: IF l_PRICE_LIST_LINE_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
1423: IF l_PRICE_LIST_LINE_rec.pricing_attribute12 = FND_API.G_MISS_CHAR THEN
1424: l_PRICE_LIST_LINE_rec.pricing_attribute12 := NULL;
1425: END IF;
1426:
1427: IF l_PRICE_LIST_LINE_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
1428: l_PRICE_LIST_LINE_rec.pricing_attribute13 := NULL;
1429: END IF;
1430:
1431: IF l_PRICE_LIST_LINE_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
1427: IF l_PRICE_LIST_LINE_rec.pricing_attribute13 = FND_API.G_MISS_CHAR THEN
1428: l_PRICE_LIST_LINE_rec.pricing_attribute13 := NULL;
1429: END IF;
1430:
1431: IF l_PRICE_LIST_LINE_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
1432: l_PRICE_LIST_LINE_rec.pricing_attribute14 := NULL;
1433: END IF;
1434:
1435: IF l_PRICE_LIST_LINE_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
1431: IF l_PRICE_LIST_LINE_rec.pricing_attribute14 = FND_API.G_MISS_CHAR THEN
1432: l_PRICE_LIST_LINE_rec.pricing_attribute14 := NULL;
1433: END IF;
1434:
1435: IF l_PRICE_LIST_LINE_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
1436: l_PRICE_LIST_LINE_rec.pricing_attribute15 := NULL;
1437: END IF;
1438:
1439: IF l_PRICE_LIST_LINE_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
1435: IF l_PRICE_LIST_LINE_rec.pricing_attribute15 = FND_API.G_MISS_CHAR THEN
1436: l_PRICE_LIST_LINE_rec.pricing_attribute15 := NULL;
1437: END IF;
1438:
1439: IF l_PRICE_LIST_LINE_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
1440: l_PRICE_LIST_LINE_rec.pricing_attribute2 := NULL;
1441: END IF;
1442:
1443: IF l_PRICE_LIST_LINE_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
1439: IF l_PRICE_LIST_LINE_rec.pricing_attribute2 = FND_API.G_MISS_CHAR THEN
1440: l_PRICE_LIST_LINE_rec.pricing_attribute2 := NULL;
1441: END IF;
1442:
1443: IF l_PRICE_LIST_LINE_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
1444: l_PRICE_LIST_LINE_rec.pricing_attribute3 := NULL;
1445: END IF;
1446:
1447: IF l_PRICE_LIST_LINE_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
1443: IF l_PRICE_LIST_LINE_rec.pricing_attribute3 = FND_API.G_MISS_CHAR THEN
1444: l_PRICE_LIST_LINE_rec.pricing_attribute3 := NULL;
1445: END IF;
1446:
1447: IF l_PRICE_LIST_LINE_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
1448: l_PRICE_LIST_LINE_rec.pricing_attribute4 := NULL;
1449: END IF;
1450:
1451: IF l_PRICE_LIST_LINE_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
1447: IF l_PRICE_LIST_LINE_rec.pricing_attribute4 = FND_API.G_MISS_CHAR THEN
1448: l_PRICE_LIST_LINE_rec.pricing_attribute4 := NULL;
1449: END IF;
1450:
1451: IF l_PRICE_LIST_LINE_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
1452: l_PRICE_LIST_LINE_rec.pricing_attribute5 := NULL;
1453: END IF;
1454:
1455: IF l_PRICE_LIST_LINE_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
1451: IF l_PRICE_LIST_LINE_rec.pricing_attribute5 = FND_API.G_MISS_CHAR THEN
1452: l_PRICE_LIST_LINE_rec.pricing_attribute5 := NULL;
1453: END IF;
1454:
1455: IF l_PRICE_LIST_LINE_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
1456: l_PRICE_LIST_LINE_rec.pricing_attribute6 := NULL;
1457: END IF;
1458:
1459: IF l_PRICE_LIST_LINE_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
1455: IF l_PRICE_LIST_LINE_rec.pricing_attribute6 = FND_API.G_MISS_CHAR THEN
1456: l_PRICE_LIST_LINE_rec.pricing_attribute6 := NULL;
1457: END IF;
1458:
1459: IF l_PRICE_LIST_LINE_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
1460: l_PRICE_LIST_LINE_rec.pricing_attribute7 := NULL;
1461: END IF;
1462:
1463: IF l_PRICE_LIST_LINE_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
1459: IF l_PRICE_LIST_LINE_rec.pricing_attribute7 = FND_API.G_MISS_CHAR THEN
1460: l_PRICE_LIST_LINE_rec.pricing_attribute7 := NULL;
1461: END IF;
1462:
1463: IF l_PRICE_LIST_LINE_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
1464: l_PRICE_LIST_LINE_rec.pricing_attribute8 := NULL;
1465: END IF;
1466:
1467: IF l_PRICE_LIST_LINE_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
1463: IF l_PRICE_LIST_LINE_rec.pricing_attribute8 = FND_API.G_MISS_CHAR THEN
1464: l_PRICE_LIST_LINE_rec.pricing_attribute8 := NULL;
1465: END IF;
1466:
1467: IF l_PRICE_LIST_LINE_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
1468: l_PRICE_LIST_LINE_rec.pricing_attribute9 := NULL;
1469: END IF;
1470:
1471: IF l_PRICE_LIST_LINE_rec.pricing_context = FND_API.G_MISS_CHAR THEN
1467: IF l_PRICE_LIST_LINE_rec.pricing_attribute9 = FND_API.G_MISS_CHAR THEN
1468: l_PRICE_LIST_LINE_rec.pricing_attribute9 := NULL;
1469: END IF;
1470:
1471: IF l_PRICE_LIST_LINE_rec.pricing_context = FND_API.G_MISS_CHAR THEN
1472: l_PRICE_LIST_LINE_rec.pricing_context := NULL;
1473: END IF;
1474:
1475: IF l_PRICE_LIST_LINE_rec.pricing_rule_id = FND_API.G_MISS_NUM THEN
1471: IF l_PRICE_LIST_LINE_rec.pricing_context = FND_API.G_MISS_CHAR THEN
1472: l_PRICE_LIST_LINE_rec.pricing_context := NULL;
1473: END IF;
1474:
1475: IF l_PRICE_LIST_LINE_rec.pricing_rule_id = FND_API.G_MISS_NUM THEN
1476: l_PRICE_LIST_LINE_rec.pricing_rule_id := NULL;
1477: END IF;
1478:
1479: IF l_PRICE_LIST_LINE_rec.primary = FND_API.G_MISS_CHAR THEN
1475: IF l_PRICE_LIST_LINE_rec.pricing_rule_id = FND_API.G_MISS_NUM THEN
1476: l_PRICE_LIST_LINE_rec.pricing_rule_id := NULL;
1477: END IF;
1478:
1479: IF l_PRICE_LIST_LINE_rec.primary = FND_API.G_MISS_CHAR THEN
1480: l_PRICE_LIST_LINE_rec.primary := NULL;
1481: END IF;
1482:
1483: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1479: IF l_PRICE_LIST_LINE_rec.primary = FND_API.G_MISS_CHAR THEN
1480: l_PRICE_LIST_LINE_rec.primary := NULL;
1481: END IF;
1482:
1483: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1484: l_PRICE_LIST_LINE_rec.program_application_id := NULL;
1485: END IF;
1486:
1487: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1483: IF l_PRICE_LIST_LINE_rec.program_application_id = FND_API.G_MISS_NUM THEN
1484: l_PRICE_LIST_LINE_rec.program_application_id := NULL;
1485: END IF;
1486:
1487: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1488: l_PRICE_LIST_LINE_rec.program_id := NULL;
1489: END IF;
1490:
1491: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1487: IF l_PRICE_LIST_LINE_rec.program_id = FND_API.G_MISS_NUM THEN
1488: l_PRICE_LIST_LINE_rec.program_id := NULL;
1489: END IF;
1490:
1491: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1492: l_PRICE_LIST_LINE_rec.program_update_date := NULL;
1493: END IF;
1494:
1495: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1491: IF l_PRICE_LIST_LINE_rec.program_update_date = FND_API.G_MISS_DATE THEN
1492: l_PRICE_LIST_LINE_rec.program_update_date := NULL;
1493: END IF;
1494:
1495: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1496: l_PRICE_LIST_LINE_rec.reprice_flag := NULL;
1497: END IF;
1498:
1499: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1495: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
1496: l_PRICE_LIST_LINE_rec.reprice_flag := NULL;
1497: END IF;
1498:
1499: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1500: l_PRICE_LIST_LINE_rec.request_id := NULL;
1501: END IF;
1502:
1503: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1499: IF l_PRICE_LIST_LINE_rec.request_id = FND_API.G_MISS_NUM THEN
1500: l_PRICE_LIST_LINE_rec.request_id := NULL;
1501: END IF;
1502:
1503: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1504: l_PRICE_LIST_LINE_rec.revision := NULL;
1505: END IF;
1506:
1507: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1503: IF l_PRICE_LIST_LINE_rec.revision = FND_API.G_MISS_CHAR THEN
1504: l_PRICE_LIST_LINE_rec.revision := NULL;
1505: END IF;
1506:
1507: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1508: l_PRICE_LIST_LINE_rec.revision_date := NULL;
1509: END IF;
1510:
1511: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1507: IF l_PRICE_LIST_LINE_rec.revision_date = FND_API.G_MISS_DATE THEN
1508: l_PRICE_LIST_LINE_rec.revision_date := NULL;
1509: END IF;
1510:
1511: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1512: l_PRICE_LIST_LINE_rec.revision_reason_code := NULL;
1513: END IF;
1514:
1515: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1511: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
1512: l_PRICE_LIST_LINE_rec.revision_reason_code := NULL;
1513: END IF;
1514:
1515: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1516: l_PRICE_LIST_LINE_rec.start_date_active := NULL;
1517: END IF;
1518:
1519: IF l_PRICE_LIST_LINE_rec.unit_code = FND_API.G_MISS_CHAR THEN
1515: IF l_PRICE_LIST_LINE_rec.start_date_active = FND_API.G_MISS_DATE THEN
1516: l_PRICE_LIST_LINE_rec.start_date_active := NULL;
1517: END IF;
1518:
1519: IF l_PRICE_LIST_LINE_rec.unit_code = FND_API.G_MISS_CHAR THEN
1520: l_PRICE_LIST_LINE_rec.unit_code := NULL;
1521: END IF;
1522:
1523: RETURN l_PRICE_LIST_LINE_rec;
1605: , 'Update_Row'
1606: );
1607: END IF;
1608:
1609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1610:
1611: END Update_Row;
1612:
1613: -- Procedure Insert_Row
1816: EXCEPTION
1817:
1818: WHEN OTHERS THEN
1819:
1820: x_return_status := FND_API.G_RET_STS_ERROR;
1821:
1822: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1823: THEN
1824: OE_MSG_PUB.Add_Exc_Msg
1901: , 'Delete_Row'
1902: );
1903: END IF;
1904:
1905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1906:
1907: END Delete_Row;
1908:
1909: -- Function Query_Row
1927: --
1928:
1929: FUNCTION Query_Rows
1930: ( p_price_list_line_id IN NUMBER :=
1931: FND_API.G_MISS_NUM
1932: , p_price_list_id IN NUMBER :=
1933: FND_API.G_MISS_NUM
1934: ) RETURN OE_Price_List_PUB.Price_List_Line_Tbl_Type
1935: IS
1929: FUNCTION Query_Rows
1930: ( p_price_list_line_id IN NUMBER :=
1931: FND_API.G_MISS_NUM
1932: , p_price_list_id IN NUMBER :=
1933: FND_API.G_MISS_NUM
1934: ) RETURN OE_Price_List_PUB.Price_List_Line_Tbl_Type
1935: IS
1936: l_PRICE_LIST_LINE_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
1937: l_PRICE_LIST_LINE_tbl OE_Price_List_PUB.Price_List_Line_Tbl_Type;
2003:
2004: IF
2005: (p_price_list_line_id IS NOT NULL
2006: AND
2007: p_price_list_line_id <> FND_API.G_MISS_NUM)
2008: AND
2009: (p_price_list_id IS NOT NULL
2010: AND
2011: p_price_list_id <> FND_API.G_MISS_NUM)
2007: p_price_list_line_id <> FND_API.G_MISS_NUM)
2008: AND
2009: (p_price_list_id IS NOT NULL
2010: AND
2011: p_price_list_id <> FND_API.G_MISS_NUM)
2012: THEN
2013: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2014: THEN
2015: OE_MSG_PUB.Add_Exc_Msg
2019: );
2020: END IF;
2021:
2022: -- Geresh Temporary comment
2023: /* RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
2024:
2025: END IF;
2026:
2027:
2097:
2098: IF
2099: (p_price_list_line_id IS NOT NULL
2100: AND
2101: p_price_list_line_id <> FND_API.G_MISS_NUM)
2102: AND
2103: (l_PRICE_LIST_LINE_tbl.COUNT = 0)
2104: THEN
2105: RAISE NO_DATA_FOUND;
2111: RETURN l_PRICE_LIST_LINE_tbl;
2112:
2113: EXCEPTION
2114:
2115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2116:
2117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2118:
2119: WHEN OTHERS THEN
2113: EXCEPTION
2114:
2115: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2116:
2117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2118:
2119: WHEN OTHERS THEN
2120:
2121: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2125: , 'Query_Rows'
2126: );
2127: END IF;
2128:
2129: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2130:
2131: END Query_Rows;
2132:
2133:
2241: EXCEPTION
2242:
2243: WHEN NO_DATA_FOUND THEN
2244:
2245: x_return_status := FND_API.G_RET_STS_ERROR;
2246: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2247:
2248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2249: THEN
2242:
2243: WHEN NO_DATA_FOUND THEN
2244:
2245: x_return_status := FND_API.G_RET_STS_ERROR;
2246: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2247:
2248: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2249: THEN
2250:
2253:
2254: END IF;
2255: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2256:
2257: x_return_status := FND_API.G_RET_STS_ERROR;
2258: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2259:
2260: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2261: THEN
2254: END IF;
2255: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2256:
2257: x_return_status := FND_API.G_RET_STS_ERROR;
2258: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2259:
2260: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2261: THEN
2262:
2265:
2266: END IF;
2267: WHEN OTHERS THEN
2268:
2269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2270: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2271:
2272: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2273: THEN
2266: END IF;
2267: WHEN OTHERS THEN
2268:
2269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2270: x_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2271:
2272: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2273: THEN
2274: OE_MSG_PUB.Add_Exc_Msg
2295: BEGIN
2296:
2297: /*
2298: IF p_PRICE_LIST_LINE_rec.customer_item_id IS NOT NULL AND
2299: p_PRICE_LIST_LINE_rec.customer_item_id <> FND_API.G_MISS_NUM AND
2300: NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.customer_item_id,
2301: p_old_PRICE_LIST_LINE_rec.customer_item_id)
2302: THEN
2303:
2307: END IF;
2308: */
2309:
2310: IF p_PRICE_LIST_LINE_rec.inventory_item_id IS NOT NULL AND
2311: p_PRICE_LIST_LINE_rec.inventory_item_id <> FND_API.G_MISS_NUM AND
2312: NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.inventory_item_id,
2313: p_old_PRICE_LIST_LINE_rec.inventory_item_id)
2314: THEN
2315: l_PRICE_LIST_LINE_val_rec.inventory_item := OE_Id_To_Value.Inventory_Item
2317: );
2318: END IF;
2319:
2320: IF p_PRICE_LIST_LINE_rec.method_code IS NOT NULL AND
2321: p_PRICE_LIST_LINE_rec.method_code <> FND_API.G_MISS_CHAR AND
2322: NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.method_code,
2323: p_old_PRICE_LIST_LINE_rec.method_code)
2324: THEN
2325: l_PRICE_LIST_LINE_val_rec.method := OE_Id_To_Value.Method
2327: );
2328: END IF;
2329: /*
2330: IF p_PRICE_LIST_LINE_rec.price_list_id IS NOT NULL AND
2331: p_PRICE_LIST_LINE_rec.price_list_id <> FND_API.G_MISS_NUM AND
2332: NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_list_id,
2333: p_old_PRICE_LIST_LINE_rec.price_list_id)
2334: THEN
2335: l_PRICE_LIST_LINE_val_rec.price_list := OE_Id_To_Value.Price_List
2338: END IF;
2339: */
2340:
2341: IF p_PRICE_LIST_LINE_rec.price_list_line_id IS NOT NULL AND
2342: p_PRICE_LIST_LINE_rec.price_list_line_id <> FND_API.G_MISS_NUM AND
2343: NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.price_list_line_id,
2344: p_old_PRICE_LIST_LINE_rec.price_list_line_id)
2345: THEN
2346: l_PRICE_LIST_LINE_val_rec.price_list_line := OE_Id_To_Value.Price_List_Line
2348: );
2349: END IF;
2350:
2351: IF p_PRICE_LIST_LINE_rec.pricing_rule_id IS NOT NULL AND
2352: p_PRICE_LIST_LINE_rec.pricing_rule_id <> FND_API.G_MISS_NUM AND
2353: NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.pricing_rule_id,
2354: p_old_PRICE_LIST_LINE_rec.pricing_rule_id)
2355: THEN
2356: l_PRICE_LIST_LINE_val_rec.pricing_rule := OE_Id_To_Value.Pricing_Rule
2358: );
2359: END IF;
2360:
2361: IF p_PRICE_LIST_LINE_rec.reprice_flag IS NOT NULL AND
2362: p_PRICE_LIST_LINE_rec.reprice_flag <> FND_API.G_MISS_CHAR AND
2363: NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.reprice_flag,
2364: p_old_PRICE_LIST_LINE_rec.reprice_flag)
2365: THEN
2366: l_PRICE_LIST_LINE_val_rec.reprice := OE_Id_To_Value.Reprice
2368: );
2369: END IF;
2370:
2371: IF p_PRICE_LIST_LINE_rec.revision_reason_code IS NOT NULL AND
2372: p_PRICE_LIST_LINE_rec.revision_reason_code <> FND_API.G_MISS_CHAR AND
2373: NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.revision_reason_code,
2374: p_old_PRICE_LIST_LINE_rec.revision_reason_code)
2375: THEN
2376: l_PRICE_LIST_LINE_val_rec.revision_reason := OE_Id_To_Value.Revision_Reason
2378: );
2379: END IF;
2380:
2381: IF p_PRICE_LIST_LINE_rec.unit_code IS NOT NULL AND
2382: p_PRICE_LIST_LINE_rec.unit_code <> FND_API.G_MISS_CHAR AND
2383: NOT OE_GLOBALS.Equal(p_PRICE_LIST_LINE_rec.unit_code,
2384: p_old_PRICE_LIST_LINE_rec.unit_code)
2385: THEN
2386: l_PRICE_LIST_LINE_val_rec.unit := OE_Id_To_Value.Unit
2403: BEGIN
2404:
2405: -- initialize return_status.
2406:
2407: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_SUCCESS;
2408:
2409: -- initialize l_PRICE_LIST_LINE_rec.
2410:
2411: l_PRICE_LIST_LINE_rec := p_PRICE_LIST_LINE_rec;
2409: -- initialize l_PRICE_LIST_LINE_rec.
2410:
2411: l_PRICE_LIST_LINE_rec := p_PRICE_LIST_LINE_rec;
2412:
2413: IF p_PRICE_LIST_LINE_val_rec.customer_item <> FND_API.G_MISS_CHAR
2414: THEN
2415:
2416: IF p_PRICE_LIST_LINE_rec.customer_item_id <> FND_API.G_MISS_NUM THEN
2417:
2412:
2413: IF p_PRICE_LIST_LINE_val_rec.customer_item <> FND_API.G_MISS_CHAR
2414: THEN
2415:
2416: IF p_PRICE_LIST_LINE_rec.customer_item_id <> FND_API.G_MISS_NUM THEN
2417:
2418: l_PRICE_LIST_LINE_rec.customer_item_id := p_PRICE_LIST_LINE_rec.customer_item_id;
2419:
2420: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2433: ( p_customer_item => p_PRICE_LIST_LINE_val_rec.customer_item
2434: );
2435: */
2436:
2437: IF l_PRICE_LIST_LINE_rec.customer_item_id = FND_API.G_MISS_NUM THEN
2438: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2439: END IF;
2440:
2441: END IF;
2434: );
2435: */
2436:
2437: IF l_PRICE_LIST_LINE_rec.customer_item_id = FND_API.G_MISS_NUM THEN
2438: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2439: END IF;
2440:
2441: END IF;
2442:
2441: END IF;
2442:
2443: END IF;
2444:
2445: IF p_PRICE_LIST_LINE_val_rec.inventory_item <> FND_API.G_MISS_CHAR
2446: THEN
2447:
2448: IF p_PRICE_LIST_LINE_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
2449:
2444:
2445: IF p_PRICE_LIST_LINE_val_rec.inventory_item <> FND_API.G_MISS_CHAR
2446: THEN
2447:
2448: IF p_PRICE_LIST_LINE_rec.inventory_item_id <> FND_API.G_MISS_NUM THEN
2449:
2450: l_PRICE_LIST_LINE_rec.inventory_item_id := p_PRICE_LIST_LINE_rec.inventory_item_id;
2451:
2452: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2463: l_PRICE_LIST_LINE_rec.inventory_item_id := OE_Value_To_Id.inventory_item
2464: ( p_inventory_item => p_PRICE_LIST_LINE_val_rec.inventory_item
2465: );
2466:
2467: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
2468: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2469: END IF;
2470:
2471: END IF;
2464: ( p_inventory_item => p_PRICE_LIST_LINE_val_rec.inventory_item
2465: );
2466:
2467: IF l_PRICE_LIST_LINE_rec.inventory_item_id = FND_API.G_MISS_NUM THEN
2468: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2469: END IF;
2470:
2471: END IF;
2472:
2471: END IF;
2472:
2473: END IF;
2474:
2475: IF p_PRICE_LIST_LINE_val_rec.method <> FND_API.G_MISS_CHAR
2476: THEN
2477:
2478: IF p_PRICE_LIST_LINE_rec.method_code <> FND_API.G_MISS_CHAR THEN
2479:
2474:
2475: IF p_PRICE_LIST_LINE_val_rec.method <> FND_API.G_MISS_CHAR
2476: THEN
2477:
2478: IF p_PRICE_LIST_LINE_rec.method_code <> FND_API.G_MISS_CHAR THEN
2479:
2480: l_PRICE_LIST_LINE_rec.method_code := p_PRICE_LIST_LINE_rec.method_code;
2481:
2482: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2493: l_PRICE_LIST_LINE_rec.method_code := OE_Value_To_Id.method
2494: ( p_method => p_PRICE_LIST_LINE_val_rec.method
2495: );
2496:
2497: IF l_PRICE_LIST_LINE_rec.method_code = FND_API.G_MISS_CHAR THEN
2498: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2499: END IF;
2500:
2501: END IF;
2494: ( p_method => p_PRICE_LIST_LINE_val_rec.method
2495: );
2496:
2497: IF l_PRICE_LIST_LINE_rec.method_code = FND_API.G_MISS_CHAR THEN
2498: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2499: END IF;
2500:
2501: END IF;
2502:
2501: END IF;
2502:
2503: END IF;
2504:
2505: IF p_PRICE_LIST_LINE_val_rec.price_list <> FND_API.G_MISS_CHAR
2506: THEN
2507:
2508: IF p_PRICE_LIST_LINE_rec.price_list_id <> FND_API.G_MISS_NUM THEN
2509:
2504:
2505: IF p_PRICE_LIST_LINE_val_rec.price_list <> FND_API.G_MISS_CHAR
2506: THEN
2507:
2508: IF p_PRICE_LIST_LINE_rec.price_list_id <> FND_API.G_MISS_NUM THEN
2509:
2510: l_PRICE_LIST_LINE_rec.price_list_id := p_PRICE_LIST_LINE_rec.price_list_id;
2511:
2512: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2523: l_PRICE_LIST_LINE_rec.price_list_id := OE_Value_To_Id.price_list
2524: ( p_price_list => p_PRICE_LIST_LINE_val_rec.price_list
2525: );
2526:
2527: IF l_PRICE_LIST_LINE_rec.price_list_id = FND_API.G_MISS_NUM THEN
2528: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2529: END IF;
2530:
2531: END IF;
2524: ( p_price_list => p_PRICE_LIST_LINE_val_rec.price_list
2525: );
2526:
2527: IF l_PRICE_LIST_LINE_rec.price_list_id = FND_API.G_MISS_NUM THEN
2528: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2529: END IF;
2530:
2531: END IF;
2532:
2531: END IF;
2532:
2533: END IF;
2534:
2535: IF p_PRICE_LIST_LINE_val_rec.price_list_line <> FND_API.G_MISS_CHAR
2536: THEN
2537:
2538: IF p_PRICE_LIST_LINE_rec.price_list_line_id <> FND_API.G_MISS_NUM THEN
2539:
2534:
2535: IF p_PRICE_LIST_LINE_val_rec.price_list_line <> FND_API.G_MISS_CHAR
2536: THEN
2537:
2538: IF p_PRICE_LIST_LINE_rec.price_list_line_id <> FND_API.G_MISS_NUM THEN
2539:
2540: l_PRICE_LIST_LINE_rec.price_list_line_id := p_PRICE_LIST_LINE_rec.price_list_line_id;
2541:
2542: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2553: l_PRICE_LIST_LINE_rec.price_list_line_id := OE_Value_To_Id.price_list_line
2554: ( p_price_list_line => p_PRICE_LIST_LINE_val_rec.price_list_line
2555: );
2556:
2557: IF l_PRICE_LIST_LINE_rec.price_list_line_id = FND_API.G_MISS_NUM THEN
2558: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2559: END IF;
2560:
2561: END IF;
2554: ( p_price_list_line => p_PRICE_LIST_LINE_val_rec.price_list_line
2555: );
2556:
2557: IF l_PRICE_LIST_LINE_rec.price_list_line_id = FND_API.G_MISS_NUM THEN
2558: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2559: END IF;
2560:
2561: END IF;
2562:
2561: END IF;
2562:
2563: END IF;
2564:
2565: IF p_PRICE_LIST_LINE_val_rec.pricing_rule <> FND_API.G_MISS_CHAR
2566: THEN
2567:
2568: IF p_PRICE_LIST_LINE_rec.pricing_rule_id <> FND_API.G_MISS_NUM THEN
2569:
2564:
2565: IF p_PRICE_LIST_LINE_val_rec.pricing_rule <> FND_API.G_MISS_CHAR
2566: THEN
2567:
2568: IF p_PRICE_LIST_LINE_rec.pricing_rule_id <> FND_API.G_MISS_NUM THEN
2569:
2570: l_PRICE_LIST_LINE_rec.pricing_rule_id := p_PRICE_LIST_LINE_rec.pricing_rule_id;
2571:
2572: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2583: l_PRICE_LIST_LINE_rec.pricing_rule_id := OE_Value_To_Id.pricing_rule
2584: ( p_pricing_rule => p_PRICE_LIST_LINE_val_rec.pricing_rule
2585: );
2586:
2587: IF l_PRICE_LIST_LINE_rec.pricing_rule_id = FND_API.G_MISS_NUM THEN
2588: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2589: END IF;
2590:
2591: END IF;
2584: ( p_pricing_rule => p_PRICE_LIST_LINE_val_rec.pricing_rule
2585: );
2586:
2587: IF l_PRICE_LIST_LINE_rec.pricing_rule_id = FND_API.G_MISS_NUM THEN
2588: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2589: END IF;
2590:
2591: END IF;
2592:
2591: END IF;
2592:
2593: END IF;
2594:
2595: IF p_PRICE_LIST_LINE_val_rec.reprice <> FND_API.G_MISS_CHAR
2596: THEN
2597:
2598: IF p_PRICE_LIST_LINE_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN
2599:
2594:
2595: IF p_PRICE_LIST_LINE_val_rec.reprice <> FND_API.G_MISS_CHAR
2596: THEN
2597:
2598: IF p_PRICE_LIST_LINE_rec.reprice_flag <> FND_API.G_MISS_CHAR THEN
2599:
2600: l_PRICE_LIST_LINE_rec.reprice_flag := p_PRICE_LIST_LINE_rec.reprice_flag;
2601:
2602: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2613: l_PRICE_LIST_LINE_rec.reprice_flag := OE_Value_To_Id.reprice
2614: ( p_reprice => p_PRICE_LIST_LINE_val_rec.reprice
2615: );
2616:
2617: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
2618: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2619: END IF;
2620:
2621: END IF;
2614: ( p_reprice => p_PRICE_LIST_LINE_val_rec.reprice
2615: );
2616:
2617: IF l_PRICE_LIST_LINE_rec.reprice_flag = FND_API.G_MISS_CHAR THEN
2618: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2619: END IF;
2620:
2621: END IF;
2622:
2621: END IF;
2622:
2623: END IF;
2624:
2625: IF p_PRICE_LIST_LINE_val_rec.revision_reason <> FND_API.G_MISS_CHAR
2626: THEN
2627:
2628: IF p_PRICE_LIST_LINE_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
2629:
2624:
2625: IF p_PRICE_LIST_LINE_val_rec.revision_reason <> FND_API.G_MISS_CHAR
2626: THEN
2627:
2628: IF p_PRICE_LIST_LINE_rec.revision_reason_code <> FND_API.G_MISS_CHAR THEN
2629:
2630: l_PRICE_LIST_LINE_rec.revision_reason_code := p_PRICE_LIST_LINE_rec.revision_reason_code;
2631:
2632: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2643: l_PRICE_LIST_LINE_rec.revision_reason_code := OE_Value_To_Id.revision_reason
2644: ( p_revision_reason => p_PRICE_LIST_LINE_val_rec.revision_reason
2645: );
2646:
2647: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
2648: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2649: END IF;
2650:
2651: END IF;
2644: ( p_revision_reason => p_PRICE_LIST_LINE_val_rec.revision_reason
2645: );
2646:
2647: IF l_PRICE_LIST_LINE_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
2648: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2649: END IF;
2650:
2651: END IF;
2652:
2656: l_Price_LIST_LINE_rec.revision_reason_code := OE_Value_To_Id.revision_reason
2657: ( p_revision_reason => p_Price_LIST_LINE_val_rec.revision_reason
2658: );
2659:
2660: IF l_Price_LIST_Line_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
2661: l_Price_LIST_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
2662: END IF;
2663:
2664:
2657: ( p_revision_reason => p_Price_LIST_LINE_val_rec.revision_reason
2658: );
2659:
2660: IF l_Price_LIST_Line_rec.revision_reason_code = FND_API.G_MISS_CHAR THEN
2661: l_Price_LIST_Line_rec.return_status := FND_API.G_RET_STS_ERROR;
2662: END IF;
2663:
2664:
2665:
2664:
2665:
2666: END IF;
2667:
2668: IF p_PRICE_LIST_LINE_val_rec.unit <> FND_API.G_MISS_CHAR
2669: THEN
2670:
2671: IF p_PRICE_LIST_LINE_rec.unit_code <> FND_API.G_MISS_CHAR THEN
2672:
2667:
2668: IF p_PRICE_LIST_LINE_val_rec.unit <> FND_API.G_MISS_CHAR
2669: THEN
2670:
2671: IF p_PRICE_LIST_LINE_rec.unit_code <> FND_API.G_MISS_CHAR THEN
2672:
2673: l_PRICE_LIST_LINE_rec.unit_code := p_PRICE_LIST_LINE_rec.unit_code;
2674:
2675: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
2686: l_PRICE_LIST_LINE_rec.unit_code := OE_Value_To_Id.unit
2687: ( p_unit => p_PRICE_LIST_LINE_val_rec.unit
2688: );
2689:
2690: IF l_PRICE_LIST_LINE_rec.unit_code = FND_API.G_MISS_CHAR THEN
2691: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2692: END IF;
2693:
2694: END IF;
2687: ( p_unit => p_PRICE_LIST_LINE_val_rec.unit
2688: );
2689:
2690: IF l_PRICE_LIST_LINE_rec.unit_code = FND_API.G_MISS_CHAR THEN
2691: l_PRICE_LIST_LINE_rec.return_status := FND_API.G_RET_STS_ERROR;
2692: END IF;
2693:
2694: END IF;
2695:
2716: exception
2717:
2718: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
2719:
2720: x_return_status := FND_API.G_RET_STS_ERROR;
2721:
2722: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
2723: THEN
2724:
2729:
2730:
2731: WHEN OTHERS THEN
2732:
2733: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2734:
2735: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2736: THEN
2737: OE_MSG_PUB.Add_Exc_Msg
3294:
3295:
3296: END IF; /* If operation = 'INSERT' */
3297:
3298: x_return_status := FND_API.G_RET_STS_SUCCESS;
3299:
3300: exception
3301:
3302: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3300: exception
3301:
3302: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3303:
3304: x_return_status := FND_API.G_RET_STS_ERROR;
3305:
3306: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
3307: THEN
3308:
3313:
3314:
3315: WHEN OTHERS THEN
3316:
3317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3318:
3319: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3320: THEN
3321: OE_MSG_PUB.Add_Exc_Msg
3328: end maintain_pricing_attributes;
3329:
3330: FUNCTION Query_Pricing_Attributes
3331: ( p_pricing_attribute_id IN NUMBER :=
3332: FND_API.G_MISS_NUM
3333: , p_list_line_id IN NUMBER :=
3334: FND_API.G_MISS_NUM
3335: ) RETURN OE_Price_List_PUB.Pricing_Attr_Tbl_Type
3336: IS
3330: FUNCTION Query_Pricing_Attributes
3331: ( p_pricing_attribute_id IN NUMBER :=
3332: FND_API.G_MISS_NUM
3333: , p_list_line_id IN NUMBER :=
3334: FND_API.G_MISS_NUM
3335: ) RETURN OE_Price_List_PUB.Pricing_Attr_Tbl_Type
3336: IS
3337: l_PRICING_ATTR_rec OE_PRICE_LIST_PUB.Pricing_Attr_Rec_Type;
3338: l_PRICING_ATTR_tbl OE_PRICE_LIST_PUB.Pricing_Attr_Tbl_Type;
3384:
3385: BEGIN
3386:
3387: IF ( ( p_pricing_attribute_id is not null
3388: and p_pricing_attribute_id <> FND_API.G_MISS_NUM)
3389: or (p_list_line_id is not null
3390: and p_list_line_id <> FND_API.G_MISS_NUM ) ) THEN
3391:
3392: FOR l_implicit_rec IN l_PRICING_ATTR_csr LOOP
3386:
3387: IF ( ( p_pricing_attribute_id is not null
3388: and p_pricing_attribute_id <> FND_API.G_MISS_NUM)
3389: or (p_list_line_id is not null
3390: and p_list_line_id <> FND_API.G_MISS_NUM ) ) THEN
3391:
3392: FOR l_implicit_rec IN l_PRICING_ATTR_csr LOOP
3393:
3394: l_PRICING_ATTR_rec.accumulate_flag := l_implicit_rec.ACCUMULATE_FLAG;
3441:
3442: IF
3443: ( (p_pricing_attribute_id IS NOT NULL
3444: AND
3445: p_pricing_attribute_id <> FND_API.G_MISS_NUM)
3446: or
3447: (p_list_line_id IS NOT NULL
3448: AND
3449: p_list_line_id <> FND_API.G_MISS_NUM) )
3445: p_pricing_attribute_id <> FND_API.G_MISS_NUM)
3446: or
3447: (p_list_line_id IS NOT NULL
3448: AND
3449: p_list_line_id <> FND_API.G_MISS_NUM) )
3450: AND
3451: (l_PRICING_ATTR_tbl.COUNT = 0)
3452: THEN
3453: RAISE NO_DATA_FOUND;
3459: RETURN l_PRICING_ATTR_tbl;
3460:
3461: EXCEPTION
3462:
3463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3465:
3466: WHEN OTHERS THEN
3467:
3460:
3461: EXCEPTION
3462:
3463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3465:
3466: WHEN OTHERS THEN
3467:
3468: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3472: , 'Query_Rows'
3473: );
3474: END IF;
3475:
3476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3477:
3478: END Query_Pricing_Attributes;
3479:
3480: