106: )
107: IS
108: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
109: l_RFD_controller_rec Controller_RFD_Rec_Type := p_RFD_controller_rec;
110: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
111: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
112: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
107: IS
108: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
109: l_RFD_controller_rec Controller_RFD_Rec_Type := p_RFD_controller_rec;
110: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
111: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
112: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
108: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
109: l_RFD_controller_rec Controller_RFD_Rec_Type := p_RFD_controller_rec;
110: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
111: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
112: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
109: l_RFD_controller_rec Controller_RFD_Rec_Type := p_RFD_controller_rec;
110: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
111: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
112: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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
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;
124: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_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;
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
188: )
189: IS
190: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
191: l_RFD_controller_rec Controller_RFD_Rec_Type := p_RFD_controller_rec;
192: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
193: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
194: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
189: IS
190: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
191: l_RFD_controller_rec Controller_RFD_Rec_Type := p_RFD_controller_rec;
192: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
193: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
194: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
190: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
191: l_RFD_controller_rec Controller_RFD_Rec_Type := p_RFD_controller_rec;
192: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
193: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
194: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
191: l_RFD_controller_rec Controller_RFD_Rec_Type := p_RFD_controller_rec;
192: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
193: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
194: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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
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;
206: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_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;
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
278: )
279: IS
280: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
281: l_RFD_controller_rec Controller_RFD_Rec_Type := p_RFD_controller_rec;
282: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
283: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
284: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
279: IS
280: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
281: l_RFD_controller_rec Controller_RFD_Rec_Type := p_RFD_controller_rec;
282: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
283: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
284: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
280: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
281: l_RFD_controller_rec Controller_RFD_Rec_Type := p_RFD_controller_rec;
282: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
283: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
284: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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;
281: l_RFD_controller_rec Controller_RFD_Rec_Type := p_RFD_controller_rec;
282: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
283: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
284: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
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
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;
296: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_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;
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
349:
350: /*PROCEDURE Lock_Row
351: ( x_return_status OUT NOCOPY VARCHAR2
352: , x_err_text OUT NOCOPY VARCHAR2
353: , p_RFD_tbl(1) IN ENG_Eco_PUB.Rit_Rec_Type
354: , x_RFD_tbl(1) OUT NOCOPY ENG_Eco_PUB.Rit_Rec_Type
355: );
356: */
357:
350: /*PROCEDURE Lock_Row
351: ( x_return_status OUT NOCOPY VARCHAR2
352: , x_err_text OUT NOCOPY VARCHAR2
353: , p_RFD_tbl(1) IN ENG_Eco_PUB.Rit_Rec_Type
354: , x_RFD_tbl(1) OUT NOCOPY ENG_Eco_PUB.Rit_Rec_Type
355: );
356: */
357:
358: END RFD_Controller;