DBA Data[Home] [Help]

APPS.ECO_CONTROLLER dependencies on ENG_ECO_PUB

Line 8: , x_ECO_rec OUT NOCOPY ENG_ECO_PUB.Eco_Rec_Type

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

Line 9: , x_unexp_ECO_rec OUT NOCOPY ENG_ECO_PUB.ECO_Unexposed_Rec_Type

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

Line 76: ( p_ECO_rec IN ENG_ECO_PUB.Eco_Rec_Type

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

Line 77: , p_unexp_ECO_rec IN ENG_ECO_PUB.ECO_Unexposed_Rec_Type

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

Line 151: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;

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;

Line 152: l1_ECO_rec ENG_ECO_PUB.ECO_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;

Line 153: l_unexp_ECO_rec ENG_ECO_PUB.ECO_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;

Line 154: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_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;

Line 155: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_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

Line 162: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_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;
166: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

Line 163: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_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

Line 234: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;

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;

Line 235: l_unexp_ECO_rec ENG_ECO_PUB.ECO_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;

Line 236: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_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;

Line 237: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_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

Line 244: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_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;
248: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

Line 245: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_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

Line 325: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;

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;

Line 326: l_unexp_ECO_rec ENG_ECO_PUB.ECO_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;

Line 327: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_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;

Line 328: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_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

Line 335: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_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;
339: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

Line 336: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_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

Line 404: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;

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;

Line 405: l_unexp_ECO_rec ENG_ECO_PUB.ECO_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;

Line 406: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_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;

Line 407: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_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

Line 414: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_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;
418: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

Line 415: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_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

Line 519: , p_ECO_rec IN ENG_Eco_PUB.Eco_Rec_Type

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:

Line 520: , x_ECO_rec OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type

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;