113: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
114: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
115: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
116: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
117: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; -- add
118: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; -- add
119: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; -- add
120: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
121: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
114: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
115: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
116: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
117: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; -- add
118: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; -- add
119: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; -- add
120: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
121: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
122: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
115: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
116: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
117: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; -- add
118: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; -- add
119: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; -- add
120: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
121: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
122: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
123: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
121: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
122: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
123: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
124: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
125: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
126: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
127: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
128:
129: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
122: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
123: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
124: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
125: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
126: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
127: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
128:
129: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
130: l_return_status VARCHAR2(1);
123: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
124: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
125: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
126: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
127: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
128:
129: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
130: l_return_status VARCHAR2(1);
131: l_msg_count NUMBER;
195: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
196: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
197: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
198: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
199: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
200: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
201: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
202: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
203: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
196: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
197: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
198: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
199: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
200: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
201: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
202: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
203: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
204: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
197: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
198: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
199: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
200: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
201: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
202: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
203: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
204: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
205: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
203: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
204: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
205: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
206: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
207: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
208: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
209: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
210:
211: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
204: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
205: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
206: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
207: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
208: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
209: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
210:
211: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
212: l_return_status VARCHAR2(1);
205: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
206: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
207: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
208: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
209: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
210:
211: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
212: l_return_status VARCHAR2(1);
213: l_msg_count NUMBER;
285: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
286: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
287: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
288: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
289: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
290: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
291: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
292: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
293: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
286: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
287: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
288: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
289: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
290: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
291: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
292: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
293: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
294: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
287: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
288: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
289: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type; --add
290: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type; --add
291: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type; --add
292: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
293: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
294: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
295: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
293: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
294: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
295: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
296: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
297: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
298: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
299: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
300:
301: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
294: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
295: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
296: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
297: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
298: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
299: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
300:
301: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
302: l_return_status VARCHAR2(1);
295: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
296: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
297: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type; --add
298: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type; --add
299: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type; --add
300:
301: l_mesg_token_tbl Error_Handler.Mesg_Token_Tbl_Type;
302: l_return_status VARCHAR2(1);
303: l_msg_count NUMBER;