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_RTG_PUB

Line 136: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,

132: p_work_order_rec IN EAM_Activity_PUB.Work_Order_Rec_Type,
133: p_operation_copy_option IN NUMBER,
134: p_resource_copy_option IN NUMBER,
135:
136: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
137: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
138: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
139: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
140: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,

Line 137: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,

133: p_operation_copy_option IN NUMBER,
134: p_resource_copy_option IN NUMBER,
135:
136: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
137: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
138: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
139: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
140: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
141: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,

Line 138: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,

134: p_resource_copy_option IN NUMBER,
135:
136: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
137: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
138: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
139: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
140: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
141: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
142: x_rtg_return_status OUT NOCOPY VARCHAR2,

Line 139: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,

135:
136: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
137: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
138: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
139: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
140: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
141: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
142: x_rtg_return_status OUT NOCOPY VARCHAR2,
143: x_rtg_msg_count OUT NOCOPY NUMBER,

Line 140: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,

136: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
137: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
138: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
139: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
140: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
141: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
142: x_rtg_return_status OUT NOCOPY VARCHAR2,
143: x_rtg_msg_count OUT NOCOPY NUMBER,
144: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type

Line 141: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,

137: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
138: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
139: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
140: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
141: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
142: x_rtg_return_status OUT NOCOPY VARCHAR2,
143: x_rtg_msg_count OUT NOCOPY NUMBER,
144: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
145: )

Line 157: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

153: l_x_pos NUMBER;
154: l_y_pos NUMBER;
155:
156: -- local variables for call the Routing Business Object API
157: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
158: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
159: l_operation_tbl_index BINARY_INTEGER;
160: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
161: l_op_resource_tbl_index BINARY_INTEGER;

Line 158: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

154: l_y_pos NUMBER;
155:
156: -- local variables for call the Routing Business Object API
157: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
158: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
159: l_operation_tbl_index BINARY_INTEGER;
160: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
161: l_op_resource_tbl_index BINARY_INTEGER;
162: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

Line 160: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

156: -- local variables for call the Routing Business Object API
157: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
158: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
159: l_operation_tbl_index BINARY_INTEGER;
160: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
161: l_op_resource_tbl_index BINARY_INTEGER;
162: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
163: l_op_network_tbl_index BINARY_INTEGER;
164:

Line 162: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

158: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
159: l_operation_tbl_index BINARY_INTEGER;
160: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
161: l_op_resource_tbl_index BINARY_INTEGER;
162: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
163: l_op_network_tbl_index BINARY_INTEGER;
164:
165: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
166: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

Line 165: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

161: l_op_resource_tbl_index BINARY_INTEGER;
162: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
163: l_op_network_tbl_index BINARY_INTEGER;
164:
165: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
166: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
167: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
168: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
169: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

Line 166: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

162: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
163: l_op_network_tbl_index BINARY_INTEGER;
164:
165: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
166: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
167: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
168: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
169: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
170: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

Line 167: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

163: l_op_network_tbl_index BINARY_INTEGER;
164:
165: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
166: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
167: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
168: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
169: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
170: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
171: l_x_rtg_return_status VARCHAR2(1);

Line 168: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

164:
165: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
166: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
167: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
168: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
169: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
170: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
171: l_x_rtg_return_status VARCHAR2(1);
172: l_x_rtg_msg_count NUMBER;

Line 169: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

165: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
166: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
167: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
168: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
169: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
170: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
171: l_x_rtg_return_status VARCHAR2(1);
172: l_x_rtg_msg_count NUMBER;
173: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

Line 170: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

166: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
167: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
168: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
169: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
170: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
171: l_x_rtg_return_status VARCHAR2(1);
172: l_x_rtg_msg_count NUMBER;
173: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
174: l_code varchar2(4); -- 13519051

Line 434: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_RTG_PUB.Process_Rtg INPUT Parameters >>>>>>>>>>>>>>>');

430: -- Only Call Routing Business Object API if operation tabel is not empty
431: IF l_operation_tbl.FIRST IS NOT NULL THEN
432: Error_Handler.initialize;
433: -- log call to Process_Rtg API
434: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_RTG_PUB.Process_Rtg INPUT Parameters >>>>>>>>>>>>>>>');
435: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_rtg_header_rec,
436: l_operation_tbl,
437: l_op_resource_tbl,
438: l_op_network_tbl);

Line 440: EAM_ActivityUtilities_PVT.Write_Debug(' Calling BOM_RTG_PUB.Process_Rtg ');

436: l_operation_tbl,
437: l_op_resource_tbl,
438: l_op_network_tbl);
439:
440: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
441: BOM_RTG_PUB.Process_Rtg(
442: p_rtg_header_rec => l_rtg_header_rec
443: , p_operation_tbl => l_operation_tbl
444: , p_op_resource_tbl => l_op_resource_tbl

Line 441: BOM_RTG_PUB.Process_Rtg(

437: l_op_resource_tbl,
438: l_op_network_tbl);
439:
440: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
441: BOM_RTG_PUB.Process_Rtg(
442: p_rtg_header_rec => l_rtg_header_rec
443: , p_operation_tbl => l_operation_tbl
444: , p_op_resource_tbl => l_op_resource_tbl
445: , p_op_network_tbl => l_op_network_tbl

Line 455: EAM_ActivityUtilities_PVT.Write_Debug(' Returned from BOM_RTG_PUB.Process_Rtg ');

451: , x_op_network_tbl => l_x_op_network_tbl
452: , x_return_status => l_x_rtg_return_status
453: , x_msg_count => l_x_rtg_msg_count
454: );
455: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
456:
457: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
458:
459: -- log errors

Line 463: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');

459: -- log errors
460: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
461: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
462: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
463: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
464: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
465: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
466: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
467: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,

Line 465: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');

461: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
462: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
463: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
464: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
465: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
466: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
467: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,
468: l_x_operation_tbl,
469: l_x_op_resource_tbl,

Line 466: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');

462: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
463: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
464: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
465: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
466: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
467: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,
468: l_x_operation_tbl,
469: l_x_op_resource_tbl,
470: l_x_op_network_tbl);

Line 919: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,

915: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
916: x_master_item_return_status OUT NOCOPY VARCHAR2,
917: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
918:
919: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
920: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
921: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
922: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
923: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,

Line 920: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,

916: x_master_item_return_status OUT NOCOPY VARCHAR2,
917: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
918:
919: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
920: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
921: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
922: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
923: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
924: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,

Line 921: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,

917: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
918:
919: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
920: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
921: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
922: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
923: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
924: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
925: x_rtg_return_status OUT NOCOPY VARCHAR2,

Line 922: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,

918:
919: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
920: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
921: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
922: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
923: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
924: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
925: x_rtg_return_status OUT NOCOPY VARCHAR2,
926: x_rtg_msg_count OUT NOCOPY NUMBER,

Line 923: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,

919: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
920: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
921: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
922: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
923: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
924: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_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,

Line 924: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,

920: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
921: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
922: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
923: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
924: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_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:

Line 973: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

969: l_x_bom_msg_count NUMBER;
970: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
971:
972: -- local variables for call the Routing Business Object API
973: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
974: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
975: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
976: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
977: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

Line 974: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

970: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
971:
972: -- local variables for call the Routing Business Object API
973: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
974: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
975: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
976: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
977: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
978: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

Line 975: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

971:
972: -- local variables for call the Routing Business Object API
973: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
974: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
975: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
976: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
977: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
978: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
979: l_x_rtg_return_status VARCHAR2(1);

Line 976: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

972: -- local variables for call the Routing Business Object API
973: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
974: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
975: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
976: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
977: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
978: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
979: l_x_rtg_return_status VARCHAR2(1);
980: l_x_rtg_msg_count NUMBER;

Line 977: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

973: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
974: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
975: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
976: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
977: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
978: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
979: l_x_rtg_return_status VARCHAR2(1);
980: l_x_rtg_msg_count NUMBER;
981: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

Line 978: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

974: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
975: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
976: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
977: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
978: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
979: l_x_rtg_return_status VARCHAR2(1);
980: l_x_rtg_msg_count NUMBER;
981: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
982:

Line 1415: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

1411: -- local variables for call the Routing Business Object API
1412: l_source_rtg_sequence_id NUMBER;
1413: l_target_rtg_sequence_id NUMBER;
1414:
1415: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1416:
1417: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1418: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1419: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

Line 1417: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

1413: l_target_rtg_sequence_id NUMBER;
1414:
1415: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1416:
1417: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1418: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1419: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1420: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1421: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

Line 1418: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

1414:
1415: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1416:
1417: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1418: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1419: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1420: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1421: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1422: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

Line 1419: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

1415: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1416:
1417: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1418: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1419: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1420: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1421: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1422: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
1423: l_x_rtg_return_status VARCHAR2(1);

Line 1420: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

1416:
1417: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1418: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1419: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1420: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1421: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1422: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
1423: l_x_rtg_return_status VARCHAR2(1);
1424: l_x_rtg_msg_count NUMBER;

Line 1421: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

1417: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1418: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1419: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1420: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1421: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1422: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
1423: l_x_rtg_return_status VARCHAR2(1);
1424: l_x_rtg_msg_count NUMBER;
1425: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

Line 1422: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

1418: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1419: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1420: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1421: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1422: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
1423: l_x_rtg_return_status VARCHAR2(1);
1424: l_x_rtg_msg_count NUMBER;
1425: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
1426:

Line 1623: EAM_ActivityUtilities_PVT.Write_Debug(' Calling BOM_RTG_PUB.Process_Rtg ');

1619: l_rtg_header_rec.Organization_Code := l_x_curr_item_rec.Organization_Code;
1620:
1621: Error_Handler.initialize;
1622: -- log call to Process_Rtg API
1623: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
1624: BOM_RTG_PUB.Process_Rtg(
1625: p_rtg_header_rec => l_rtg_header_rec
1626: , x_rtg_header_rec => l_x_rtg_header_rec
1627: , x_rtg_revision_tbl => l_x_rtg_revision_tbl

Line 1624: BOM_RTG_PUB.Process_Rtg(

1620:
1621: Error_Handler.initialize;
1622: -- log call to Process_Rtg API
1623: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
1624: BOM_RTG_PUB.Process_Rtg(
1625: p_rtg_header_rec => l_rtg_header_rec
1626: , x_rtg_header_rec => l_x_rtg_header_rec
1627: , x_rtg_revision_tbl => l_x_rtg_revision_tbl
1628: , x_operation_tbl => l_x_operation_tbl

Line 1635: EAM_ActivityUtilities_PVT.Write_Debug(' Returned from BOM_RTG_PUB.Process_Rtg ');

1631: , x_op_network_tbl => l_x_op_network_tbl
1632: , x_return_status => l_x_rtg_return_status
1633: , x_msg_count => l_x_rtg_msg_count
1634: );
1635: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
1636:
1637: -- log errors
1638: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1639: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);

Line 1641: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');

1637: -- log errors
1638: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1639: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1640: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1641: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1642: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1643: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1644:
1645: -- Handle errors

Line 1643: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');

1639: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1640: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1641: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1642: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1643: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1644:
1645: -- Handle errors
1646: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1647: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_BOM_BO_FAILED');

Line 1950: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

1946: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
1947: l_x_master_item_return_status VARCHAR2(1);
1948: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1949: -- output variables of Routing Business Object API
1950: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1951: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1952: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1953: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1954: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

Line 1951: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

1947: l_x_master_item_return_status VARCHAR2(1);
1948: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1949: -- output variables of Routing Business Object API
1950: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1951: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1952: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1953: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1954: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1955: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

Line 1952: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

1948: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1949: -- output variables of Routing Business Object API
1950: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1951: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1952: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1953: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1954: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1955: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
1956: l_x_rtg_return_status VARCHAR2(1);

Line 1953: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

1949: -- output variables of Routing Business Object API
1950: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1951: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1952: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1953: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1954: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_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;

Line 1954: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

1950: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1951: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1952: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1953: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1954: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_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

Line 1955: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

1951: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1952: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1953: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1954: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_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;

Line 2648: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,

2644:
2645: PROCEDURE Create_Routing_Header(
2646: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
2647:
2648: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
2649: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
2650: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
2651: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
2652: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,

Line 2649: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,

2645: PROCEDURE Create_Routing_Header(
2646: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
2647:
2648: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
2649: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
2650: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
2651: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
2652: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
2653: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,

Line 2650: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,

2646: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
2647:
2648: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
2649: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
2650: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
2651: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
2652: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
2653: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
2654: x_rtg_return_status OUT NOCOPY VARCHAR2,

Line 2651: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,

2647:
2648: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
2649: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
2650: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
2651: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
2652: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
2653: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
2654: x_rtg_return_status OUT NOCOPY VARCHAR2,
2655: x_rtg_msg_count OUT NOCOPY NUMBER,

Line 2652: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,

2648: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
2649: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
2650: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
2651: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
2652: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
2653: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
2654: x_rtg_return_status OUT NOCOPY VARCHAR2,
2655: x_rtg_msg_count OUT NOCOPY NUMBER,
2656: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type

Line 2653: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,

2649: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
2650: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
2651: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
2652: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
2653: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
2654: x_rtg_return_status OUT NOCOPY VARCHAR2,
2655: x_rtg_msg_count OUT NOCOPY NUMBER,
2656: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
2657: )

Line 2664: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

2660: --l_current_date CONSTANT DATE := sysdate;
2661: l_create_txn_type CONSTANT VARCHAR(10) := 'CREATE';
2662:
2663: -- local variables for call the Routing Business Object API
2664: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2665: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2666: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2667: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2668:

Line 2665: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

2661: l_create_txn_type CONSTANT VARCHAR(10) := 'CREATE';
2662:
2663: -- local variables for call the Routing Business Object API
2664: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2665: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2666: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2667: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2668:
2669:

Line 2666: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

2662:
2663: -- local variables for call the Routing Business Object API
2664: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2665: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2666: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2667: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2668:
2669:
2670: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

Line 2667: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

2663: -- local variables for call the Routing Business Object API
2664: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2665: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2666: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2667: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2668:
2669:
2670: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2671: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

Line 2670: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

2666: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2667: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2668:
2669:
2670: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2671: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2672: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2673: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2674: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

Line 2671: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

2667: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2668:
2669:
2670: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2671: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2672: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2673: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2674: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2675: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

Line 2672: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

2668:
2669:
2670: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2671: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2672: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2673: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2674: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2675: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2676: l_x_rtg_return_status VARCHAR2(1);

Line 2673: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

2669:
2670: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2671: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2672: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2673: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2674: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2675: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2676: l_x_rtg_return_status VARCHAR2(1);
2677: l_x_rtg_msg_count NUMBER;

Line 2674: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

2670: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2671: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2672: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2673: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2674: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2675: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2676: l_x_rtg_return_status VARCHAR2(1);
2677: l_x_rtg_msg_count NUMBER;
2678: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

Line 2675: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

2671: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2672: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2673: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2674: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2675: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2676: l_x_rtg_return_status VARCHAR2(1);
2677: l_x_rtg_msg_count NUMBER;
2678: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
2679:

Line 2693: EAM_ActivityUtilities_PVT.Write_Debug(' Calling BOM_RTG_PUB.Process_Rtg ');

2689: l_rtg_header_rec.Transaction_Type := l_create_txn_type;
2690:
2691: Error_Handler.initialize;
2692: -- log call to Process_Rtg API
2693: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
2694: BOM_RTG_PUB.Process_Rtg(
2695: p_rtg_header_rec => l_rtg_header_rec
2696: , p_operation_tbl => l_operation_tbl
2697: , p_op_resource_tbl => l_op_resource_tbl

Line 2694: BOM_RTG_PUB.Process_Rtg(

2690:
2691: Error_Handler.initialize;
2692: -- log call to Process_Rtg API
2693: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
2694: BOM_RTG_PUB.Process_Rtg(
2695: p_rtg_header_rec => l_rtg_header_rec
2696: , p_operation_tbl => l_operation_tbl
2697: , p_op_resource_tbl => l_op_resource_tbl
2698: , p_op_network_tbl => l_op_network_tbl

Line 2708: EAM_ActivityUtilities_PVT.Write_Debug(' Returned from BOM_RTG_PUB.Process_Rtg ');

2704: , x_op_network_tbl => l_x_op_network_tbl
2705: , x_return_status => l_x_rtg_return_status
2706: , x_msg_count => l_x_rtg_msg_count
2707: );
2708: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
2709:
2710: -- Assign outputs.
2711: x_rtg_header_rec := l_x_rtg_header_rec;
2712: x_rtg_revision_tbl := l_x_rtg_revision_tbl;

Line 2731: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

2727: p_inventory_item_name varchar2,
2728: p_organization_code varchar2,
2729: x_return_status OUT NOCOPY VARCHAR2
2730: )is
2731: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2732: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2733: l_operation_tbl_index BINARY_INTEGER;
2734: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2735: l_op_resource_tbl_index BINARY_INTEGER;

Line 2732: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

2728: p_organization_code varchar2,
2729: x_return_status OUT NOCOPY VARCHAR2
2730: )is
2731: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2732: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2733: l_operation_tbl_index BINARY_INTEGER;
2734: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2735: l_op_resource_tbl_index BINARY_INTEGER;
2736: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

Line 2734: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

2730: )is
2731: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2732: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2733: l_operation_tbl_index BINARY_INTEGER;
2734: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2735: l_op_resource_tbl_index BINARY_INTEGER;
2736: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2737: l_op_network_tbl_index BINARY_INTEGER;
2738:

Line 2736: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

2732: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2733: l_operation_tbl_index BINARY_INTEGER;
2734: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2735: l_op_resource_tbl_index BINARY_INTEGER;
2736: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2737: l_op_network_tbl_index BINARY_INTEGER;
2738:
2739: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2740: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

Line 2739: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

2735: l_op_resource_tbl_index BINARY_INTEGER;
2736: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2737: l_op_network_tbl_index BINARY_INTEGER;
2738:
2739: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2740: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2741: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2742: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2743: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

Line 2740: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

2736: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2737: l_op_network_tbl_index BINARY_INTEGER;
2738:
2739: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2740: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2741: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2742: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2743: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2744: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

Line 2741: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

2737: l_op_network_tbl_index BINARY_INTEGER;
2738:
2739: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2740: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2741: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2742: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2743: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2744: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2745: l_x_rtg_return_status VARCHAR2(1);

Line 2742: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

2738:
2739: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2740: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2741: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2742: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2743: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2744: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2745: l_x_rtg_return_status VARCHAR2(1);
2746: l_x_rtg_msg_count NUMBER;

Line 2743: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

2739: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2740: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2741: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2742: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2743: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2744: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2745: l_x_rtg_return_status VARCHAR2(1);
2746: l_x_rtg_msg_count NUMBER;
2747: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

Line 2744: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

2740: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2741: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2742: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2743: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2744: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2745: l_x_rtg_return_status VARCHAR2(1);
2746: l_x_rtg_msg_count NUMBER;
2747: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
2748: