DBA Data[Home] [Help]

APPS.FLM_COPY_ROUTING dependencies on BOM_RTG_PUB

Line 170: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;

166:
167: l_assembly_item_name varchar2(81);
168: l_today date := sysdate;
169:
170: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

Line 171: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;

167: l_assembly_item_name varchar2(81);
168: l_today date := sysdate;
169:
170: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

Line 172: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

168: l_today date := sysdate;
169:
170: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:

Line 173: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;

169:
170: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;

Line 174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

170: l_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
171: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;

Line 175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

171: l_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
172: l_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
173: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
179: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

Line 177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;

173: l_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
179: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
180: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

Line 178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;

174: l_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
179: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
180: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

Line 179: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

175: l_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
176:
177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
179: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
180: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
183:

Line 180: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;

176:
177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
179: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
180: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
183:
184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;

Line 181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

177: o_rtg_header_rec Bom_Rtg_Pub.Rtg_Header_Rec_Type;
178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
179: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
180: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
183:
184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
185: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

Line 182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

178: o_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
179: o_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
180: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
183:
184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
185: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
186: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;

Line 184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;

180: o_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
183:
184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
185: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
186: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
187: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
188: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

Line 185: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

181: o_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
183:
184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
185: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
186: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
187: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
188: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
189:

Line 186: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;

182: o_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
183:
184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
185: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
186: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
187: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
188: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
189:
190: a_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

Line 187: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;

183:
184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
185: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
186: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
187: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
188: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
189:
190: a_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
191:

Line 188: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;

184: t_rtg_revision_tbl Bom_Rtg_Pub.Rtg_Revision_Tbl_Type;
185: t_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
186: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
187: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
188: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
189:
190: a_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
191:
192: o_return_status Varchar2(8);

Line 190: a_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;

186: t_op_resource_tbl Bom_Rtg_Pub.Op_Resource_Tbl_Type;
187: t_sub_resource_tbl Bom_Rtg_Pub.Sub_Resource_Tbl_Type;
188: t_op_network_tbl Bom_Rtg_Pub.Op_Network_Tbl_Type;
189:
190: a_operation_tbl Bom_Rtg_Pub.Operation_Tbl_Type;
191:
192: o_return_status Varchar2(8);
193: o_msg_count Number;
194: l_msg varchar2(1000);

Line 1367: Bom_Rtg_Pub.Process_Rtg( p_rtg_header_rec =>l_rtg_header_rec

1363: CLOSE c_networks;
1364:
1365: error_handler.initialize;
1366:
1367: Bom_Rtg_Pub.Process_Rtg( p_rtg_header_rec =>l_rtg_header_rec
1368: ,p_rtg_revision_tbl =>l_rtg_revision_tbl
1369: ,p_operation_tbl =>l_operation_tbl
1370: ,p_op_resource_tbl =>l_op_resource_tbl
1371: ,p_sub_resource_tbl =>l_sub_resource_tbl