DBA Data[Home] [Help]

APPS.REV_CONTROLLER dependencies on ENG_ECO_PUB

Line 8: , x_REV_tbl OUT NOCOPY ENG_ECO_PUB.Eco_Revision_Tbl_Type

4: -- Procedure Create_Exp_Unexp_Rec
5:
6: PROCEDURE Create_Exp_Unexp_Rec
7: ( p_controller_REV_rec IN REV_Controller.Controller_REV_Rec_Type
8: , x_REV_tbl OUT NOCOPY ENG_ECO_PUB.Eco_Revision_Tbl_Type
9: , x_unexp_REV_rec OUT NOCOPY ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type
10: )
11: IS
12: BEGIN

Line 9: , x_unexp_REV_rec OUT NOCOPY ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type

5:
6: PROCEDURE Create_Exp_Unexp_Rec
7: ( p_controller_REV_rec IN REV_Controller.Controller_REV_Rec_Type
8: , x_REV_tbl OUT NOCOPY ENG_ECO_PUB.Eco_Revision_Tbl_Type
9: , x_unexp_REV_rec OUT NOCOPY ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type
10: )
11: IS
12: BEGIN
13: -- Create exposed record

Line 46: ( p_REV_tbl IN ENG_ECO_PUB.Eco_Revision_Tbl_Type

42:
43: END Create_Exp_Unexp_Rec;
44:
45: PROCEDURE Create_Controller_Rec
46: ( p_REV_tbl IN ENG_ECO_PUB.Eco_Revision_Tbl_Type
47: , p_unexp_REV_rec IN ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type
48: , x_controller_REV_rec OUT NOCOPY REV_Controller.Controller_REV_Rec_Type
49: )
50: IS

Line 47: , p_unexp_REV_rec IN ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type

43: END Create_Exp_Unexp_Rec;
44:
45: PROCEDURE Create_Controller_Rec
46: ( p_REV_tbl IN ENG_ECO_PUB.Eco_Revision_Tbl_Type
47: , p_unexp_REV_rec IN ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type
48: , x_controller_REV_rec OUT NOCOPY REV_Controller.Controller_REV_Rec_Type
49: )
50: IS
51: BEGIN

Line 93: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;

89: )
90: IS
91: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
92: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
93: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
94: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
95: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
96: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
97: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

Line 94: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;

90: IS
91: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
92: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
93: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
94: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
95: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
96: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
97: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
98: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

Line 95: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;

91: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
92: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
93: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
94: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
95: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
96: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
97: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
98: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
99: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

Line 96: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

92: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
93: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
94: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
95: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
96: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
97: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
98: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
99: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
100:

Line 105: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

101: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
102: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
103: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
104:
105: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
106: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
107: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
108: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
109: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;

Line 106: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

102: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
103: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
104:
105: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
106: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
107: l_rev_component_tbl BOM_BO_PUB.Rev_Component_Tbl_Type;
108: l_ref_designator_tbl BOM_BO_PUB.Ref_Designator_Tbl_Type;
109: l_sub_component_tbl BOM_BO_PUB.Sub_Component_Tbl_Type;
110:

Line 190: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;

186: )
187: IS
188: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
189: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
190: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
191: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
192: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
193: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
194: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;

Line 191: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;

187: IS
188: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
189: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
190: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
191: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
192: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
193: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
194: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
195: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;

Line 192: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;

188: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
189: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
190: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
191: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
192: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
193: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
194: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
195: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
196: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;

Line 193: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

189: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;
190: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
191: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
192: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
193: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
194: l_unexp_CMP_rec BOM_BO_PUB.Rev_Comp_Unexposed_Rec_Type;
195: l_unexp_SBC_rec BOM_BO_PUB.Sub_Comp_Unexposed_Rec_Type;
196: l_unexp_RFD_rec BOM_BO_PUB.Ref_Desg_Unexposed_Rec_Type;
197:

Line 202: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

198: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
199: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
200: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
201:
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;

Line 203: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

199: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
200: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
201:
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:

Line 266: ( p_REV_controller_rec IN ENG_ECO_PUB.Controller_REV_Rec_Type

262: /*
263: --Procedure Change_Attibute
264:
265: PROCEDURE Change_Attribute
266: ( p_REV_controller_rec IN ENG_ECO_PUB.Controller_REV_Rec_Type
267: , p_control_rec IN ENG_ECO_PUB.Control_Rec_Type
268: , p_record_status IN VARCHAR2
269: , x_REV_controller_rec IN OUT NOCOPY ENG_ECO_PUB.Controller_REV_Rec_Type
270: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 267: , p_control_rec IN ENG_ECO_PUB.Control_Rec_Type

263: --Procedure Change_Attibute
264:
265: PROCEDURE Change_Attribute
266: ( p_REV_controller_rec IN ENG_ECO_PUB.Controller_REV_Rec_Type
267: , p_control_rec IN ENG_ECO_PUB.Control_Rec_Type
268: , p_record_status IN VARCHAR2
269: , x_REV_controller_rec IN OUT NOCOPY ENG_ECO_PUB.Controller_REV_Rec_Type
270: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
271: , x_return_status OUT NOCOPY VARCHAR2

Line 269: , x_REV_controller_rec IN OUT NOCOPY ENG_ECO_PUB.Controller_REV_Rec_Type

265: PROCEDURE Change_Attribute
266: ( p_REV_controller_rec IN ENG_ECO_PUB.Controller_REV_Rec_Type
267: , p_control_rec IN ENG_ECO_PUB.Control_Rec_Type
268: , p_record_status IN VARCHAR2
269: , x_REV_controller_rec IN OUT NOCOPY ENG_ECO_PUB.Controller_REV_Rec_Type
270: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
271: , x_return_status OUT NOCOPY VARCHAR2
272: )
273: IS

Line 274: l_control_rec ENG_ECO_PUB.Control_Rec_Type := p_control_rec;

270: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
271: , x_return_status OUT NOCOPY VARCHAR2
272: )
273: IS
274: l_control_rec ENG_ECO_PUB.Control_Rec_Type := p_control_rec;
275: l_REV_controller_rec ENG_ECO_PUB.Controller_REV_Rec_Type := p_REV_controller_rec;
276: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
277: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
278: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;

Line 275: l_REV_controller_rec ENG_ECO_PUB.Controller_REV_Rec_Type := p_REV_controller_rec;

271: , x_return_status OUT NOCOPY VARCHAR2
272: )
273: IS
274: l_control_rec ENG_ECO_PUB.Control_Rec_Type := p_control_rec;
275: l_REV_controller_rec ENG_ECO_PUB.Controller_REV_Rec_Type := p_REV_controller_rec;
276: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
277: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
278: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
279: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

Line 276: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;

272: )
273: IS
274: l_control_rec ENG_ECO_PUB.Control_Rec_Type := p_control_rec;
275: l_REV_controller_rec ENG_ECO_PUB.Controller_REV_Rec_Type := p_REV_controller_rec;
276: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
277: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
278: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
279: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
280: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;

Line 277: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;

273: IS
274: l_control_rec ENG_ECO_PUB.Control_Rec_Type := p_control_rec;
275: l_REV_controller_rec ENG_ECO_PUB.Controller_REV_Rec_Type := p_REV_controller_rec;
276: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
277: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
278: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
279: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
280: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
281: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;

Line 278: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;

274: l_control_rec ENG_ECO_PUB.Control_Rec_Type := p_control_rec;
275: l_REV_controller_rec ENG_ECO_PUB.Controller_REV_Rec_Type := p_REV_controller_rec;
276: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
277: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
278: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
279: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
280: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
281: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
282: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;

Line 279: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;

275: l_REV_controller_rec ENG_ECO_PUB.Controller_REV_Rec_Type := p_REV_controller_rec;
276: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
277: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
278: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;
279: l_unexp_REV_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
280: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
281: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
282: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
283:

Line 284: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;

280: l_unexp_rev_op_rec BOM_RTG_PUB.Rev_Op_Unexposed_Rec_Type;
281: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
282: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
283:
284: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
285: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
286: l_rev_component_tbl ENG_ECO_PUB.Eco_Revision_Tbl_Type;
287: l_ref_designator_tbl ENG_ECO_PUB.Ref_Designator_Tbl_Type;
288: l_sub_component_tbl ENG_ECO_PUB.Sub_Component_Tbl_Type;

Line 285: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;

281: l_unexp_rev_op_res_rec BOM_RTG_PUB.Rev_Op_Res_Unexposed_Rec_Type;
282: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
283:
284: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
285: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
286: l_rev_component_tbl ENG_ECO_PUB.Eco_Revision_Tbl_Type;
287: l_ref_designator_tbl ENG_ECO_PUB.Ref_Designator_Tbl_Type;
288: l_sub_component_tbl ENG_ECO_PUB.Sub_Component_Tbl_Type;
289:

Line 286: l_rev_component_tbl ENG_ECO_PUB.Eco_Revision_Tbl_Type;

282: l_unexp_rev_sub_res_rec BOM_RTG_PUB.Rev_Sub_Res_Unexposed_Rec_Type;
283:
284: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
285: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
286: l_rev_component_tbl ENG_ECO_PUB.Eco_Revision_Tbl_Type;
287: l_ref_designator_tbl ENG_ECO_PUB.Ref_Designator_Tbl_Type;
288: l_sub_component_tbl ENG_ECO_PUB.Sub_Component_Tbl_Type;
289:
290: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;

Line 287: l_ref_designator_tbl ENG_ECO_PUB.Ref_Designator_Tbl_Type;

283:
284: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
285: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
286: l_rev_component_tbl ENG_ECO_PUB.Eco_Revision_Tbl_Type;
287: l_ref_designator_tbl ENG_ECO_PUB.Ref_Designator_Tbl_Type;
288: l_sub_component_tbl ENG_ECO_PUB.Sub_Component_Tbl_Type;
289:
290: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
291: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;

Line 288: l_sub_component_tbl ENG_ECO_PUB.Sub_Component_Tbl_Type;

284: l_eco_revision_tbl ENG_Eco_PUB.Eco_Revision_Tbl_Type;
285: l_revised_item_tbl ENG_Eco_PUB.Revised_Item_Tbl_Type;
286: l_rev_component_tbl ENG_ECO_PUB.Eco_Revision_Tbl_Type;
287: l_ref_designator_tbl ENG_ECO_PUB.Ref_Designator_Tbl_Type;
288: l_sub_component_tbl ENG_ECO_PUB.Sub_Component_Tbl_Type;
289:
290: l_rev_operation_tbl BOM_RTG_PUB.Rev_Operation_Tbl_Type;
291: l_rev_op_resource_tbl BOM_RTG_PUB.Rev_Op_Resource_Tbl_Type;
292: l_rev_sub_resource_tbl BOM_RTG_PUB.Rev_Sub_Resource_Tbl_Type;

Line 354: , p_REV_tbl(1) IN ENG_Eco_PUB.Rit_Rec_Type

350:
351: PROCEDURE Lock_Row
352: ( x_return_status OUT NOCOPY VARCHAR2
353: , x_err_text OUT NOCOPY VARCHAR2
354: , p_REV_tbl(1) IN ENG_Eco_PUB.Rit_Rec_Type
355: , x_REV_tbl(1) OUT NOCOPY ENG_Eco_PUB.Rit_Rec_Type
356: );
357: */
358:

Line 355: , x_REV_tbl(1) OUT NOCOPY ENG_Eco_PUB.Rit_Rec_Type

351: PROCEDURE Lock_Row
352: ( x_return_status OUT NOCOPY VARCHAR2
353: , x_err_text OUT NOCOPY VARCHAR2
354: , p_REV_tbl(1) IN ENG_Eco_PUB.Rit_Rec_Type
355: , x_REV_tbl(1) OUT NOCOPY ENG_Eco_PUB.Rit_Rec_Type
356: );
357: */
358:
359: END REV_Controller;