APPS.ENG_RIT_CONTROLLER dependencies on BOM_BO_PUB

Line 185: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

181: -- Procedure Initialize_Record
182:
183: PROCEDURE Initialize_Record
184: ( p_RIT_controller_rec IN ENG_RIT_Controller.Controller_Rit_Rec_Type
185: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
186: , x_RIT_controller_rec IN OUT NOCOPY ENG_RIT_Controller.Controller_Rit_Rec_Type
187: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
188: , x_return_status OUT NOCOPY VARCHAR2
189: )

Line 191: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

187: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
188: , x_return_status OUT NOCOPY VARCHAR2
189: )
190: IS
191: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
192: l_RIT_controller_rec ENG_RIT_Controller.Controller_Rit_Rec_Type := p_rit_controller_rec;
193: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
194: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
195: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 197: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

193: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
194: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
195: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
196: l_unexp_RIT_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
197: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
198: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
199: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
200: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
201: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;

Line 198: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

194: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
195: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
196: l_unexp_RIT_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
197: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
198: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
199: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
200: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
201: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
202: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;

Line 199: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

195: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
196: l_unexp_RIT_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
197: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
198: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
199: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
200: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
201: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
202: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
203: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 205: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

201: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
202: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
203: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
204: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
205: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
206: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
207: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
208: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
209: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;

Line 206: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

202: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
203: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
204: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
205: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
206: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
207: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
208: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
209: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
210: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;

Line 207: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

203: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
204: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
205: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
206: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
207: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
208: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
209: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
210: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
211:

Line 282: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

278: -- Procedure Validate_And_Write
279:
280: PROCEDURE Validate_And_Write
281: ( p_RIT_controller_rec IN ENG_RIT_Controller.Controller_Rit_Rec_Type
282: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
283: , p_record_status IN VARCHAR2
284: , x_RIT_controller_rec IN OUT NOCOPY ENG_RIT_Controller.Controller_Rit_Rec_Type
285: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
286: , x_return_status OUT NOCOPY VARCHAR2

Line 289: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

285: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
286: , x_return_status OUT NOCOPY VARCHAR2
287: )
288: IS
289: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
290: l_RIT_controller_rec ENG_RIT_Controller.Controller_Rit_Rec_Type := p_rit_controller_rec;
291: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
292: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
293: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 295: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

291: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
292: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
293: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
294: l_unexp_RIT_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
295: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
296: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
297: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
298: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
299: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;

Line 296: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

292: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
293: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
294: l_unexp_RIT_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
295: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
296: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
297: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
298: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
299: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
300: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;

Line 297: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

293: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
294: l_unexp_RIT_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
295: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
296: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
297: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
298: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
299: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
300: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
301: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 303: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

299: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
300: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
301: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
302: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
303: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
304: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
305: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
306: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
307: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;

Line 304: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

300: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
301: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
302: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
303: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
304: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
305: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
306: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
307: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
308: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;

Line 305: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

301: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
302: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
303: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
304: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
305: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
306: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
307: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
308: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
309:

Line 374: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

370: -- Procedure Delete_Row
371:
372: PROCEDURE Delete_Row
373: ( p_RIT_controller_rec IN ENG_RIT_Controller.Controller_Rit_Rec_Type
374: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
375: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
376: , x_return_status OUT NOCOPY VARCHAR2
377: )
378: IS

Line 379: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

375: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
376: , x_return_status OUT NOCOPY VARCHAR2
377: )
378: IS
379: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
380: l_RIT_controller_rec ENG_RIT_Controller.Controller_Rit_Rec_Type := p_rit_controller_rec;
381: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
382: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
383: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 385: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

381: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
382: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
383: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
384: l_unexp_RIT_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
385: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
386: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
387: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
388: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
389: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;

Line 386: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

382: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
383: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
384: l_unexp_RIT_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
385: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
386: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
387: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
388: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
389: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
390: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;

Line 387: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

383: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
384: l_unexp_RIT_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
385: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
386: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
387: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
388: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
389: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
390: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
391: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 393: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

389: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
390: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
391: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
392: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
393: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
394: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
395: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
396: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
397: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;

Line 394: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

390: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
391: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
392: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
393: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
394: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
395: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
396: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
397: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
398: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;

Line 395: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

391: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
392: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
393: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
394: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
395: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
396: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
397: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
398: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
399:

Line 456: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type

452: --Procedure Change_Attibute
453:
454: PROCEDURE Change_Attribute
455: ( p_RIT_controller_rec IN ENG_RIT_Controller.Controller_Rit_Rec_Type
456: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
457: , p_record_status IN VARCHAR2
458: , x_RIT_controller_rec IN OUT NOCOPY ENG_RIT_Controller.Controller_Rit_Rec_Type
459: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
460: , x_return_status OUT NOCOPY VARCHAR2

Line 464: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;

460: , x_return_status OUT NOCOPY VARCHAR2
461: , x_disable_revision OUT NOCOPY NUMBER --Bug no:3034642
462: )
463: IS
464: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
465: l_RIT_controller_rec ENG_RIT_Controller.Controller_Rit_Rec_Type := p_rit_controller_rec;
466: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
467: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
468: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 470: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

466: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
467: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
468: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
469: l_unexp_RIT_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
470: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
471: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
472: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
473: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
474: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;

Line 471: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

467: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
468: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
469: l_unexp_RIT_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
470: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
471: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
472: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
473: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
474: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
475: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;

Line 472: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

468: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
469: l_unexp_RIT_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
470: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
471: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
472: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
473: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
474: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
475: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
476: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

Line 478: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;

474: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
475: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
476: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
477: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
478: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
479: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
480: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
481: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
482: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;

Line 479: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;

475: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
476: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
477: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
478: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
479: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
480: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
481: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
482: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
483: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;

Line 480: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

476: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
477: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
478: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
479: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
480: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
481: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
482: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
483: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;
484: