eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_DEFAULT_SUB_OP_RES dependencies on BOM_RTG_PUB

Line 47: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

43:
44:
45: -- Get Flex Sub Operation Resource
46: PROCEDURE Get_Flex_Sub_Op_Res
47: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
48: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
49: )
50: IS
51: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

Line 48: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

44:
45: -- Get Flex Sub Operation Resource
46: PROCEDURE Get_Flex_Sub_Op_Res
47: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
48: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
49: )
50: IS
51: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
52: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;

Line 51: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

47: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
48: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
49: )
50: IS
51: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
52: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
53:
54: BEGIN
55: -- Initialize operation exp and unexp record

Line 52: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;

48: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
49: )
50: IS
51: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
52: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
53:
54: BEGIN
55: -- Initialize operation exp and unexp record
56: l_rev_sub_resource_rec := p_rev_sub_resource_rec ;

Line 143: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type

139: * This procedure will default values in all the sub operation
140: * resource fields that the user has left unfilled.
141: **********************************************************************/
142: PROCEDURE Attribute_Defaulting
143: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
144: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
145: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
146: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
147: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 144: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

140: * resource fields that the user has left unfilled.
141: **********************************************************************/
142: PROCEDURE Attribute_Defaulting
143: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
144: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
145: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
146: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
147: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
148: , x_return_status IN OUT NOCOPY VARCHAR2

Line 145: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type

141: **********************************************************************/
142: PROCEDURE Attribute_Defaulting
143: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
144: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
145: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
146: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
147: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
148: , x_return_status IN OUT NOCOPY VARCHAR2
149: )

Line 146: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

142: PROCEDURE Attribute_Defaulting
143: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
144: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
145: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
146: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
147: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
148: , x_return_status IN OUT NOCOPY VARCHAR2
149: )
150: IS

Line 151: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

147: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
148: , x_return_status IN OUT NOCOPY VARCHAR2
149: )
150: IS
151: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
152: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
153:
154: BEGIN
155:

Line 152: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;

148: , x_return_status IN OUT NOCOPY VARCHAR2
149: )
150: IS
151: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
152: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
153:
154: BEGIN
155:
156: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 159: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes

155:
156: x_return_status := FND_API.G_RET_STS_SUCCESS;
157:
158: -- Convert Routing Op Resource to ECO Op Resource
159: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes
160: ( p_rtg_sub_resource_rec => p_sub_resource_rec
161: , p_rtg_sub_res_unexp_rec => p_sub_res_unexp_rec
162: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
163: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec

Line 173: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec

169: --
170: BOM_Default_Sub_Op_Res.Attribute_Defaulting
171: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
172: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
173: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec
174: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
175: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
176: , x_return_status => x_return_status
177: , x_mesg_token_tbl => x_mesg_token_tbl

Line 182: Bom_Rtg_Pub.Convert_EcoSubRes_To_RtgSubRes

178: ) ;
179:
180:
181: -- Convert the Common record to Routing Record
182: Bom_Rtg_Pub.Convert_EcoSubRes_To_RtgSubRes
183: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
184: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
185: , x_rtg_sub_resource_rec => x_sub_resource_rec
186: , x_rtg_sub_res_unexp_rec => x_sub_res_unexp_rec

Line 204: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

200: * appropriate values. Defualting will happen for
201: * exposed as well as unexposed columns.
202: *********************************************************************/
203: PROCEDURE Attribute_Defaulting
204: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
205: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
206: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
207: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
208: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

Line 205: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

201: * exposed as well as unexposed columns.
202: *********************************************************************/
203: PROCEDURE Attribute_Defaulting
204: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
205: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
206: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
207: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
208: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
209: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 206: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type

202: *********************************************************************/
203: PROCEDURE Attribute_Defaulting
204: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
205: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
206: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
207: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
208: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
209: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
210: , x_return_status IN OUT NOCOPY VARCHAR2

Line 207: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

203: PROCEDURE Attribute_Defaulting
204: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
205: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
206: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
207: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
208: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
209: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
210: , x_return_status IN OUT NOCOPY VARCHAR2
211: )

Line 208: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

204: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
205: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
206: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
207: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
208: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
209: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
210: , x_return_status IN OUT NOCOPY VARCHAR2
211: )
212:

Line 215: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

211: )
212:
213: IS
214:
215: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
216: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
217:
218: l_return_status VARCHAR2(1);
219: l_err_text VARCHAR2(2000) ;

Line 216: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;

212:
213: IS
214:
215: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
216: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
217:
218: l_return_status VARCHAR2(1);
219: l_err_text VARCHAR2(2000) ;
220: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 361: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type

357: * The procedure will populate the NULL columns from the
358: * record that is queried from the database.
359: ********************************************************************/
360: PROCEDURE Populate_Null_Columns
361: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
362: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
363: , p_old_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
364: , p_old_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
365: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type

Line 362: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

358: * record that is queried from the database.
359: ********************************************************************/
360: PROCEDURE Populate_Null_Columns
361: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
362: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
363: , p_old_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
364: , p_old_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
365: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
366: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

Line 363: , p_old_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type

359: ********************************************************************/
360: PROCEDURE Populate_Null_Columns
361: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
362: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
363: , p_old_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
364: , p_old_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
365: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
366: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
367: )

Line 364: , p_old_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

360: PROCEDURE Populate_Null_Columns
361: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
362: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
363: , p_old_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
364: , p_old_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
365: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
366: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
367: )
368:

Line 365: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type

361: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
362: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
363: , p_old_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
364: , p_old_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
365: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
366: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
367: )
368:
369: IS

Line 366: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

362: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
363: , p_old_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
364: , p_old_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
365: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
366: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
367: )
368:
369: IS
370: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

Line 370: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

366: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
367: )
368:
369: IS
370: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
371: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
372: l_old_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
373: l_old_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
374:

Line 371: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;

367: )
368:
369: IS
370: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
371: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
372: l_old_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
373: l_old_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
374:
375:

Line 372: l_old_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

368:
369: IS
370: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
371: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
372: l_old_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
373: l_old_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
374:
375:
376: BEGIN

Line 373: l_old_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;

369: IS
370: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
371: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
372: l_old_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
373: l_old_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
374:
375:
376: BEGIN
377:

Line 379: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes

375:
376: BEGIN
377:
378: -- Convert Routing Sub Op Resource to Revised Sub Op Resource
379: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes
380: ( p_rtg_sub_resource_rec => p_sub_resource_rec
381: , p_rtg_sub_res_unexp_rec => p_sub_res_unexp_rec
382: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
383: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec

Line 387: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes

383: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
384: ) ;
385:
386: -- Also Convert Old Rtg Sub Op Resource to Old Revised Sub Op Resource
387: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes
388: ( p_rtg_sub_resource_rec => p_old_sub_resource_rec
389: , p_rtg_sub_res_unexp_rec => p_old_sub_res_unexp_rec
390: , x_rev_sub_resource_rec => l_old_rev_sub_resource_rec
391: , x_rev_sub_res_unexp_rec => l_old_rev_sub_res_unexp_rec

Line 413: Bom_Rtg_Pub.Convert_EcoSubRes_To_RtgSubRes

409: -- record back in the RTG BO's records
410: --
411:
412: -- Convert the Common record to Routing Record
413: Bom_Rtg_Pub.Convert_EcoSubRes_To_RtgSubRes
414: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
415: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
416: , x_rtg_sub_resource_rec => x_sub_resource_rec
417: , x_rtg_sub_res_unexp_rec => x_sub_res_unexp_rec

Line 440: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

436: * record with values from the database record, for all
437: * columns that the user has left NULL.
438: ********************************************************************/
439: PROCEDURE Populate_Null_Columns
440: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
441: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
442: , p_old_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
443: , p_old_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
444: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

Line 441: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

437: * columns that the user has left NULL.
438: ********************************************************************/
439: PROCEDURE Populate_Null_Columns
440: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
441: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
442: , p_old_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
443: , p_old_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
444: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
445: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

Line 442: , p_old_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

438: ********************************************************************/
439: PROCEDURE Populate_Null_Columns
440: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
441: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
442: , p_old_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
443: , p_old_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
444: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
445: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
446: )

Line 443: , p_old_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

439: PROCEDURE Populate_Null_Columns
440: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
441: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
442: , p_old_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
443: , p_old_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
444: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
445: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
446: )
447: IS

Line 444: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

440: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
441: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
442: , p_old_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
443: , p_old_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
444: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
445: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
446: )
447: IS
448:

Line 445: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

441: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
442: , p_old_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
443: , p_old_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
444: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
445: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
446: )
447: IS
448:
449: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

Line 449: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

445: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
446: )
447: IS
448:
449: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
450: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
451:
452: BEGIN
453: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

Line 450: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;

446: )
447: IS
448:
449: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
450: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
451:
452: BEGIN
453: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
454: ('Within the Sub Operation Resource Populate null columns...') ;

Line 698: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type

694: * This procedure will entity default values in all the op resource.
695: * fields that the user has left unfilled.
696: **********************************************************************/
697: PROCEDURE Entity_Defaulting
698: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
699: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
700: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
701: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
702: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 699: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

695: * fields that the user has left unfilled.
696: **********************************************************************/
697: PROCEDURE Entity_Defaulting
698: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
699: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
700: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
701: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
702: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
703: , x_return_status IN OUT NOCOPY VARCHAR2

Line 700: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type

696: **********************************************************************/
697: PROCEDURE Entity_Defaulting
698: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
699: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
700: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
701: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
702: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
703: , x_return_status IN OUT NOCOPY VARCHAR2
704: )

Line 701: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type

697: PROCEDURE Entity_Defaulting
698: ( p_sub_resource_rec IN Bom_Rtg_Pub.Sub_Resource_Rec_Type
699: , p_sub_res_unexp_rec IN Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
700: , x_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Resource_Rec_Type
701: , x_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Sub_Res_Unexposed_Rec_Type
702: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
703: , x_return_status IN OUT NOCOPY VARCHAR2
704: )
705: IS

Line 706: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

702: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
703: , x_return_status IN OUT NOCOPY VARCHAR2
704: )
705: IS
706: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
707: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
708:
709: l_err_text VARCHAR2(2000) ;
710:

Line 707: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;

703: , x_return_status IN OUT NOCOPY VARCHAR2
704: )
705: IS
706: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
707: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
708:
709: l_err_text VARCHAR2(2000) ;
710:
711: BEGIN

Line 724: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes

720: -- Entity Defaulting procedure.
721: --
722:
723: -- Convert Routing Op Resource to ECO Op Resource
724: Bom_Rtg_Pub.Convert_RtgSubRes_To_EcoSubRes
725: ( p_rtg_sub_resource_rec => p_sub_resource_rec
726: , p_rtg_sub_res_unexp_rec => p_sub_res_unexp_rec
727: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
728: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec

Line 738: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec

734: --
735: BOM_Default_Sub_Op_Res.Entity_Defaulting
736: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
737: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
738: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec
739: , x_rev_sub_resource_rec => l_rev_sub_resource_rec
740: , x_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
741: , x_return_status => x_return_status
742: , x_mesg_token_tbl => x_mesg_token_tbl

Line 746: Bom_Rtg_Pub.Convert_EcoSubRes_To_RtgSubRes

742: , x_mesg_token_tbl => x_mesg_token_tbl
743: ) ;
744:
745: -- Convert the ECO record to Routing Record
746: Bom_Rtg_Pub.Convert_EcoSubRes_To_RtgSubRes
747: ( p_rev_sub_resource_rec => l_rev_sub_resource_rec
748: , p_rev_sub_res_unexp_rec => l_rev_sub_res_unexp_rec
749: , x_rtg_sub_resource_rec => x_sub_resource_rec
750: , x_rtg_sub_res_unexp_rec => x_sub_res_unexp_rec

Line 769: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

765: * appropriate values. Defualting will happen for
766: * exposed as well as unexposed columns.
767: **********************************************************************/
768: PROCEDURE Entity_Defaulting
769: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
770: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
771: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
772: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
773: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

Line 770: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

766: * exposed as well as unexposed columns.
767: **********************************************************************/
768: PROCEDURE Entity_Defaulting
769: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
770: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
771: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
772: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
773: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
774: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 771: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type

767: **********************************************************************/
768: PROCEDURE Entity_Defaulting
769: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
770: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
771: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
772: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
773: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
774: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
775: , x_return_status IN OUT NOCOPY VARCHAR2

Line 772: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type

768: PROCEDURE Entity_Defaulting
769: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
770: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
771: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
772: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
773: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
774: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
775: , x_return_status IN OUT NOCOPY VARCHAR2
776: )

Line 773: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type

769: ( p_rev_sub_resource_rec IN Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
770: , p_rev_sub_res_unexp_rec IN Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
771: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
772: , x_rev_sub_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type
773: , x_rev_sub_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type
774: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
775: , x_return_status IN OUT NOCOPY VARCHAR2
776: )
777:

Line 779: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;

775: , x_return_status IN OUT NOCOPY VARCHAR2
776: )
777:
778: IS
779: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
780: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
781:
782: l_return_status VARCHAR2(1);
783: l_err_text VARCHAR2(2000) ;

Line 780: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;

776: )
777:
778: IS
779: l_rev_sub_resource_rec Bom_Rtg_Pub.Rev_Sub_Resource_Rec_Type ;
780: l_rev_sub_res_unexp_rec Bom_Rtg_Pub.Rev_Sub_Res_Unexposed_Rec_Type ;
781:
782: l_return_status VARCHAR2(1);
783: l_err_text VARCHAR2(2000) ;
784: l_Token_Tbl Error_Handler.Token_Tbl_Type ;