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 554: -- x_Return_Status := FND_API.G_RET_STS_SUCCESS;

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

Line 573: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

569: );
570: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
571: END IF;
572:
573: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
574: END Update_Row;
575:
576: /*****************************************************************************
577: * Procedure : Insert_Row

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

613: -- BOM form : BOMFDBOM.fmb won't insert the Old_component_sequence_id.
614: -- ENG form : ENGFDECN.fmb will always inserts Old_component_sequence_id.
615:
616: if l_Bo_Id = BOM_Globals.G_ECO_BO THEN
617: if (p_rev_comp_Unexp_rec.old_component_sequence_id = FND_API.G_MISS_NUM)
618: or (p_rev_comp_Unexp_rec.old_component_sequence_id is NULL) then
619: l_old_component_sequence_id := p_rev_comp_Unexp_rec.component_sequence_id;
620: else
621: l_old_component_sequence_id := p_rev_comp_Unexp_rec.old_component_sequence_id;

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

620: else
621: l_old_component_sequence_id := p_rev_comp_Unexp_rec.old_component_sequence_id;
622: end if;
623: else
624: if (p_rev_comp_Unexp_rec.old_component_sequence_id = FND_API.G_MISS_NUM) then
625: l_old_component_sequence_id := NULL;
626: else
627: l_old_component_sequence_id := p_rev_comp_Unexp_rec.old_component_sequence_id;
628: end if;

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

644:
645: /* need to populate Operation Lead Time percent corresponding to the operation
646: -vhymavat bug3537394 */
647: IF((p_rev_component_rec.new_operation_sequence_number IS NULL) OR
648: (p_rev_component_rec.new_operation_sequence_number =FND_API.G_MISS_NUM) ) THEN
649:
650: IF (( p_rev_component_rec.operation_sequence_number IS NULL) OR
651: ( p_rev_component_rec.operation_sequence_number =FND_API.G_MISS_NUM)) THEN
652: l_operation_seq_num := 1;

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

647: IF((p_rev_component_rec.new_operation_sequence_number IS NULL) OR
648: (p_rev_component_rec.new_operation_sequence_number =FND_API.G_MISS_NUM) ) THEN
649:
650: IF (( p_rev_component_rec.operation_sequence_number IS NULL) OR
651: ( p_rev_component_rec.operation_sequence_number =FND_API.G_MISS_NUM)) THEN
652: l_operation_seq_num := 1;
653: ELSE
654: l_operation_seq_num := p_rev_component_rec.operation_sequence_number;
655: END IF;

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

760: , p_rev_component_rec.maximum_allowed_quantity
761: , p_rev_comp_Unexp_rec.component_sequence_id
762: , BOM_Globals.Get_Prog_AppId
763: , p_rev_component_rec.wip_supply_type
764: , DECODE(p_rev_comp_Unexp_rec.supply_locator_id, FND_API.G_MISS_NUM,
765: NULL, p_rev_comp_Unexp_rec.supply_locator_id)
766: , p_rev_comp_Unexp_rec.bom_item_type
767: , l_operation_seq_num
768: , p_rev_comp_Unexp_rec.component_item_id

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

770: , BOM_Globals.Get_User_Id /* Last Updated By */
771: , SYSDATE /* Creation Date */
772: , BOM_Globals.Get_User_Id /* Created By */
773: , BOM_Globals.Get_User_Id /* Last Update Login */
774: , DECODE(p_rev_component_rec.item_sequence_number, FND_API.G_MISS_NUM,
775: 1, NULL,1,p_rev_component_rec.item_sequence_number)
776: , DECODE(p_rev_component_rec.basis_type,FND_API.G_MISS_NUM,
777: NULL,p_rev_component_rec.basis_type)
778: , p_rev_component_rec.quantity_per_assembly

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

772: , BOM_Globals.Get_User_Id /* Created By */
773: , BOM_Globals.Get_User_Id /* Last Update Login */
774: , DECODE(p_rev_component_rec.item_sequence_number, FND_API.G_MISS_NUM,
775: 1, NULL,1,p_rev_component_rec.item_sequence_number)
776: , DECODE(p_rev_component_rec.basis_type,FND_API.G_MISS_NUM,
777: NULL,p_rev_component_rec.basis_type)
778: , p_rev_component_rec.quantity_per_assembly
779: , p_rev_component_rec.projected_yield
780: , p_rev_component_rec.comments

Line 829: -- , FND_API.G_MISS_NUM

825: , NULL /* Include On Bill Docs */
826: , p_rev_component_rec.minimum_allowed_quantity
827: , p_rev_component_rec.acd_type
828: -- , DECODE( p_rev_comp_Unexp_rec.old_component_sequence_id
829: -- , FND_API.G_MISS_NUM
830: -- , NULL
831: -- ,p_rev_comp_Unexp_rec.old_component_sequence_id
832: -- )
833: , l_old_component_sequence_id

Line 841: , FND_API.G_MISS_CHAR

837: , SYSDATE /* program_update_date */
838: , p_rev_comp_Unexp_rec.pick_components
839: , p_rev_component_rec.original_system_reference
840: , DECODE( p_rev_component_rec.from_end_item_unit_number
841: , FND_API.G_MISS_CHAR
842: , null
843: , p_rev_component_rec.from_end_item_unit_number
844: )
845: , DECODE( p_rev_component_rec.to_end_item_unit_number

Line 846: , FND_API.G_MISS_CHAR

842: , null
843: , p_rev_component_rec.from_end_item_unit_number
844: )
845: , DECODE( p_rev_component_rec.to_end_item_unit_number
846: , FND_API.G_MISS_CHAR
847: , null
848: , p_rev_component_rec.to_end_item_unit_number
849: )
850: , BOM_Globals.Get_Eco_For_Production

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

870: , p_src_comp_seq_id => p_rev_comp_Unexp_rec.component_sequence_id
871: , x_Mesg_Token_Tbl => x_Mesg_Token_Tbl
872: , x_Return_Status => x_Return_Status
873: );
874: --x_Return_Status := FND_API.G_RET_STS_SUCCESS;
875:
876: EXCEPTION
877:
878: WHEN OTHERS THEN

Line 895: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

891: );
892: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
893: END IF;
894:
895: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
896:
897: END Insert_Row;
898:
899: /****************************************************************************

Line 953: x_return_status := FND_API.G_RET_STS_SUCCESS;

949: -- Initialize Common Record and Status
950: --
951: l_rev_component_rec := p_rev_component_rec ;
952: l_rev_comp_unexp_rec := p_rev_comp_unexp_rec ;
953: x_return_status := FND_API.G_RET_STS_SUCCESS;
954:
955: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
956: THEN
957:

Line 1004: x_return_status := FND_API.G_RET_STS_ERROR;

1000: , p_mesg_token_tbl => l_mesg_token_Tbl
1001: , x_mesg_token_tbl => l_mesg_token_tbl
1002: );
1003:
1004: x_return_status := FND_API.G_RET_STS_ERROR;
1005: x_mesg_token_tbl := l_mesg_token_tbl;
1006: RETURN;
1007: END IF;
1008:

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

1011: l_rev_comp_unexp_rec.DG_Description := DG.description;
1012:
1013: END LOOP;
1014:
1015: IF l_rev_comp_unexp_rec.DG_Sequence_Id <> FND_API.G_MISS_NUM
1016: THEN
1017: l_dg_sequence_id := l_rev_comp_unexp_rec.DG_Sequence_Id;
1018: ELSE
1019: l_dg_sequence_id := NULL;

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

1051: , x_Return_Status => x_Return_Status);
1052:
1053: END IF ;
1054:
1055: --x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1056: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1057:
1058: EXCEPTION
1059:

Line 1072: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1068: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1069: );
1070: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
1071: END IF;
1072: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1073: END Delete_Row;
1074:
1075: /*******************************************************
1076: * This is copy of the procedure that is currently used by

Line 1310: l_return_status := FND_API.G_RET_STS_SUCCESS;

1306: err_code varchar2(100);
1307: BEGIN
1308: l_rev_component_rec := p_rev_component_rec;
1309: l_rev_comp_unexp_rec := p_rev_comp_unexp_rec;
1310: l_return_status := FND_API.G_RET_STS_SUCCESS;
1311:
1312: l_Token_Tbl(1).Token_Name := 'REVISED_COMPONENT_NAME';
1313: l_Token_Tbl(1).Token_Value := l_rev_component_rec.component_item_name;
1314:

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

1409: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1410: , x_return_status => l_Return_Status
1411: );
1412:
1413: If (x_return_Status = FND_API.G_RET_STS_SUCCESS) Then
1414:
1415: Begin
1416: SELECT BOM_ITEM_TYPE
1417: INTO l_bom_item_type

Line 1560: l_return_status := FND_API.G_RET_STS_ERROR;

1556: , p_Mesg_Token_Tbl=> l_Mesg_Token_Tbl
1557: , x_Mesg_Token_Tbl=> l_Mesg_Token_Tbl
1558: , p_Token_Tbl => l_Token_Tbl
1559: );
1560: l_return_status := FND_API.G_RET_STS_ERROR;
1561: RETURN;
1562: END IF;
1563:
1564: IF l_Rev_Component_Rec.Transaction_Type = BOM_GLOBALS.G_OPR_CREATE THEN

Line 1593: l_return_status := FND_API.G_RET_STS_ERROR;

1589: , p_Mesg_Token_Tbl=> l_Mesg_Token_Tbl
1590: , x_Mesg_Token_Tbl=> l_Mesg_Token_Tbl
1591: , p_Token_Tbl => l_Token_Tbl
1592: );
1593: l_return_status := FND_API.G_RET_STS_ERROR;
1594: END IF;
1595: END IF;
1596: END IF;
1597:

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

1756: l_Rev_Comp_Unexp_Rec Bom_Bo_Pub.Rev_Comp_Unexposed_Rec_Type :=
1757: p_Rev_Comp_Unexp_Rec;
1758: BEGIN
1759:
1760: IF l_rev_component_rec.supply_subinventory = FND_API.G_MISS_CHAR THEN
1761: l_rev_component_rec.supply_subinventory := NULL;
1762: END IF;
1763:
1764: IF l_rev_component_rec.required_for_revenue = FND_API.G_MISS_NUM THEN

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

1760: IF l_rev_component_rec.supply_subinventory = FND_API.G_MISS_CHAR THEN
1761: l_rev_component_rec.supply_subinventory := NULL;
1762: END IF;
1763:
1764: IF l_rev_component_rec.required_for_revenue = FND_API.G_MISS_NUM THEN
1765: l_rev_component_rec.required_for_revenue := NULL;
1766: END IF;
1767:
1768: IF l_rev_component_rec.maximum_allowed_quantity = FND_API.G_MISS_NUM THEN

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

1764: IF l_rev_component_rec.required_for_revenue = FND_API.G_MISS_NUM THEN
1765: l_rev_component_rec.required_for_revenue := NULL;
1766: END IF;
1767:
1768: IF l_rev_component_rec.maximum_allowed_quantity = FND_API.G_MISS_NUM THEN
1769: l_rev_component_rec.maximum_allowed_quantity := NULL;
1770: END IF;
1771:
1772:

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

1769: l_rev_component_rec.maximum_allowed_quantity := NULL;
1770: END IF;
1771:
1772:
1773: IF l_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN
1774: l_rev_component_rec.wip_supply_type := NULL;
1775: END IF;
1776:
1777: IF l_rev_component_rec.location_name = FND_API.G_MISS_NUM THEN

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

1773: IF l_rev_component_rec.wip_supply_type = FND_API.G_MISS_NUM THEN
1774: l_rev_component_rec.wip_supply_type := NULL;
1775: END IF;
1776:
1777: IF l_rev_component_rec.location_name = FND_API.G_MISS_NUM THEN
1778: l_rev_comp_unexp_rec.supply_locator_id := NULL;
1779: END IF;
1780:
1781: IF l_rev_component_rec.operation_sequence_number = FND_API.G_MISS_NUM THEN

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

1777: IF l_rev_component_rec.location_name = FND_API.G_MISS_NUM THEN
1778: l_rev_comp_unexp_rec.supply_locator_id := NULL;
1779: END IF;
1780:
1781: IF l_rev_component_rec.operation_sequence_number = FND_API.G_MISS_NUM THEN
1782: l_rev_component_rec.operation_sequence_number := NULL;
1783: END IF;
1784:
1785: IF l_rev_component_rec.item_sequence_number = FND_API.G_MISS_NUM THEN

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

1781: IF l_rev_component_rec.operation_sequence_number = FND_API.G_MISS_NUM THEN
1782: l_rev_component_rec.operation_sequence_number := NULL;
1783: END IF;
1784:
1785: IF l_rev_component_rec.item_sequence_number = FND_API.G_MISS_NUM THEN
1786: l_rev_component_rec.item_sequence_number := NULL;
1787: END IF;
1788:
1789: IF l_rev_component_rec.quantity_per_assembly = FND_API.G_MISS_NUM THEN

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

1785: IF l_rev_component_rec.item_sequence_number = FND_API.G_MISS_NUM THEN
1786: l_rev_component_rec.item_sequence_number := NULL;
1787: END IF;
1788:
1789: IF l_rev_component_rec.quantity_per_assembly = FND_API.G_MISS_NUM THEN
1790: l_rev_component_rec.quantity_per_assembly := NULL;
1791: END IF;
1792:
1793: IF l_rev_component_rec.projected_yield = FND_API.G_MISS_NUM THEN

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

1789: IF l_rev_component_rec.quantity_per_assembly = FND_API.G_MISS_NUM THEN
1790: l_rev_component_rec.quantity_per_assembly := NULL;
1791: END IF;
1792:
1793: IF l_rev_component_rec.projected_yield = FND_API.G_MISS_NUM THEN
1794: l_rev_component_rec.projected_yield := NULL;
1795: END IF;
1796:
1797: IF l_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN

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

1793: IF l_rev_component_rec.projected_yield = FND_API.G_MISS_NUM THEN
1794: l_rev_component_rec.projected_yield := NULL;
1795: END IF;
1796:
1797: IF l_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN
1798: l_rev_component_rec.comments := NULL;
1799: END IF;
1800:
1801: IF l_rev_component_rec.start_effective_date = FND_API.G_MISS_DATE THEN

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

1797: IF l_rev_component_rec.comments = FND_API.G_MISS_CHAR THEN
1798: l_rev_component_rec.comments := NULL;
1799: END IF;
1800:
1801: IF l_rev_component_rec.start_effective_date = FND_API.G_MISS_DATE THEN
1802: l_rev_component_rec.start_effective_date := NULL;
1803: END IF;
1804:
1805: IF l_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN

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

1801: IF l_rev_component_rec.start_effective_date = FND_API.G_MISS_DATE THEN
1802: l_rev_component_rec.start_effective_date := NULL;
1803: END IF;
1804:
1805: IF l_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN
1806: l_rev_component_rec.disable_date := NULL;
1807: END IF;
1808:
1809: IF l_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN

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

1805: IF l_rev_component_rec.disable_date = FND_API.G_MISS_DATE THEN
1806: l_rev_component_rec.disable_date := NULL;
1807: END IF;
1808:
1809: IF l_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1810: l_rev_component_rec.attribute_category := NULL;
1811: END IF;
1812:
1813: IF l_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN

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

1809: IF l_rev_component_rec.attribute_category = FND_API.G_MISS_CHAR THEN
1810: l_rev_component_rec.attribute_category := NULL;
1811: END IF;
1812:
1813: IF l_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1814: l_rev_component_rec.attribute1 := NULL;
1815: END IF;
1816:
1817: IF l_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN

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

1813: IF l_rev_component_rec.attribute1 = FND_API.G_MISS_CHAR THEN
1814: l_rev_component_rec.attribute1 := NULL;
1815: END IF;
1816:
1817: IF l_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1818: l_rev_component_rec.attribute2 := NULL;
1819: END IF;
1820:
1821: IF l_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN

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

1817: IF l_rev_component_rec.attribute2 = FND_API.G_MISS_CHAR THEN
1818: l_rev_component_rec.attribute2 := NULL;
1819: END IF;
1820:
1821: IF l_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1822: l_rev_component_rec.attribute3 := NULL;
1823: END IF;
1824:
1825: IF l_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN

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

1821: IF l_rev_component_rec.attribute3 = FND_API.G_MISS_CHAR THEN
1822: l_rev_component_rec.attribute3 := NULL;
1823: END IF;
1824:
1825: IF l_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1826: l_rev_component_rec.attribute4 := NULL;
1827: END IF;
1828:
1829: IF l_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN

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

1825: IF l_rev_component_rec.attribute4 = FND_API.G_MISS_CHAR THEN
1826: l_rev_component_rec.attribute4 := NULL;
1827: END IF;
1828:
1829: IF l_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1830: l_rev_component_rec.attribute5 := NULL;
1831: END IF;
1832:
1833: IF l_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN

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

1829: IF l_rev_component_rec.attribute5 = FND_API.G_MISS_CHAR THEN
1830: l_rev_component_rec.attribute5 := NULL;
1831: END IF;
1832:
1833: IF l_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1834: l_rev_component_rec.attribute6 := NULL;
1835: END IF;
1836:
1837: IF l_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN

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

1833: IF l_rev_component_rec.attribute6 = FND_API.G_MISS_CHAR THEN
1834: l_rev_component_rec.attribute6 := NULL;
1835: END IF;
1836:
1837: IF l_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1838: l_rev_component_rec.attribute7 := NULL;
1839: END IF;
1840:
1841: IF l_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN

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

1837: IF l_rev_component_rec.attribute7 = FND_API.G_MISS_CHAR THEN
1838: l_rev_component_rec.attribute7 := NULL;
1839: END IF;
1840:
1841: IF l_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1842: l_rev_component_rec.attribute8 := NULL;
1843: END IF;
1844:
1845: IF l_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN

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

1841: IF l_rev_component_rec.attribute8 = FND_API.G_MISS_CHAR THEN
1842: l_rev_component_rec.attribute8 := NULL;
1843: END IF;
1844:
1845: IF l_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1846: l_rev_component_rec.attribute9 := NULL;
1847: END IF;
1848:
1849: IF l_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN

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

1845: IF l_rev_component_rec.attribute9 = FND_API.G_MISS_CHAR THEN
1846: l_rev_component_rec.attribute9 := NULL;
1847: END IF;
1848:
1849: IF l_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1850: l_rev_component_rec.attribute10 := NULL;
1851: END IF;
1852:
1853: IF l_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN

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

1849: IF l_rev_component_rec.attribute10 = FND_API.G_MISS_CHAR THEN
1850: l_rev_component_rec.attribute10 := NULL;
1851: END IF;
1852:
1853: IF l_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1854: l_rev_component_rec.attribute11 := NULL;
1855: END IF;
1856:
1857: IF l_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN

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

1853: IF l_rev_component_rec.attribute11 = FND_API.G_MISS_CHAR THEN
1854: l_rev_component_rec.attribute11 := NULL;
1855: END IF;
1856:
1857: IF l_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1858: l_rev_component_rec.attribute12 := NULL;
1859: END IF;
1860:
1861: IF l_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN

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

1857: IF l_rev_component_rec.attribute12 = FND_API.G_MISS_CHAR THEN
1858: l_rev_component_rec.attribute12 := NULL;
1859: END IF;
1860:
1861: IF l_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1862: l_rev_component_rec.attribute13 := NULL;
1863: END IF;
1864:
1865: IF l_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN

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

1861: IF l_rev_component_rec.attribute13 = FND_API.G_MISS_CHAR THEN
1862: l_rev_component_rec.attribute13 := NULL;
1863: END IF;
1864:
1865: IF l_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1866: l_rev_component_rec.attribute14 := NULL;
1867: END IF;
1868:
1869: IF l_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN

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

1865: IF l_rev_component_rec.attribute14 = FND_API.G_MISS_CHAR THEN
1866: l_rev_component_rec.attribute14 := NULL;
1867: END IF;
1868:
1869: IF l_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1870: l_rev_component_rec.attribute15 := NULL;
1871: END IF;
1872:
1873: IF l_rev_component_rec.planning_percent = FND_API.G_MISS_NUM THEN

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

1869: IF l_rev_component_rec.attribute15 = FND_API.G_MISS_CHAR THEN
1870: l_rev_component_rec.attribute15 := NULL;
1871: END IF;
1872:
1873: IF l_rev_component_rec.planning_percent = FND_API.G_MISS_NUM THEN
1874: l_rev_component_rec.planning_percent := NULL;
1875: END IF;
1876:
1877: IF l_rev_component_rec.quantity_related = FND_API.G_MISS_NUM THEN

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

1873: IF l_rev_component_rec.planning_percent = FND_API.G_MISS_NUM THEN
1874: l_rev_component_rec.planning_percent := NULL;
1875: END IF;
1876:
1877: IF l_rev_component_rec.quantity_related = FND_API.G_MISS_NUM THEN
1878: l_rev_component_rec.quantity_related := NULL;
1879: END IF;
1880:
1881: IF l_rev_component_rec.so_basis = FND_API.G_MISS_NUM THEN

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

1877: IF l_rev_component_rec.quantity_related = FND_API.G_MISS_NUM THEN
1878: l_rev_component_rec.quantity_related := NULL;
1879: END IF;
1880:
1881: IF l_rev_component_rec.so_basis = FND_API.G_MISS_NUM THEN
1882: l_rev_component_rec.so_basis := NULL;
1883: END IF;
1884:
1885: IF l_rev_component_rec.optional = FND_API.G_MISS_NUM THEN

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

1881: IF l_rev_component_rec.so_basis = FND_API.G_MISS_NUM THEN
1882: l_rev_component_rec.so_basis := NULL;
1883: END IF;
1884:
1885: IF l_rev_component_rec.optional = FND_API.G_MISS_NUM THEN
1886: l_rev_component_rec.optional := NULL;
1887: END IF;
1888:
1889: IF l_rev_component_rec.mutually_exclusive = FND_API.G_MISS_NUM THEN

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

1885: IF l_rev_component_rec.optional = FND_API.G_MISS_NUM THEN
1886: l_rev_component_rec.optional := NULL;
1887: END IF;
1888:
1889: IF l_rev_component_rec.mutually_exclusive = FND_API.G_MISS_NUM THEN
1890: l_rev_component_rec.mutually_exclusive := NULL;
1891: END IF;
1892:
1893: IF l_rev_component_rec.include_in_cost_rollup = FND_API.G_MISS_NUM THEN

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

1889: IF l_rev_component_rec.mutually_exclusive = FND_API.G_MISS_NUM THEN
1890: l_rev_component_rec.mutually_exclusive := NULL;
1891: END IF;
1892:
1893: IF l_rev_component_rec.include_in_cost_rollup = FND_API.G_MISS_NUM THEN
1894: l_rev_component_rec.include_in_cost_rollup := NULL;
1895: END IF;
1896:
1897: IF l_rev_component_rec.check_atp = FND_API.G_MISS_NUM THEN

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

1893: IF l_rev_component_rec.include_in_cost_rollup = FND_API.G_MISS_NUM THEN
1894: l_rev_component_rec.include_in_cost_rollup := NULL;
1895: END IF;
1896:
1897: IF l_rev_component_rec.check_atp = FND_API.G_MISS_NUM THEN
1898: l_rev_component_rec.check_atp := NULL;
1899: END IF;
1900:
1901: IF l_rev_component_rec.shipping_allowed = FND_API.G_MISS_NUM THEN

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

1897: IF l_rev_component_rec.check_atp = FND_API.G_MISS_NUM THEN
1898: l_rev_component_rec.check_atp := NULL;
1899: END IF;
1900:
1901: IF l_rev_component_rec.shipping_allowed = FND_API.G_MISS_NUM THEN
1902: l_rev_component_rec.shipping_allowed := NULL;
1903: END IF;
1904:
1905: IF l_rev_component_rec.required_to_ship = FND_API.G_MISS_NUM THEN

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

1901: IF l_rev_component_rec.shipping_allowed = FND_API.G_MISS_NUM THEN
1902: l_rev_component_rec.shipping_allowed := NULL;
1903: END IF;
1904:
1905: IF l_rev_component_rec.required_to_ship = FND_API.G_MISS_NUM THEN
1906: l_rev_component_rec.required_to_ship := NULL;
1907: END IF;
1908:
1909: IF l_rev_component_rec.include_on_ship_docs = FND_API.G_MISS_NUM THEN

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

1905: IF l_rev_component_rec.required_to_ship = FND_API.G_MISS_NUM THEN
1906: l_rev_component_rec.required_to_ship := NULL;
1907: END IF;
1908:
1909: IF l_rev_component_rec.include_on_ship_docs = FND_API.G_MISS_NUM THEN
1910: l_rev_component_rec.include_on_ship_docs := NULL;
1911: END IF;
1912:
1913: IF l_rev_component_rec.minimum_allowed_quantity = FND_API.G_MISS_NUM THEN

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

1909: IF l_rev_component_rec.include_on_ship_docs = FND_API.G_MISS_NUM THEN
1910: l_rev_component_rec.include_on_ship_docs := NULL;
1911: END IF;
1912:
1913: IF l_rev_component_rec.minimum_allowed_quantity = FND_API.G_MISS_NUM THEN
1914: l_rev_component_rec.minimum_allowed_quantity := NULL;
1915: END IF;
1916:
1917: IF l_rev_component_rec.acd_type = FND_API.G_MISS_NUM THEN

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

1913: IF l_rev_component_rec.minimum_allowed_quantity = FND_API.G_MISS_NUM THEN
1914: l_rev_component_rec.minimum_allowed_quantity := NULL;
1915: END IF;
1916:
1917: IF l_rev_component_rec.acd_type = FND_API.G_MISS_NUM THEN
1918: l_rev_component_rec.acd_type := NULL;
1919: END IF;
1920:
1921: -- Added in 11.5.9 by ADEY

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

1918: l_rev_component_rec.acd_type := NULL;
1919: END IF;
1920:
1921: -- Added in 11.5.9 by ADEY
1922: IF l_rev_component_rec.auto_request_material = FND_API.G_MISS_CHAR THEN
1923: l_rev_component_rec.auto_request_material := NULL;
1924: END IF;
1925:
1926: IF l_rev_component_rec.Suggested_Vendor_Name = FND_API.G_MISS_CHAR THEN --- Deepu

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

1922: IF l_rev_component_rec.auto_request_material = FND_API.G_MISS_CHAR THEN
1923: l_rev_component_rec.auto_request_material := NULL;
1924: END IF;
1925:
1926: IF l_rev_component_rec.Suggested_Vendor_Name = FND_API.G_MISS_CHAR THEN --- Deepu
1927: l_rev_component_rec.Suggested_Vendor_Name := NULL;
1928: l_Rev_Comp_Unexp_Rec.Vendor_Id := NULL;
1929: END IF;
1930:

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

1928: l_Rev_Comp_Unexp_Rec.Vendor_Id := NULL;
1929: END IF;
1930:
1931: /*
1932: IF l_rev_component_rec.purchasing_category_id = FND_API.G_MISS_NUM THEN --- Deepu
1933: l_rev_component_rec.purchasing_category_id := NULL;
1934: END IF;
1935: */
1936: IF l_rev_component_rec.Unit_Price = FND_API.G_MISS_NUM THEN --- Deepu

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

1932: IF l_rev_component_rec.purchasing_category_id = FND_API.G_MISS_NUM THEN --- Deepu
1933: l_rev_component_rec.purchasing_category_id := NULL;
1934: END IF;
1935: */
1936: IF l_rev_component_rec.Unit_Price = FND_API.G_MISS_NUM THEN --- Deepu
1937: l_rev_component_rec.Unit_Price := NULL;
1938: END IF;
1939:
1940: x_Rev_Component_Rec := l_rev_component_rec;