DBA Data[Home] [Help]

APPS.SBC_CONTROLLER dependencies on SBC_CONTROLLER

Line 1: PACKAGE BODY SBC_Controller AS

1: PACKAGE BODY SBC_Controller AS
2: /* $Header: ENGCSBCB.pls 115.7 2003/07/08 12:40:30 akumar ship $ */
3:
4: -- Procedure Create_Exp_Unexp_Rec
5:

Line 103: ( p_SBC_controller_rec IN Controller_SBC_Rec_Type

99:
100: -- Procedure Initialize_Record
101:
102: PROCEDURE Initialize_Record
103: ( p_SBC_controller_rec IN Controller_SBC_Rec_Type
104: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
105: , x_SBC_controller_rec IN OUT NOCOPY Controller_SBC_Rec_Type
106: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
107: , x_return_status OUT NOCOPY VARCHAR2

Line 105: , x_SBC_controller_rec IN OUT NOCOPY Controller_SBC_Rec_Type

101:
102: PROCEDURE Initialize_Record
103: ( p_SBC_controller_rec IN Controller_SBC_Rec_Type
104: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
105: , x_SBC_controller_rec IN OUT NOCOPY Controller_SBC_Rec_Type
106: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
107: , x_return_status OUT NOCOPY VARCHAR2
108: )
109: IS

Line 111: l_SBC_controller_rec Controller_SBC_Rec_Type := p_SBC_controller_rec;

107: , x_return_status OUT NOCOPY VARCHAR2
108: )
109: IS
110: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
111: l_SBC_controller_rec Controller_SBC_Rec_Type := p_SBC_controller_rec;
112: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
113: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
114: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
115: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;

Line 137: ( p_controller_SBC_rec => l_SBC_controller_rec

133: l_msg_count NUMBER;
134: l_disable_revision NUMBER:=2; --BUG 3034642
135: BEGIN
136: Create_Exp_Unexp_Rec
137: ( p_controller_SBC_rec => l_SBC_controller_rec
138: , x_SBC_tbl => l_sub_component_tbl
139: , x_unexp_SBC_rec => l_unexp_SBC_rec
140: );
141:

Line 174: , x_controller_SBC_rec => l_SBC_controller_rec

170:
171: Create_Controller_Rec
172: ( p_SBC_tbl => l_sub_component_tbl
173: , p_unexp_SBC_rec => l_unexp_SBC_rec
174: , x_controller_SBC_rec => l_SBC_controller_rec
175: );
176:
177: x_SBC_controller_rec := l_SBC_controller_rec;
178: x_return_status := l_return_status;

Line 177: x_SBC_controller_rec := l_SBC_controller_rec;

173: , p_unexp_SBC_rec => l_unexp_SBC_rec
174: , x_controller_SBC_rec => l_SBC_controller_rec
175: );
176:
177: x_SBC_controller_rec := l_SBC_controller_rec;
178: x_return_status := l_return_status;
179: END Initialize_Record;
180:
181: -- Procedure Validate_And_Write

Line 184: ( p_SBC_controller_rec IN Controller_SBC_Rec_Type

180:
181: -- Procedure Validate_And_Write
182:
183: PROCEDURE Validate_And_Write
184: ( p_SBC_controller_rec IN Controller_SBC_Rec_Type
185: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
186: , p_record_status IN VARCHAR2
187: , x_SBC_controller_rec IN OUT NOCOPY Controller_SBC_Rec_Type
188: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 187: , x_SBC_controller_rec IN OUT NOCOPY Controller_SBC_Rec_Type

183: PROCEDURE Validate_And_Write
184: ( p_SBC_controller_rec IN Controller_SBC_Rec_Type
185: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
186: , p_record_status IN VARCHAR2
187: , x_SBC_controller_rec IN OUT NOCOPY Controller_SBC_Rec_Type
188: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
189: , x_return_status OUT NOCOPY VARCHAR2
190: )
191: IS

Line 193: l_SBC_controller_rec Controller_SBC_Rec_Type := p_SBC_controller_rec;

189: , x_return_status OUT NOCOPY VARCHAR2
190: )
191: IS
192: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
193: l_SBC_controller_rec Controller_SBC_Rec_Type := p_SBC_controller_rec;
194: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
195: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
196: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
197: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;

Line 219: ( p_controller_SBC_rec => l_SBC_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_SBC_rec => l_SBC_controller_rec
220: , x_SBC_tbl => l_sub_component_tbl
221: , x_unexp_SBC_rec => l_unexp_SBC_rec
222: );
223:

Line 265: , x_controller_SBC_rec => l_SBC_controller_rec

261:
262: Create_Controller_Rec
263: ( p_SBC_tbl => l_sub_component_tbl
264: , p_unexp_SBC_rec => l_unexp_SBC_rec
265: , x_controller_SBC_rec => l_SBC_controller_rec
266: );
267:
268: x_SBC_controller_rec := l_SBC_controller_rec;
269: x_return_status := l_return_status;

Line 268: x_SBC_controller_rec := l_SBC_controller_rec;

264: , p_unexp_SBC_rec => l_unexp_SBC_rec
265: , x_controller_SBC_rec => l_SBC_controller_rec
266: );
267:
268: x_SBC_controller_rec := l_SBC_controller_rec;
269: x_return_status := l_return_status;
270:
271: END Validate_And_Write;
272:

Line 276: ( p_SBC_controller_rec IN Controller_SBC_Rec_Type

272:
273: -- Procedure Delete_Row
274:
275: PROCEDURE Delete_Row
276: ( p_SBC_controller_rec IN Controller_SBC_Rec_Type
277: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
278: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
279: , x_return_status OUT NOCOPY VARCHAR2
280: )

Line 283: l_SBC_controller_rec Controller_SBC_Rec_Type := p_SBC_controller_rec;

279: , x_return_status OUT NOCOPY VARCHAR2
280: )
281: IS
282: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
283: l_SBC_controller_rec Controller_SBC_Rec_Type := p_SBC_controller_rec;
284: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
285: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
286: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
287: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;

Line 309: ( p_controller_SBC_rec => l_SBC_controller_rec

305: l_msg_count NUMBER;
306: l_disable_revision NUMBER:=2; --BUG 3034642
307: BEGIN
308: Create_Exp_Unexp_Rec
309: ( p_controller_SBC_rec => l_SBC_controller_rec
310: , x_SBC_tbl => l_sub_component_tbl
311: , x_unexp_SBC_rec => l_unexp_SBC_rec
312: );
313:

Line 346: , x_controller_SBC_rec => l_SBC_controller_rec

342:
343: Create_Controller_Rec
344: ( p_SBC_tbl => l_sub_component_tbl
345: , p_unexp_SBC_rec => l_unexp_SBC_rec
346: , x_controller_SBC_rec => l_SBC_controller_rec
347: );
348:
349: x_return_status := l_return_status;
350: END Delete_Row;

Line 355: ( p_SBC_controller_rec IN Controller_SBC_Rec_Type

351:
352: --Procedure Change_Attibute
353:
354: PROCEDURE Change_Attribute
355: ( p_SBC_controller_rec IN Controller_SBC_Rec_Type
356: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
357: , p_record_status IN VARCHAR2
358: , x_SBC_controller_rec IN OUT NOCOPY Controller_SBC_Rec_Type
359: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 358: , x_SBC_controller_rec IN OUT NOCOPY Controller_SBC_Rec_Type

354: PROCEDURE Change_Attribute
355: ( p_SBC_controller_rec IN Controller_SBC_Rec_Type
356: , p_control_rec IN BOM_BO_PUB.Control_Rec_Type
357: , p_record_status IN VARCHAR2
358: , x_SBC_controller_rec IN OUT NOCOPY Controller_SBC_Rec_Type
359: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
360: , x_return_status OUT NOCOPY VARCHAR2
361: )
362: IS

Line 364: l_SBC_controller_rec Controller_SBC_Rec_Type := p_SBC_controller_rec;

360: , x_return_status OUT NOCOPY VARCHAR2
361: )
362: IS
363: l_control_rec BOM_BO_PUB.Control_Rec_Type := p_control_rec;
364: l_SBC_controller_rec Controller_SBC_Rec_Type := p_SBC_controller_rec;
365: l_ECO_rec ENG_ECO_PUB.ECO_Rec_Type;
366: l_unexp_eco_rec ENG_ECO_PUB.ECO_Unexposed_Rec_Type;
367: l_unexp_eco_rev_rec ENG_ECO_PUB.Eco_Rev_Unexposed_Rec_Type;
368: l_unexp_rev_item_rec ENG_ECO_PUB.Rev_Item_Unexposed_Rec_Type;

Line 390: ( p_controller_SBC_rec => l_SBC_controller_rec

386: l_msg_count NUMBER;
387: l_disable_revision NUMBER:=2; --BUG 3034642
388: BEGIN
389: Create_Exp_Unexp_Rec
390: ( p_controller_SBC_rec => l_SBC_controller_rec
391: , x_SBC_tbl => l_sub_component_tbl
392: , x_unexp_SBC_rec => l_unexp_SBC_rec
393: );
394:

Line 436: , x_controller_SBC_rec => l_SBC_controller_rec

432:
433: Create_Controller_Rec
434: ( p_SBC_tbl => l_sub_component_tbl
435: , p_unexp_SBC_rec => l_unexp_SBC_rec
436: , x_controller_SBC_rec => l_SBC_controller_rec
437: );
438:
439: x_SBC_controller_rec := l_SBC_controller_rec;
440: x_return_status := l_return_status;

Line 439: x_SBC_controller_rec := l_SBC_controller_rec;

435: , p_unexp_SBC_rec => l_unexp_SBC_rec
436: , x_controller_SBC_rec => l_SBC_controller_rec
437: );
438:
439: x_SBC_controller_rec := l_SBC_controller_rec;
440: x_return_status := l_return_status;
441: END Change_Attribute;
442:
443: /*PROCEDURE Lock_Row

Line 451: END SBC_Controller;

447: , x_SBC_tbl(1) OUT NOCOPY ENG_Eco_PUB.Rit_Rec_Type
448: );
449: */
450:
451: END SBC_Controller;