DBA Data[Home] [Help]

APPS.ECO_CONTROLLER dependencies on ECO_CONTROLLER

Line 1: PACKAGE BODY ECO_Controller AS

1: PACKAGE BODY ECO_Controller AS
2: /* $Header: ENGCECOB.pls 115.11 2003/10/30 11:21:31 akumar ship $ */
3:
4: -- Procedure Create_Exp_Unexp_Rec
5:

Line 142: ( p_ECO_controller_rec IN Controller_Eco_Rec_Type

138:
139: -- Procedure Initialize_Record
140:
141: PROCEDURE Initialize_Record
142: ( p_ECO_controller_rec IN Controller_Eco_Rec_Type
143: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
144: , x_ECO_controller_rec IN OUT NOCOPY Controller_Eco_Rec_Type
145: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
146: , x_return_status OUT NOCOPY VARCHAR2

Line 144: , x_ECO_controller_rec IN OUT NOCOPY Controller_Eco_Rec_Type

140:
141: PROCEDURE Initialize_Record
142: ( p_ECO_controller_rec IN Controller_Eco_Rec_Type
143: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
144: , x_ECO_controller_rec IN OUT NOCOPY Controller_Eco_Rec_Type
145: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
146: , x_return_status OUT NOCOPY VARCHAR2
147: )
148: IS

Line 150: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;

146: , x_return_status OUT NOCOPY VARCHAR2
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;

Line 177: ( p_controller_ECO_rec => l_ECO_controller_rec

173: l_msg_count NUMBER;
174: l_disable_revision NUMBER:=2; --BUG 3034642
175: BEGIN
176: Create_Exp_Unexp_Rec
177: ( p_controller_ECO_rec => l_ECO_controller_rec
178: , x_ECO_rec => l_ECO_rec
179: , x_unexp_ECO_rec => l_unexp_ECO_rec
180: );
181:

Line 214: , x_controller_ECO_rec => l_eco_controller_rec

210:
211: Create_Controller_Rec
212: ( p_ECO_rec => l1_eco_rec
213: , p_unexp_eco_rec => l_unexp_eco_rec
214: , x_controller_ECO_rec => l_eco_controller_rec
215: );
216:
217: x_eco_controller_rec := l_eco_controller_rec;
218: x_return_status := l_return_status;

Line 217: x_eco_controller_rec := l_eco_controller_rec;

213: , p_unexp_eco_rec => l_unexp_eco_rec
214: , x_controller_ECO_rec => l_eco_controller_rec
215: );
216:
217: x_eco_controller_rec := l_eco_controller_rec;
218: x_return_status := l_return_status;
219: END Initialize_Record;
220:
221: -- Procedure Validate_And_Write

Line 224: ( p_ECO_controller_rec IN Controller_Eco_Rec_Type

220:
221: -- Procedure Validate_And_Write
222:
223: PROCEDURE Validate_And_Write
224: ( p_ECO_controller_rec IN Controller_Eco_Rec_Type
225: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
226: , p_record_status IN VARCHAR2
227: , x_ECO_controller_rec IN OUT NOCOPY Controller_Eco_Rec_Type
228: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 227: , x_ECO_controller_rec IN OUT NOCOPY Controller_Eco_Rec_Type

223: PROCEDURE Validate_And_Write
224: ( p_ECO_controller_rec IN Controller_Eco_Rec_Type
225: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
226: , p_record_status IN VARCHAR2
227: , x_ECO_controller_rec IN OUT NOCOPY Controller_Eco_Rec_Type
228: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
229: , x_return_status OUT NOCOPY VARCHAR2
230: )
231: IS

Line 233: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;

229: , x_return_status OUT NOCOPY VARCHAR2
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;

Line 260: ( p_controller_ECO_rec => l_ECO_controller_rec

256: l_disable_revision NUMBER:=2; --BUG 3034642
257: BEGIN
258:
259: Create_Exp_Unexp_Rec
260: ( p_controller_ECO_rec => l_ECO_controller_rec
261: , x_ECO_rec => l_ECO_rec
262: , x_unexp_ECO_rec => l_unexp_ECO_rec
263: );
264:

Line 307: , x_controller_ECO_rec => l_eco_controller_rec

303:
304: Create_Controller_Rec
305: ( p_ECO_rec => l_eco_rec
306: , p_unexp_eco_rec => l_unexp_eco_rec
307: , x_controller_ECO_rec => l_eco_controller_rec
308: );
309:
310: x_eco_controller_rec := l_eco_controller_rec;
311: x_return_status := l_return_status;

Line 310: x_eco_controller_rec := l_eco_controller_rec;

306: , p_unexp_eco_rec => l_unexp_eco_rec
307: , x_controller_ECO_rec => l_eco_controller_rec
308: );
309:
310: x_eco_controller_rec := l_eco_controller_rec;
311: x_return_status := l_return_status;
312: END Validate_And_Write;
313:
314: -- Procedure Delete_Row

Line 317: ( p_ECO_controller_rec IN Controller_Eco_Rec_Type

313:
314: -- Procedure Delete_Row
315:
316: PROCEDURE Delete_Row
317: ( p_ECO_controller_rec IN Controller_Eco_Rec_Type
318: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
319: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
320: , x_return_status OUT NOCOPY VARCHAR2
321: )

Line 324: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;

320: , x_return_status OUT NOCOPY VARCHAR2
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;

Line 350: ( p_controller_ECO_rec => l_ECO_controller_rec

346: l_msg_count NUMBER;
347: l_disable_revision NUMBER:=2; --BUG 3034642
348: BEGIN
349: Create_Exp_Unexp_Rec
350: ( p_controller_ECO_rec => l_ECO_controller_rec
351: , x_ECO_rec => l_ECO_rec
352: , x_unexp_ECO_rec => l_unexp_ECO_rec
353: );
354:

Line 394: ( p_ECO_controller_rec IN Controller_Eco_Rec_Type

390:
391: --Procedure Change_Attibute
392:
393: PROCEDURE Change_Attribute
394: ( p_ECO_controller_rec IN Controller_Eco_Rec_Type
395: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
396: , p_record_status IN VARCHAR2
397: , x_ECO_controller_rec IN OUT NOCOPY Controller_Eco_Rec_Type
398: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 397: , x_ECO_controller_rec IN OUT NOCOPY Controller_Eco_Rec_Type

393: PROCEDURE Change_Attribute
394: ( p_ECO_controller_rec IN Controller_Eco_Rec_Type
395: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
396: , p_record_status IN VARCHAR2
397: , x_ECO_controller_rec IN OUT NOCOPY Controller_Eco_Rec_Type
398: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
399: , x_return_status OUT NOCOPY VARCHAR2
400: )
401: IS

Line 403: l_ECO_controller_rec Controller_Eco_Rec_Type := p_ECO_controller_rec;

399: , x_return_status OUT NOCOPY VARCHAR2
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;

Line 431: ( p_controller_ECO_rec => l_ECO_controller_rec

427: l_disable_revision NUMBER:=2; --BUG 3034642
428: BEGIN
429:
430: Create_Exp_Unexp_Rec
431: ( p_controller_ECO_rec => l_ECO_controller_rec
432: , x_ECO_rec => l_ECO_rec
433: , x_unexp_ECO_rec => l_unexp_ECO_rec
434: );
435:

Line 474: , x_controller_ECO_rec => l_eco_controller_rec

470: );
471: Create_Controller_Rec
472: ( p_ECO_rec => l_eco_rec
473: , p_unexp_eco_rec => l_unexp_eco_rec
474: , x_controller_ECO_rec => l_eco_controller_rec
475: );
476: x_eco_controller_rec := l_eco_controller_rec;
477: x_return_status := l_return_status;
478:

Line 476: x_eco_controller_rec := l_eco_controller_rec;

472: ( p_ECO_rec => l_eco_rec
473: , p_unexp_eco_rec => l_unexp_eco_rec
474: , x_controller_ECO_rec => l_eco_controller_rec
475: );
476: x_eco_controller_rec := l_eco_controller_rec;
477: x_return_status := l_return_status;
478:
479: /*
480: EXCEPTION

Line 524: END ECO_Controller;

520: , x_ECO_rec OUT NOCOPY ENG_Eco_PUB.Eco_Rec_Type
521: );
522: */
523:
524: END ECO_Controller;