APPS.ECO_CONTROLLER dependencies on BOM_BO_PUB

Line 143: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

139: -- Procedure Initialize_Record
140:
141: PROCEDURE Initialize_Record
142: ( p_ECO_controller_rec IN Controller_Eco_Rec_Type
143: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
144: , x_ECO_controller_rec IN OUT NOCOPY Controller_Eco_Rec_Type
145: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
146: , x_return_status OUT NOCOPY VARCHAR2
147: )

Line 149: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

145: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
146: , x_return_status OUT NOCOPY VARCHAR2
147: )
148: IS
149: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
150: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
151: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
152: l1_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
153: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;

Line 156: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

152: l1_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
153: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
154: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
155: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
156: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
157: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
158: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
159: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
160: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

Line 157: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

153: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
154: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
155: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
156: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
157: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
158: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
159: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
160: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
161: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

Line 158: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

154: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
155: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
156: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
157: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
158: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
159: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
160: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
161: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
162: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 164: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

160: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
161: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
162: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
163: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
164: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
165: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
166: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
167: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
168: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 165: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

161: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
162: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
163: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
164: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
165: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
166: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
167: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
168: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
169: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 166: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

162: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
163: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
164: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
165: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
166: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
167: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
168: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
169: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
170:

Line 225: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

221: -- Procedure Validate_And_Write
222:
223: PROCEDURE Validate_And_Write
224: ( p_ECO_controller_rec IN Controller_Eco_Rec_Type
225: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
226: , p_record_status IN VARCHAR2
227: , x_ECO_controller_rec IN OUT NOCOPY Controller_Eco_Rec_Type
228: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
229: , x_return_status OUT NOCOPY VARCHAR2

Line 232: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

228: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
229: , x_return_status OUT NOCOPY VARCHAR2
230: )
231: IS
232: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
233: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
234: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
235: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
236: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 238: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

234: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
235: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
236: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
237: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
238: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
239: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
240: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
241: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
242: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

Line 239: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

235: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
236: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
237: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
238: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
239: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
240: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
241: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
242: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
243: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

Line 240: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

236: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
237: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
238: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
239: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
240: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
241: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
242: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
243: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
244: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 246: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

242: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
243: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
244: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
245: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
246: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
247: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
248: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
249: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
250: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 247: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

243: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
244: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
245: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
246: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
247: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
248: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
249: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
250: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
251: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 248: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

244: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
245: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
246: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
247: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
248: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
249: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
250: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
251: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
252:

Line 318: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

314: -- Procedure Delete_Row
315:
316: PROCEDURE Delete_Row
317: ( p_ECO_controller_rec IN Controller_Eco_Rec_Type
318: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
319: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
320: , x_return_status OUT NOCOPY VARCHAR2
321: )
322: IS

Line 323: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

319: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
320: , x_return_status OUT NOCOPY VARCHAR2
321: )
322: IS
323: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
324: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
325: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
326: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
327: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 329: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

325: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
326: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
327: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
328: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
329: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
330: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
331: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
332: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
333: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

Line 330: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

326: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
327: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
328: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
329: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
330: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
331: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
332: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
333: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
334: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

Line 331: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

327: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
328: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
329: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
330: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
331: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
332: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
333: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
334: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
335: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 337: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

333: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
334: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
335: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
336: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
337: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
338: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
339: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
340: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
341: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 338: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

334: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
335: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
336: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
337: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
338: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
339: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
340: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
341: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
342: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 339: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

335: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
336: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
337: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
338: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
339: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
340: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
341: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
342: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
343:

Line 395: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

391: --Procedure Change_Attibute
392:
393: PROCEDURE Change_Attribute
394: ( p_ECO_controller_rec IN Controller_Eco_Rec_Type
395: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
396: , p_record_status IN VARCHAR2
397: , x_ECO_controller_rec IN OUT NOCOPY Controller_Eco_Rec_Type
398: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
399: , x_return_status OUT NOCOPY VARCHAR2

Line 402: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

398: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
399: , x_return_status OUT NOCOPY VARCHAR2
400: )
401: IS
402: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
403: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
404: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
405: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
406: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 408: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

404: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
405: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
406: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
407: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
408: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
409: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
410: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
411: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
412: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add

Line 409: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

405: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
406: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
407: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
408: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
409: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
410: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
411: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
412: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
413: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add

Line 410: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

406: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
407: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
408: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
409: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
410: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
411: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
412: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
413: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
414: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 416: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

412: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
413: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
414: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
415: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
416: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
417: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
418: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
419: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
420: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add

Line 417: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

413: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
414: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
415: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
416: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
417: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
418: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
419: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
420: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
421: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add

Line 418: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

414: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
415: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
416: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
417: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
418: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
419: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
420: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
421: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
422: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;