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;
163: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_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;
163: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
164: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_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;
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;
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:
171: l_mesg_token_tbl Error_Handler.Mesg_Token_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:
171: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
172: l_return_status VARCHAR2(1);
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:
171: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
172: l_return_status VARCHAR2(1);
173: l_msg_count NUMBER;
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;
245: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_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;
245: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
246: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_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;
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;
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:
253: l_mesg_token_tbl Error_Handler.Mesg_Token_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:
253: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
254: l_return_status VARCHAR2(1);
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:
253: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
254: l_return_status VARCHAR2(1);
255: l_msg_count NUMBER;
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;
336: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_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;
336: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
337: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_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;
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;
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:
344: l_mesg_token_tbl Error_Handler.Mesg_Token_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:
344: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
345: l_return_status VARCHAR2(1);
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:
344: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
345: l_return_status VARCHAR2(1);
346: l_msg_count NUMBER;
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;
415: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_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;
415: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
416: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_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;
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;
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;
423: l_return_status VARCHAR2(1);
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;
423: l_return_status VARCHAR2(1);
424: l_msg_count NUMBER;
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;
423: l_return_status VARCHAR2(1);
424: l_msg_count NUMBER;
425: l_other_message VARCHAR2(50);