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:

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

404: -- Only Call Routing Business Object API if operation tabel is not empty
405: IF l_operation_tbl.FIRST IS NOT NULL THEN
406: Error_Handler.initialize;
407: -- log call to Process_Rtg API
408: EAM_ActivityUtilities_PVT.Write_Debug('>>>>>>>>>>>>>>> BOM_RTG_PUB.Process_Rtg INPUT Parameters >>>>>>>>>>>>>>>');
409: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_rtg_header_rec,
410: l_operation_tbl,
411: l_op_resource_tbl,
412: l_op_network_tbl);

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

410: l_operation_tbl,
411: l_op_resource_tbl,
412: l_op_network_tbl);
413:
414: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
415: BOM_RTG_PUB.Process_Rtg(
416: p_rtg_header_rec => l_rtg_header_rec
417: , p_operation_tbl => l_operation_tbl
418: , p_op_resource_tbl => l_op_resource_tbl

Line 415: BOM_RTG_PUB.Process_Rtg(

411: l_op_resource_tbl,
412: l_op_network_tbl);
413:
414: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
415: BOM_RTG_PUB.Process_Rtg(
416: p_rtg_header_rec => l_rtg_header_rec
417: , p_operation_tbl => l_operation_tbl
418: , p_op_resource_tbl => l_op_resource_tbl
419: , p_op_network_tbl => l_op_network_tbl

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

425: , x_op_network_tbl => l_x_op_network_tbl
426: , x_return_status => l_x_rtg_return_status
427: , x_msg_count => l_x_rtg_msg_count
428: );
429: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
430:
431: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
432:
433: -- log errors

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

433: -- log errors
434: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
435: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
436: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
437: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
438: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
439: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
440: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
441: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,

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

435: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
436: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
437: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
438: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
439: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
440: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
441: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,
442: l_x_operation_tbl,
443: l_x_op_resource_tbl,

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

436: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
437: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
438: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
439: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
440: EAM_ActivityUtilities_PVT.Write_Debug('<<<<<<<<<<<<<<< BOM_RTG_PUB.Process_Rtg OUTPUT Parameters <<<<<<<<<<<<<<<');
441: EAM_ActivityUtilities_PVT.Log_Process_Rtg_Parameters(l_x_rtg_header_rec,
442: l_x_operation_tbl,
443: l_x_op_resource_tbl,
444: l_x_op_network_tbl);

Line 888: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,

884: x_master_item_rec OUT NOCOPY INV_Item_GRP.Item_Rec_Type,
885: x_master_item_return_status OUT NOCOPY VARCHAR2,
886: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
887:
888: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
889: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
890: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
891: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
892: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,

Line 889: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,

885: x_master_item_return_status OUT NOCOPY VARCHAR2,
886: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
887:
888: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
889: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
890: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
891: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
892: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
893: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,

Line 890: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,

886: x_master_item_error_tbl OUT NOCOPY INV_Item_GRP.Error_Tbl_Type,
887:
888: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
889: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
890: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
891: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
892: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
893: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
894: x_rtg_return_status OUT NOCOPY VARCHAR2,

Line 891: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,

887:
888: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
889: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
890: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
891: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
892: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
893: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
894: x_rtg_return_status OUT NOCOPY VARCHAR2,
895: x_rtg_msg_count OUT NOCOPY NUMBER,

Line 892: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,

888: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
889: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
890: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
891: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
892: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
893: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_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,

Line 893: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,

889: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
890: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
891: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
892: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
893: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_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:

Line 942: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

938: l_x_bom_msg_count NUMBER;
939: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
940:
941: -- local variables for call the Routing Business Object API
942: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
943: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
944: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
945: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
946: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

Line 943: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

939: l_x_bom_msg_list Error_Handler.Error_Tbl_Type;
940:
941: -- local variables for call the Routing Business Object API
942: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
943: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
944: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
945: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
946: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
947: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

Line 944: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

940:
941: -- local variables for call the Routing Business Object API
942: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
943: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
944: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
945: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
946: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
947: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
948: l_x_rtg_return_status VARCHAR2(1);

Line 945: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

941: -- local variables for call the Routing Business Object API
942: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
943: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
944: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
945: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
946: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
947: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
948: l_x_rtg_return_status VARCHAR2(1);
949: l_x_rtg_msg_count NUMBER;

Line 946: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

942: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
943: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
944: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
945: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
946: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
947: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
948: l_x_rtg_return_status VARCHAR2(1);
949: l_x_rtg_msg_count NUMBER;
950: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

Line 947: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

943: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
944: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
945: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
946: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
947: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
948: l_x_rtg_return_status VARCHAR2(1);
949: l_x_rtg_msg_count NUMBER;
950: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
951:

Line 1384: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

1380: -- local variables for call the Routing Business Object API
1381: l_source_rtg_sequence_id NUMBER;
1382: l_target_rtg_sequence_id NUMBER;
1383:
1384: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1385:
1386: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1387: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1388: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

Line 1386: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

1382: l_target_rtg_sequence_id NUMBER;
1383:
1384: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1385:
1386: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1387: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1388: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1389: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1390: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

Line 1387: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

1383:
1384: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1385:
1386: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1387: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1388: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1389: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1390: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1391: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

Line 1388: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

1384: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1385:
1386: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1387: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1388: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1389: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1390: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1391: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
1392: l_x_rtg_return_status VARCHAR2(1);

Line 1389: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

1385:
1386: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1387: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1388: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1389: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1390: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1391: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
1392: l_x_rtg_return_status VARCHAR2(1);
1393: l_x_rtg_msg_count NUMBER;

Line 1390: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

1386: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1387: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1388: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1389: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1390: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1391: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
1392: l_x_rtg_return_status VARCHAR2(1);
1393: l_x_rtg_msg_count NUMBER;
1394: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

Line 1391: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

1387: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1388: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1389: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1390: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1391: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
1392: l_x_rtg_return_status VARCHAR2(1);
1393: l_x_rtg_msg_count NUMBER;
1394: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
1395:

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

1588: l_rtg_header_rec.Organization_Code := l_x_curr_item_rec.Organization_Code;
1589:
1590: Error_Handler.initialize;
1591: -- log call to Process_Rtg API
1592: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
1593: BOM_RTG_PUB.Process_Rtg(
1594: p_rtg_header_rec => l_rtg_header_rec
1595: , x_rtg_header_rec => l_x_rtg_header_rec
1596: , x_rtg_revision_tbl => l_x_rtg_revision_tbl

Line 1593: BOM_RTG_PUB.Process_Rtg(

1589:
1590: Error_Handler.initialize;
1591: -- log call to Process_Rtg API
1592: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
1593: BOM_RTG_PUB.Process_Rtg(
1594: p_rtg_header_rec => l_rtg_header_rec
1595: , x_rtg_header_rec => l_x_rtg_header_rec
1596: , x_rtg_revision_tbl => l_x_rtg_revision_tbl
1597: , x_operation_tbl => l_x_operation_tbl

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

1600: , x_op_network_tbl => l_x_op_network_tbl
1601: , x_return_status => l_x_rtg_return_status
1602: , x_msg_count => l_x_rtg_msg_count
1603: );
1604: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
1605:
1606: -- log errors
1607: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1608: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);

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

1606: -- log errors
1607: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_return_status=' || l_x_rtg_return_status);
1608: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1609: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1610: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1611: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1612: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1613:
1614: -- Handle errors

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

1608: EAM_ActivityUtilities_PVT.Write_Debug('l_x_rtg_msg_count=' || l_x_rtg_msg_count);
1609: Error_Handler.Get_Message_List(l_x_rtg_msg_list);
1610: EAM_ActivityUtilities_PVT.Write_Debug('Results of BOM_RTG_PUB.Process_Rtg >>>>>');
1611: EAM_ActivityUtilities_PVT.Log_Bom_Error_Tbl(l_x_rtg_msg_list);
1612: EAM_ActivityUtilities_PVT.Write_Debug('End of Results of BOM_RTG_PUB.Process_Rtg <<<<<');
1613:
1614: -- Handle errors
1615: IF l_x_bom_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1616: FND_MESSAGE.SET_NAME('EAM', 'EAM_ABO_BOM_BO_FAILED');

Line 1919: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

1915: l_x_master_item_rec INV_Item_GRP.Item_Rec_Type;
1916: l_x_master_item_return_status VARCHAR2(1);
1917: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1918: -- output variables of Routing Business Object API
1919: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1920: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1921: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1922: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1923: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

Line 1920: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

1916: l_x_master_item_return_status VARCHAR2(1);
1917: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1918: -- output variables of Routing Business Object API
1919: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1920: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1921: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1922: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1923: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1924: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

Line 1921: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

1917: l_x_master_item_error_tbl INV_Item_GRP.Error_Tbl_Type;
1918: -- output variables of Routing Business Object API
1919: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1920: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1921: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1922: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1923: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
1924: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
1925: l_x_rtg_return_status VARCHAR2(1);

Line 1922: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

1918: -- output variables of Routing Business Object API
1919: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1920: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1921: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1922: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1923: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_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;

Line 1923: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

1919: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
1920: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1921: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1922: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1923: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_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

Line 1924: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

1920: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
1921: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
1922: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
1923: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_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;

Line 2617: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,

2613:
2614: PROCEDURE Create_Routing_Header(
2615: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
2616:
2617: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
2618: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
2619: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
2620: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
2621: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,

Line 2618: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,

2614: PROCEDURE Create_Routing_Header(
2615: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
2616:
2617: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
2618: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
2619: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
2620: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
2621: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
2622: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,

Line 2619: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,

2615: p_target_item_rec IN INV_Item_GRP.Item_Rec_Type,
2616:
2617: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
2618: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
2619: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
2620: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
2621: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
2622: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
2623: x_rtg_return_status OUT NOCOPY VARCHAR2,

Line 2620: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,

2616:
2617: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
2618: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
2619: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
2620: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
2621: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
2622: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
2623: x_rtg_return_status OUT NOCOPY VARCHAR2,
2624: x_rtg_msg_count OUT NOCOPY NUMBER,

Line 2621: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,

2617: x_rtg_header_rec OUT NOCOPY BOM_Rtg_Pub.Rtg_Header_Rec_Type,
2618: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
2619: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
2620: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
2621: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
2622: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
2623: x_rtg_return_status OUT NOCOPY VARCHAR2,
2624: x_rtg_msg_count OUT NOCOPY NUMBER,
2625: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type

Line 2622: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,

2618: x_rtg_revision_tbl OUT NOCOPY BOM_Rtg_Pub.Rtg_Revision_Tbl_Type,
2619: x_operation_tbl OUT NOCOPY BOM_Rtg_Pub.Operation_Tbl_Type,
2620: x_op_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Resource_Tbl_Type,
2621: x_sub_resource_tbl OUT NOCOPY BOM_Rtg_Pub.Sub_Resource_Tbl_Type,
2622: x_op_network_tbl OUT NOCOPY BOM_Rtg_Pub.Op_Network_Tbl_Type,
2623: x_rtg_return_status OUT NOCOPY VARCHAR2,
2624: x_rtg_msg_count OUT NOCOPY NUMBER,
2625: x_rtg_msg_list OUT NOCOPY Error_Handler.Error_Tbl_Type
2626: )

Line 2633: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

2629: --l_current_date CONSTANT DATE := sysdate;
2630: l_create_txn_type CONSTANT VARCHAR(10) := 'CREATE';
2631:
2632: -- local variables for call the Routing Business Object API
2633: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2634: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2635: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2636: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2637:

Line 2634: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

2630: l_create_txn_type CONSTANT VARCHAR(10) := 'CREATE';
2631:
2632: -- local variables for call the Routing Business Object API
2633: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2634: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2635: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2636: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2637:
2638:

Line 2635: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

2631:
2632: -- local variables for call the Routing Business Object API
2633: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2634: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2635: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2636: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2637:
2638:
2639: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

Line 2636: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

2632: -- local variables for call the Routing Business Object API
2633: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2634: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2635: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2636: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2637:
2638:
2639: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2640: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

Line 2639: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

2635: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2636: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2637:
2638:
2639: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2640: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2641: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2642: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2643: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

Line 2640: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

2636: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2637:
2638:
2639: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2640: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2641: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2642: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2643: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2644: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

Line 2641: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

2637:
2638:
2639: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2640: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2641: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2642: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2643: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2644: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2645: l_x_rtg_return_status VARCHAR2(1);

Line 2642: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

2638:
2639: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2640: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2641: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2642: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2643: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2644: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2645: l_x_rtg_return_status VARCHAR2(1);
2646: l_x_rtg_msg_count NUMBER;

Line 2643: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

2639: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2640: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2641: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2642: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2643: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2644: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2645: l_x_rtg_return_status VARCHAR2(1);
2646: l_x_rtg_msg_count NUMBER;
2647: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

Line 2644: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

2640: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2641: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2642: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2643: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2644: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2645: l_x_rtg_return_status VARCHAR2(1);
2646: l_x_rtg_msg_count NUMBER;
2647: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
2648:

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

2658: l_rtg_header_rec.Transaction_Type := l_create_txn_type;
2659:
2660: Error_Handler.initialize;
2661: -- log call to Process_Rtg API
2662: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
2663: BOM_RTG_PUB.Process_Rtg(
2664: p_rtg_header_rec => l_rtg_header_rec
2665: , p_operation_tbl => l_operation_tbl
2666: , p_op_resource_tbl => l_op_resource_tbl

Line 2663: BOM_RTG_PUB.Process_Rtg(

2659:
2660: Error_Handler.initialize;
2661: -- log call to Process_Rtg API
2662: EAM_ActivityUtilities_PVT.Write_Debug('********** Calling BOM_RTG_PUB.Process_Rtg **********');
2663: BOM_RTG_PUB.Process_Rtg(
2664: p_rtg_header_rec => l_rtg_header_rec
2665: , p_operation_tbl => l_operation_tbl
2666: , p_op_resource_tbl => l_op_resource_tbl
2667: , p_op_network_tbl => l_op_network_tbl

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

2673: , x_op_network_tbl => l_x_op_network_tbl
2674: , x_return_status => l_x_rtg_return_status
2675: , x_msg_count => l_x_rtg_msg_count
2676: );
2677: EAM_ActivityUtilities_PVT.Write_Debug('********** Returned from BOM_RTG_PUB.Process_Rtg **********');
2678:
2679: -- Assign outputs.
2680: x_rtg_header_rec := l_x_rtg_header_rec;
2681: x_rtg_revision_tbl := l_x_rtg_revision_tbl;

Line 2700: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

2696: p_inventory_item_name varchar2,
2697: p_organization_code varchar2,
2698: x_return_status OUT NOCOPY VARCHAR2
2699: )is
2700: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2701: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2702: l_operation_tbl_index BINARY_INTEGER;
2703: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2704: l_op_resource_tbl_index BINARY_INTEGER;

Line 2701: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

2697: p_organization_code varchar2,
2698: x_return_status OUT NOCOPY VARCHAR2
2699: )is
2700: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2701: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2702: l_operation_tbl_index BINARY_INTEGER;
2703: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2704: l_op_resource_tbl_index BINARY_INTEGER;
2705: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

Line 2703: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

2699: )is
2700: l_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2701: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2702: l_operation_tbl_index BINARY_INTEGER;
2703: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2704: l_op_resource_tbl_index BINARY_INTEGER;
2705: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2706: l_op_network_tbl_index BINARY_INTEGER;
2707:

Line 2705: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

2701: l_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2702: l_operation_tbl_index BINARY_INTEGER;
2703: l_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2704: l_op_resource_tbl_index BINARY_INTEGER;
2705: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2706: l_op_network_tbl_index BINARY_INTEGER;
2707:
2708: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2709: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

Line 2708: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;

2704: l_op_resource_tbl_index BINARY_INTEGER;
2705: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2706: l_op_network_tbl_index BINARY_INTEGER;
2707:
2708: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2709: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2710: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2711: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2712: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

Line 2709: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;

2705: l_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2706: l_op_network_tbl_index BINARY_INTEGER;
2707:
2708: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2709: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2710: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2711: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2712: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2713: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

Line 2710: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;

2706: l_op_network_tbl_index BINARY_INTEGER;
2707:
2708: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2709: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2710: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2711: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2712: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2713: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2714: l_x_rtg_return_status VARCHAR2(1);

Line 2711: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;

2707:
2708: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2709: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2710: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2711: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2712: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2713: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2714: l_x_rtg_return_status VARCHAR2(1);
2715: l_x_rtg_msg_count NUMBER;

Line 2712: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;

2708: l_x_rtg_header_rec BOM_RTG_PUB.Rtg_Header_Rec_Type;
2709: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2710: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2711: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2712: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2713: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2714: l_x_rtg_return_status VARCHAR2(1);
2715: l_x_rtg_msg_count NUMBER;
2716: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;

Line 2713: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;

2709: l_x_rtg_revision_tbl BOM_RTG_PUB.Rtg_Revision_Tbl_Type;
2710: l_x_operation_tbl BOM_RTG_PUB.Operation_Tbl_Type;
2711: l_x_op_resource_tbl BOM_RTG_PUB.Op_Resource_Tbl_Type;
2712: l_x_sub_resource_tbl BOM_RTG_PUB.Sub_Resource_Tbl_Type;
2713: l_x_op_network_tbl BOM_RTG_PUB.Op_Network_Tbl_Type;
2714: l_x_rtg_return_status VARCHAR2(1);
2715: l_x_rtg_msg_count NUMBER;
2716: l_x_rtg_msg_list Error_Handler.Error_Tbl_Type;
2717: