DBA Data[Home] [Help]

APPS.REV_CONTROLLER dependencies on REV_CONTROLLER

Line 1: PACKAGE BODY REV_Controller AS

1: PACKAGE BODY REV_Controller AS
2: /* $Header: ENGCREVB.pls 115.8 2003/07/08 12:25:37 akumar ship $ */
3:
4: -- Procedure Create_Exp_Unexp_Rec
5:

Line 7: ( p_controller_REV_rec IN REV_Controller.Controller_REV_Rec_Type

3:
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

Line 48: , x_controller_REV_rec OUT NOCOPY REV_Controller.Controller_REV_Rec_Type

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
52:

Line 83: ( p_REV_controller_rec IN REV_Controller.Controller_REV_Rec_Type

79:
80: -- Procedure Validate_And_Write
81:
82: PROCEDURE Validate_And_Write
83: ( p_REV_controller_rec IN REV_Controller.Controller_REV_Rec_Type
84: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
85: , p_record_status IN VARCHAR2
86: , x_REV_controller_rec IN OUT NOCOPY REV_Controller.Controller_REV_Rec_Type
87: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 86: , x_REV_controller_rec IN OUT NOCOPY REV_Controller.Controller_REV_Rec_Type

82: PROCEDURE Validate_And_Write
83: ( p_REV_controller_rec IN REV_Controller.Controller_REV_Rec_Type
84: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
85: , p_record_status IN VARCHAR2
86: , x_REV_controller_rec IN OUT NOCOPY REV_Controller.Controller_REV_Rec_Type
87: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
88: , x_return_status OUT NOCOPY VARCHAR2
89: )
90: IS

Line 92: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;

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

Line 122: ( p_controller_REV_rec => l_REV_controller_rec

118: l_msg_count NUMBER;
119: l_disable_revision NUMBER:=2; --BUG 3034642
120: BEGIN
121: Create_Exp_Unexp_Rec
122: ( p_controller_REV_rec => l_REV_controller_rec
123: , x_REV_tbl => l_eco_revision_tbl
124: , x_unexp_REV_rec => l_unexp_REV_rec
125: );
126:

Line 171: , x_controller_REV_rec => l_REV_controller_rec

167:
168: Create_Controller_Rec
169: ( p_REV_tbl => l_eco_revision_tbl
170: , p_unexp_REV_rec => l_unexp_REV_rec
171: , x_controller_REV_rec => l_REV_controller_rec
172: );
173:
174: x_REV_controller_rec := l_REV_controller_rec;
175: x_return_status := l_return_status;

Line 174: x_REV_controller_rec := l_REV_controller_rec;

170: , p_unexp_REV_rec => l_unexp_REV_rec
171: , x_controller_REV_rec => l_REV_controller_rec
172: );
173:
174: x_REV_controller_rec := l_REV_controller_rec;
175: x_return_status := l_return_status;
176:
177: END Validate_And_Write;
178:

Line 182: ( p_REV_controller_rec IN REV_Controller.Controller_REV_Rec_Type

178:
179: -- Procedure Delete_Row
180:
181: PROCEDURE Delete_Row
182: ( p_REV_controller_rec IN REV_Controller.Controller_REV_Rec_Type
183: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
184: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
185: , x_return_status OUT NOCOPY VARCHAR2
186: )

Line 189: l_REV_controller_rec REV_Controller.Controller_REV_Rec_Type := p_REV_controller_rec;

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

Line 219: ( p_controller_REV_rec => l_REV_controller_rec

215: l_msg_count NUMBER;
216: l_disable_revision NUMBER:=2; --BUG 3034642
217: BEGIN
218: Create_Exp_Unexp_Rec
219: ( p_controller_REV_rec => l_REV_controller_rec
220: , x_REV_tbl => l_eco_revision_tbl
221: , x_unexp_REV_rec => l_unexp_REV_rec
222: );
223:

Line 256: , x_controller_REV_rec => l_REV_controller_rec

252:
253: Create_Controller_Rec
254: ( p_REV_tbl => l_eco_revision_tbl
255: , p_unexp_REV_rec => l_unexp_REV_rec
256: , x_controller_REV_rec => l_REV_controller_rec
257: );
258:
259: x_return_status := l_return_status;
260: END Delete_Row;

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 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 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 301: ( p_controller_REV_rec => l_REV_controller_rec

297: l_msg_count NUMBER;
298: l_disable_revision NUMBER:=2; --BUG 3034642
299: BEGIN
300: Create_Exp_Unexp_Rec
301: ( p_controller_REV_rec => l_REV_controller_rec
302: , x_REV_tbl => l_rev_component_tbl
303: , x_unexp_REV_rec => l_unexp_REV_rec
304: );
305:

Line 344: , x_controller_REV_rec => l_REV_controller_rec

340:
341: Create_Controller_Rec
342: ( p_REV_tbl => l_rev_component_tbl
343: , p_unexp_REV_rec => l_unexp_REV_rec
344: , x_controller_REV_rec => l_REV_controller_rec
345: );
346:
347: x_REV_controller_rec := l_REV_controller_rec;
348: x_return_status := l_return_status;

Line 347: x_REV_controller_rec := l_REV_controller_rec;

343: , p_unexp_REV_rec => l_unexp_REV_rec
344: , x_controller_REV_rec => l_REV_controller_rec
345: );
346:
347: x_REV_controller_rec := l_REV_controller_rec;
348: x_return_status := l_return_status;
349: END Change_Attribute;
350:
351: PROCEDURE Lock_Row

Line 359: END REV_Controller;

355: , x_REV_tbl(1) OUT NOCOPY ENG_Eco_PUB.Rit_Rec_Type
356: );
357: */
358:
359: END REV_Controller;