4: -- Procedure Create_Exp_Unexp_Rec
5:
6: PROCEDURE Create_Exp_Unexp_Rec
7: ( p_controller_ECO_rec IN Controller_Eco_Rec_Type
8: , x_ECO_rec OUT NOCOPY ENG_ECO_PUB.Eco_Rec_Type
9: , x_unexp_ECO_rec OUT NOCOPY ENG_ECO_PUB.ECO_Unexposed_Rec_Type
10: )
11: IS
12: BEGIN
5:
6: PROCEDURE Create_Exp_Unexp_Rec
7: ( p_controller_ECO_rec IN Controller_Eco_Rec_Type
8: , x_ECO_rec OUT NOCOPY ENG_ECO_PUB.Eco_Rec_Type
9: , x_unexp_ECO_rec OUT NOCOPY ENG_ECO_PUB.ECO_Unexposed_Rec_Type
10: )
11: IS
12: BEGIN
13: -- Create exposed record
72:
73: END Create_Exp_Unexp_Rec;
74:
75: PROCEDURE Create_Controller_Rec
76: ( p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
77: , p_unexp_ECO_rec IN ENG_ECO_PUB.ECO_Unexposed_Rec_Type
78: , x_controller_ECO_rec OUT NOCOPY Controller_Eco_Rec_Type
79: )
80: IS
73: END Create_Exp_Unexp_Rec;
74:
75: PROCEDURE Create_Controller_Rec
76: ( p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type
77: , p_unexp_ECO_rec IN ENG_ECO_PUB.ECO_Unexposed_Rec_Type
78: , x_controller_ECO_rec OUT NOCOPY Controller_Eco_Rec_Type
79: )
80: IS
81: BEGIN
147: )
148: IS
149: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
150: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
151: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
152: l1_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
153: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
154: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
155: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
148: IS
149: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
150: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
151: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
152: l1_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
153: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
154: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
149: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
150: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
151: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
152: l1_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
153: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
154: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
150: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
151: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
152: l1_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
153: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
154: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
151: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
152: l1_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
153: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
154: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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
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;
166: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_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;
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
230: )
231: IS
232: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
233: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
234: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
235: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
236: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
231: IS
232: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
233: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
234: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
235: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
236: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
232: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
233: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
234: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
235: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
236: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
233: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
234: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
235: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
236: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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
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;
248: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_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;
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
321: )
322: IS
323: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
324: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
325: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
326: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
327: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
322: IS
323: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
324: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
325: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
326: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
327: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
323: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
324: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
325: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
326: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
327: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
324: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
325: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
326: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
327: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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
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;
339: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_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;
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
400: )
401: IS
402: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
403: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
404: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
405: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
406: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
401: IS
402: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
403: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
404: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
405: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
406: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
402: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
403: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
404: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
405: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
406: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
403: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;
404: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
405: l_unexp_ECO_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
406: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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
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;
418: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_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;
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
515:
516: /*PROCEDURE Lock_Row
517: ( x_return_status OUT NOCOPY VARCHAR2
518: , x_err_text OUT NOCOPY VARCHAR2
519: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
520: , x_ECO_rec OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
521: );
522: */
523:
516: /*PROCEDURE Lock_Row
517: ( x_return_status OUT NOCOPY VARCHAR2
518: , x_err_text OUT NOCOPY VARCHAR2
519: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type
520: , x_ECO_rec OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
521: );
522: */
523:
524: END ECO_Controller;