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.EAM_ACTIVITY_PUB dependencies on BOM_BO_PUB

Line 468: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,

464: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
465: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
466: p_material_copy_option IN NUMBER,
467:
468: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
469: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
470: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
471: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
472: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,

Line 469: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,

465: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
466: p_material_copy_option IN NUMBER,
467:
468: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
469: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
470: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
471: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
472: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
473: x_bom_return_status OUT NOCOPY VARCHAR2,

Line 470: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,

466: p_material_copy_option IN NUMBER,
467:
468: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
469: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
470: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
471: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
472: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
473: x_bom_return_status OUT NOCOPY VARCHAR2,
474: x_bom_msg_count OUT NOCOPY NUMBER,

Line 471: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,

467:
468: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
469: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
470: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
471: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
472: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
473: x_bom_return_status OUT NOCOPY VARCHAR2,
474: x_bom_msg_count OUT NOCOPY NUMBER,
475: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type

Line 472: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,

468: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
469: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
470: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
471: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
472: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
473: x_bom_return_status OUT NOCOPY VARCHAR2,
474: x_bom_msg_count OUT NOCOPY NUMBER,
475: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
476: )

Line 482: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;

478: l_current_date CONSTANT DATE := sysdate;
479: l_effectivity_date CONSTANT DATE := l_current_date;
480: l_create_txn_type CONSTANT VARCHAR(10) := 'CREATE';
481: -- local variabels for calling BOM Business Object API
482: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
483: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
484: l_bom_comp_tbl_index BINARY_INTEGER;
485:
486: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

Line 483: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

479: l_effectivity_date CONSTANT DATE := l_current_date;
480: l_create_txn_type CONSTANT VARCHAR(10) := 'CREATE';
481: -- local variabels for calling BOM Business Object API
482: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
483: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
484: l_bom_comp_tbl_index BINARY_INTEGER;
485:
486: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
487: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

Line 486: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

482: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
483: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
484: l_bom_comp_tbl_index BINARY_INTEGER;
485:
486: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
487: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
488: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
489: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
490: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

Line 487: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

483: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
484: l_bom_comp_tbl_index BINARY_INTEGER;
485:
486: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
487: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
488: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
489: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
490: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
491: l_x_bom_return_status VARCHAR2(1);

Line 488: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

484: l_bom_comp_tbl_index BINARY_INTEGER;
485:
486: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
487: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
488: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
489: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
490: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
491: l_x_bom_return_status VARCHAR2(1);
492: l_x_bom_msg_count NUMBER;

Line 489: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;

485:
486: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
487: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
488: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
489: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
490: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
491: l_x_bom_return_status VARCHAR2(1);
492: l_x_bom_msg_count NUMBER;
493: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

Line 490: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

486: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
487: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
488: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
489: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
490: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
491: l_x_bom_return_status VARCHAR2(1);
492: l_x_bom_msg_count NUMBER;
493: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
494: l_stock_enabled_flag varchar2(1);

Line 600: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_BO_PUB.Process_BOM INPUT Parameters >>>>>>>>>>>>>>>');

596: IF l_bom_component_tbl.FIRST IS NOT NULL THEN
597:
598: Error_Handler.initialize;
599: -- log call to Process_BOM API
600: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_BO_PUB.Process_BOM INPUT Parameters >>>>>>>>>>>>>>>');
601: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_bom_head_rec,
602: l_bom_component_tbl);
603:
604: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');

Line 604: EAM_ActivityUtilities_PVT.Write_Debug(' Calling BOM_BO_PUB.Process_BOM ');

600: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_BO_PUB.Process_BOM INPUT Parameters >>>>>>>>>>>>>>>');
601: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_bom_head_rec,
602: l_bom_component_tbl);
603:
604: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
605: BOM_BO_PUB.Process_BOM(
606: p_bom_header_rec => l_bom_head_rec,
607: p_bom_component_tbl => l_bom_component_tbl,
608: x_bom_header_rec => l_x_bom_header_rec,

Line 605: BOM_BO_PUB.Process_BOM(

601: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_bom_head_rec,
602: l_bom_component_tbl);
603:
604: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
605: BOM_BO_PUB.Process_BOM(
606: p_bom_header_rec => l_bom_head_rec,
607: p_bom_component_tbl => l_bom_component_tbl,
608: x_bom_header_rec => l_x_bom_header_rec,
609: x_bom_revision_tbl => l_x_bom_revision_tbl,

Line 616: EAM_ActivityUtilities_PVT.Write_Debug(' Returned from BOM_BO_PUB.Process_BOM ');

612: x_bom_sub_component_tbl => l_x_bom_sub_component_tbl,
613: x_return_status => l_x_bom_return_status,
614: x_msg_count => l_x_bom_msg_count
615: );
616: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
617:
618: Error_Handler.Get_Message_List(l_x_bom_msg_list);
619:
620: -- log errors

Line 624: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');

620: -- log errors
621: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
622: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
623: Error_Handler.Get_Message_List(l_x_bom_msg_list);
624: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
625: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
626: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
627: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
628: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,

Line 626: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');

622: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
623: Error_Handler.Get_Message_List(l_x_bom_msg_list);
624: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
625: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
626: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
627: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
628: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,
629: l_x_bom_component_tbl);
630:

Line 627: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');

623: Error_Handler.Get_Message_List(l_x_bom_msg_list);
624: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
625: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
626: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
627: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
628: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,
629: l_x_bom_component_tbl);
630:
631:

Line 898: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,

894: x_rtg_return_status OUT NOCOPY VARCHAR2,
895: x_rtg_msg_count OUT NOCOPY NUMBER,
896: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,
897:
898: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
899: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
900: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
901: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
902: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,

Line 899: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,

895: x_rtg_msg_count OUT NOCOPY NUMBER,
896: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,
897:
898: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
899: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
900: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
901: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
902: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
903: x_bom_return_status OUT NOCOPY VARCHAR2,

Line 900: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,

896: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,
897:
898: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
899: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
900: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
901: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
902: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
903: x_bom_return_status OUT NOCOPY VARCHAR2,
904: x_bom_msg_count OUT NOCOPY NUMBER,

Line 901: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,

897:
898: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
899: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
900: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
901: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
902: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
903: x_bom_return_status OUT NOCOPY VARCHAR2,
904: x_bom_msg_count OUT NOCOPY NUMBER,
905: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,

Line 902: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,

898: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
899: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
900: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
901: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
902: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
903: x_bom_return_status OUT NOCOPY VARCHAR2,
904: x_bom_msg_count OUT NOCOPY NUMBER,
905: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,
906:

Line 932: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

928: l_x_master_item_return_status VARCHAR2(1);
929: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
930:
931: -- local variabels for calling BOM Business Object API
932: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
933: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
934: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
935: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
936: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

Line 933: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

929: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
930:
931: -- local variabels for calling BOM Business Object API
932: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
933: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
934: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
935: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
936: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
937: l_x_bom_return_status VARCHAR2(1);

Line 934: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

930:
931: -- local variabels for calling BOM Business Object API
932: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
933: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
934: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
935: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
936: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
937: l_x_bom_return_status VARCHAR2(1);
938: l_x_bom_msg_count NUMBER;

Line 935: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;

931: -- local variabels for calling BOM Business Object API
932: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
933: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
934: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
935: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
936: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
937: l_x_bom_return_status VARCHAR2(1);
938: l_x_bom_msg_count NUMBER;
939: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

Line 936: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

932: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
933: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
934: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
935: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
936: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
937: l_x_bom_return_status VARCHAR2(1);
938: l_x_bom_msg_count NUMBER;
939: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
940:

Line 1369: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;

1365: l_source_bom_sequence_id NUMBER;
1366: l_target_bom_sequence_id NUMBER;
1367: l_copy_bill_error_msg VARCHAR2(20000);
1368:
1369: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1370:
1371: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1372: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1373: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

Line 1371: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

1367: l_copy_bill_error_msg VARCHAR2(20000);
1368:
1369: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1370:
1371: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1372: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1373: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1374: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1375: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

Line 1372: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

1368:
1369: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1370:
1371: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1372: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1373: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1374: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1375: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1376: l_x_bom_return_status VARCHAR2(1);

Line 1373: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

1369: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1370:
1371: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1372: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1373: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1374: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1375: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1376: l_x_bom_return_status VARCHAR2(1);
1377: l_x_bom_msg_count NUMBER;

Line 1374: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;

1370:
1371: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1372: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1373: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1374: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1375: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1376: l_x_bom_return_status VARCHAR2(1);
1377: l_x_bom_msg_count NUMBER;
1378: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

Line 1375: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

1371: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1372: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1373: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1374: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1375: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1376: l_x_bom_return_status VARCHAR2(1);
1377: l_x_bom_msg_count NUMBER;
1378: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
1379:

Line 1685: EAM_ActivityUtilities_PVT.Write_Debug(' Calling BOM_BO_PUB.Process_BOM ');

1681:
1682: -- Create empty BOM header through BOM Business Object API
1683: Error_Handler.initialize;
1684: -- log call to Process_BOM API
1685: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
1686: BOM_BO_PUB.Process_BOM(
1687: p_bom_header_rec => l_bom_head_rec,
1688: x_bom_header_rec => l_x_bom_header_rec,
1689: x_bom_revision_tbl => l_x_bom_revision_tbl,

Line 1686: BOM_BO_PUB.Process_BOM(

1682: -- Create empty BOM header through BOM Business Object API
1683: Error_Handler.initialize;
1684: -- log call to Process_BOM API
1685: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
1686: BOM_BO_PUB.Process_BOM(
1687: p_bom_header_rec => l_bom_head_rec,
1688: x_bom_header_rec => l_x_bom_header_rec,
1689: x_bom_revision_tbl => l_x_bom_revision_tbl,
1690: x_bom_component_tbl => l_x_bom_component_tbl,

Line 1696: EAM_ActivityUtilities_PVT.Write_Debug(' Returned from BOM_BO_PUB.Process_BOM ');

1692: x_bom_sub_component_tbl => l_x_bom_sub_component_tbl,
1693: x_return_status => l_x_bom_return_status,
1694: x_msg_count => l_x_bom_msg_count
1695: );
1696: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
1697:
1698: -- log errors
1699: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1700: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);

Line 1702: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');

1698: -- log errors
1699: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1700: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1701: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1702: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1703: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1704: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1705:
1706: -- Handle errors

Line 1704: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');

1700: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1701: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1702: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1703: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1704: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1705:
1706: -- Handle errors
1707: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1708: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RTG_BO_FAILED');

Line 1928: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

1924: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
1925: l_x_rtg_return_status VARCHAR2(1);
1926: l_x_rtg_msg_count NUMBER;
1927: -- output variables of BOM Business Object API
1928: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1929: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1930: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1931: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1932: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

Line 1929: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

1925: l_x_rtg_return_status VARCHAR2(1);
1926: l_x_rtg_msg_count NUMBER;
1927: -- output variables of BOM Business Object API
1928: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1929: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1930: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1931: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1932: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1933: l_x_bom_return_status VARCHAR2(1);

Line 1930: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

1926: l_x_rtg_msg_count NUMBER;
1927: -- output variables of BOM Business Object API
1928: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1929: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1930: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1931: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1932: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1933: l_x_bom_return_status VARCHAR2(1);
1934: l_x_bom_msg_count NUMBER;

Line 1931: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;

1927: -- output variables of BOM Business Object API
1928: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1929: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1930: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1931: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1932: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1933: l_x_bom_return_status VARCHAR2(1);
1934: l_x_bom_msg_count NUMBER;
1935: -- Routing and BOM common Error Handler

Line 1932: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

1928: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1929: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1930: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1931: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1932: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1933: l_x_bom_return_status VARCHAR2(1);
1934: l_x_bom_msg_count NUMBER;
1935: -- Routing and BOM common Error Handler
1936: l_x_bom_error_list Error_Handler.Error_Tbl_Type;

Line 2354: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,

2350: --p_source_activity_id IN NUMBER, -- inventory_item_id
2351:
2352: --p_material_copy_option IN NUMBER,
2353:
2354: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
2355: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
2356: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
2357: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
2358: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,

Line 2355: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,

2351:
2352: --p_material_copy_option IN NUMBER,
2353:
2354: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
2355: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
2356: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
2357: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
2358: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
2359: x_bom_return_status OUT NOCOPY VARCHAR2,

Line 2356: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,

2352: --p_material_copy_option IN NUMBER,
2353:
2354: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
2355: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
2356: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
2357: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
2358: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
2359: x_bom_return_status OUT NOCOPY VARCHAR2,
2360: x_bom_msg_count OUT NOCOPY NUMBER,

Line 2357: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,

2353:
2354: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
2355: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
2356: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
2357: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
2358: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
2359: x_bom_return_status OUT NOCOPY VARCHAR2,
2360: x_bom_msg_count OUT NOCOPY NUMBER,
2361: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type

Line 2358: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,

2354: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
2355: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
2356: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
2357: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
2358: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
2359: x_bom_return_status OUT NOCOPY VARCHAR2,
2360: x_bom_msg_count OUT NOCOPY NUMBER,
2361: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
2362:

Line 2368: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;

2364: IS
2365: --l_current_date CONSTANT DATE := sysdate;
2366: l_create_txn_type CONSTANT VARCHAR(10) := 'CREATE';
2367: -- local variabels for calling BOM Business Object API
2368: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2369: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2370: l_bom_comp_tbl_index BINARY_INTEGER;
2371:
2372: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

Line 2369: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

2365: --l_current_date CONSTANT DATE := sysdate;
2366: l_create_txn_type CONSTANT VARCHAR(10) := 'CREATE';
2367: -- local variabels for calling BOM Business Object API
2368: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2369: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2370: l_bom_comp_tbl_index BINARY_INTEGER;
2371:
2372: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2373: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

Line 2372: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

2368: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2369: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2370: l_bom_comp_tbl_index BINARY_INTEGER;
2371:
2372: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2373: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
2374: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2375: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
2376: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

Line 2373: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

2369: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2370: l_bom_comp_tbl_index BINARY_INTEGER;
2371:
2372: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2373: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
2374: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2375: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
2376: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
2377: l_x_bom_return_status VARCHAR2(1);

Line 2374: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

2370: l_bom_comp_tbl_index BINARY_INTEGER;
2371:
2372: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2373: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
2374: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2375: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
2376: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
2377: l_x_bom_return_status VARCHAR2(1);
2378: l_x_bom_msg_count NUMBER;

Line 2375: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;

2371:
2372: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2373: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
2374: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2375: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
2376: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
2377: l_x_bom_return_status VARCHAR2(1);
2378: l_x_bom_msg_count NUMBER;
2379: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

Line 2376: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

2372: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2373: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
2374: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2375: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
2376: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
2377: l_x_bom_return_status VARCHAR2(1);
2378: l_x_bom_msg_count NUMBER;
2379: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
2380:

Line 2413: EAM_ActivityUtilities_PVT.Write_Debug(' Calling BOM_BO_PUB.Process_BOM ');

2409: */
2410: --l_bom_head_rec.Alternate_Bom_Code := l_bom_bom_row.alternate_bom_designator;
2411: --l_bom_head_rec.Assembly_Type := l_bom_bom_row.assembly_type;
2412: -- log call to Process_BOM API
2413: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
2414: BOM_BO_PUB.Process_BOM(
2415: p_bom_header_rec => l_bom_head_rec,
2416: p_bom_component_tbl => l_bom_component_tbl,
2417: x_bom_header_rec => l_x_bom_header_rec,

Line 2414: BOM_BO_PUB.Process_BOM(

2410: --l_bom_head_rec.Alternate_Bom_Code := l_bom_bom_row.alternate_bom_designator;
2411: --l_bom_head_rec.Assembly_Type := l_bom_bom_row.assembly_type;
2412: -- log call to Process_BOM API
2413: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
2414: BOM_BO_PUB.Process_BOM(
2415: p_bom_header_rec => l_bom_head_rec,
2416: p_bom_component_tbl => l_bom_component_tbl,
2417: x_bom_header_rec => l_x_bom_header_rec,
2418: x_bom_revision_tbl => l_x_bom_revision_tbl,

Line 2425: EAM_ActivityUtilities_PVT.Write_Debug(' Returned from BOM_BO_PUB.Process_BOM ');

2421: x_bom_sub_component_tbl => l_x_bom_sub_component_tbl,
2422: x_return_status => l_x_bom_return_status,
2423: x_msg_count => l_x_bom_msg_count
2424: );
2425: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
2426:
2427: x_bom_header_rec := l_x_bom_header_rec;
2428: x_bom_revision_tbl := l_x_bom_revision_tbl;
2429: x_bom_component_tbl := l_x_bom_component_tbl;

Line 2445: x_bom_header_rec BOM_BO_PUB.BOM_Head_Rec_Type;

2441: p_organization_code varchar2,
2442: x_return_status OUT NOCOPY VARCHAR2
2443: )is
2444: l_target_item_rec INV_Item_GRP.Item_Rec_Type;
2445: x_bom_header_rec BOM_BO_PUB.BOM_Head_Rec_Type;
2446: x_bom_revision_tbl BOM_BO_PUB.BOM_Revision_Tbl_Type;
2447: x_bom_component_tbl BOM_BO_PUB.BOM_Comps_Tbl_Type;
2448: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;
2449: x_bom_sub_component_tbl BOM_BO_PUB.BOM_Sub_Component_Tbl_Type;

Line 2446: x_bom_revision_tbl BOM_BO_PUB.BOM_Revision_Tbl_Type;

2442: x_return_status OUT NOCOPY VARCHAR2
2443: )is
2444: l_target_item_rec INV_Item_GRP.Item_Rec_Type;
2445: x_bom_header_rec BOM_BO_PUB.BOM_Head_Rec_Type;
2446: x_bom_revision_tbl BOM_BO_PUB.BOM_Revision_Tbl_Type;
2447: x_bom_component_tbl BOM_BO_PUB.BOM_Comps_Tbl_Type;
2448: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;
2449: x_bom_sub_component_tbl BOM_BO_PUB.BOM_Sub_Component_Tbl_Type;
2450: x_bom_return_status VARCHAR2(1);

Line 2447: x_bom_component_tbl BOM_BO_PUB.BOM_Comps_Tbl_Type;

2443: )is
2444: l_target_item_rec INV_Item_GRP.Item_Rec_Type;
2445: x_bom_header_rec BOM_BO_PUB.BOM_Head_Rec_Type;
2446: x_bom_revision_tbl BOM_BO_PUB.BOM_Revision_Tbl_Type;
2447: x_bom_component_tbl BOM_BO_PUB.BOM_Comps_Tbl_Type;
2448: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;
2449: x_bom_sub_component_tbl BOM_BO_PUB.BOM_Sub_Component_Tbl_Type;
2450: x_bom_return_status VARCHAR2(1);
2451: x_bom_msg_count NUMBER;

Line 2448: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;

2444: l_target_item_rec INV_Item_GRP.Item_Rec_Type;
2445: x_bom_header_rec BOM_BO_PUB.BOM_Head_Rec_Type;
2446: x_bom_revision_tbl BOM_BO_PUB.BOM_Revision_Tbl_Type;
2447: x_bom_component_tbl BOM_BO_PUB.BOM_Comps_Tbl_Type;
2448: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;
2449: x_bom_sub_component_tbl BOM_BO_PUB.BOM_Sub_Component_Tbl_Type;
2450: x_bom_return_status VARCHAR2(1);
2451: x_bom_msg_count NUMBER;
2452: x_bom_msg_list Error_Handler.Error_Tbl_Type;

Line 2449: x_bom_sub_component_tbl BOM_BO_PUB.BOM_Sub_Component_Tbl_Type;

2445: x_bom_header_rec BOM_BO_PUB.BOM_Head_Rec_Type;
2446: x_bom_revision_tbl BOM_BO_PUB.BOM_Revision_Tbl_Type;
2447: x_bom_component_tbl BOM_BO_PUB.BOM_Comps_Tbl_Type;
2448: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;
2449: x_bom_sub_component_tbl BOM_BO_PUB.BOM_Sub_Component_Tbl_Type;
2450: x_bom_return_status VARCHAR2(1);
2451: x_bom_msg_count NUMBER;
2452: x_bom_msg_list Error_Handler.Error_Tbl_Type;
2453: