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 151: AND g_rev_component_rec.inverse_quantity <> FND_API.G_MISS_NUM)

147: l_Assembly_Item_Id NUMBER;
148: l_Organization_Id NUMBER;
149: BEGIN
150: IF (g_rev_component_rec.inverse_quantity IS NOT NULL
151: AND g_rev_component_rec.inverse_quantity <> FND_API.G_MISS_NUM)
152: THEN
153: IF (g_rev_component_rec.inverse_quantity = 0)
154: THEN
155: l_component_quantity := 0;

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

444: BEGIN
445:
446: -- In the future call Flex APIs for defaults
447:
448: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
449: g_rev_component_rec.attribute_category := NULL;
450: END IF;
451:
452: IF g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

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

448: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
449: g_rev_component_rec.attribute_category := NULL;
450: END IF;
451:
452: IF g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
453: g_rev_component_rec.attribute1 := NULL;
454: END IF;
455:
456: IF g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

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

452: IF g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
453: g_rev_component_rec.attribute1 := NULL;
454: END IF;
455:
456: IF g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
457: g_rev_component_rec.attribute2 := NULL;
458: END IF;
459:
460: IF g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

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

456: IF g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
457: g_rev_component_rec.attribute2 := NULL;
458: END IF;
459:
460: IF g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
461: g_rev_component_rec.attribute3 := NULL;
462: END IF;
463:
464: IF g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

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

460: IF g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
461: g_rev_component_rec.attribute3 := NULL;
462: END IF;
463:
464: IF g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
465: g_rev_component_rec.attribute4 := NULL;
466: END IF;
467:
468: IF g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

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

464: IF g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
465: g_rev_component_rec.attribute4 := NULL;
466: END IF;
467:
468: IF g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
469: g_rev_component_rec.attribute5 := NULL;
470: END IF;
471:
472: IF g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

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

468: IF g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
469: g_rev_component_rec.attribute5 := NULL;
470: END IF;
471:
472: IF g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
473: g_rev_component_rec.attribute6 := NULL;
474: END IF;
475:
476: IF g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

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

472: IF g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
473: g_rev_component_rec.attribute6 := NULL;
474: END IF;
475:
476: IF g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
477: g_rev_component_rec.attribute7 := NULL;
478: END IF;
479:
480: IF g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

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

476: IF g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
477: g_rev_component_rec.attribute7 := NULL;
478: END IF;
479:
480: IF g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
481: g_rev_component_rec.attribute8 := NULL;
482: END IF;
483:
484: IF g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

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

480: IF g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
481: g_rev_component_rec.attribute8 := NULL;
482: END IF;
483:
484: IF g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
485: g_rev_component_rec.attribute9 := NULL;
486: END IF;
487:
488: IF g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

484: IF g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
485: g_rev_component_rec.attribute9 := NULL;
486: END IF;
487:
488: IF g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
489: g_rev_component_rec.attribute10 := NULL;
490: END IF;
491:
492: IF g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

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

488: IF g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
489: g_rev_component_rec.attribute10 := NULL;
490: END IF;
491:
492: IF g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
493: g_rev_component_rec.attribute11 := NULL;
494: END IF;
495:
496: IF g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN

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

492: IF g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
493: g_rev_component_rec.attribute11 := NULL;
494: END IF;
495:
496: IF g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
497: g_rev_component_rec.attribute12 := NULL;
498: END IF;
499:
500: IF g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN

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

496: IF g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
497: g_rev_component_rec.attribute12 := NULL;
498: END IF;
499:
500: IF g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
501: g_rev_component_rec.attribute13 := NULL;
502: END IF;
503:
504: IF g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN

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

500: IF g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
501: g_rev_component_rec.attribute13 := NULL;
502: END IF;
503:
504: IF g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
505: g_rev_component_rec.attribute14 := NULL;
506: END IF;
507:
508: IF g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN

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

504: IF g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
505: g_rev_component_rec.attribute14 := NULL;
506: END IF;
507:
508: IF g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
509: g_rev_component_rec.attribute15 := NULL;
510: END IF;
511:
512: END Get_Flex_Rev_Component;

Line 585: x_return_status := fnd_api.g_ret_sts_success;

581:
582: g_rev_component_rec := p_rev_component_rec;
583: g_Rev_Comp_Unexp_Rec := p_Rev_Comp_Unexp_Rec;
584:
585: x_return_status := fnd_api.g_ret_sts_success;
586:
587: -- Get the profile value which indicates whether
588: -- wip values should be defaulted from those that of an
589: -- item.

Line 601: g_Rev_Comp_Unexp_Rec.component_sequence_id = FND_API.G_MISS_NUM

597: -- Default Component_Sequence_Id
598: --
599: ***********************************************************/
600: IF g_Rev_Comp_Unexp_Rec.component_sequence_id IS NULL OR
601: g_Rev_Comp_Unexp_Rec.component_sequence_id = FND_API.G_MISS_NUM
602: THEN
603: g_Rev_Comp_Unexp_Rec.component_sequence_id :=
604: Get_Component_Sequence;
605: END IF;

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

634: -- Default To_End_Item_Unit_Number
635: --
636: ************************************************************/
637:
638: IF NVL(g_rev_component_rec.acd_type, FND_API.G_MISS_NUM) = 3 AND
639: g_rev_comp_unexp_rec.old_component_sequence_id IS NOT NULL AND
640: ((p_control_rec.caller_type = 'FORM' AND
641: p_control_rec.unit_controlled_item)
642: OR

Line 653: FND_API.G_MISS_CHAR) <>

649: l_to_end_item_unit_number :=
650: Get_To_End_Item_Number;
651:
652: IF (NVL(g_rev_component_rec.to_end_item_unit_number,
653: FND_API.G_MISS_CHAR) <>
654: NVL(l_to_end_item_unit_number, FND_API.G_MISS_CHAR))
655: AND l_to_end_item_unit_number IS NOT NULL
656: THEN
657: l_Token_Tbl(1).Token_Name := 'REVISED_COMPONENT_NAME';

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

650: Get_To_End_Item_Number;
651:
652: IF (NVL(g_rev_component_rec.to_end_item_unit_number,
653: FND_API.G_MISS_CHAR) <>
654: NVL(l_to_end_item_unit_number, FND_API.G_MISS_CHAR))
655: AND l_to_end_item_unit_number IS NOT NULL
656: THEN
657: l_Token_Tbl(1).Token_Name := 'REVISED_COMPONENT_NAME';
658: l_Token_Tbl(1).Token_Value := g_rev_component_rec.component_item_name;

Line 695: g_rev_component_rec.acd_type <> FND_API.G_MISS_NUM

691: -- Added an OR condition so that the defaulting happens for BOM
692: -- BO as well, since ACD_type is null when coming thru BOM - By RC
693:
694: IF ( g_rev_component_rec.acd_type IS NOT NULL AND
695: g_rev_component_rec.acd_type <> FND_API.G_MISS_NUM
696: ) OR
697: Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_BOM_BO
698: THEN
699:

Line 708: fnd_api.g_miss_num))

704: *************************************************************/
705:
706: IF ((g_rev_component_rec.item_sequence_number IS NULL) OR
707: (g_rev_component_rec.item_sequence_number =
708: fnd_api.g_miss_num))
709: AND l_assy_item_type <> Bom_Globals.G_PRODUCT_FAMILY --* Added for Bug 4568522
710: THEN
711:
712: g_rev_component_rec.item_sequence_number :=

Line 741: IF g_rev_component_rec.new_operation_sequence_number = FND_API.G_MISS_NUM

737: --
738: -- make sure that new_operation_sequence is set to null if the
739: -- has not entered any value.
740: --
741: IF g_rev_component_rec.new_operation_sequence_number = FND_API.G_MISS_NUM
742: THEN
743: g_rev_component_rec.new_operation_sequence_number := null;
744: END IF;
745:

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

767: THEN
768: g_rev_component_rec.quantity_per_assembly :=
769: Get_Component_Quantity;
770: /* Commented as part of bug#3310077.
771: ELSIF g_rev_component_rec.quantity_per_assembly <> FND_API.G_MISS_NUM THEN -- added for bug 2442791
772: g_rev_component_rec.quantity_per_assembly :=
773: round(g_rev_component_rec.quantity_per_assembly, 7);
774: */
775: END IF;

Line 786: g_rev_comp_unexp_rec.pick_components = FND_API.G_MISS_NUM

782: --
783: *************************************************************/
784:
785: IF g_Rev_Comp_Unexp_Rec.pick_components IS NULL OR
786: g_rev_comp_unexp_rec.pick_components = FND_API.G_MISS_NUM
787: THEN
788: g_Rev_Comp_Unexp_Rec.pick_components :=
789: Get_Pick_Components;
790: END IF;

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

818: --
819: -- Default Disable Date
820: --
821: **************************************************************/
822: IF g_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN
823: g_rev_component_rec.disable_date := NULL;
824: END IF;
825:
826: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('After Effectivity Defaulted . . .'); END IF;

Line 889: g_rev_comp_unexp_rec.component_item_id <> FND_API.G_MISS_NUM

885: -- records that come in thru the ECO form.
886: -- By AS on 07/28/99
887:
888: IF g_rev_comp_unexp_rec.component_item_id IS NOT NULL AND
889: g_rev_comp_unexp_rec.component_item_id <> FND_API.G_MISS_NUM
890: THEN
891:
892: /************************************************************
893: --

Line 920: g_rev_comp_unexp_rec.bom_item_type = FND_API.G_MISS_NUM

916:
917: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('After Check ATP Defualted . . . '); END IF;
918:
919: IF g_rev_comp_Unexp_rec.bom_item_type IS NULL OR
920: g_rev_comp_unexp_rec.bom_item_type = FND_API.G_MISS_NUM
921: THEN
922: g_rev_comp_Unexp_rec.bom_item_type := get_bom_item_type;
923: END IF;
924:

Line 945: g_rev_comp_unexp_rec.component_item_id = FND_API.G_MISS_NUM

941: -- Defaulting used by the ECO form
942: -- Added by AS on 07/29/99
943:
944: IF g_rev_comp_unexp_rec.component_item_id IS NULL OR
945: g_rev_comp_unexp_rec.component_item_id = FND_API.G_MISS_NUM
946: THEN
947: g_rev_component_rec.check_atp := 2;
948: END IF;
949:

Line 988: FND_API.G_MISS_CHAR THEN

984: -- Supply Locator also.
985: --
986: **************************************************************/
987: IF g_rev_component_rec.supply_subinventory =
988: FND_API.G_MISS_CHAR THEN
989: g_rev_component_rec.supply_subinventory := NULL;
990: g_Rev_Comp_Unexp_Rec.Supply_Locator_Id := NULL;
991: END IF;
992:

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

999: -- Added in 11.5.9 by ADEY
1000: ***********************************************************/
1001:
1002: IF (g_rev_component_rec.auto_request_material IS NULL
1003: OR g_rev_component_rec.auto_request_material = FND_API.G_MISS_CHAR)
1004: AND l_assy_item_type <> Bom_Globals.G_PRODUCT_FAMILY --* Added for Bug 4568522
1005: THEN
1006:
1007: g_rev_component_rec.auto_request_material :=

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

1022: --
1023: **************************************************************/
1024:
1025: IF g_rev_component_rec.Unit_Price IS NULL
1026: OR g_rev_component_rec.Unit_Price = FND_API.G_MISS_NUM THEN
1027: g_rev_component_rec.Unit_Price := get_unit_price;
1028: END IF;
1029:
1030: IF g_rev_component_rec.location_name =

Line 1031: FND_API.G_MISS_CHAR THEN

1027: g_rev_component_rec.Unit_Price := get_unit_price;
1028: END IF;
1029:
1030: IF g_rev_component_rec.location_name =
1031: FND_API.G_MISS_CHAR THEN
1032: g_rev_component_rec.location_name := NULL;
1033: g_rev_comp_unexp_rec.Supply_Locator_Id := NULL;
1034: END IF;
1035:

Line 1037: FND_API.G_MISS_NUM THEN

1033: g_rev_comp_unexp_rec.Supply_Locator_Id := NULL;
1034: END IF;
1035:
1036: IF g_rev_component_rec.minimum_allowed_quantity =
1037: FND_API.G_MISS_NUM THEN
1038: g_rev_component_rec.minimum_allowed_quantity := NULL;
1039: END IF;
1040:
1041: IF g_rev_component_rec.maximum_allowed_quantity =

Line 1042: FND_API.G_MISS_NUM THEN

1038: g_rev_component_rec.minimum_allowed_quantity := NULL;
1039: END IF;
1040:
1041: IF g_rev_component_rec.maximum_allowed_quantity =
1042: FND_API.G_MISS_NUM THEN
1043: g_rev_component_rec.maximum_allowed_quantity := NULL;
1044: END IF;
1045:
1046:

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

1043: g_rev_component_rec.maximum_allowed_quantity := NULL;
1044: END IF;
1045:
1046:
1047: IF g_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN
1048: g_rev_component_rec.comments := NULL;
1049: END IF;
1050:
1051: IF g_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN

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

1047: IF g_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN
1048: g_rev_component_rec.comments := NULL;
1049: END IF;
1050:
1051: IF g_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN
1052: g_rev_component_rec.wip_supply_type := NULL;
1053: END IF;
1054:
1055: IF g_rev_component_rec.Suggested_Vendor_Name =

Line 1056: FND_API.G_MISS_CHAR THEN --- Deepu

1052: g_rev_component_rec.wip_supply_type := NULL;
1053: END IF;
1054:
1055: IF g_rev_component_rec.Suggested_Vendor_Name =
1056: FND_API.G_MISS_CHAR THEN --- Deepu
1057: g_rev_component_rec.Suggested_Vendor_Name := NULL;
1058: END IF;
1059: /*
1060: IF g_rev_component_rec.Purchasing_Category =

Line 1061: FND_API.G_MISS_CHAR THEN --- Deepu

1057: g_rev_component_rec.Suggested_Vendor_Name := NULL;
1058: END IF;
1059: /*
1060: IF g_rev_component_rec.Purchasing_Category =
1061: FND_API.G_MISS_CHAR THEN --- Deepu
1062: g_rev_component_rec.Purchasing_Category := NULL;
1063: END IF;
1064:
1065: */

Line 1077: FND_API.G_MISS_NUM

1073: LOOP
1074: IF g_rev_component_rec.wip_supply_type IS NULL
1075: OR
1076: g_rev_component_rec.wip_supply_type =
1077: FND_API.G_MISS_NUM
1078: THEN
1079: g_rev_component_rec.wip_supply_type :=
1080: c_default.wip_supply_type;
1081: END IF;

Line 1086: FND_API.G_MISS_CHAR

1082:
1083: IF g_rev_component_rec.supply_subinventory IS NULL
1084: OR
1085: g_rev_component_rec.supply_subinventory =
1086: FND_API.G_MISS_CHAR
1087: THEN
1088: g_rev_component_rec.supply_subinventory :=
1089: c_default.wip_supply_subinventory;
1090: END IF;

Line 1095: FND_API.G_MISS_NUM

1091:
1092: IF g_rev_comp_unexp_rec.supply_locator_id IS NULL
1093: OR
1094: g_rev_comp_unexp_rec.supply_locator_id =
1095: FND_API.G_MISS_NUM
1096: THEN
1097: g_rev_comp_unexp_rec.supply_locator_id
1098: :=
1099: c_default.wip_supply_locator_id;

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

1102: END LOOP;
1103:
1104: END IF;
1105:
1106: IF g_rev_component_rec.acd_type = FND_API.G_MISS_NUM THEN
1107: g_rev_component_rec.acd_type := NULL;
1108: END IF;
1109:
1110: IF g_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM

Line 1110: IF g_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM

1106: IF g_rev_component_rec.acd_type = FND_API.G_MISS_NUM THEN
1107: g_rev_component_rec.acd_type := NULL;
1108: END IF;
1109:
1110: IF g_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM
1111: THEN
1112: g_rev_comp_unexp_rec.supply_locator_id := NULL;
1113: END IF;
1114:

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

1115: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute defaulting enforce_int_requirements_code...'); END IF;
1116:
1117: /* bug2758790, form defaults the enforce req code to 0 and value to 'none' */
1118:
1119: IF( g_rev_comp_unexp_rec.enforce_int_requirements_code = FND_API.G_MISS_NUM
1120: or g_rev_comp_unexp_rec.enforce_int_requirements_code is NULL)
1121: AND l_assy_item_type <> Bom_Globals.G_PRODUCT_FAMILY --* Added for Bug 4568522
1122: THEN
1123: g_rev_comp_unexp_rec.enforce_int_requirements_code := 0;

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

1123: g_rev_comp_unexp_rec.enforce_int_requirements_code := 0;
1124: END IF;
1125:
1126: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute defaulting enforce_int_requirements...'); END IF;
1127: IF (g_rev_component_rec.enforce_int_requirements = FND_API.G_MISS_CHAR
1128: or g_rev_component_rec.enforce_int_requirements is NULL)
1129: AND l_assy_item_type <> Bom_Globals.G_PRODUCT_FAMILY --* Added for Bug 4568522
1130: THEN
1131: g_rev_component_rec.enforce_int_requirements := Get_EnforceInteger_Value(

Line 1143: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR

1139: --* End of Bug 4568522
1140:
1141: END IF;
1142:
1143: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR
1144: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
1145: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
1146: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1147: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR

Line 1144: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR

1140:
1141: END IF;
1142:
1143: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR
1144: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
1145: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
1146: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1147: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1148: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR

Line 1145: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR

1141: END IF;
1142:
1143: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR
1144: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
1145: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
1146: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1147: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1148: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1149: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR

Line 1146: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR

1142:
1143: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR
1144: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
1145: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
1146: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1147: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1148: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1149: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1150: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR

Line 1147: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR

1143: IF g_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR
1144: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
1145: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
1146: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1147: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1148: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1149: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1150: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1151: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR

Line 1148: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR

1144: OR g_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR
1145: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
1146: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1147: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1148: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1149: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1150: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1151: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1152: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR

Line 1149: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR

1145: OR g_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR
1146: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1147: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1148: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1149: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1150: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1151: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1152: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1153: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR

Line 1150: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR

1146: OR g_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR
1147: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1148: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1149: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1150: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1151: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1152: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1153: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1154: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR

Line 1151: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR

1147: OR g_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR
1148: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1149: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1150: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1151: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1152: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1153: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1154: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1155: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR

Line 1152: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR

1148: OR g_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR
1149: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1150: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1151: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1152: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1153: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1154: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1155: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
1156: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR

Line 1153: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR

1149: OR g_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR
1150: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1151: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1152: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1153: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1154: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1155: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
1156: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
1157: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR

Line 1154: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR

1150: OR g_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR
1151: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1152: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1153: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1154: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1155: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
1156: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
1157: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR
1158: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR

Line 1155: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR

1151: OR g_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR
1152: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1153: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1154: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1155: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
1156: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
1157: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR
1158: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR
1159: THEN

Line 1156: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR

1152: OR g_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR
1153: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1154: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1155: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
1156: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
1157: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR
1158: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR
1159: THEN
1160:

Line 1157: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR

1153: OR g_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR
1154: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1155: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
1156: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
1157: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR
1158: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR
1159: THEN
1160:
1161: Get_Flex_Rev_Component;

Line 1158: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR

1154: OR g_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR
1155: OR g_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR
1156: OR g_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR
1157: OR g_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR
1158: OR g_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR
1159: THEN
1160:
1161: Get_Flex_Rev_Component;
1162:

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

1192: )
1193: IS
1194: l_rev_component_rec Bom_Bo_Pub.Rev_Component_Rec_Type;
1195: l_rev_comp_unexp_rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type;
1196: l_return_status VARCHAR2(1):=FND_API.G_RET_STS_SUCCESS;
1197: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
1198: BEGIN
1199:
1200: --

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

1268: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=
1269: p_Rev_Comp_Unexp_Rec;
1270: BEGIN
1271:
1272: IF l_rev_component_rec.supply_subinventory = FND_API.G_MISS_CHAR THEN
1273: l_rev_component_rec.supply_subinventory := NULL;
1274: l_rev_component_rec.location_name := NULL;
1275: l_rev_comp_unexp_rec.supply_locator_id := NULL;
1276: ELSIF l_rev_component_rec.supply_subinventory IS NULL THEN

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

1277: l_rev_component_rec.supply_subinventory :=
1278: p_old_rev_component_rec.supply_subinventory;
1279: /* Bug 2694107 */
1280: If (p_rev_comp_unexp_rec.supply_locator_id IS NULL) or
1281: (p_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM) THEN
1282: l_rev_comp_unexp_rec.supply_locator_id :=
1283: p_old_rev_comp_unexp_rec.supply_locator_id;
1284: End if;
1285: /* Bug 2694107 */

Line 1299: FND_API.G_MISS_NUM

1295: p_old_rev_comp_unexp_rec.supply_locator_id OR
1296: ( l_rev_comp_unexp_rec.supply_locator_id IS NOT
1297: NULL AND
1298: l_rev_comp_unexp_rec.supply_locator_id =
1299: FND_API.G_MISS_NUM
1300: )
1301: )
1302: )
1303: THEN

Line 1312: FND_API.G_MISS_NUM

1308: ELSIF l_rev_component_rec.Supply_Subinventory IS NOT NULL AND
1309: l_rev_component_rec.Supply_Subinventory <>
1310: p_old_rev_component_rec.supply_subinventory AND
1311: l_rev_comp_unexp_rec.supply_locator_id =
1312: FND_API.G_MISS_NUM
1313: THEN
1314: -- dbms_output.put_line('Supply Locator made NULL . . .');
1315:
1316: l_rev_comp_unexp_rec.supply_locator_id := NULL;

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

1324: l_rev_comp_unexp_rec.supply_locator_id :=
1325: p_old_rev_comp_unexp_rec.supply_locator_id;
1326: END IF;
1327:
1328: IF l_rev_comp_unexp_rec.supply_locator_id = FND_API.G_MISS_NUM THEN
1329: l_rev_comp_unexp_rec.supply_locator_id := NULL;
1330: l_rev_component_rec.location_name := NULL;
1331: END IF;
1332:

Line 1349: ELSIF l_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM

1345: IF l_rev_component_rec.wip_supply_type IS NULL THEN
1346: l_rev_component_rec.wip_supply_type :=
1347: p_old_rev_component_rec.wip_supply_type;
1348: /* Added for bug3221540 */
1349: ELSIF l_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM
1350: THEN
1351: l_rev_component_rec.wip_supply_type := NULL;
1352: END IF;
1353:

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

1367: p_old_rev_component_rec.basis_type;
1368: END IF;
1369:
1370: IF l_rev_component_rec.quantity_per_assembly IS NULL
1371: AND (l_rev_component_rec.inverse_quantity = FND_API.G_MISS_NUM
1372: OR l_rev_component_rec.inverse_quantity IS NULL
1373: OR l_rev_component_rec.inverse_quantity = 0)
1374: THEN
1375: l_rev_component_rec.quantity_per_assembly :=

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

1374: THEN
1375: l_rev_component_rec.quantity_per_assembly :=
1376: p_old_rev_component_rec.quantity_per_assembly;
1377: /* Commented as part of bug#3310077
1378: ELSIF l_rev_component_rec.quantity_per_assembly <> FND_API.G_MISS_NUM THEN -- added for bug 2442791
1379: l_rev_component_rec.quantity_per_assembly :=
1380: round(l_rev_component_rec.quantity_per_assembly, 7);
1381: */
1382: END IF;

Line 1400: ELSIF l_rev_component_rec.disable_date = FND_API.G_MISS_DATE

1396: IF l_rev_component_rec.disable_date IS NULL THEN
1397: l_rev_component_rec.disable_date :=
1398: p_old_rev_component_rec.disable_date;
1399: /* Added for bug 3486547 */
1400: ELSIF l_rev_component_rec.disable_date = FND_API.G_MISS_DATE
1401: then
1402: l_rev_component_rec.disable_date := NULL;
1403: END IF;
1404:

Line 1552: IF l_rev_component_rec.from_end_item_unit_number = FND_API.G_MISS_CHAR

1548: l_rev_component_rec.acd_type :=
1549: p_old_rev_component_rec.acd_type;
1550: END IF;
1551:
1552: IF l_rev_component_rec.from_end_item_unit_number = FND_API.G_MISS_CHAR
1553: THEN
1554: l_rev_component_rec.from_end_item_unit_number := null;
1555: ELSIF l_rev_component_rec.from_end_item_unit_number IS NULL
1556: THEN

Line 1561: IF l_rev_component_rec.to_end_item_unit_number = FND_API.G_MISS_CHAR

1557: l_rev_component_rec.from_end_item_unit_number :=
1558: p_old_rev_component_rec.from_end_item_unit_number;
1559: END IF;
1560:
1561: IF l_rev_component_rec.to_end_item_unit_number = FND_API.G_MISS_CHAR
1562: THEN
1563: l_rev_component_rec.to_end_item_unit_number := null;
1564: ELSIF l_rev_component_rec.to_end_item_unit_number IS NULL
1565: THEN

Line 1629: FND_API.G_MISS_NUM

1625: **************************************************/
1626:
1627: IF l_Rev_Comp_Unexp_Rec.component_sequence_id IS NULL OR
1628: l_Rev_Comp_Unexp_Rec.component_sequence_id =
1629: FND_API.G_MISS_NUM
1630: THEN
1631: l_Rev_Comp_Unexp_Rec.component_sequence_id :=
1632: Get_Component_Sequence;
1633:

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

1642:
1643: l_rev_comp_unexp_rec.pick_components :=
1644: p_old_rev_comp_unexp_rec.pick_components;
1645:
1646: IF l_rev_component_rec.enforce_int_requirements = FND_API.G_MISS_CHAR THEN
1647: l_rev_comp_unexp_rec.enforce_int_requirements_code := 0;
1648: l_rev_component_rec.enforce_int_requirements := Get_EnforceInteger_Value(
1649: p_enforce_integer => 0);
1650: ELSIF l_rev_component_rec.enforce_int_requirements IS NULL THEN

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

1762:
1763: IF (p_rev_component_rec.quantity_per_assembly) IS NULL
1764: THEN
1765: IF (p_rev_component_rec.inverse_quantity IS NOT NULL
1766: AND p_rev_component_rec.inverse_quantity <> FND_API.G_MISS_NUM)
1767: THEN
1768: IF (p_rev_component_rec.inverse_quantity = 0)
1769: THEN
1770: x_rev_component_rec.quantity_per_assembly := 0;