145: )
146: IS
147: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
148: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
149: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
150: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
151: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
152: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
153: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
146: IS
147: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
148: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
149: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
150: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
151: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
152: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
153: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
154: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
147: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
148: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
149: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
150: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
151: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
152: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
153: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
154: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
155: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
148: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
149: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
150: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
151: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
152: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
153: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
154: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
155: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
156: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
155: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
156: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
157: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
158: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
159: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
160: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
161: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
162: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
163: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
156: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
157: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
158: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
159: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
160: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
161: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
162: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
163: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
164: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
227: )
228: IS
229: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
230: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
231: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
232: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
233: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
234: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
235: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
228: IS
229: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
230: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
231: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
232: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
233: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
234: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
235: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
236: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
229: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
230: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
231: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
232: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
233: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
234: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
235: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
236: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
237: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
230: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
231: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
232: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
233: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
234: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
235: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
236: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
237: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
238: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
237: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
238: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
239: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
240: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
241: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
242: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
243: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
244: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
245: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
238: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
239: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
240: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
241: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
242: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
243: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
244: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
245: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
246: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
318: )
319: IS
320: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
321: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
322: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
323: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
324: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
325: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
326: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
319: IS
320: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
321: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
322: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
323: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
324: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
325: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
326: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
327: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
320: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
321: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
322: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
323: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
324: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
325: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
326: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
327: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
328: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
321: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
322: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
323: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
324: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
325: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
326: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
327: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
328: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
329: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
328: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
329: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
330: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
331: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
332: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
333: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
334: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
335: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
336: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
329: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
330: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
331: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
332: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
333: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
334: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
335: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
336: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
337: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
402: )
403: IS
404: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
405: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
406: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
407: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
408: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
409: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
410: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
403: IS
404: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
405: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
406: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
407: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
408: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
409: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
410: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
411: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
404: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
405: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
406: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
407: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
408: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
409: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
410: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
411: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
412: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
405: l_RES_controller_rec ENG_RES_Controller.Controller_Res_Rec_Type := p_res_controller_rec;
406: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
407: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
408: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
409: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
410: l_unexp_rev_comp_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
411: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
412: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
413: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
412: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
413: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
414: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
415: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
416: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
417: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
418: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
419: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
420: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
413: l_unexp_OPS_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
414: l_unexp_RES_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
415: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
416: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
417: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
418: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
419: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
420: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
421: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
522:
523: /*PROCEDURE Lock_Row
524: ( x_return_status OUT NOCOPY VARCHAR2
525: , x_err_text OUT NOCOPY VARCHAR2
526: , p_RES_tbl(1) IN ENG_Eco_PUB.Rit_Rec_Type
527: , x_RES_tbl(1) OUT NOCOPY ENG_Eco_PUB.Rit_Rec_Type
528: );
529: */
530:
523: /*PROCEDURE Lock_Row
524: ( x_return_status OUT NOCOPY VARCHAR2
525: , x_err_text OUT NOCOPY VARCHAR2
526: , p_RES_tbl(1) IN ENG_Eco_PUB.Rit_Rec_Type
527: , x_RES_tbl(1) OUT NOCOPY ENG_Eco_PUB.Rit_Rec_Type
528: );
529: */
530:
531: END ENG_RES_Controller;