95: 'Get_Currency'
96: );
97: END IF;
98:
99: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
100:
101:
102:
103: END Get_Currency;
172: 'Get_Price_List'
173: );
174: END IF;
175:
176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
177:
178:
179:
180: END Get_List_Header;
439: 'Get_Currency_Header'
440: );
441: END IF;
442:
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444:
445: END;
446: else
447: RETURN NULL;
503: 'Get_Rounding_Factor'
504: );
505: END IF;
506:
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508:
509: END Get_Rounding_Factor;
510:
511: FUNCTION Get_Ship_Method
545: 'Get_Start_Date_Active'
546: );
547: END IF;
548:
549: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
550:
551: END Get_Start_Date_Active;
552:
553: FUNCTION Get_Terms
628: BEGIN
629:
630: -- In the future call Flex APIs for defaults
631:
632: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
633: g_PRICE_LIST_rec.attribute1 := NULL;
634: END IF;
635:
636: IF g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
632: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR THEN
633: g_PRICE_LIST_rec.attribute1 := NULL;
634: END IF;
635:
636: IF g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
637: g_PRICE_LIST_rec.attribute10 := NULL;
638: END IF;
639:
640: IF g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
636: IF g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR THEN
637: g_PRICE_LIST_rec.attribute10 := NULL;
638: END IF;
639:
640: IF g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
641: g_PRICE_LIST_rec.attribute11 := NULL;
642: END IF;
643:
644: IF g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
640: IF g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR THEN
641: g_PRICE_LIST_rec.attribute11 := NULL;
642: END IF;
643:
644: IF g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
645: g_PRICE_LIST_rec.attribute12 := NULL;
646: END IF;
647:
648: IF g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
644: IF g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR THEN
645: g_PRICE_LIST_rec.attribute12 := NULL;
646: END IF;
647:
648: IF g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
649: g_PRICE_LIST_rec.attribute13 := NULL;
650: END IF;
651:
652: IF g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
648: IF g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR THEN
649: g_PRICE_LIST_rec.attribute13 := NULL;
650: END IF;
651:
652: IF g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
653: g_PRICE_LIST_rec.attribute14 := NULL;
654: END IF;
655:
656: IF g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
652: IF g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR THEN
653: g_PRICE_LIST_rec.attribute14 := NULL;
654: END IF;
655:
656: IF g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
657: g_PRICE_LIST_rec.attribute15 := NULL;
658: END IF;
659:
660: IF g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
656: IF g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR THEN
657: g_PRICE_LIST_rec.attribute15 := NULL;
658: END IF;
659:
660: IF g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
661: g_PRICE_LIST_rec.attribute2 := NULL;
662: END IF;
663:
664: IF g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
660: IF g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR THEN
661: g_PRICE_LIST_rec.attribute2 := NULL;
662: END IF;
663:
664: IF g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
665: g_PRICE_LIST_rec.attribute3 := NULL;
666: END IF;
667:
668: IF g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
664: IF g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR THEN
665: g_PRICE_LIST_rec.attribute3 := NULL;
666: END IF;
667:
668: IF g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
669: g_PRICE_LIST_rec.attribute4 := NULL;
670: END IF;
671:
672: IF g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
668: IF g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR THEN
669: g_PRICE_LIST_rec.attribute4 := NULL;
670: END IF;
671:
672: IF g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
673: g_PRICE_LIST_rec.attribute5 := NULL;
674: END IF;
675:
676: IF g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
672: IF g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR THEN
673: g_PRICE_LIST_rec.attribute5 := NULL;
674: END IF;
675:
676: IF g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
677: g_PRICE_LIST_rec.attribute6 := NULL;
678: END IF;
679:
680: IF g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
676: IF g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR THEN
677: g_PRICE_LIST_rec.attribute6 := NULL;
678: END IF;
679:
680: IF g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
681: g_PRICE_LIST_rec.attribute7 := NULL;
682: END IF;
683:
684: IF g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
680: IF g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR THEN
681: g_PRICE_LIST_rec.attribute7 := NULL;
682: END IF;
683:
684: IF g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
685: g_PRICE_LIST_rec.attribute8 := NULL;
686: END IF;
687:
688: IF g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
684: IF g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR THEN
685: g_PRICE_LIST_rec.attribute8 := NULL;
686: END IF;
687:
688: IF g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
689: g_PRICE_LIST_rec.attribute9 := NULL;
690: END IF;
691:
692: IF g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
688: IF g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR THEN
689: g_PRICE_LIST_rec.attribute9 := NULL;
690: END IF;
691:
692: IF g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR THEN
693: g_PRICE_LIST_rec.context := NULL;
694: END IF;
695:
696: END Get_Flex_Price_List;
720: oe_msg_pub.Add;
721:
722: END IF;
723:
724: RAISE FND_API.G_EXC_ERROR;
725:
726: END IF;
727:
728: -- Initialize g_PRICE_LIST_rec
730: g_PRICE_LIST_rec := p_PRICE_LIST_rec;
731:
732: -- Default missing attributes.
733:
734: IF g_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR THEN
735:
736: g_PRICE_LIST_rec.automatic_flag := Get_Automatic;
737:
738: IF g_PRICE_LIST_rec.automatic_flag IS NOT NULL THEN
752: END IF;
753:
754: END IF;
755:
756: IF g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR THEN
757:
758: g_PRICE_LIST_rec.comments := Get_Comments;
759:
760: IF g_PRICE_LIST_rec.comments IS NOT NULL THEN
774: END IF;
775:
776: END IF;
777:
778: IF g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR THEN
779:
780: g_PRICE_LIST_rec.currency_code := Get_Currency;
781:
782: IF g_PRICE_LIST_rec.currency_code IS NOT NULL THEN
796: END IF;
797:
798: END IF;
799:
800: IF g_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR THEN
801:
802: g_PRICE_LIST_rec.discount_lines_flag := Get_Discount_Lines;
803:
804: IF g_PRICE_LIST_rec.discount_lines_flag IS NOT NULL THEN
818: END IF;
819:
820: END IF;
821:
822: IF g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE THEN
823:
824: g_PRICE_LIST_rec.end_date_active := Get_End_Date_Active;
825:
826: IF g_PRICE_LIST_rec.end_date_active IS NOT NULL THEN
840: END IF;
841:
842: END IF;
843:
844: IF g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN
845:
846: g_PRICE_LIST_rec.freight_terms_code := Get_Freight_Terms;
847:
848: IF g_PRICE_LIST_rec.freight_terms_code IS NOT NULL THEN
862: END IF;
863:
864: END IF;
865:
866: IF g_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR THEN
867:
868: g_PRICE_LIST_rec.gsa_indicator := Get_Gsa_Indicator;
869:
870: IF g_PRICE_LIST_rec.gsa_indicator IS NOT NULL THEN
884: END IF;
885:
886: END IF;
887:
888: IF g_PRICE_LIST_rec.active_flag = FND_API.G_MISS_CHAR THEN
889: g_PRICE_LIST_rec.active_flag := Get_Active_Flag;
890: IF g_PRICE_LIST_rec.active_flag IS NOT NULL THEN
891: IF QP_Validate.active(g_PRICE_LIST_rec.active_flag)
892: THEN
901: END IF;
902: END IF;
903:
904: -- mkarya for bug 1944882
905: IF g_PRICE_LIST_rec.mobile_download = FND_API.G_MISS_CHAR THEN
906: g_PRICE_LIST_rec.mobile_download := Get_Mobile_Download;
907: IF g_PRICE_LIST_rec.mobile_download IS NOT NULL THEN
908: IF QP_Validate.mobile_download(g_PRICE_LIST_rec.mobile_download)
909: THEN
918: END IF;
919: END IF;
920:
921: -- Pricing Security gtippire
922: IF g_PRICE_LIST_rec.global_flag = FND_API.G_MISS_CHAR THEN
923: g_PRICE_LIST_rec.global_flag := Get_Global_Flag;
924: IF g_PRICE_LIST_rec.global_flag IS NOT NULL THEN
925: IF QP_Validate.global_flag(g_PRICE_LIST_rec.global_flag)
926: THEN
936: END IF;
937:
938:
939: -- Attributes Manager Giri
940: IF g_PRICE_LIST_rec.pte_code = FND_API.G_MISS_CHAR THEN
941: g_PRICE_LIST_rec.pte_code := Get_Pte;
942: IF g_PRICE_LIST_rec.pte_code IS NOT NULL THEN
943: IF QP_Validate.pte(g_PRICE_LIST_rec.pte_code)
944: THEN
953: END IF;
954: END IF;
955:
956:
957: IF g_PRICE_LIST_rec.name = FND_API.G_MISS_CHAR THEN
958:
959: g_PRICE_LIST_rec.name := Get_Name;
960:
961: IF g_PRICE_LIST_rec.name IS NOT NULL THEN
975: END IF;
976:
977: END IF;
978:
979: IF g_PRICE_LIST_rec.description = FND_API.G_MISS_CHAR THEN
980:
981: g_PRICE_LIST_rec.description := Get_Description;
982:
983: IF g_PRICE_LIST_rec.description IS NOT NULL THEN
997: END IF;
998:
999: END IF;
1000:
1001: IF g_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM THEN
1002:
1003: g_PRICE_LIST_rec.list_header_id := Get_List_Header;
1004:
1005: IF g_PRICE_LIST_rec.list_header_id IS NOT NULL THEN
1019: END IF;
1020:
1021: END IF;
1022:
1023: IF g_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR THEN
1024:
1025: g_PRICE_LIST_rec.list_type_code := Get_List_Type;
1026:
1027: IF g_PRICE_LIST_rec.list_type_code IS NOT NULL THEN
1041: END IF;
1042:
1043: END IF;
1044:
1045: IF g_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR THEN
1046:
1047: g_PRICE_LIST_rec.version_no := Get_Version;
1048:
1049: IF g_PRICE_LIST_rec.version_no IS NOT NULL THEN
1063: END IF;
1064:
1065: END IF;
1066:
1067: IF g_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR THEN
1068:
1069: g_PRICE_LIST_rec.prorate_flag := Get_Prorate;
1070:
1071: IF g_PRICE_LIST_rec.prorate_flag IS NOT NULL THEN
1085: END IF;
1086:
1087: END IF;
1088:
1089: IF g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM THEN
1090:
1091: g_PRICE_LIST_rec.rounding_factor := Get_Rounding_Factor;
1092:
1093: IF g_PRICE_LIST_rec.rounding_factor IS NOT NULL THEN
1108:
1109: END IF;
1110:
1111: -- Multi-Currency SunilPandey
1112: IF g_PRICE_LIST_rec.currency_header_id = FND_API.G_MISS_NUM THEN
1113: g_PRICE_LIST_rec.currency_header_id := Get_Currency_Header;
1114: IF g_PRICE_LIST_rec.currency_header_id IS NOT NULL THEN
1115: IF QP_Validate.currency_header(g_PRICE_LIST_rec.currency_header_id)
1116: THEN
1124: END IF;
1125: END IF;
1126: END IF;
1127:
1128: IF g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR THEN
1129:
1130: g_PRICE_LIST_rec.ship_method_code := Get_Ship_Method;
1131:
1132: IF g_PRICE_LIST_rec.ship_method_code IS NOT NULL THEN
1146: END IF;
1147:
1148: END IF;
1149:
1150: IF g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE THEN
1151:
1152: g_PRICE_LIST_rec.start_date_active := Get_Start_Date_Active;
1153:
1154: /*
1173: */
1174:
1175: END IF;
1176:
1177: IF g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM THEN
1178:
1179: oe_debug_pub.add('defaulting terms id');
1180: g_PRICE_LIST_rec.terms_id := Get_Terms;
1181:
1198:
1199: END IF;
1200:
1201: --Blanket Sales Order
1202: IF g_PRICE_LIST_rec.list_source_code = FND_API.G_MISS_CHAR THEN
1203:
1204: g_PRICE_LIST_REC.list_source_code := Get_List_Source_Code;
1205:
1206: IF g_PRICE_LIST_REC.list_source_code IS NOT NULL THEN
1221: END IF;
1222:
1223:
1224: --Blanket Sales Order
1225: IF g_PRICE_LIST_rec.orig_system_header_ref = FND_API.G_MISS_CHAR THEN
1226:
1227: g_PRICE_LIST_REC.orig_system_header_ref := Get_Orig_System_Header_ref;
1228:
1229: /* IF g_PRICE_LIST_REC.orig_system_header_ref IS NOT NULL THEN
1243: */
1244: END IF;
1245:
1246: --Blanket pricing
1247: IF g_PRICE_LIST_rec.source_system_code = FND_API.G_MISS_CHAR THEN
1248:
1249: g_PRICE_LIST_REC.source_system_code := Get_Source_System_Code;
1250:
1251: IF g_PRICE_LIST_REC.source_system_code IS NOT NULL THEN
1264:
1265: END IF;
1266: END IF;
1267:
1268: IF g_PRICE_LIST_rec.shareable_flag = FND_API.G_MISS_CHAR THEN
1269:
1270: g_PRICE_LIST_REC.shareable_flag := Get_Shareable_Flag;
1271:
1272: IF g_PRICE_LIST_REC.shareable_flag IS NOT NULL THEN
1286: END IF;
1287: END IF;
1288:
1289:
1290: IF g_PRICE_LIST_rec.sold_to_org_id = FND_API.G_MISS_NUM THEN
1291:
1292: g_PRICE_LIST_REC.sold_to_org_id := Get_Sold_To_Org_Id;
1293:
1294: IF g_PRICE_LIST_REC.sold_to_org_id IS NOT NULL THEN
1307:
1308: END IF;
1309: END IF;
1310:
1311: IF g_PRICE_LIST_rec.locked_from_list_header_id = FND_API.G_MISS_NUM THEN
1312:
1313: g_PRICE_LIST_REC.locked_from_list_header_id := Get_Locked_From_List_Header_Id;
1314:
1315: IF g_PRICE_LIST_REC.locked_from_list_header_id IS NOT NULL THEN
1329: END IF;
1330: END IF;
1331:
1332: --added for MOAC
1333: IF g_PRICE_LIST_rec.org_id = FND_API.G_MISS_NUM THEN
1334:
1335: IF g_PRICE_LIST_rec.global_flag = 'N' THEN
1336: --global_flag defaulting happens before org_id defaulting
1337: g_PRICE_LIST_REC.org_id := Get_Org_Id;
1356:
1357: END IF;
1358: END IF;
1359:
1360: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
1361: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
1362: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
1363: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1364: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1357: END IF;
1358: END IF;
1359:
1360: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
1361: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
1362: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
1363: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1364: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1365: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1358: END IF;
1359:
1360: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
1361: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
1362: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
1363: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1364: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1365: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1366: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1359:
1360: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
1361: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
1362: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
1363: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1364: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1365: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1366: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1367: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1360: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
1361: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
1362: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
1363: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1364: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1365: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1366: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1367: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1368: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1361: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
1362: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
1363: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1364: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1365: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1366: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1367: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1368: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1369: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1362: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
1363: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1364: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1365: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1366: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1367: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1368: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1369: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1370: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1363: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1364: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1365: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1366: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1367: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1368: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1369: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1370: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1371: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1364: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1365: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1366: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1367: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1368: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1369: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1370: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1371: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1372: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1365: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1366: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1367: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1368: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1369: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1370: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1371: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1372: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1373: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1366: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1367: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1368: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1369: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1370: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1371: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1372: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1373: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1374: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1367: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1368: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1369: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1370: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1371: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1372: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1373: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1374: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1375: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
1368: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1369: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1370: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1371: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1372: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1373: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1374: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1375: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
1376: THEN
1369: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1370: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1371: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1372: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1373: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1374: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1375: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
1376: THEN
1377:
1370: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1371: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1372: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1373: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1374: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1375: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
1376: THEN
1377:
1378: oe_debug_Pub.add('getting flex field info');
1371: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1372: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1373: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1374: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1375: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
1376: THEN
1377:
1378: oe_debug_Pub.add('getting flex field info');
1379:
1381: oe_debug_Pub.add('after getting flex field');
1382:
1383: END IF;
1384:
1385: IF g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM THEN
1386:
1387: g_PRICE_LIST_rec.created_by := NULL;
1388:
1389: END IF;
1387: g_PRICE_LIST_rec.created_by := NULL;
1388:
1389: END IF;
1390:
1391: IF g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE THEN
1392:
1393: g_PRICE_LIST_rec.creation_date := NULL;
1394:
1395: END IF;
1393: g_PRICE_LIST_rec.creation_date := NULL;
1394:
1395: END IF;
1396:
1397: IF g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM THEN
1398:
1399: g_PRICE_LIST_rec.last_updated_by := NULL;
1400:
1401: END IF;
1399: g_PRICE_LIST_rec.last_updated_by := NULL;
1400:
1401: END IF;
1402:
1403: IF g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE THEN
1404:
1405: g_PRICE_LIST_rec.last_update_date := NULL;
1406:
1407: END IF;
1405: g_PRICE_LIST_rec.last_update_date := NULL;
1406:
1407: END IF;
1408:
1409: IF g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM THEN
1410:
1411: g_PRICE_LIST_rec.last_update_login := NULL;
1412:
1413: END IF;
1411: g_PRICE_LIST_rec.last_update_login := NULL;
1412:
1413: END IF;
1414:
1415: IF g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM THEN
1416:
1417: g_PRICE_LIST_rec.program_application_id := NULL;
1418:
1419: END IF;
1417: g_PRICE_LIST_rec.program_application_id := NULL;
1418:
1419: END IF;
1420:
1421: IF g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM THEN
1422:
1423: g_PRICE_LIST_rec.program_id := NULL;
1424:
1425: END IF;
1423: g_PRICE_LIST_rec.program_id := NULL;
1424:
1425: END IF;
1426:
1427: IF g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE THEN
1428:
1429: g_PRICE_LIST_rec.program_update_date := NULL;
1430:
1431: END IF;
1429: g_PRICE_LIST_rec.program_update_date := NULL;
1430:
1431: END IF;
1432:
1433: IF g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM THEN
1434:
1435: g_PRICE_LIST_rec.request_id := NULL;
1436:
1437: END IF;
1437: END IF;
1438:
1439: -- Redefault if there are any missing attributes.
1440:
1441: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
1442: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
1443: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
1444: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1445: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1438:
1439: -- Redefault if there are any missing attributes.
1440:
1441: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
1442: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
1443: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
1444: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1445: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1446: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1439: -- Redefault if there are any missing attributes.
1440:
1441: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
1442: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
1443: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
1444: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1445: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1446: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1447: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1440:
1441: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
1442: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
1443: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
1444: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1445: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1446: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1447: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1448: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1441: IF g_PRICE_LIST_rec.attribute1 = FND_API.G_MISS_CHAR
1442: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
1443: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
1444: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1445: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1446: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1447: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1448: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1449: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1442: OR g_PRICE_LIST_rec.attribute10 = FND_API.G_MISS_CHAR
1443: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
1444: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1445: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1446: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1447: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1448: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1449: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1450: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1443: OR g_PRICE_LIST_rec.attribute11 = FND_API.G_MISS_CHAR
1444: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1445: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1446: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1447: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1448: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1449: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1450: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1451: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1444: OR g_PRICE_LIST_rec.attribute12 = FND_API.G_MISS_CHAR
1445: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1446: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1447: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1448: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1449: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1450: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1451: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1452: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1445: OR g_PRICE_LIST_rec.attribute13 = FND_API.G_MISS_CHAR
1446: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1447: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1448: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1449: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1450: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1451: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1452: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1453: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1446: OR g_PRICE_LIST_rec.attribute14 = FND_API.G_MISS_CHAR
1447: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1448: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1449: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1450: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1451: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1452: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1453: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1454: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1447: OR g_PRICE_LIST_rec.attribute15 = FND_API.G_MISS_CHAR
1448: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1449: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1450: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1451: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1452: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1453: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1454: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1455: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1448: OR g_PRICE_LIST_rec.attribute2 = FND_API.G_MISS_CHAR
1449: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1450: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1451: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1452: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1453: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1454: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1455: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1456: OR g_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR
1449: OR g_PRICE_LIST_rec.attribute3 = FND_API.G_MISS_CHAR
1450: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1451: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1452: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1453: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1454: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1455: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1456: OR g_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR
1457: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
1450: OR g_PRICE_LIST_rec.attribute4 = FND_API.G_MISS_CHAR
1451: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1452: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1453: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1454: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1455: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1456: OR g_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR
1457: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
1458: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
1451: OR g_PRICE_LIST_rec.attribute5 = FND_API.G_MISS_CHAR
1452: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1453: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1454: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1455: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1456: OR g_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR
1457: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
1458: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
1459: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
1452: OR g_PRICE_LIST_rec.attribute6 = FND_API.G_MISS_CHAR
1453: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1454: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1455: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1456: OR g_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR
1457: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
1458: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
1459: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
1460: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
1453: OR g_PRICE_LIST_rec.attribute7 = FND_API.G_MISS_CHAR
1454: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1455: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1456: OR g_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR
1457: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
1458: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
1459: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
1460: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
1461: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
1454: OR g_PRICE_LIST_rec.attribute8 = FND_API.G_MISS_CHAR
1455: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1456: OR g_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR
1457: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
1458: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
1459: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
1460: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
1461: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
1462: OR g_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR
1455: OR g_PRICE_LIST_rec.attribute9 = FND_API.G_MISS_CHAR
1456: OR g_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR
1457: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
1458: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
1459: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
1460: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
1461: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
1462: OR g_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR
1463: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
1456: OR g_PRICE_LIST_rec.automatic_flag = FND_API.G_MISS_CHAR
1457: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
1458: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
1459: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
1460: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
1461: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
1462: OR g_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR
1463: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
1464: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
1457: OR g_PRICE_LIST_rec.comments = FND_API.G_MISS_CHAR
1458: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
1459: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
1460: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
1461: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
1462: OR g_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR
1463: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
1464: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
1465: OR g_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR
1458: OR g_PRICE_LIST_rec.context = FND_API.G_MISS_CHAR
1459: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
1460: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
1461: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
1462: OR g_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR
1463: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
1464: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
1465: OR g_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR
1466: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
1459: OR g_PRICE_LIST_rec.created_by = FND_API.G_MISS_NUM
1460: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
1461: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
1462: OR g_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR
1463: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
1464: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
1465: OR g_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR
1466: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
1467: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
1460: OR g_PRICE_LIST_rec.creation_date = FND_API.G_MISS_DATE
1461: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
1462: OR g_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR
1463: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
1464: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
1465: OR g_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR
1466: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
1467: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
1468: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
1461: OR g_PRICE_LIST_rec.currency_code = FND_API.G_MISS_CHAR
1462: OR g_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR
1463: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
1464: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
1465: OR g_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR
1466: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
1467: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
1468: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
1469: OR g_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM
1462: OR g_PRICE_LIST_rec.discount_lines_flag = FND_API.G_MISS_CHAR
1463: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
1464: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
1465: OR g_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR
1466: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
1467: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
1468: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
1469: OR g_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM
1470: OR g_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR
1463: OR g_PRICE_LIST_rec.end_date_active = FND_API.G_MISS_DATE
1464: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
1465: OR g_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR
1466: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
1467: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
1468: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
1469: OR g_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM
1470: OR g_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR
1471: OR g_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR
1464: OR g_PRICE_LIST_rec.freight_terms_code = FND_API.G_MISS_CHAR
1465: OR g_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR
1466: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
1467: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
1468: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
1469: OR g_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM
1470: OR g_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR
1471: OR g_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR
1472: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
1465: OR g_PRICE_LIST_rec.gsa_indicator = FND_API.G_MISS_CHAR
1466: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
1467: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
1468: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
1469: OR g_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM
1470: OR g_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR
1471: OR g_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR
1472: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
1473: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
1466: OR g_PRICE_LIST_rec.last_updated_by = FND_API.G_MISS_NUM
1467: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
1468: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
1469: OR g_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM
1470: OR g_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR
1471: OR g_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR
1472: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
1473: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
1474: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
1467: OR g_PRICE_LIST_rec.last_update_date = FND_API.G_MISS_DATE
1468: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
1469: OR g_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM
1470: OR g_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR
1471: OR g_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR
1472: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
1473: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
1474: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
1475: OR g_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR
1468: OR g_PRICE_LIST_rec.last_update_login = FND_API.G_MISS_NUM
1469: OR g_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM
1470: OR g_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR
1471: OR g_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR
1472: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
1473: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
1474: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
1475: OR g_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR
1476: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
1469: OR g_PRICE_LIST_rec.list_header_id = FND_API.G_MISS_NUM
1470: OR g_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR
1471: OR g_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR
1472: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
1473: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
1474: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
1475: OR g_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR
1476: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
1477: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
1470: OR g_PRICE_LIST_rec.list_type_code = FND_API.G_MISS_CHAR
1471: OR g_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR
1472: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
1473: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
1474: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
1475: OR g_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR
1476: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
1477: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
1478: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
1471: OR g_PRICE_LIST_rec.version_no = FND_API.G_MISS_CHAR
1472: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
1473: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
1474: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
1475: OR g_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR
1476: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
1477: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
1478: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
1479: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
1472: OR g_PRICE_LIST_rec.program_application_id = FND_API.G_MISS_NUM
1473: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
1474: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
1475: OR g_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR
1476: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
1477: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
1478: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
1479: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
1480: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
1473: OR g_PRICE_LIST_rec.program_id = FND_API.G_MISS_NUM
1474: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
1475: OR g_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR
1476: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
1477: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
1478: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
1479: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
1480: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
1481: THEN
1474: OR g_PRICE_LIST_rec.program_update_date = FND_API.G_MISS_DATE
1475: OR g_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR
1476: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
1477: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
1478: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
1479: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
1480: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
1481: THEN
1482:
1475: OR g_PRICE_LIST_rec.prorate_flag = FND_API.G_MISS_CHAR
1476: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
1477: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
1478: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
1479: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
1480: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
1481: THEN
1482:
1483: oe_debug_pub.add('redefault attributes 1');
1476: OR g_PRICE_LIST_rec.request_id = FND_API.G_MISS_NUM
1477: OR g_PRICE_LIST_rec.rounding_factor = FND_API.G_MISS_NUM
1478: OR g_PRICE_LIST_rec.ship_method_code = FND_API.G_MISS_CHAR
1479: OR g_PRICE_LIST_rec.start_date_active = FND_API.G_MISS_DATE
1480: OR g_PRICE_LIST_rec.terms_id = FND_API.G_MISS_NUM
1481: THEN
1482:
1483: oe_debug_pub.add('redefault attributes 1');
1484: