APPS.BOM_DEFAULT_OP_RES dependencies on BOM_RTG_PUB

Line 69: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

65:
66:
67: -- Get Flex Operation Resource
68: PROCEDURE Get_Flex_Op_Res
69: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
70: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
71: )
72: IS
73: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

Line 70: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

66:
67: -- Get Flex Operation Resource
68: PROCEDURE Get_Flex_Op_Res
69: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
70: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
71: )
72: IS
73: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
74: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

Line 73: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

69: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
70: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
71: )
72: IS
73: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
74: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
75:
76: BEGIN
77: -- Initialize operation exp and unexp record

Line 74: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

70: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
71: )
72: IS
73: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
74: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
75:
76: BEGIN
77: -- Initialize operation exp and unexp record
78: l_rev_op_resource_rec := p_rev_op_resource_rec ;

Line 375: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type

371: * This procedure will default values in all the operation
372: * resource fields that the user has left unfilled.
373: **********************************************************************/
374: PROCEDURE Attribute_Defaulting
375: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
376: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
377: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
378: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
379: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 376: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

372: * resource fields that the user has left unfilled.
373: **********************************************************************/
374: PROCEDURE Attribute_Defaulting
375: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
376: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
377: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
378: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
379: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
380: , x_return_status IN OUT NOCOPY VARCHAR2

Line 377: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type

373: **********************************************************************/
374: PROCEDURE Attribute_Defaulting
375: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
376: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
377: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
378: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
379: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
380: , x_return_status IN OUT NOCOPY VARCHAR2
381: )

Line 378: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

374: PROCEDURE Attribute_Defaulting
375: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
376: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
377: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
378: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
379: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
380: , x_return_status IN OUT NOCOPY VARCHAR2
381: )
382: IS

Line 383: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

379: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
380: , x_return_status IN OUT NOCOPY VARCHAR2
381: )
382: IS
383: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
384: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
385:
386: BEGIN
387:

Line 384: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

380: , x_return_status IN OUT NOCOPY VARCHAR2
381: )
382: IS
383: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
384: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
385:
386: BEGIN
387:
388: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 391: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes

387:
388: x_return_status := FND_API.G_RET_STS_SUCCESS;
389:
390: -- Convert Routing Op Resource to ECO Op Resource
391: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes
392: ( p_rtg_op_resource_rec => p_op_resource_rec
393: , p_rtg_op_res_unexp_rec => p_op_res_unexp_rec
394: , x_rev_op_resource_rec => l_rev_op_resource_rec
395: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec

Line 405: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec

401: --
402: BOM_Default_Op_Res.Attribute_Defaulting
403: ( p_rev_op_resource_rec => l_rev_op_resource_rec
404: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
405: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec
406: , x_rev_op_resource_rec => l_rev_op_resource_rec
407: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
408: , x_return_status => x_return_status
409: , x_mesg_token_tbl => x_mesg_token_tbl

Line 414: Bom_Rtg_Pub.Convert_EcoRes_To_RtgRes

410: ) ;
411:
412:
413: -- Convert the Common record to Routing Record
414: Bom_Rtg_Pub.Convert_EcoRes_To_RtgRes
415: ( p_rev_op_resource_rec => l_rev_op_resource_rec
416: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
417: , x_rtg_op_resource_rec => x_op_resource_rec
418: , x_rtg_op_res_unexp_rec => x_op_res_unexp_rec

Line 437: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

433: * appropriate values. Defualting will happen for
434: * exposed as well as unexposed columns.
435: *********************************************************************/
436: PROCEDURE Attribute_Defaulting
437: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
438: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
439: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
440: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
441: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

Line 438: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

434: * exposed as well as unexposed columns.
435: *********************************************************************/
436: PROCEDURE Attribute_Defaulting
437: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
438: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
439: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
440: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
441: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
442: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 439: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type

435: *********************************************************************/
436: PROCEDURE Attribute_Defaulting
437: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
438: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
439: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
440: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
441: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
442: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
443: , x_return_status IN OUT NOCOPY VARCHAR2

Line 440: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

436: PROCEDURE Attribute_Defaulting
437: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
438: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
439: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
440: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
441: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
442: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
443: , x_return_status IN OUT NOCOPY VARCHAR2
444: )

Line 441: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

437: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
438: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
439: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
440: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
441: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
442: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
443: , x_return_status IN OUT NOCOPY VARCHAR2
444: )
445:

Line 448: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

444: )
445:
446: IS
447:
448: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
449: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
450:
451: l_return_status VARCHAR2(1);
452: l_err_text VARCHAR2(2000) ;

Line 449: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

445:
446: IS
447:
448: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
449: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
450:
451: l_return_status VARCHAR2(1);
452: l_err_text VARCHAR2(2000) ;
453: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 591: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type

587: * The procedure will populate the NULL columns from the
588: * record that is queried from the database.
589: ********************************************************************/
590: PROCEDURE Populate_Null_Columns
591: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
592: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
593: , p_old_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
594: , p_old_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
595: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type

Line 592: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

588: * record that is queried from the database.
589: ********************************************************************/
590: PROCEDURE Populate_Null_Columns
591: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
592: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
593: , p_old_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
594: , p_old_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
595: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
596: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

Line 593: , p_old_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type

589: ********************************************************************/
590: PROCEDURE Populate_Null_Columns
591: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
592: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
593: , p_old_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
594: , p_old_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
595: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
596: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
597: )

Line 594: , p_old_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

590: PROCEDURE Populate_Null_Columns
591: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
592: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
593: , p_old_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
594: , p_old_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
595: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
596: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
597: )
598:

Line 595: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type

591: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
592: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
593: , p_old_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
594: , p_old_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
595: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
596: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
597: )
598:
599: IS

Line 596: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

592: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
593: , p_old_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
594: , p_old_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
595: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
596: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
597: )
598:
599: IS
600: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

Line 600: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

596: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
597: )
598:
599: IS
600: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
601: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
602: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
603: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
604:

Line 601: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

597: )
598:
599: IS
600: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
601: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
602: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
603: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
604:
605:

Line 602: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

598:
599: IS
600: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
601: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
602: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
603: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
604:
605:
606: BEGIN

Line 603: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

599: IS
600: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
601: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
602: l_old_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
603: l_old_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
604:
605:
606: BEGIN
607:

Line 609: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes

605:
606: BEGIN
607:
608: -- Convert Routing Op Resource to Revised Op Resource
609: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes
610: ( p_rtg_op_resource_rec => p_op_resource_rec
611: , p_rtg_op_res_unexp_rec => p_op_res_unexp_rec
612: , x_rev_op_resource_rec => l_rev_op_resource_rec
613: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec

Line 617: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes

613: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
614: ) ;
615:
616: -- Also Convert Old Rtg Op Resource to Old Revised Op Resource
617: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes
618: ( p_rtg_op_resource_rec => p_old_op_resource_rec
619: , p_rtg_op_res_unexp_rec => p_old_op_res_unexp_rec
620: , x_rev_op_resource_rec => l_old_rev_op_resource_rec
621: , x_rev_op_res_unexp_rec => l_old_rev_op_res_unexp_rec

Line 643: Bom_Rtg_Pub.Convert_EcoRes_To_RtgRes

639: -- record back in the RTG BO's records
640: --
641:
642: -- Convert the Common record to Routing Record
643: Bom_Rtg_Pub.Convert_EcoRes_To_RtgRes
644: ( p_rev_op_resource_rec => l_rev_op_resource_rec
645: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
646: , x_rtg_op_resource_rec => x_op_resource_rec
647: , x_rtg_op_res_unexp_rec => x_op_res_unexp_rec

Line 670: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

666: * record with values from the database record, for all
667: * columns that the user has left NULL.
668: ********************************************************************/
669: PROCEDURE Populate_Null_Columns
670: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
671: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
672: , p_old_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
673: , p_old_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
674: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

Line 671: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

667: * columns that the user has left NULL.
668: ********************************************************************/
669: PROCEDURE Populate_Null_Columns
670: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
671: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
672: , p_old_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
673: , p_old_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
674: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
675: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

Line 672: , p_old_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

668: ********************************************************************/
669: PROCEDURE Populate_Null_Columns
670: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
671: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
672: , p_old_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
673: , p_old_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
674: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
675: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
676: )

Line 673: , p_old_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

669: PROCEDURE Populate_Null_Columns
670: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
671: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
672: , p_old_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
673: , p_old_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
674: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
675: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
676: )
677: IS

Line 674: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

670: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
671: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
672: , p_old_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
673: , p_old_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
674: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
675: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
676: )
677: IS
678:

Line 675: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

671: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
672: , p_old_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
673: , p_old_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
674: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
675: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
676: )
677: IS
678:
679: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

Line 679: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

675: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
676: )
677: IS
678:
679: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
680: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
681:
682: BEGIN
683: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

Line 680: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

676: )
677: IS
678:
679: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
680: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
681:
682: BEGIN
683: IF BOM_Rtg_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
684: ('Within the Operation Resource Populate null columns...') ;

Line 933: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type

929: * This procedure will entity default values in all the op resource.
930: * fields that the user has left unfilled.
931: **********************************************************************/
932: PROCEDURE Entity_Defaulting
933: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
934: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
935: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
936: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
937: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 934: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

930: * fields that the user has left unfilled.
931: **********************************************************************/
932: PROCEDURE Entity_Defaulting
933: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
934: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
935: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
936: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
937: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
938: , x_return_status IN OUT NOCOPY VARCHAR2

Line 935: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type

931: **********************************************************************/
932: PROCEDURE Entity_Defaulting
933: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
934: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
935: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
936: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
937: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
938: , x_return_status IN OUT NOCOPY VARCHAR2
939: )

Line 936: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type

932: PROCEDURE Entity_Defaulting
933: ( p_op_resource_rec IN Bom_Rtg_Pub.Op_Resource_Rec_Type
934: , p_op_res_unexp_rec IN Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
935: , x_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Resource_Rec_Type
936: , x_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Res_Unexposed_Rec_Type
937: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
938: , x_return_status IN OUT NOCOPY VARCHAR2
939: )
940: IS

Line 941: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

937: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
938: , x_return_status IN OUT NOCOPY VARCHAR2
939: )
940: IS
941: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
942: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
943:
944: l_return_status VARCHAR2(1);
945: l_err_text VARCHAR2(2000) ;

Line 942: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

938: , x_return_status IN OUT NOCOPY VARCHAR2
939: )
940: IS
941: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
942: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
943:
944: l_return_status VARCHAR2(1);
945: l_err_text VARCHAR2(2000) ;
946: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 961: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes

957: -- Entity Defaulting procedure.
958: --
959:
960: -- Convert Routing Op Resource to ECO Op Resource
961: Bom_Rtg_Pub.Convert_RtgRes_To_EcoRes
962: ( p_rtg_op_resource_rec => p_op_resource_rec
963: , p_rtg_op_res_unexp_rec => p_op_res_unexp_rec
964: , x_rev_op_resource_rec => l_rev_op_resource_rec
965: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec

Line 975: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec

971: --
972: BOM_Default_Op_Res.Entity_Defaulting
973: ( p_rev_op_resource_rec => l_rev_op_resource_rec
974: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
975: , p_control_Rec => Bom_Rtg_Pub.G_Default_Control_Rec
976: , x_rev_op_resource_rec => l_rev_op_resource_rec
977: , x_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
978: , x_return_status => x_return_status
979: , x_mesg_token_tbl => x_mesg_token_tbl

Line 983: Bom_Rtg_Pub.Convert_EcoRes_To_RtgRes

979: , x_mesg_token_tbl => x_mesg_token_tbl
980: ) ;
981:
982: -- Convert the ECO record to Routing Record
983: Bom_Rtg_Pub.Convert_EcoRes_To_RtgRes
984: ( p_rev_op_resource_rec => l_rev_op_resource_rec
985: , p_rev_op_res_unexp_rec => l_rev_op_res_unexp_rec
986: , x_rtg_op_resource_rec => x_op_resource_rec
987: , x_rtg_op_res_unexp_rec => x_op_res_unexp_rec

Line 1006: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

1002: * appropriate values. Defualting will happen for
1003: * exposed as well as unexposed columns.
1004: **********************************************************************/
1005: PROCEDURE Entity_Defaulting
1006: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
1007: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
1008: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
1009: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
1010: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

Line 1007: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

1003: * exposed as well as unexposed columns.
1004: **********************************************************************/
1005: PROCEDURE Entity_Defaulting
1006: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
1007: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
1008: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
1009: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
1010: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
1011: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1008: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type

1004: **********************************************************************/
1005: PROCEDURE Entity_Defaulting
1006: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
1007: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
1008: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
1009: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
1010: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
1011: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1012: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1009: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type

1005: PROCEDURE Entity_Defaulting
1006: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
1007: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
1008: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
1009: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
1010: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
1011: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1012: , x_return_status IN OUT NOCOPY VARCHAR2
1013: )

Line 1010: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type

1006: ( p_rev_op_resource_rec IN Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
1007: , p_rev_op_res_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
1008: , p_control_Rec IN Bom_Rtg_Pub.Control_Rec_Type
1009: , x_rev_op_resource_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type
1010: , x_rev_op_res_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type
1011: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1012: , x_return_status IN OUT NOCOPY VARCHAR2
1013: )
1014:

Line 1016: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;

1012: , x_return_status IN OUT NOCOPY VARCHAR2
1013: )
1014:
1015: IS
1016: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1017: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1018:
1019: l_return_status VARCHAR2(1);
1020: l_err_text VARCHAR2(2000) ;

Line 1017: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;

1013: )
1014:
1015: IS
1016: l_rev_op_resource_rec Bom_Rtg_Pub.Rev_Op_Resource_Rec_Type ;
1017: l_rev_op_res_unexp_rec Bom_Rtg_Pub.Rev_Op_Res_Unexposed_Rec_Type ;
1018:
1019: l_return_status VARCHAR2(1);
1020: l_err_text VARCHAR2(2000) ;
1021: l_Token_Tbl Error_Handler.Token_Tbl_Type ;