183: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
184: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
185: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
186: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
187: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
188: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
189: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
190: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
191: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
184: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
185: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
186: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
187: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
188: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
189: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
190: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
191: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
192: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
185: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
186: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
187: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
188: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
189: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
190: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
191: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
192: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
193: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
191: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
192: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
193: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
194: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
195: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
196: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
197: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
198: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
199: l_return_status VARCHAR2(1);
192: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
193: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
194: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
195: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
196: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
197: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
198: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
199: l_return_status VARCHAR2(1);
200: l_msg_count NUMBER;
193: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
194: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
195: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
196: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
197: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
198: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
199: l_return_status VARCHAR2(1);
200: l_msg_count NUMBER;
201: l_disable_revision NUMBER:=2; --BUG 3034642
264: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
265: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
266: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
267: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
268: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
269: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
270: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
271: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
272: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
265: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
266: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
267: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
268: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
269: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
270: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
271: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
272: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
273: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
266: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
267: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
268: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
269: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
270: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
271: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
272: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
273: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
274: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
272: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
273: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
274: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
275: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
276: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
277: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
278: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
279:
280: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
273: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
274: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
275: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
276: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
277: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
278: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
279:
280: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
281: l_return_status VARCHAR2(1);
274: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
275: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
276: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
277: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
278: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
279:
280: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
281: l_return_status VARCHAR2(1);
282: l_msg_count NUMBER;
354: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
355: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
356: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
357: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
358: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
359: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
360: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
361: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
362: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
355: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
356: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
357: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
358: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
359: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
360: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
361: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
362: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
363: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
356: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
357: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
358: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
359: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
360: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
361: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
362: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
363: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
364: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
362: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
363: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
364: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
365: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
366: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
367: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
368: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
369:
370:
363: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
364: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
365: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
366: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
367: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
368: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
369:
370:
371:
364: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
365: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
366: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
367: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
368: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
369:
370:
371:
372: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
437: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
438: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
439: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
440: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
441: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
442: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
443: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
444: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
445: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
438: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
439: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
440: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
441: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
442: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
443: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
444: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
445: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
446: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
439: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
440: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
441: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
442: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
443: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
444: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
445: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
446: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
447: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
445: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
446: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
447: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
448: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
449: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
450: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
451: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
452:
453:
446: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
447: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
448: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
449: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
450: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
451: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
452:
453:
454: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
447: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
448: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
449: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
450: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
451: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
452:
453:
454: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
455: l_return_status VARCHAR2(1);