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_BOM_COMPONENT_UTIL dependencies on FND_API

Line 356: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR) =

352: WHERE component_item_id = p_component_item_id
353: AND effectivity_date = p_effectivity_date
354: AND operation_seq_num = nvl(p_operation_sequence_number,1) --Bug 5856042
355: AND bill_sequence_id = p_bill_sequence_id
356: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR) =
357: NVL(p_from_end_item_number, FND_API.G_MISS_CHAR);
358:
359: x_Return_Status := BOM_Globals.G_RECORD_FOUND;
360: x_Rev_Component_Rec := l_rev_component_rec;

Line 357: NVL(p_from_end_item_number, FND_API.G_MISS_CHAR);

353: AND effectivity_date = p_effectivity_date
354: AND operation_seq_num = nvl(p_operation_sequence_number,1) --Bug 5856042
355: AND bill_sequence_id = p_bill_sequence_id
356: AND NVL(from_end_item_unit_number, FND_API.G_MISS_CHAR) =
357: NVL(p_from_end_item_number, FND_API.G_MISS_CHAR);
358:
359: x_Return_Status := BOM_Globals.G_RECORD_FOUND;
360: x_Rev_Component_Rec := l_rev_component_rec;
361: x_Rev_Comp_Unexp_Rec := l_Rev_Comp_Unexp_Rec;

Line 368: l_rev_comp_unexp_rec.enforce_int_requirements_code <> FND_API.G_MISS_NUM THEN

364:
365: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Selecting the lookup meaning for enforce int requirements code . . .'); END IF;
366:
367: IF l_rev_comp_unexp_rec.enforce_int_requirements_code IS NOT NULL AND
368: l_rev_comp_unexp_rec.enforce_int_requirements_code <> FND_API.G_MISS_NUM THEN
369: Begin
370: SELECT meaning INTO l_rev_component_rec.enforce_int_requirements FROM mfg_lookups
371: WHERE lookup_type = 'BOM_ENFORCE_INT_REQUIREMENTS' AND
372: lookup_code = l_rev_comp_unexp_rec.enforce_int_requirements_code;

Line 386: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

382: , p_mesg_token_tbl => p_mesg_token_tbl
383: , x_mesg_token_tbl => x_mesg_token_tbl
384: );
385:
386: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
387: End;
388: END IF;
389:
390:

Line 411: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

407: , p_mesg_token_tbl => p_mesg_token_tbl
408: , x_mesg_token_tbl => x_mesg_token_tbl
409: );
410:
411: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
412:
413: END Query_Row;
414:
415: /***************************************************************************

Line 443: (p_rev_component_rec.new_operation_sequence_number =FND_API.G_MISS_NUM) ) THEN

439:
440: /* need to populate Operation Lead Time percent corresponding to the operation
441: -vhymavat bug3537394 */
442: IF((p_rev_component_rec.new_operation_sequence_number IS NULL) OR
443: (p_rev_component_rec.new_operation_sequence_number =FND_API.G_MISS_NUM) ) THEN
444: l_operation_seq_num := p_rev_component_rec.operation_sequence_number;
445:
446: ELSE
447: l_operation_seq_num :=p_rev_component_rec.new_operation_sequence_number;

Line 468: DECODE(p_rev_comp_Unexp_rec.supply_locator_id, FND_API.G_MISS_NUM,

464: , REQUIRED_FOR_REVENUE = p_rev_component_rec.required_for_revenue
465: , HIGH_QUANTITY = p_rev_component_rec.maximum_allowed_quantity
466: , WIP_SUPPLY_TYPE = p_rev_component_rec.wip_supply_type
467: , SUPPLY_LOCATOR_ID =
468: DECODE(p_rev_comp_Unexp_rec.supply_locator_id, FND_API.G_MISS_NUM,
469: NULL, p_rev_comp_Unexp_rec.supply_locator_id)
470: , OPERATION_SEQ_NUM = l_operation_seq_num
471: , EFFECTIVITY_DATE =
472: DECODE( p_rev_component_rec.new_effectivity_date

Line 473: , FND_API.G_MISS_DATE

469: NULL, p_rev_comp_Unexp_rec.supply_locator_id)
470: , OPERATION_SEQ_NUM = l_operation_seq_num
471: , EFFECTIVITY_DATE =
472: DECODE( p_rev_component_rec.new_effectivity_date
473: , FND_API.G_MISS_DATE
474: , p_rev_component_rec.start_effective_date
475: , NULL
476: , p_rev_component_rec.start_effective_date
477: , p_rev_component_rec.new_effectivity_date

Line 484: FND_API.G_MISS_NUM, null,p_rev_component_rec.basis_type)

480: , LAST_UPDATED_BY = BOM_Globals.Get_User_Id
481: , LAST_UPDATE_LOGIN = BOM_Globals.Get_User_Id
482: , ITEM_NUM = p_rev_component_rec.item_sequence_number
483: , BASIS_TYPE = decode(p_rev_component_rec.basis_type,
484: FND_API.G_MISS_NUM, null,p_rev_component_rec.basis_type)
485: , COMPONENT_QUANTITY = p_rev_component_rec.quantity_per_assembly
486: , COMPONENT_YIELD_FACTOR = p_rev_component_rec.projected_yield
487: , COMPONENT_REMARKS =
488: DECODE( p_rev_component_rec.comments, --bug:4178604 Replace FND_API.G_MISS_CHAR by NULL

Line 488: DECODE( p_rev_component_rec.comments, --bug:4178604 Replace FND_API.G_MISS_CHAR by NULL

484: FND_API.G_MISS_NUM, null,p_rev_component_rec.basis_type)
485: , COMPONENT_QUANTITY = p_rev_component_rec.quantity_per_assembly
486: , COMPONENT_YIELD_FACTOR = p_rev_component_rec.projected_yield
487: , COMPONENT_REMARKS =
488: DECODE( p_rev_component_rec.comments, --bug:4178604 Replace FND_API.G_MISS_CHAR by NULL
489: FND_API.G_MISS_CHAR,NULL,
490: p_rev_component_rec.comments)
491: , DISABLE_DATE = p_rev_component_rec.disable_date
492: , ATTRIBUTE_CATEGORY = p_rev_component_rec.attribute_category

Line 489: FND_API.G_MISS_CHAR,NULL,

485: , COMPONENT_QUANTITY = p_rev_component_rec.quantity_per_assembly
486: , COMPONENT_YIELD_FACTOR = p_rev_component_rec.projected_yield
487: , COMPONENT_REMARKS =
488: DECODE( p_rev_component_rec.comments, --bug:4178604 Replace FND_API.G_MISS_CHAR by NULL
489: FND_API.G_MISS_CHAR,NULL,
490: p_rev_component_rec.comments)
491: , DISABLE_DATE = p_rev_component_rec.disable_date
492: , ATTRIBUTE_CATEGORY = p_rev_component_rec.attribute_category
493: , ATTRIBUTE1 = p_rev_component_rec.attribute1

Line 527: ,FND_API.G_MISS_CHAR

523: , Original_System_Reference =
524: p_rev_component_rec.original_system_reference
525: , From_End_Item_Unit_Number =
526: DECODE(p_rev_component_rec.new_from_end_item_unit_number
527: ,FND_API.G_MISS_CHAR
528: ,p_rev_component_rec.from_end_item_unit_number
529: ,NULL
530: ,p_rev_component_rec.from_end_item_unit_number
531: ,p_rev_component_rec.new_from_end_item_unit_number

Line 535: , FND_API.G_MISS_CHAR

531: ,p_rev_component_rec.new_from_end_item_unit_number
532: )
533: , To_End_Item_Unit_Number =
534: DECODE( p_rev_component_rec.to_end_item_unit_number
535: , FND_API.G_MISS_CHAR
536: , NULL
537: , p_rev_component_rec.to_end_item_unit_number
538: )
539: , Enforce_Int_Requirements = p_rev_comp_Unexp_rec.Enforce_Int_Requirements_code

Line 555: -- x_Return_Status := FND_API.G_RET_STS_SUCCESS;

551: BOMPCMBM.Update_Related_Components( p_src_comp_seq_id => p_Rev_Comp_Unexp_Rec.component_sequence_id
552: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
553: , x_Return_Status => x_Return_Status
554: );
555: -- x_Return_Status := FND_API.G_RET_STS_SUCCESS;
556: EXCEPTION
557:
558: WHEN OTHERS THEN
559:

Line 574: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

570: );
571: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
572: END IF;
573:
574: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
575: END Update_Row;
576:
577: --following function has been added for bug 7713832
578: FUNCTION Get_Src_Comp_Seq_Id(p_component_item_id IN NUMBER

Line 663: if (p_rev_comp_Unexp_rec.old_component_sequence_id = FND_API.G_MISS_NUM)

659: -- It was removed so that while migrating common bill components
660: --common_component_sequence_id is populated correctly
661:
662: if l_Bo_Id = BOM_Globals.G_ECO_BO THEN
663: if (p_rev_comp_Unexp_rec.old_component_sequence_id = FND_API.G_MISS_NUM)
664: or (p_rev_comp_Unexp_rec.old_component_sequence_id is NULL) then
665: --l_old_component_sequence_id := p_rev_comp_Unexp_rec.component_sequence_id;
666: l_src_comp_seq_id := null;
667: else

Line 676: if (p_rev_comp_Unexp_rec.old_component_sequence_id = FND_API.G_MISS_NUM) then

672: component_sequence_id = l_old_component_sequence_id;
673: end if;
674: end if;
675: else
676: if (p_rev_comp_Unexp_rec.old_component_sequence_id = FND_API.G_MISS_NUM) then
677: l_old_component_sequence_id := NULL;
678: else
679: l_old_component_sequence_id := p_rev_comp_Unexp_rec.old_component_sequence_id;
680: if l_old_component_sequence_id is not null then

Line 706: (p_rev_component_rec.new_operation_sequence_number =FND_API.G_MISS_NUM) ) THEN

702:
703: /* need to populate Operation Lead Time percent corresponding to the operation
704: -vhymavat bug3537394 */
705: IF((p_rev_component_rec.new_operation_sequence_number IS NULL) OR
706: (p_rev_component_rec.new_operation_sequence_number =FND_API.G_MISS_NUM) ) THEN
707:
708: IF (( p_rev_component_rec.operation_sequence_number IS NULL) OR
709: ( p_rev_component_rec.operation_sequence_number =FND_API.G_MISS_NUM)) THEN
710: l_operation_seq_num := 1;

Line 709: ( p_rev_component_rec.operation_sequence_number =FND_API.G_MISS_NUM)) THEN

705: IF((p_rev_component_rec.new_operation_sequence_number IS NULL) OR
706: (p_rev_component_rec.new_operation_sequence_number =FND_API.G_MISS_NUM) ) THEN
707:
708: IF (( p_rev_component_rec.operation_sequence_number IS NULL) OR
709: ( p_rev_component_rec.operation_sequence_number =FND_API.G_MISS_NUM)) THEN
710: l_operation_seq_num := 1;
711: ELSE
712: l_operation_seq_num := p_rev_component_rec.operation_sequence_number;
713: END IF;

Line 832: , DECODE(p_rev_comp_Unexp_rec.supply_locator_id, FND_API.G_MISS_NUM,

828: , p_rev_component_rec.maximum_allowed_quantity
829: , p_rev_comp_Unexp_rec.component_sequence_id
830: , BOM_Globals.Get_Prog_AppId
831: , p_rev_component_rec.wip_supply_type
832: , DECODE(p_rev_comp_Unexp_rec.supply_locator_id, FND_API.G_MISS_NUM,
833: NULL, p_rev_comp_Unexp_rec.supply_locator_id)
834: , p_rev_comp_Unexp_rec.bom_item_type
835: , l_operation_seq_num
836: , p_rev_comp_Unexp_rec.component_item_id

Line 842: , DECODE(p_rev_component_rec.item_sequence_number, FND_API.G_MISS_NUM,

838: , BOM_Globals.Get_User_Id /* Last Updated By */
839: , SYSDATE /* Creation Date */
840: , BOM_Globals.Get_User_Id /* Created By */
841: , BOM_Globals.Get_User_Id /* Last Update Login */
842: , DECODE(p_rev_component_rec.item_sequence_number, FND_API.G_MISS_NUM,
843: 1, NULL,1,p_rev_component_rec.item_sequence_number)
844: , DECODE(p_rev_component_rec.basis_type,FND_API.G_MISS_NUM,
845: NULL,p_rev_component_rec.basis_type)
846: , p_rev_component_rec.quantity_per_assembly

Line 844: , DECODE(p_rev_component_rec.basis_type,FND_API.G_MISS_NUM,

840: , BOM_Globals.Get_User_Id /* Created By */
841: , BOM_Globals.Get_User_Id /* Last Update Login */
842: , DECODE(p_rev_component_rec.item_sequence_number, FND_API.G_MISS_NUM,
843: 1, NULL,1,p_rev_component_rec.item_sequence_number)
844: , DECODE(p_rev_component_rec.basis_type,FND_API.G_MISS_NUM,
845: NULL,p_rev_component_rec.basis_type)
846: , p_rev_component_rec.quantity_per_assembly
847: , p_rev_component_rec.projected_yield
848: , p_rev_component_rec.comments

Line 897: -- , FND_API.G_MISS_NUM

893: , NULL /* Include On Bill Docs */
894: , p_rev_component_rec.minimum_allowed_quantity
895: , p_rev_component_rec.acd_type
896: -- , DECODE( p_rev_comp_Unexp_rec.old_component_sequence_id
897: -- , FND_API.G_MISS_NUM
898: -- , NULL
899: -- ,p_rev_comp_Unexp_rec.old_component_sequence_id
900: -- )
901: , l_old_component_sequence_id

Line 909: , FND_API.G_MISS_CHAR

905: , SYSDATE /* program_update_date */
906: , p_rev_comp_Unexp_rec.pick_components
907: , p_rev_component_rec.original_system_reference
908: , DECODE( p_rev_component_rec.from_end_item_unit_number
909: , FND_API.G_MISS_CHAR
910: , null
911: , p_rev_component_rec.from_end_item_unit_number
912: )
913: , DECODE( p_rev_component_rec.to_end_item_unit_number

Line 914: , FND_API.G_MISS_CHAR

910: , null
911: , p_rev_component_rec.from_end_item_unit_number
912: )
913: , DECODE( p_rev_component_rec.to_end_item_unit_number
914: , FND_API.G_MISS_CHAR
915: , null
916: , p_rev_component_rec.to_end_item_unit_number
917: )
918: , BOM_Globals.Get_Eco_For_Production

Line 969: --x_Return_Status := FND_API.G_RET_STS_SUCCESS;

965: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
966: , x_Return_Status => x_Return_Status
967: );
968: END IF;
969: --x_Return_Status := FND_API.G_RET_STS_SUCCESS;
970:
971: EXCEPTION
972: --included for Bug 9076970
973: -- if bom is imported w/o routing same components menat to be imported at different operation_seq_num will now

Line 997: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

993: );
994: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
995: END IF;
996:
997: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
998:
999: END Insert_Row;
1000:
1001: /****************************************************************************

Line 1055: x_return_status := FND_API.G_RET_STS_SUCCESS;

1051: -- Initialize Common Record and Status
1052: --
1053: l_rev_component_rec := p_rev_component_rec ;
1054: l_rev_comp_unexp_rec := p_rev_comp_unexp_rec ;
1055: x_return_status := FND_API.G_RET_STS_SUCCESS;
1056:
1057: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
1058: THEN
1059:

Line 1111: x_return_status := FND_API.G_RET_STS_ERROR;

1107: , p_mesg_token_tbl => l_mesg_token_Tbl
1108: , x_mesg_token_tbl => l_mesg_token_tbl
1109: );
1110:
1111: x_return_status := FND_API.G_RET_STS_ERROR;
1112: x_mesg_token_tbl := l_mesg_token_tbl;
1113: RETURN;
1114: END IF;
1115:

Line 1122: IF l_rev_comp_unexp_rec.DG_Sequence_Id <> FND_API.G_MISS_NUM

1118: l_rev_comp_unexp_rec.DG_Description := DG.description;
1119:
1120: END LOOP;
1121:
1122: IF l_rev_comp_unexp_rec.DG_Sequence_Id <> FND_API.G_MISS_NUM
1123: THEN
1124: l_dg_sequence_id := l_rev_comp_unexp_rec.DG_Sequence_Id;
1125: ELSE
1126: l_dg_sequence_id := NULL;

Line 1162: --x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1158: , x_Return_Status => x_Return_Status);
1159:
1160: END IF ;
1161:
1162: --x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1163: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1164:
1165: EXCEPTION
1166:

Line 1179: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1175: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1176: );
1177: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1178: END IF;
1179: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1180: END Delete_Row;
1181:
1182: /*******************************************************
1183: * This is copy of the procedure that is currently used by

Line 1417: l_return_status := FND_API.G_RET_STS_SUCCESS;

1413: err_code varchar2(100);
1414: BEGIN
1415: l_rev_component_rec := p_rev_component_rec;
1416: l_rev_comp_unexp_rec := p_rev_comp_unexp_rec;
1417: l_return_status := FND_API.G_RET_STS_SUCCESS;
1418:
1419: l_Token_Tbl(1).Token_Name := 'REVISED_COMPONENT_NAME';
1420: l_Token_Tbl(1).Token_Value := l_rev_component_rec.component_item_name;
1421:

Line 1520: If (x_return_Status = FND_API.G_RET_STS_SUCCESS) Then

1516: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1517: , x_return_status => l_Return_Status
1518: );
1519:
1520: If (x_return_Status = FND_API.G_RET_STS_SUCCESS) Then
1521:
1522: Begin
1523: SELECT BOM_ITEM_TYPE
1524: INTO l_bom_item_type

Line 1668: l_return_status := FND_API.G_RET_STS_ERROR;

1664: , p_Mesg_Token_Tbl=> l_Mesg_Token_Tbl
1665: , x_Mesg_Token_Tbl=> l_Mesg_Token_Tbl
1666: , p_Token_Tbl => l_Token_Tbl
1667: );
1668: l_return_status := FND_API.G_RET_STS_ERROR;
1669: RETURN;
1670: END IF;
1671:
1672: IF l_Rev_Component_Rec.Transaction_Type = BOM_GLOBALS.G_OPR_CREATE THEN

Line 1701: l_return_status := FND_API.G_RET_STS_ERROR;

1697: , p_Mesg_Token_Tbl=> l_Mesg_Token_Tbl
1698: , x_Mesg_Token_Tbl=> l_Mesg_Token_Tbl
1699: , p_Token_Tbl => l_Token_Tbl
1700: );
1701: l_return_status := FND_API.G_RET_STS_ERROR;
1702: END IF;
1703: END IF;
1704: END IF;
1705:

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

1864: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=
1865: p_Rev_Comp_Unexp_Rec;
1866: BEGIN
1867:
1868: IF l_rev_component_rec.supply_subinventory = FND_API.G_MISS_CHAR THEN
1869: l_rev_component_rec.supply_subinventory := NULL;
1870: END IF;
1871:
1872: IF l_rev_component_rec.required_for_revenue = FND_API.G_MISS_NUM THEN

Line 1872: IF l_rev_component_rec.required_for_revenue = FND_API.G_MISS_NUM THEN

1868: IF l_rev_component_rec.supply_subinventory = FND_API.G_MISS_CHAR THEN
1869: l_rev_component_rec.supply_subinventory := NULL;
1870: END IF;
1871:
1872: IF l_rev_component_rec.required_for_revenue = FND_API.G_MISS_NUM THEN
1873: l_rev_component_rec.required_for_revenue := NULL;
1874: END IF;
1875:
1876: IF l_rev_component_rec.maximum_allowed_quantity = FND_API.G_MISS_NUM THEN

Line 1876: IF l_rev_component_rec.maximum_allowed_quantity = FND_API.G_MISS_NUM THEN

1872: IF l_rev_component_rec.required_for_revenue = FND_API.G_MISS_NUM THEN
1873: l_rev_component_rec.required_for_revenue := NULL;
1874: END IF;
1875:
1876: IF l_rev_component_rec.maximum_allowed_quantity = FND_API.G_MISS_NUM THEN
1877: l_rev_component_rec.maximum_allowed_quantity := NULL;
1878: END IF;
1879:
1880:

Line 1881: IF l_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN

1877: l_rev_component_rec.maximum_allowed_quantity := NULL;
1878: END IF;
1879:
1880:
1881: IF l_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN
1882: l_rev_component_rec.wip_supply_type := NULL;
1883: END IF;
1884:
1885: IF l_rev_component_rec.location_name = FND_API.G_MISS_NUM THEN

Line 1885: IF l_rev_component_rec.location_name = FND_API.G_MISS_NUM THEN

1881: IF l_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN
1882: l_rev_component_rec.wip_supply_type := NULL;
1883: END IF;
1884:
1885: IF l_rev_component_rec.location_name = FND_API.G_MISS_NUM THEN
1886: l_rev_comp_unexp_rec.supply_locator_id := NULL;
1887: END IF;
1888:
1889: IF l_rev_component_rec.operation_sequence_number = FND_API.G_MISS_NUM THEN

Line 1889: IF l_rev_component_rec.operation_sequence_number = FND_API.G_MISS_NUM THEN

1885: IF l_rev_component_rec.location_name = FND_API.G_MISS_NUM THEN
1886: l_rev_comp_unexp_rec.supply_locator_id := NULL;
1887: END IF;
1888:
1889: IF l_rev_component_rec.operation_sequence_number = FND_API.G_MISS_NUM THEN
1890: l_rev_component_rec.operation_sequence_number := NULL;
1891: END IF;
1892:
1893: IF l_rev_component_rec.item_sequence_number = FND_API.G_MISS_NUM THEN

Line 1893: IF l_rev_component_rec.item_sequence_number = FND_API.G_MISS_NUM THEN

1889: IF l_rev_component_rec.operation_sequence_number = FND_API.G_MISS_NUM THEN
1890: l_rev_component_rec.operation_sequence_number := NULL;
1891: END IF;
1892:
1893: IF l_rev_component_rec.item_sequence_number = FND_API.G_MISS_NUM THEN
1894: l_rev_component_rec.item_sequence_number := NULL;
1895: END IF;
1896:
1897: IF l_rev_component_rec.quantity_per_assembly = FND_API.G_MISS_NUM THEN

Line 1897: IF l_rev_component_rec.quantity_per_assembly = FND_API.G_MISS_NUM THEN

1893: IF l_rev_component_rec.item_sequence_number = FND_API.G_MISS_NUM THEN
1894: l_rev_component_rec.item_sequence_number := NULL;
1895: END IF;
1896:
1897: IF l_rev_component_rec.quantity_per_assembly = FND_API.G_MISS_NUM THEN
1898: l_rev_component_rec.quantity_per_assembly := NULL;
1899: END IF;
1900:
1901: IF l_rev_component_rec.projected_yield = FND_API.G_MISS_NUM THEN

Line 1901: IF l_rev_component_rec.projected_yield = FND_API.G_MISS_NUM THEN

1897: IF l_rev_component_rec.quantity_per_assembly = FND_API.G_MISS_NUM THEN
1898: l_rev_component_rec.quantity_per_assembly := NULL;
1899: END IF;
1900:
1901: IF l_rev_component_rec.projected_yield = FND_API.G_MISS_NUM THEN
1902: l_rev_component_rec.projected_yield := NULL;
1903: END IF;
1904:
1905: IF l_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN

Line 1905: IF l_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN

1901: IF l_rev_component_rec.projected_yield = FND_API.G_MISS_NUM THEN
1902: l_rev_component_rec.projected_yield := NULL;
1903: END IF;
1904:
1905: IF l_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN
1906: l_rev_component_rec.comments := NULL;
1907: END IF;
1908:
1909: IF l_rev_component_rec.start_effective_date = FND_API.G_MISS_DATE THEN

Line 1909: IF l_rev_component_rec.start_effective_date = FND_API.G_MISS_DATE THEN

1905: IF l_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN
1906: l_rev_component_rec.comments := NULL;
1907: END IF;
1908:
1909: IF l_rev_component_rec.start_effective_date = FND_API.G_MISS_DATE THEN
1910: l_rev_component_rec.start_effective_date := NULL;
1911: END IF;
1912:
1913: IF l_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN

Line 1913: IF l_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN

1909: IF l_rev_component_rec.start_effective_date = FND_API.G_MISS_DATE THEN
1910: l_rev_component_rec.start_effective_date := NULL;
1911: END IF;
1912:
1913: IF l_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN
1914: l_rev_component_rec.disable_date := NULL;
1915: END IF;
1916:
1917: IF l_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN

Line 1917: IF l_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN

1913: IF l_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN
1914: l_rev_component_rec.disable_date := NULL;
1915: END IF;
1916:
1917: IF l_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1918: l_rev_component_rec.attribute_category := NULL;
1919: END IF;
1920:
1921: IF l_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

Line 1921: IF l_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

1917: IF l_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1918: l_rev_component_rec.attribute_category := NULL;
1919: END IF;
1920:
1921: IF l_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1922: l_rev_component_rec.attribute1 := NULL;
1923: END IF;
1924:
1925: IF l_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

Line 1925: IF l_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

1921: IF l_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1922: l_rev_component_rec.attribute1 := NULL;
1923: END IF;
1924:
1925: IF l_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1926: l_rev_component_rec.attribute2 := NULL;
1927: END IF;
1928:
1929: IF l_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

Line 1929: IF l_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

1925: IF l_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1926: l_rev_component_rec.attribute2 := NULL;
1927: END IF;
1928:
1929: IF l_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1930: l_rev_component_rec.attribute3 := NULL;
1931: END IF;
1932:
1933: IF l_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

Line 1933: IF l_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

1929: IF l_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1930: l_rev_component_rec.attribute3 := NULL;
1931: END IF;
1932:
1933: IF l_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1934: l_rev_component_rec.attribute4 := NULL;
1935: END IF;
1936:
1937: IF l_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

Line 1937: IF l_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

1933: IF l_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1934: l_rev_component_rec.attribute4 := NULL;
1935: END IF;
1936:
1937: IF l_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1938: l_rev_component_rec.attribute5 := NULL;
1939: END IF;
1940:
1941: IF l_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

Line 1941: IF l_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

1937: IF l_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1938: l_rev_component_rec.attribute5 := NULL;
1939: END IF;
1940:
1941: IF l_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1942: l_rev_component_rec.attribute6 := NULL;
1943: END IF;
1944:
1945: IF l_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

Line 1945: IF l_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

1941: IF l_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1942: l_rev_component_rec.attribute6 := NULL;
1943: END IF;
1944:
1945: IF l_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1946: l_rev_component_rec.attribute7 := NULL;
1947: END IF;
1948:
1949: IF l_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

Line 1949: IF l_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

1945: IF l_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1946: l_rev_component_rec.attribute7 := NULL;
1947: END IF;
1948:
1949: IF l_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1950: l_rev_component_rec.attribute8 := NULL;
1951: END IF;
1952:
1953: IF l_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

Line 1953: IF l_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

1949: IF l_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1950: l_rev_component_rec.attribute8 := NULL;
1951: END IF;
1952:
1953: IF l_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1954: l_rev_component_rec.attribute9 := NULL;
1955: END IF;
1956:
1957: IF l_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

Line 1957: IF l_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

1953: IF l_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1954: l_rev_component_rec.attribute9 := NULL;
1955: END IF;
1956:
1957: IF l_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1958: l_rev_component_rec.attribute10 := NULL;
1959: END IF;
1960:
1961: IF l_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

Line 1961: IF l_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

1957: IF l_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1958: l_rev_component_rec.attribute10 := NULL;
1959: END IF;
1960:
1961: IF l_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1962: l_rev_component_rec.attribute11 := NULL;
1963: END IF;
1964:
1965: IF l_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN

Line 1965: IF l_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN

1961: IF l_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1962: l_rev_component_rec.attribute11 := NULL;
1963: END IF;
1964:
1965: IF l_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1966: l_rev_component_rec.attribute12 := NULL;
1967: END IF;
1968:
1969: IF l_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN

Line 1969: IF l_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN

1965: IF l_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1966: l_rev_component_rec.attribute12 := NULL;
1967: END IF;
1968:
1969: IF l_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1970: l_rev_component_rec.attribute13 := NULL;
1971: END IF;
1972:
1973: IF l_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN

Line 1973: IF l_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN

1969: IF l_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1970: l_rev_component_rec.attribute13 := NULL;
1971: END IF;
1972:
1973: IF l_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1974: l_rev_component_rec.attribute14 := NULL;
1975: END IF;
1976:
1977: IF l_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN

Line 1977: IF l_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN

1973: IF l_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1974: l_rev_component_rec.attribute14 := NULL;
1975: END IF;
1976:
1977: IF l_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1978: l_rev_component_rec.attribute15 := NULL;
1979: END IF;
1980:
1981: IF l_rev_component_rec.planning_percent = FND_API.G_MISS_NUM THEN

Line 1981: IF l_rev_component_rec.planning_percent = FND_API.G_MISS_NUM THEN

1977: IF l_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1978: l_rev_component_rec.attribute15 := NULL;
1979: END IF;
1980:
1981: IF l_rev_component_rec.planning_percent = FND_API.G_MISS_NUM THEN
1982: l_rev_component_rec.planning_percent := NULL;
1983: END IF;
1984:
1985: IF l_rev_component_rec.quantity_related = FND_API.G_MISS_NUM THEN

Line 1985: IF l_rev_component_rec.quantity_related = FND_API.G_MISS_NUM THEN

1981: IF l_rev_component_rec.planning_percent = FND_API.G_MISS_NUM THEN
1982: l_rev_component_rec.planning_percent := NULL;
1983: END IF;
1984:
1985: IF l_rev_component_rec.quantity_related = FND_API.G_MISS_NUM THEN
1986: l_rev_component_rec.quantity_related := NULL;
1987: END IF;
1988:
1989: IF l_rev_component_rec.so_basis = FND_API.G_MISS_NUM THEN

Line 1989: IF l_rev_component_rec.so_basis = FND_API.G_MISS_NUM THEN

1985: IF l_rev_component_rec.quantity_related = FND_API.G_MISS_NUM THEN
1986: l_rev_component_rec.quantity_related := NULL;
1987: END IF;
1988:
1989: IF l_rev_component_rec.so_basis = FND_API.G_MISS_NUM THEN
1990: l_rev_component_rec.so_basis := NULL;
1991: END IF;
1992:
1993: IF l_rev_component_rec.optional = FND_API.G_MISS_NUM THEN

Line 1993: IF l_rev_component_rec.optional = FND_API.G_MISS_NUM THEN

1989: IF l_rev_component_rec.so_basis = FND_API.G_MISS_NUM THEN
1990: l_rev_component_rec.so_basis := NULL;
1991: END IF;
1992:
1993: IF l_rev_component_rec.optional = FND_API.G_MISS_NUM THEN
1994: l_rev_component_rec.optional := NULL;
1995: END IF;
1996:
1997: IF l_rev_component_rec.mutually_exclusive = FND_API.G_MISS_NUM THEN

Line 1997: IF l_rev_component_rec.mutually_exclusive = FND_API.G_MISS_NUM THEN

1993: IF l_rev_component_rec.optional = FND_API.G_MISS_NUM THEN
1994: l_rev_component_rec.optional := NULL;
1995: END IF;
1996:
1997: IF l_rev_component_rec.mutually_exclusive = FND_API.G_MISS_NUM THEN
1998: l_rev_component_rec.mutually_exclusive := NULL;
1999: END IF;
2000:
2001: IF l_rev_component_rec.include_in_cost_rollup = FND_API.G_MISS_NUM THEN

Line 2001: IF l_rev_component_rec.include_in_cost_rollup = FND_API.G_MISS_NUM THEN

1997: IF l_rev_component_rec.mutually_exclusive = FND_API.G_MISS_NUM THEN
1998: l_rev_component_rec.mutually_exclusive := NULL;
1999: END IF;
2000:
2001: IF l_rev_component_rec.include_in_cost_rollup = FND_API.G_MISS_NUM THEN
2002: l_rev_component_rec.include_in_cost_rollup := NULL;
2003: END IF;
2004:
2005: IF l_rev_component_rec.check_atp = FND_API.G_MISS_NUM THEN

Line 2005: IF l_rev_component_rec.check_atp = FND_API.G_MISS_NUM THEN

2001: IF l_rev_component_rec.include_in_cost_rollup = FND_API.G_MISS_NUM THEN
2002: l_rev_component_rec.include_in_cost_rollup := NULL;
2003: END IF;
2004:
2005: IF l_rev_component_rec.check_atp = FND_API.G_MISS_NUM THEN
2006: l_rev_component_rec.check_atp := NULL;
2007: END IF;
2008:
2009: IF l_rev_component_rec.shipping_allowed = FND_API.G_MISS_NUM THEN

Line 2009: IF l_rev_component_rec.shipping_allowed = FND_API.G_MISS_NUM THEN

2005: IF l_rev_component_rec.check_atp = FND_API.G_MISS_NUM THEN
2006: l_rev_component_rec.check_atp := NULL;
2007: END IF;
2008:
2009: IF l_rev_component_rec.shipping_allowed = FND_API.G_MISS_NUM THEN
2010: l_rev_component_rec.shipping_allowed := NULL;
2011: END IF;
2012:
2013: IF l_rev_component_rec.required_to_ship = FND_API.G_MISS_NUM THEN

Line 2013: IF l_rev_component_rec.required_to_ship = FND_API.G_MISS_NUM THEN

2009: IF l_rev_component_rec.shipping_allowed = FND_API.G_MISS_NUM THEN
2010: l_rev_component_rec.shipping_allowed := NULL;
2011: END IF;
2012:
2013: IF l_rev_component_rec.required_to_ship = FND_API.G_MISS_NUM THEN
2014: l_rev_component_rec.required_to_ship := NULL;
2015: END IF;
2016:
2017: IF l_rev_component_rec.include_on_ship_docs = FND_API.G_MISS_NUM THEN

Line 2017: IF l_rev_component_rec.include_on_ship_docs = FND_API.G_MISS_NUM THEN

2013: IF l_rev_component_rec.required_to_ship = FND_API.G_MISS_NUM THEN
2014: l_rev_component_rec.required_to_ship := NULL;
2015: END IF;
2016:
2017: IF l_rev_component_rec.include_on_ship_docs = FND_API.G_MISS_NUM THEN
2018: l_rev_component_rec.include_on_ship_docs := NULL;
2019: END IF;
2020:
2021: IF l_rev_component_rec.minimum_allowed_quantity = FND_API.G_MISS_NUM THEN

Line 2021: IF l_rev_component_rec.minimum_allowed_quantity = FND_API.G_MISS_NUM THEN

2017: IF l_rev_component_rec.include_on_ship_docs = FND_API.G_MISS_NUM THEN
2018: l_rev_component_rec.include_on_ship_docs := NULL;
2019: END IF;
2020:
2021: IF l_rev_component_rec.minimum_allowed_quantity = FND_API.G_MISS_NUM THEN
2022: l_rev_component_rec.minimum_allowed_quantity := NULL;
2023: END IF;
2024:
2025: IF l_rev_component_rec.acd_type = FND_API.G_MISS_NUM THEN

Line 2025: IF l_rev_component_rec.acd_type = FND_API.G_MISS_NUM THEN

2021: IF l_rev_component_rec.minimum_allowed_quantity = FND_API.G_MISS_NUM THEN
2022: l_rev_component_rec.minimum_allowed_quantity := NULL;
2023: END IF;
2024:
2025: IF l_rev_component_rec.acd_type = FND_API.G_MISS_NUM THEN
2026: l_rev_component_rec.acd_type := NULL;
2027: END IF;
2028:
2029: -- Added in 11.5.9 by ADEY

Line 2030: IF l_rev_component_rec.auto_request_material = FND_API.G_MISS_CHAR THEN

2026: l_rev_component_rec.acd_type := NULL;
2027: END IF;
2028:
2029: -- Added in 11.5.9 by ADEY
2030: IF l_rev_component_rec.auto_request_material = FND_API.G_MISS_CHAR THEN
2031: l_rev_component_rec.auto_request_material := NULL;
2032: END IF;
2033:
2034: IF l_rev_component_rec.Suggested_Vendor_Name = FND_API.G_MISS_CHAR THEN --- Deepu

Line 2034: IF l_rev_component_rec.Suggested_Vendor_Name = FND_API.G_MISS_CHAR THEN --- Deepu

2030: IF l_rev_component_rec.auto_request_material = FND_API.G_MISS_CHAR THEN
2031: l_rev_component_rec.auto_request_material := NULL;
2032: END IF;
2033:
2034: IF l_rev_component_rec.Suggested_Vendor_Name = FND_API.G_MISS_CHAR THEN --- Deepu
2035: l_rev_component_rec.Suggested_Vendor_Name := NULL;
2036: l_Rev_Comp_Unexp_Rec.Vendor_Id := NULL;
2037: END IF;
2038:

Line 2040: IF l_rev_component_rec.purchasing_category_id = FND_API.G_MISS_NUM THEN --- Deepu

2036: l_Rev_Comp_Unexp_Rec.Vendor_Id := NULL;
2037: END IF;
2038:
2039: /*
2040: IF l_rev_component_rec.purchasing_category_id = FND_API.G_MISS_NUM THEN --- Deepu
2041: l_rev_component_rec.purchasing_category_id := NULL;
2042: END IF;
2043: */
2044: IF l_rev_component_rec.Unit_Price = FND_API.G_MISS_NUM THEN --- Deepu

Line 2044: IF l_rev_component_rec.Unit_Price = FND_API.G_MISS_NUM THEN --- Deepu

2040: IF l_rev_component_rec.purchasing_category_id = FND_API.G_MISS_NUM THEN --- Deepu
2041: l_rev_component_rec.purchasing_category_id := NULL;
2042: END IF;
2043: */
2044: IF l_rev_component_rec.Unit_Price = FND_API.G_MISS_NUM THEN --- Deepu
2045: l_rev_component_rec.Unit_Price := NULL;
2046: END IF;
2047:
2048: x_Rev_Component_Rec := l_rev_component_rec;