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 494: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,

490: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
491: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
492: p_material_copy_option IN NUMBER,
493:
494: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
495: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
496: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
497: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
498: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,

Line 495: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,

491: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
492: p_material_copy_option IN NUMBER,
493:
494: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
495: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
496: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
497: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
498: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
499: x_bom_return_status OUT NOCOPY VARCHAR2,

Line 496: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,

492: p_material_copy_option IN NUMBER,
493:
494: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
495: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
496: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
497: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
498: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
499: x_bom_return_status OUT NOCOPY VARCHAR2,
500: x_bom_msg_count OUT NOCOPY NUMBER,

Line 497: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,

493:
494: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
495: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
496: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
497: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
498: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
499: x_bom_return_status OUT NOCOPY VARCHAR2,
500: x_bom_msg_count OUT NOCOPY NUMBER,
501: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type

Line 498: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,

494: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
495: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
496: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
497: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
498: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
499: x_bom_return_status OUT NOCOPY VARCHAR2,
500: x_bom_msg_count OUT NOCOPY NUMBER,
501: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
502: )

Line 508: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;

504: l_current_date CONSTANT DATE := sysdate;
505: l_effectivity_date CONSTANT DATE := l_current_date;
506: l_create_txn_type CONSTANT VARCHAR(10) := 'CREATE';
507: -- local variabels for calling BOM Business Object API
508: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
509: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
510: l_bom_comp_tbl_index BINARY_INTEGER;
511:
512: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

Line 509: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

505: l_effectivity_date CONSTANT DATE := l_current_date;
506: l_create_txn_type CONSTANT VARCHAR(10) := 'CREATE';
507: -- local variabels for calling BOM Business Object API
508: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
509: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
510: l_bom_comp_tbl_index BINARY_INTEGER;
511:
512: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
513: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

Line 512: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

508: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
509: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
510: l_bom_comp_tbl_index BINARY_INTEGER;
511:
512: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
513: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
514: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
515: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
516: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

Line 513: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

509: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
510: l_bom_comp_tbl_index BINARY_INTEGER;
511:
512: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
513: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
514: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
515: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
516: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
517: l_x_bom_return_status VARCHAR2(1);

Line 514: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

510: l_bom_comp_tbl_index BINARY_INTEGER;
511:
512: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
513: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
514: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
515: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
516: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
517: l_x_bom_return_status VARCHAR2(1);
518: l_x_bom_msg_count NUMBER;

Line 515: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;

511:
512: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
513: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
514: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
515: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
516: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
517: l_x_bom_return_status VARCHAR2(1);
518: l_x_bom_msg_count NUMBER;
519: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

Line 516: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

512: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
513: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
514: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
515: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
516: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
517: l_x_bom_return_status VARCHAR2(1);
518: l_x_bom_msg_count NUMBER;
519: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
520: l_stock_enabled_flag varchar2(1);

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

622: IF l_bom_component_tbl.FIRST IS NOT NULL THEN
623:
624: Error_Handler.initialize;
625: -- log call to Process_BOM API
626: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_BO_PUB.Process_BOM INPUT Parameters >>>>>>>>>>>>>>>');
627: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_bom_head_rec,
628: l_bom_component_tbl);
629:
630: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');

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

626: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_BO_PUB.Process_BOM INPUT Parameters >>>>>>>>>>>>>>>');
627: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_bom_head_rec,
628: l_bom_component_tbl);
629:
630: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
631: BOM_BO_PUB.Process_BOM(
632: p_bom_header_rec => l_bom_head_rec,
633: p_bom_component_tbl => l_bom_component_tbl,
634: x_bom_header_rec => l_x_bom_header_rec,

Line 631: BOM_BO_PUB.Process_BOM(

627: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_bom_head_rec,
628: l_bom_component_tbl);
629:
630: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
631: BOM_BO_PUB.Process_BOM(
632: p_bom_header_rec => l_bom_head_rec,
633: p_bom_component_tbl => l_bom_component_tbl,
634: x_bom_header_rec => l_x_bom_header_rec,
635: x_bom_revision_tbl => l_x_bom_revision_tbl,

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

638: x_bom_sub_component_tbl => l_x_bom_sub_component_tbl,
639: x_return_status => l_x_bom_return_status,
640: x_msg_count => l_x_bom_msg_count
641: );
642: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
643:
644: Error_Handler.Get_Message_List(l_x_bom_msg_list);
645:
646: -- log errors

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

646: -- log errors
647: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
648: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
649: Error_Handler.Get_Message_List(l_x_bom_msg_list);
650: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
651: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
652: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
653: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
654: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,

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

648: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
649: Error_Handler.Get_Message_List(l_x_bom_msg_list);
650: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
651: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
652: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
653: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
654: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,
655: l_x_bom_component_tbl);
656:

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

649: Error_Handler.Get_Message_List(l_x_bom_msg_list);
650: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
651: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
652: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
653: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_BO_PUB.Process_BOM OUTPUT Parameters <<<<<<<<<<<<<<<');
654: EAM_ActivityUtilities_PVT.Log_Process_BOM_Parameters(l_x_bom_header_rec,
655: l_x_bom_component_tbl);
656:
657:

Line 929: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,

925: x_rtg_return_status OUT NOCOPY VARCHAR2,
926: x_rtg_msg_count OUT NOCOPY NUMBER,
927: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,
928:
929: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
930: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
931: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
932: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
933: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,

Line 930: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,

926: x_rtg_msg_count OUT NOCOPY NUMBER,
927: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,
928:
929: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
930: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
931: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
932: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
933: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
934: x_bom_return_status OUT NOCOPY VARCHAR2,

Line 931: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,

927: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,
928:
929: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
930: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
931: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
932: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
933: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
934: x_bom_return_status OUT NOCOPY VARCHAR2,
935: x_bom_msg_count OUT NOCOPY NUMBER,

Line 932: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,

928:
929: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
930: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
931: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
932: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
933: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
934: x_bom_return_status OUT NOCOPY VARCHAR2,
935: x_bom_msg_count OUT NOCOPY NUMBER,
936: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,

Line 933: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,

929: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
930: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
931: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
932: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
933: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
934: x_bom_return_status OUT NOCOPY VARCHAR2,
935: x_bom_msg_count OUT NOCOPY NUMBER,
936: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type,
937:

Line 963: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

959: l_x_master_item_return_status VARCHAR2(1);
960: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
961:
962: -- local variabels for calling BOM Business Object API
963: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
964: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
965: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
966: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
967: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

Line 964: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

960: l_x_master_item_error_tbl INV_Item_GRP.Error_tbl_type;
961:
962: -- local variabels for calling BOM Business Object API
963: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
964: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
965: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
966: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
967: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
968: l_x_bom_return_status VARCHAR2(1);

Line 965: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

961:
962: -- local variabels for calling BOM Business Object API
963: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
964: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
965: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
966: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
967: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
968: l_x_bom_return_status VARCHAR2(1);
969: l_x_bom_msg_count NUMBER;

Line 966: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;

962: -- local variabels for calling BOM Business Object API
963: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
964: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
965: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
966: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
967: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
968: l_x_bom_return_status VARCHAR2(1);
969: l_x_bom_msg_count NUMBER;
970: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

Line 967: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

963: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
964: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
965: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
966: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
967: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
968: l_x_bom_return_status VARCHAR2(1);
969: l_x_bom_msg_count NUMBER;
970: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
971:

Line 1400: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;

1396: l_source_bom_sequence_id NUMBER;
1397: l_target_bom_sequence_id NUMBER;
1398: l_copy_bill_error_msg VARCHAR2(20000);
1399:
1400: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1401:
1402: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1403: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1404: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

Line 1402: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

1398: l_copy_bill_error_msg VARCHAR2(20000);
1399:
1400: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1401:
1402: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1403: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1404: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1405: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1406: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

Line 1403: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

1399:
1400: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1401:
1402: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1403: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1404: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1405: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1406: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1407: l_x_bom_return_status VARCHAR2(1);

Line 1404: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

1400: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1401:
1402: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1403: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1404: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1405: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1406: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1407: l_x_bom_return_status VARCHAR2(1);
1408: l_x_bom_msg_count NUMBER;

Line 1405: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;

1401:
1402: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1403: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1404: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1405: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1406: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1407: l_x_bom_return_status VARCHAR2(1);
1408: l_x_bom_msg_count NUMBER;
1409: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

Line 1406: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

1402: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1403: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1404: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1405: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1406: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1407: l_x_bom_return_status VARCHAR2(1);
1408: l_x_bom_msg_count NUMBER;
1409: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
1410:

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

1712:
1713: -- Create empty BOM header through BOM Business Object API
1714: Error_Handler.initialize;
1715: -- log call to Process_BOM API
1716: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
1717: BOM_BO_PUB.Process_BOM(
1718: p_bom_header_rec => l_bom_head_rec,
1719: x_bom_header_rec => l_x_bom_header_rec,
1720: x_bom_revision_tbl => l_x_bom_revision_tbl,

Line 1717: BOM_BO_PUB.Process_BOM(

1713: -- Create empty BOM header through BOM Business Object API
1714: Error_Handler.initialize;
1715: -- log call to Process_BOM API
1716: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
1717: BOM_BO_PUB.Process_BOM(
1718: p_bom_header_rec => l_bom_head_rec,
1719: x_bom_header_rec => l_x_bom_header_rec,
1720: x_bom_revision_tbl => l_x_bom_revision_tbl,
1721: x_bom_component_tbl => l_x_bom_component_tbl,

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

1723: x_bom_sub_component_tbl => l_x_bom_sub_component_tbl,
1724: x_return_status => l_x_bom_return_status,
1725: x_msg_count => l_x_bom_msg_count
1726: );
1727: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
1728:
1729: -- log errors
1730: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1731: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);

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

1729: -- log errors
1730: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_return_status=' || l_x_bom_return_status);
1731: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1732: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1733: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1734: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1735: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1736:
1737: -- Handle errors

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

1731: EAM_ActivityUtilities_PVT.Write_Debug('l_x_bom_msg_count=' || l_x_bom_msg_count);
1732: Error_Handler.Get_Message_List(l_x_bom_msg_list);
1733: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_BO_PUB.Process_BOM >>>>>');
1734: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_bom_msg_list);
1735: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_BO_PUB.Process_BOM <<<<<');
1736:
1737: -- Handle errors
1738: IF l_x_rtg_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1739: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_RTG_BO_FAILED');

Line 1959: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

1955: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
1956: l_x_rtg_return_status VARCHAR2(1);
1957: l_x_rtg_msg_count NUMBER;
1958: -- output variables of BOM Business Object API
1959: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1960: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1961: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1962: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1963: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

Line 1960: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

1956: l_x_rtg_return_status VARCHAR2(1);
1957: l_x_rtg_msg_count NUMBER;
1958: -- output variables of BOM Business Object API
1959: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1960: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1961: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1962: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1963: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1964: l_x_bom_return_status VARCHAR2(1);

Line 1961: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

1957: l_x_rtg_msg_count NUMBER;
1958: -- output variables of BOM Business Object API
1959: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1960: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1961: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1962: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1963: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1964: l_x_bom_return_status VARCHAR2(1);
1965: l_x_bom_msg_count NUMBER;

Line 1962: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;

1958: -- output variables of BOM Business Object API
1959: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1960: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1961: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1962: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1963: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1964: l_x_bom_return_status VARCHAR2(1);
1965: l_x_bom_msg_count NUMBER;
1966: -- Routing and BOM common Error Handler

Line 1963: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

1959: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
1960: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
1961: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
1962: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
1963: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
1964: l_x_bom_return_status VARCHAR2(1);
1965: l_x_bom_msg_count NUMBER;
1966: -- Routing and BOM common Error Handler
1967: l_x_bom_error_list Error_Handler.Error_Tbl_Type;

Line 2385: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,

2381: --p_source_activity_id IN NUMBER, -- inventory_item_id
2382:
2383: --p_material_copy_option IN NUMBER,
2384:
2385: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
2386: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
2387: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
2388: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
2389: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,

Line 2386: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,

2382:
2383: --p_material_copy_option IN NUMBER,
2384:
2385: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
2386: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
2387: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
2388: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
2389: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
2390: x_bom_return_status OUT NOCOPY VARCHAR2,

Line 2387: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,

2383: --p_material_copy_option IN NUMBER,
2384:
2385: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
2386: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
2387: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
2388: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
2389: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
2390: x_bom_return_status OUT NOCOPY VARCHAR2,
2391: x_bom_msg_count OUT NOCOPY NUMBER,

Line 2388: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,

2384:
2385: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
2386: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
2387: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
2388: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
2389: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
2390: x_bom_return_status OUT NOCOPY VARCHAR2,
2391: x_bom_msg_count OUT NOCOPY NUMBER,
2392: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type

Line 2389: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,

2385: x_bom_header_rec OUT NOCOPY BOM_BO_PUB.BOM_Head_Rec_Type,
2386: x_bom_revision_tbl OUT NOCOPY BOM_BO_PUB.BOM_Revision_Tbl_Type,
2387: x_bom_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Comps_Tbl_Type,
2388: x_bom_ref_designator_tbl OUT NOCOPY BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type,
2389: x_bom_sub_component_tbl OUT NOCOPY BOM_BO_PUB.BOM_Sub_Component_Tbl_Type,
2390: x_bom_return_status OUT NOCOPY VARCHAR2,
2391: x_bom_msg_count OUT NOCOPY NUMBER,
2392: x_bom_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
2393:

Line 2399: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;

2395: IS
2396: --l_current_date CONSTANT DATE := sysdate;
2397: l_create_txn_type CONSTANT VARCHAR(10) := 'CREATE';
2398: -- local variabels for calling BOM Business Object API
2399: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2400: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2401: l_bom_comp_tbl_index BINARY_INTEGER;
2402:
2403: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

Line 2400: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

2396: --l_current_date CONSTANT DATE := sysdate;
2397: l_create_txn_type CONSTANT VARCHAR(10) := 'CREATE';
2398: -- local variabels for calling BOM Business Object API
2399: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2400: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2401: l_bom_comp_tbl_index BINARY_INTEGER;
2402:
2403: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2404: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

Line 2403: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;

2399: l_bom_head_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2400: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2401: l_bom_comp_tbl_index BINARY_INTEGER;
2402:
2403: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2404: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
2405: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2406: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
2407: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

Line 2404: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;

2400: l_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2401: l_bom_comp_tbl_index BINARY_INTEGER;
2402:
2403: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2404: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
2405: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2406: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
2407: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
2408: l_x_bom_return_status VARCHAR2(1);

Line 2405: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;

2401: l_bom_comp_tbl_index BINARY_INTEGER;
2402:
2403: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2404: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
2405: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2406: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
2407: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
2408: l_x_bom_return_status VARCHAR2(1);
2409: l_x_bom_msg_count NUMBER;

Line 2406: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;

2402:
2403: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2404: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
2405: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2406: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
2407: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
2408: l_x_bom_return_status VARCHAR2(1);
2409: l_x_bom_msg_count NUMBER;
2410: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;

Line 2407: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;

2403: l_x_bom_header_rec BOM_BO_PUB.Bom_Head_Rec_Type;
2404: l_x_bom_revision_tbl BOM_BO_PUB.Bom_Revision_Tbl_Type;
2405: l_x_bom_component_tbl BOM_BO_PUB.Bom_Comps_Tbl_Type;
2406: l_x_bom_ref_designator_tbl BOM_BO_PUB.Bom_Ref_Designator_Tbl_Type;
2407: l_x_bom_sub_component_tbl BOM_BO_PUB.Bom_Sub_Component_Tbl_Type;
2408: l_x_bom_return_status VARCHAR2(1);
2409: l_x_bom_msg_count NUMBER;
2410: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
2411:

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

2440: */
2441: --l_bom_head_rec.Alternate_Bom_Code := l_bom_bom_row.alternate_bom_designator;
2442: --l_bom_head_rec.Assembly_Type := l_bom_bom_row.assembly_type;
2443: -- log call to Process_BOM API
2444: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
2445: BOM_BO_PUB.Process_BOM(
2446: p_bom_header_rec => l_bom_head_rec,
2447: p_bom_component_tbl => l_bom_component_tbl,
2448: x_bom_header_rec => l_x_bom_header_rec,

Line 2445: BOM_BO_PUB.Process_BOM(

2441: --l_bom_head_rec.Alternate_Bom_Code := l_bom_bom_row.alternate_bom_designator;
2442: --l_bom_head_rec.Assembly_Type := l_bom_bom_row.assembly_type;
2443: -- log call to Process_BOM API
2444: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_BO_PUB.Process_BOM **********');
2445: BOM_BO_PUB.Process_BOM(
2446: p_bom_header_rec => l_bom_head_rec,
2447: p_bom_component_tbl => l_bom_component_tbl,
2448: x_bom_header_rec => l_x_bom_header_rec,
2449: x_bom_revision_tbl => l_x_bom_revision_tbl,

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

2452: x_bom_sub_component_tbl => l_x_bom_sub_component_tbl,
2453: x_return_status => l_x_bom_return_status,
2454: x_msg_count => l_x_bom_msg_count
2455: );
2456: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_BO_PUB.Process_BOM **********');
2457:
2458: x_bom_header_rec := l_x_bom_header_rec;
2459: x_bom_revision_tbl := l_x_bom_revision_tbl;
2460: x_bom_component_tbl := l_x_bom_component_tbl;

Line 2476: x_bom_header_rec BOM_BO_PUB.BOM_Head_Rec_Type;

2472: p_organization_code varchar2,
2473: x_return_status OUT NOCOPY VARCHAR2
2474: )is
2475: l_target_item_rec INV_Item_GRP.Item_Rec_Type;
2476: x_bom_header_rec BOM_BO_PUB.BOM_Head_Rec_Type;
2477: x_bom_revision_tbl BOM_BO_PUB.BOM_Revision_Tbl_Type;
2478: x_bom_component_tbl BOM_BO_PUB.BOM_Comps_Tbl_Type;
2479: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;
2480: x_bom_sub_component_tbl BOM_BO_PUB.BOM_Sub_Component_Tbl_Type;

Line 2477: x_bom_revision_tbl BOM_BO_PUB.BOM_Revision_Tbl_Type;

2473: x_return_status OUT NOCOPY VARCHAR2
2474: )is
2475: l_target_item_rec INV_Item_GRP.Item_Rec_Type;
2476: x_bom_header_rec BOM_BO_PUB.BOM_Head_Rec_Type;
2477: x_bom_revision_tbl BOM_BO_PUB.BOM_Revision_Tbl_Type;
2478: x_bom_component_tbl BOM_BO_PUB.BOM_Comps_Tbl_Type;
2479: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;
2480: x_bom_sub_component_tbl BOM_BO_PUB.BOM_Sub_Component_Tbl_Type;
2481: x_bom_return_status VARCHAR2(1);

Line 2478: x_bom_component_tbl BOM_BO_PUB.BOM_Comps_Tbl_Type;

2474: )is
2475: l_target_item_rec INV_Item_GRP.Item_Rec_Type;
2476: x_bom_header_rec BOM_BO_PUB.BOM_Head_Rec_Type;
2477: x_bom_revision_tbl BOM_BO_PUB.BOM_Revision_Tbl_Type;
2478: x_bom_component_tbl BOM_BO_PUB.BOM_Comps_Tbl_Type;
2479: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;
2480: x_bom_sub_component_tbl BOM_BO_PUB.BOM_Sub_Component_Tbl_Type;
2481: x_bom_return_status VARCHAR2(1);
2482: x_bom_msg_count NUMBER;

Line 2479: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;

2475: l_target_item_rec INV_Item_GRP.Item_Rec_Type;
2476: x_bom_header_rec BOM_BO_PUB.BOM_Head_Rec_Type;
2477: x_bom_revision_tbl BOM_BO_PUB.BOM_Revision_Tbl_Type;
2478: x_bom_component_tbl BOM_BO_PUB.BOM_Comps_Tbl_Type;
2479: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;
2480: x_bom_sub_component_tbl BOM_BO_PUB.BOM_Sub_Component_Tbl_Type;
2481: x_bom_return_status VARCHAR2(1);
2482: x_bom_msg_count NUMBER;
2483: x_bom_msg_list Error_Handler.Error_Tbl_Type;

Line 2480: x_bom_sub_component_tbl BOM_BO_PUB.BOM_Sub_Component_Tbl_Type;

2476: x_bom_header_rec BOM_BO_PUB.BOM_Head_Rec_Type;
2477: x_bom_revision_tbl BOM_BO_PUB.BOM_Revision_Tbl_Type;
2478: x_bom_component_tbl BOM_BO_PUB.BOM_Comps_Tbl_Type;
2479: x_bom_ref_designator_tbl BOM_BO_PUB.BOM_Ref_Designator_Tbl_Type;
2480: x_bom_sub_component_tbl BOM_BO_PUB.BOM_Sub_Component_Tbl_Type;
2481: x_bom_return_status VARCHAR2(1);
2482: x_bom_msg_count NUMBER;
2483: x_bom_msg_list Error_Handler.Error_Tbl_Type;
2484: