eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_DEFAULT_BOM_COMPONENT dependencies on FND_API

Line 223: AND g_rev_component_rec.inverse_quantity <> FND_API.G_MISS_NUM)

219: l_Assembly_Item_Id NUMBER;
220: l_Organization_Id NUMBER;
221: BEGIN
222: IF (g_rev_component_rec.inverse_quantity IS NOT NULL
223: AND g_rev_component_rec.inverse_quantity <> FND_API.G_MISS_NUM)
224: THEN
225: IF (g_rev_component_rec.inverse_quantity = 0)
226: THEN
227: l_component_quantity := 0;

Line 523: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN

519: BEGIN
520:
521: -- In the future call Flex APIs for defaults
522:
523: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
524: g_rev_component_rec.attribute_category := NULL;
525: END IF;
526:
527: IF g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 527: IF g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

523: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
524: g_rev_component_rec.attribute_category := NULL;
525: END IF;
526:
527: IF g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
528: g_rev_component_rec.attribute1 := NULL;
529: END IF;
530:
531: IF g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 531: IF g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

527: IF g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
528: g_rev_component_rec.attribute1 := NULL;
529: END IF;
530:
531: IF g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
532: g_rev_component_rec.attribute2 := NULL;
533: END IF;
534:
535: IF g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 535: IF g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

531: IF g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
532: g_rev_component_rec.attribute2 := NULL;
533: END IF;
534:
535: IF g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
536: g_rev_component_rec.attribute3 := NULL;
537: END IF;
538:
539: IF g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 539: IF g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

535: IF g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
536: g_rev_component_rec.attribute3 := NULL;
537: END IF;
538:
539: IF g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
540: g_rev_component_rec.attribute4 := NULL;
541: END IF;
542:
543: IF g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 543: IF g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

539: IF g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
540: g_rev_component_rec.attribute4 := NULL;
541: END IF;
542:
543: IF g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
544: g_rev_component_rec.attribute5 := NULL;
545: END IF;
546:
547: IF g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 547: IF g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

543: IF g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
544: g_rev_component_rec.attribute5 := NULL;
545: END IF;
546:
547: IF g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
548: g_rev_component_rec.attribute6 := NULL;
549: END IF;
550:
551: IF g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 551: IF g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

547: IF g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
548: g_rev_component_rec.attribute6 := NULL;
549: END IF;
550:
551: IF g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
552: g_rev_component_rec.attribute7 := NULL;
553: END IF;
554:
555: IF g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 555: IF g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

551: IF g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
552: g_rev_component_rec.attribute7 := NULL;
553: END IF;
554:
555: IF g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
556: g_rev_component_rec.attribute8 := NULL;
557: END IF;
558:
559: IF g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 559: IF g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

555: IF g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
556: g_rev_component_rec.attribute8 := NULL;
557: END IF;
558:
559: IF g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
560: g_rev_component_rec.attribute9 := NULL;
561: END IF;
562:
563: IF g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 563: IF g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

559: IF g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
560: g_rev_component_rec.attribute9 := NULL;
561: END IF;
562:
563: IF g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
564: g_rev_component_rec.attribute10 := NULL;
565: END IF;
566:
567: IF g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 567: IF g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

563: IF g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
564: g_rev_component_rec.attribute10 := NULL;
565: END IF;
566:
567: IF g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
568: g_rev_component_rec.attribute11 := NULL;
569: END IF;
570:
571: IF g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 571: IF g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN

567: IF g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
568: g_rev_component_rec.attribute11 := NULL;
569: END IF;
570:
571: IF g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
572: g_rev_component_rec.attribute12 := NULL;
573: END IF;
574:
575: IF g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 575: IF g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN

571: IF g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
572: g_rev_component_rec.attribute12 := NULL;
573: END IF;
574:
575: IF g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
576: g_rev_component_rec.attribute13 := NULL;
577: END IF;
578:
579: IF g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 579: IF g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN

575: IF g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
576: g_rev_component_rec.attribute13 := NULL;
577: END IF;
578:
579: IF g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
580: g_rev_component_rec.attribute14 := NULL;
581: END IF;
582:
583: IF g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 583: IF g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN

579: IF g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
580: g_rev_component_rec.attribute14 := NULL;
581: END IF;
582:
583: IF g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
584: g_rev_component_rec.attribute15 := NULL;
585: END IF;
586:
587: END Get_Flex_Rev_Component;

Line 660: x_return_status := fnd_api.g_ret_sts_success;

656:
657: g_rev_component_rec := p_rev_component_rec;
658: g_Rev_Comp_Unexp_Rec := p_Rev_Comp_Unexp_Rec;
659:
660: x_return_status := fnd_api.g_ret_sts_success;
661:
662: -- Get the profile value which indicates whether
663: -- wip values should be defaulted from those that of an
664: -- item.

Line 681: NVL(g_rev_component_rec.new_operation_sequence_number,FND_API.G_MISS_NUM)

677: g_rev_component_rec.transaction_type = BOM_Globals.G_OPR_CREATE
678: ) OR
679: ( g_rev_component_rec.operation_sequence_number <> 1 AND
680: NVL(g_rev_Component_rec.ACD_Type, 1) = 2 AND
681: NVL(g_rev_component_rec.new_operation_sequence_number,FND_API.G_MISS_NUM)
682: = FND_API.G_MISS_NUM
683: )
684:
685: THEN

Line 682: = FND_API.G_MISS_NUM

678: ) OR
679: ( g_rev_component_rec.operation_sequence_number <> 1 AND
680: NVL(g_rev_Component_rec.ACD_Type, 1) = 2 AND
681: NVL(g_rev_component_rec.new_operation_sequence_number,FND_API.G_MISS_NUM)
682: = FND_API.G_MISS_NUM
683: )
684:
685: THEN
686: g_rev_component_rec.operation_sequence_number := 1;

Line 699: g_rev_component_rec.new_operation_sequence_number <> FND_API.G_MISS_NUM

695: ) AND
696: (
697: --NVL(p_old_rev_component_rec.operation_sequence_number, 1) <>
698: --NVL(p_rev_component_rec.new_operation_sequence_number, 1) AND
699: g_rev_component_rec.new_operation_sequence_number <> FND_API.G_MISS_NUM
700: )
701: )
702: THEN
703: g_rev_component_rec.new_operation_sequence_number := 1;

Line 720: g_Rev_Comp_Unexp_Rec.component_sequence_id = FND_API.G_MISS_NUM

716: -- Default Component_Sequence_Id
717: --
718: ***********************************************************/
719: IF g_Rev_Comp_Unexp_Rec.component_sequence_id IS NULL OR
720: g_Rev_Comp_Unexp_Rec.component_sequence_id = FND_API.G_MISS_NUM
721: THEN
722: g_Rev_Comp_Unexp_Rec.component_sequence_id :=
723: Get_Component_Sequence;
724: END IF;

Line 730: FND_API.G_MISS_NUM) AND

726: --bug 14490716 (begin)
727: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Defaulting old component sequence id '); END IF;
728: IF (g_Rev_Comp_Unexp_Rec.old_component_sequence_id IS NULL OR
729: g_Rev_Comp_Unexp_Rec.old_component_sequence_id =
730: FND_API.G_MISS_NUM) AND
731: (NVL(g_rev_component_rec.acd_type, FND_API.G_MISS_NUM) = 1)
732:
733: THEN
734: g_Rev_Comp_Unexp_Rec.old_component_sequence_id :=

Line 731: (NVL(g_rev_component_rec.acd_type, FND_API.G_MISS_NUM) = 1)

727: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Defaulting old component sequence id '); END IF;
728: IF (g_Rev_Comp_Unexp_Rec.old_component_sequence_id IS NULL OR
729: g_Rev_Comp_Unexp_Rec.old_component_sequence_id =
730: FND_API.G_MISS_NUM) AND
731: (NVL(g_rev_component_rec.acd_type, FND_API.G_MISS_NUM) = 1)
732:
733: THEN
734: g_Rev_Comp_Unexp_Rec.old_component_sequence_id :=
735: g_Rev_Comp_Unexp_Rec.component_sequence_id;

Line 773: IF NVL(g_rev_component_rec.acd_type, FND_API.G_MISS_NUM) = 3 AND

769: -- Default To_End_Item_Unit_Number
770: --
771: ************************************************************/
772:
773: IF NVL(g_rev_component_rec.acd_type, FND_API.G_MISS_NUM) = 3 AND
774: g_rev_comp_unexp_rec.old_component_sequence_id IS NOT NULL AND
775: ((p_control_rec.caller_type = 'FORM' AND
776: p_control_rec.unit_controlled_item)
777: OR

Line 788: FND_API.G_MISS_CHAR) <>

784: l_to_end_item_unit_number :=
785: Get_To_End_Item_Number;
786:
787: IF (NVL(g_rev_component_rec.to_end_item_unit_number,
788: FND_API.G_MISS_CHAR) <>
789: NVL(l_to_end_item_unit_number, FND_API.G_MISS_CHAR))
790: AND l_to_end_item_unit_number IS NOT NULL
791: THEN
792: l_Token_Tbl(1).Token_Name := 'REVISED_COMPONENT_NAME';

Line 789: NVL(l_to_end_item_unit_number, FND_API.G_MISS_CHAR))

785: Get_To_End_Item_Number;
786:
787: IF (NVL(g_rev_component_rec.to_end_item_unit_number,
788: FND_API.G_MISS_CHAR) <>
789: NVL(l_to_end_item_unit_number, FND_API.G_MISS_CHAR))
790: AND l_to_end_item_unit_number IS NOT NULL
791: THEN
792: l_Token_Tbl(1).Token_Name := 'REVISED_COMPONENT_NAME';
793: l_Token_Tbl(1).Token_Value := g_rev_component_rec.component_item_name;

Line 830: g_rev_component_rec.acd_type <> FND_API.G_MISS_NUM

826: -- Added an OR condition so that the defaulting happens for BOM
827: -- BO as well, since ACD_type is null when coming thru BOM - By RC
828:
829: IF ( g_rev_component_rec.acd_type IS NOT NULL AND
830: g_rev_component_rec.acd_type <> FND_API.G_MISS_NUM
831: ) OR
832: Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_BOM_BO
833: THEN
834:

Line 843: fnd_api.g_miss_num))

839: *************************************************************/
840:
841: IF ((g_rev_component_rec.item_sequence_number IS NULL) OR
842: (g_rev_component_rec.item_sequence_number =
843: fnd_api.g_miss_num))
844: AND l_assy_item_type <> Bom_Globals.G_PRODUCT_FAMILY --* Added for Bug 4568522
845: THEN
846:
847: g_rev_component_rec.item_sequence_number :=

Line 876: IF g_rev_component_rec.new_operation_sequence_number = FND_API.G_MISS_NUM

872: --
873: -- make sure that new_operation_sequence is set to null if the
874: -- has not entered any value.
875: --
876: IF g_rev_component_rec.new_operation_sequence_number = FND_API.G_MISS_NUM
877: THEN
878: g_rev_component_rec.new_operation_sequence_number := null;
879: END IF;
880:

Line 906: ELSIF g_rev_component_rec.quantity_per_assembly <> FND_API.G_MISS_NUM THEN -- added for bug 2442791

902: THEN
903: g_rev_component_rec.quantity_per_assembly :=
904: Get_Component_Quantity;
905: /* Commented as part of bug#3310077.
906: ELSIF g_rev_component_rec.quantity_per_assembly <> FND_API.G_MISS_NUM THEN -- added for bug 2442791
907: g_rev_component_rec.quantity_per_assembly :=
908: round(g_rev_component_rec.quantity_per_assembly, 7);
909: */
910: END IF;

Line 921: g_rev_comp_unexp_rec.pick_components = FND_API.G_MISS_NUM

917: --
918: *************************************************************/
919:
920: IF g_Rev_Comp_Unexp_Rec.pick_components IS NULL OR
921: g_rev_comp_unexp_rec.pick_components = FND_API.G_MISS_NUM
922: THEN
923: g_Rev_Comp_Unexp_Rec.pick_components :=
924: Get_Pick_Components;
925: END IF;

Line 957: IF g_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN

953: --
954: -- Default Disable Date
955: --
956: **************************************************************/
957: IF g_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN
958: g_rev_component_rec.disable_date := NULL;
959: END IF;
960:
961: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('After Effectivity Defaulted . . .'); END IF;

Line 1024: g_rev_comp_unexp_rec.component_item_id <> FND_API.G_MISS_NUM

1020: -- records that come in thru the ECO form.
1021: -- By AS on 07/28/99
1022:
1023: IF g_rev_comp_unexp_rec.component_item_id IS NOT NULL AND
1024: g_rev_comp_unexp_rec.component_item_id <> FND_API.G_MISS_NUM
1025: THEN
1026:
1027: /************************************************************
1028: --

Line 1055: g_rev_comp_unexp_rec.bom_item_type = FND_API.G_MISS_NUM

1051:
1052: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('After Check ATP Defualted . . . '); END IF;
1053:
1054: IF g_rev_comp_Unexp_rec.bom_item_type IS NULL OR
1055: g_rev_comp_unexp_rec.bom_item_type = FND_API.G_MISS_NUM
1056: THEN
1057: g_rev_comp_Unexp_rec.bom_item_type := get_bom_item_type;
1058: END IF;
1059:

Line 1080: g_rev_comp_unexp_rec.component_item_id = FND_API.G_MISS_NUM

1076: -- Defaulting used by the ECO form
1077: -- Added by AS on 07/29/99
1078:
1079: IF g_rev_comp_unexp_rec.component_item_id IS NULL OR
1080: g_rev_comp_unexp_rec.component_item_id = FND_API.G_MISS_NUM
1081: THEN
1082: g_rev_component_rec.check_atp := 2;
1083: END IF;
1084:

Line 1123: FND_API.G_MISS_CHAR or g_rev_component_rec.supply_subinventory is NULL THEN

1119: -- Supply Locator also.
1120: --
1121: **************************************************************/
1122: IF g_rev_component_rec.supply_subinventory =
1123: FND_API.G_MISS_CHAR or g_rev_component_rec.supply_subinventory is NULL THEN
1124: g_rev_component_rec.supply_subinventory := NULL;
1125: g_Rev_Comp_Unexp_Rec.Supply_Locator_Id := NULL;
1126: END IF;
1127:

Line 1138: OR g_rev_component_rec.auto_request_material = FND_API.G_MISS_CHAR)

1134: -- Added in 11.5.9 by ADEY
1135: ***********************************************************/
1136:
1137: IF (g_rev_component_rec.auto_request_material IS NULL
1138: OR g_rev_component_rec.auto_request_material = FND_API.G_MISS_CHAR)
1139: AND l_assy_item_type <> Bom_Globals.G_PRODUCT_FAMILY --* Added for Bug 4568522
1140: THEN
1141:
1142: g_rev_component_rec.auto_request_material :=

Line 1161: OR g_rev_component_rec.Unit_Price = FND_API.G_MISS_NUM THEN

1157: --
1158: **************************************************************/
1159:
1160: IF g_rev_component_rec.Unit_Price IS NULL
1161: OR g_rev_component_rec.Unit_Price = FND_API.G_MISS_NUM THEN
1162: g_rev_component_rec.Unit_Price := get_unit_price;
1163: END IF;
1164:
1165: IF g_rev_component_rec.location_name =

Line 1166: FND_API.G_MISS_CHAR or g_rev_component_rec.location_name is NULL THEN

1162: g_rev_component_rec.Unit_Price := get_unit_price;
1163: END IF;
1164:
1165: IF g_rev_component_rec.location_name =
1166: FND_API.G_MISS_CHAR or g_rev_component_rec.location_name is NULL THEN
1167: g_rev_component_rec.location_name := NULL;
1168: g_rev_comp_unexp_rec.Supply_Locator_Id := NULL;
1169: END IF;
1170:

Line 1172: FND_API.G_MISS_NUM THEN

1168: g_rev_comp_unexp_rec.Supply_Locator_Id := NULL;
1169: END IF;
1170:
1171: IF g_rev_component_rec.minimum_allowed_quantity =
1172: FND_API.G_MISS_NUM THEN
1173: g_rev_component_rec.minimum_allowed_quantity := NULL;
1174: END IF;
1175:
1176: IF g_rev_component_rec.maximum_allowed_quantity =

Line 1177: FND_API.G_MISS_NUM THEN

1173: g_rev_component_rec.minimum_allowed_quantity := NULL;
1174: END IF;
1175:
1176: IF g_rev_component_rec.maximum_allowed_quantity =
1177: FND_API.G_MISS_NUM THEN
1178: g_rev_component_rec.maximum_allowed_quantity := NULL;
1179: END IF;
1180:
1181:

Line 1182: IF g_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN

1178: g_rev_component_rec.maximum_allowed_quantity := NULL;
1179: END IF;
1180:
1181:
1182: IF g_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN
1183: g_rev_component_rec.comments := NULL;
1184: END IF;
1185:
1186: IF g_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN

Line 1186: IF g_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN

1182: IF g_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN
1183: g_rev_component_rec.comments := NULL;
1184: END IF;
1185:
1186: IF g_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN
1187: g_rev_component_rec.wip_supply_type := NULL;
1188: END IF;
1189:
1190: IF g_rev_component_rec.Suggested_Vendor_Name =

Line 1191: FND_API.G_MISS_CHAR THEN --- Deepu

1187: g_rev_component_rec.wip_supply_type := NULL;
1188: END IF;
1189:
1190: IF g_rev_component_rec.Suggested_Vendor_Name =
1191: FND_API.G_MISS_CHAR THEN --- Deepu
1192: g_rev_component_rec.Suggested_Vendor_Name := NULL;
1193: END IF;
1194: /*
1195: IF g_rev_component_rec.Purchasing_Category =

Line 1196: FND_API.G_MISS_CHAR THEN --- Deepu

1192: g_rev_component_rec.Suggested_Vendor_Name := NULL;
1193: END IF;
1194: /*
1195: IF g_rev_component_rec.Purchasing_Category =
1196: FND_API.G_MISS_CHAR THEN --- Deepu
1197: g_rev_component_rec.Purchasing_Category := NULL;
1198: END IF;
1199:
1200: */

Line 1212: FND_API.G_MISS_NUM

1208: LOOP
1209: IF g_rev_component_rec.wip_supply_type IS NULL
1210: OR
1211: g_rev_component_rec.wip_supply_type =
1212: FND_API.G_MISS_NUM
1213: THEN
1214: g_rev_component_rec.wip_supply_type :=
1215: c_default.wip_supply_type;
1216: END IF;

Line 1221: FND_API.G_MISS_CHAR

1217:
1218: IF g_rev_component_rec.supply_subinventory IS NULL
1219: OR
1220: g_rev_component_rec.supply_subinventory =
1221: FND_API.G_MISS_CHAR
1222: THEN
1223: g_rev_component_rec.supply_subinventory :=
1224: c_default.wip_supply_subinventory;
1225: END IF;

Line 1230: FND_API.G_MISS_NUM

1226:
1227: IF g_rev_comp_unexp_rec.supply_locator_id IS NULL
1228: OR
1229: g_rev_comp_unexp_rec.supply_locator_id =
1230: FND_API.G_MISS_NUM
1231: THEN
1232: g_rev_comp_unexp_rec.supply_locator_id
1233: :=
1234: c_default.wip_supply_locator_id;

Line 1241: IF g_rev_component_rec.acd_type = FND_API.G_MISS_NUM THEN

1237: END LOOP;
1238:
1239: END IF;
1240:
1241: IF g_rev_component_rec.acd_type = FND_API.G_MISS_NUM THEN
1242: g_rev_component_rec.acd_type := NULL;
1243: END IF;
1244:
1245: IF g_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM or g_rev_comp_unexp_rec.supply_locator_id is NULL

Line 1245: IF g_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM or g_rev_comp_unexp_rec.supply_locator_id is NULL

1241: IF g_rev_component_rec.acd_type = FND_API.G_MISS_NUM THEN
1242: g_rev_component_rec.acd_type := NULL;
1243: END IF;
1244:
1245: IF g_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM or g_rev_comp_unexp_rec.supply_locator_id is NULL
1246: THEN
1247: g_rev_comp_unexp_rec.supply_locator_id := NULL;
1248: END IF;
1249:

Line 1254: IF( g_rev_comp_unexp_rec.enforce_int_requirements_code = FND_API.G_MISS_NUM

1250: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute defaulting enforce_int_requirements_code...'); END IF;
1251:
1252: /* bug2758790, form defaults the enforce req code to 0 and value to 'none' */
1253:
1254: IF( g_rev_comp_unexp_rec.enforce_int_requirements_code = FND_API.G_MISS_NUM
1255: or g_rev_comp_unexp_rec.enforce_int_requirements_code is NULL)
1256: AND l_assy_item_type <> Bom_Globals.G_PRODUCT_FAMILY --* Added for Bug 4568522
1257: THEN
1258: g_rev_comp_unexp_rec.enforce_int_requirements_code := 0;

Line 1262: IF (g_rev_component_rec.enforce_int_requirements = FND_API.G_MISS_CHAR

1258: g_rev_comp_unexp_rec.enforce_int_requirements_code := 0;
1259: END IF;
1260:
1261: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute defaulting enforce_int_requirements...'); END IF;
1262: IF (g_rev_component_rec.enforce_int_requirements = FND_API.G_MISS_CHAR
1263: or g_rev_component_rec.enforce_int_requirements is NULL)
1264: AND l_assy_item_type <> Bom_Globals.G_PRODUCT_FAMILY --* Added for Bug 4568522
1265: THEN
1266: g_rev_component_rec.enforce_int_requirements := Get_EnforceInteger_Value(

Line 1278: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR

1274: --* End of Bug 4568522
1275:
1276: END IF;
1277:
1278: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR
1279: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
1280: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
1281: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1282: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR

Line 1279: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR

1275:
1276: END IF;
1277:
1278: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR
1279: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
1280: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
1281: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1282: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1283: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR

Line 1280: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR

1276: END IF;
1277:
1278: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR
1279: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
1280: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
1281: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1282: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1283: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1284: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR

Line 1281: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR

1277:
1278: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR
1279: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
1280: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
1281: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1282: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1283: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1284: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1285: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR

Line 1282: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR

1278: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR
1279: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
1280: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
1281: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1282: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1283: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1284: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1285: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1286: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR

Line 1283: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR

1279: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
1280: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
1281: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1282: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1283: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1284: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1285: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1286: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1287: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR

Line 1284: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR

1280: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
1281: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1282: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1283: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1284: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1285: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1286: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1287: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1288: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR

Line 1285: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR

1281: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1282: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1283: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1284: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1285: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1286: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1287: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1288: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1289: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR

Line 1286: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR

1282: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1283: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1284: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1285: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1286: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1287: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1288: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1289: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1290: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR

Line 1287: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR

1283: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1284: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1285: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1286: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1287: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1288: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1289: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1290: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
1291: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR

Line 1288: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR

1284: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1285: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1286: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1287: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1288: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1289: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1290: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
1291: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
1292: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR

Line 1289: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR

1285: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1286: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1287: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1288: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1289: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1290: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
1291: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
1292: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR
1293: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR

Line 1290: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR

1286: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1287: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1288: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1289: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1290: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
1291: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
1292: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR
1293: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR
1294: THEN

Line 1291: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR

1287: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1288: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1289: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1290: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
1291: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
1292: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR
1293: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR
1294: THEN
1295:

Line 1292: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR

1288: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1289: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1290: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
1291: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
1292: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR
1293: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR
1294: THEN
1295:
1296: Get_Flex_Rev_Component;

Line 1293: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR

1289: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1290: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
1291: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
1292: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR
1293: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR
1294: THEN
1295:
1296: Get_Flex_Rev_Component;
1297:

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

1327: )
1328: IS
1329: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
1330: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
1331: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1332: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
1333: BEGIN
1334:
1335: --

Line 1407: IF l_rev_component_rec.supply_subinventory = FND_API.G_MISS_CHAR THEN

1403: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=
1404: p_Rev_Comp_Unexp_Rec;
1405: BEGIN
1406:
1407: IF l_rev_component_rec.supply_subinventory = FND_API.G_MISS_CHAR THEN
1408: l_rev_component_rec.supply_subinventory := NULL;
1409: l_rev_component_rec.location_name := NULL;
1410: l_rev_comp_unexp_rec.supply_locator_id := NULL;
1411: ELSIF l_rev_component_rec.supply_subinventory IS NULL THEN

Line 1416: (p_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM) THEN

1412: l_rev_component_rec.supply_subinventory :=
1413: p_old_rev_component_rec.supply_subinventory;
1414: /* Bug 2694107 */
1415: If (p_rev_comp_unexp_rec.supply_locator_id IS NULL) or
1416: (p_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM) THEN
1417: l_rev_comp_unexp_rec.supply_locator_id :=
1418: p_old_rev_comp_unexp_rec.supply_locator_id;
1419: End if;
1420: /* Bug 2694107 */

Line 1434: FND_API.G_MISS_NUM

1430: p_old_rev_comp_unexp_rec.supply_locator_id OR
1431: ( l_rev_comp_unexp_rec.supply_locator_id IS NOT
1432: NULL AND
1433: l_rev_comp_unexp_rec.supply_locator_id =
1434: FND_API.G_MISS_NUM
1435: )
1436: )
1437: )
1438: THEN

Line 1447: FND_API.G_MISS_NUM

1443: ELSIF l_rev_component_rec.Supply_Subinventory IS NOT NULL AND
1444: l_rev_component_rec.Supply_Subinventory <>
1445: p_old_rev_component_rec.supply_subinventory AND
1446: l_rev_comp_unexp_rec.supply_locator_id =
1447: FND_API.G_MISS_NUM
1448: THEN
1449: -- dbms_output.put_line('Supply Locator made NULL . . .');
1450:
1451: l_rev_comp_unexp_rec.supply_locator_id := NULL;

Line 1463: IF l_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM THEN

1459: l_rev_comp_unexp_rec.supply_locator_id :=
1460: p_old_rev_comp_unexp_rec.supply_locator_id;
1461: END IF;
1462:
1463: IF l_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM THEN
1464: l_rev_comp_unexp_rec.supply_locator_id := NULL;
1465: l_rev_component_rec.location_name := NULL;
1466: END IF;
1467:

Line 1484: ELSIF l_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM

1480: IF l_rev_component_rec.wip_supply_type IS NULL THEN
1481: l_rev_component_rec.wip_supply_type :=
1482: p_old_rev_component_rec.wip_supply_type;
1483: /* Added for bug3221540 */
1484: ELSIF l_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM
1485: THEN
1486: l_rev_component_rec.wip_supply_type := NULL;
1487: END IF;
1488:

Line 1506: AND (l_rev_component_rec.inverse_quantity = FND_API.G_MISS_NUM

1502: p_old_rev_component_rec.basis_type;
1503: END IF;
1504:
1505: IF l_rev_component_rec.quantity_per_assembly IS NULL
1506: AND (l_rev_component_rec.inverse_quantity = FND_API.G_MISS_NUM
1507: OR l_rev_component_rec.inverse_quantity IS NULL
1508: OR l_rev_component_rec.inverse_quantity = 0)
1509: THEN
1510: l_rev_component_rec.quantity_per_assembly :=

Line 1513: ELSIF l_rev_component_rec.quantity_per_assembly <> FND_API.G_MISS_NUM THEN -- added for bug 2442791

1509: THEN
1510: l_rev_component_rec.quantity_per_assembly :=
1511: p_old_rev_component_rec.quantity_per_assembly;
1512: /* Commented as part of bug#3310077
1513: ELSIF l_rev_component_rec.quantity_per_assembly <> FND_API.G_MISS_NUM THEN -- added for bug 2442791
1514: l_rev_component_rec.quantity_per_assembly :=
1515: round(l_rev_component_rec.quantity_per_assembly, 7);
1516: */
1517: END IF;

Line 1535: ELSIF l_rev_component_rec.disable_date = FND_API.G_MISS_DATE

1531: IF l_rev_component_rec.disable_date IS NULL THEN
1532: l_rev_component_rec.disable_date :=
1533: p_old_rev_component_rec.disable_date;
1534: /* Added for bug 3486547 */
1535: ELSIF l_rev_component_rec.disable_date = FND_API.G_MISS_DATE
1536: then
1537: l_rev_component_rec.disable_date := NULL;
1538: END IF;
1539:

Line 1687: IF l_rev_component_rec.from_end_item_unit_number = FND_API.G_MISS_CHAR

1683: l_rev_component_rec.acd_type :=
1684: p_old_rev_component_rec.acd_type;
1685: END IF;
1686:
1687: IF l_rev_component_rec.from_end_item_unit_number = FND_API.G_MISS_CHAR
1688: THEN
1689: l_rev_component_rec.from_end_item_unit_number := null;
1690: ELSIF l_rev_component_rec.from_end_item_unit_number IS NULL
1691: THEN

Line 1696: IF l_rev_component_rec.to_end_item_unit_number = FND_API.G_MISS_CHAR

1692: l_rev_component_rec.from_end_item_unit_number :=
1693: p_old_rev_component_rec.from_end_item_unit_number;
1694: END IF;
1695:
1696: IF l_rev_component_rec.to_end_item_unit_number = FND_API.G_MISS_CHAR
1697: THEN
1698: l_rev_component_rec.to_end_item_unit_number := null;
1699: ELSIF l_rev_component_rec.to_end_item_unit_number IS NULL
1700: THEN

Line 1764: FND_API.G_MISS_NUM

1760: **************************************************/
1761:
1762: IF l_Rev_Comp_Unexp_Rec.component_sequence_id IS NULL OR
1763: l_Rev_Comp_Unexp_Rec.component_sequence_id =
1764: FND_API.G_MISS_NUM
1765: THEN
1766: l_Rev_Comp_Unexp_Rec.component_sequence_id :=
1767: Get_Component_Sequence;
1768:

Line 1782: IF l_rev_component_rec.enforce_int_requirements = FND_API.G_MISS_CHAR THEN

1778:
1779: l_rev_comp_unexp_rec.pick_components :=
1780: p_old_rev_comp_unexp_rec.pick_components;
1781:
1782: IF l_rev_component_rec.enforce_int_requirements = FND_API.G_MISS_CHAR THEN
1783: l_rev_comp_unexp_rec.enforce_int_requirements_code := 0;
1784: l_rev_component_rec.enforce_int_requirements := Get_EnforceInteger_Value(
1785: p_enforce_integer => 0);
1786: ELSIF l_rev_component_rec.enforce_int_requirements IS NULL THEN

Line 1902: AND p_rev_component_rec.inverse_quantity <> FND_API.G_MISS_NUM)

1898:
1899: IF (p_rev_component_rec.quantity_per_assembly) IS NULL
1900: THEN
1901: IF (p_rev_component_rec.inverse_quantity IS NOT NULL
1902: AND p_rev_component_rec.inverse_quantity <> FND_API.G_MISS_NUM)
1903: THEN
1904: IF (p_rev_component_rec.inverse_quantity = 0)
1905: THEN
1906: x_rev_component_rec.quantity_per_assembly := 0;