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_VALIDATE_OP_SEQ dependencies on BOM_RTG_PUB

Line 350: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type

346: * After calling Check_Existence, convert old Common
347: * operation record back to Routing Operation Record
348: *********************************************************************/
349: PROCEDURE Check_Existence
350: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
351: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
352: , x_old_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
353: , x_old_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
354: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 351: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type

347: * operation record back to Routing Operation Record
348: *********************************************************************/
349: PROCEDURE Check_Existence
350: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
351: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
352: , x_old_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
353: , x_old_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
354: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
355: , x_return_status IN OUT NOCOPY VARCHAR2

Line 352: , x_old_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type

348: *********************************************************************/
349: PROCEDURE Check_Existence
350: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
351: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
352: , x_old_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
353: , x_old_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
354: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
355: , x_return_status IN OUT NOCOPY VARCHAR2
356: )

Line 353: , x_old_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type

349: PROCEDURE Check_Existence
350: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
351: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
352: , x_old_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
353: , x_old_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
354: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
355: , x_return_status IN OUT NOCOPY VARCHAR2
356: )
357: IS

Line 358: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

354: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
355: , x_return_status IN OUT NOCOPY VARCHAR2
356: )
357: IS
358: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
359: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
360: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
361: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
362:

Line 359: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

355: , x_return_status IN OUT NOCOPY VARCHAR2
356: )
357: IS
358: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
359: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
360: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
361: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
362:
363: BEGIN

Line 360: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

356: )
357: IS
358: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
359: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
360: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
361: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
362:
363: BEGIN
364: -- Convert Routing Operation to Common Operation

Line 361: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

357: IS
358: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
359: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
360: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
361: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
362:
363: BEGIN
364: -- Convert Routing Operation to Common Operation
365: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

Line 365: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

361: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
362:
363: BEGIN
364: -- Convert Routing Operation to Common Operation
365: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp
366: ( p_rtg_operation_rec => p_operation_rec
367: , p_rtg_op_unexp_rec => p_op_unexp_rec
368: , x_com_operation_rec => l_com_operation_rec
369: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 383: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp

379: , x_mesg_token_tbl => x_mesg_token_tbl
380: ) ;
381:
382: -- Convert old Common Opeartion Record back to Routing Operation
383: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp
384: ( p_com_operation_rec => l_old_com_operation_rec
385: , p_com_op_unexp_rec => l_old_com_op_unexp_rec
386: , x_rtg_operation_rec => x_old_operation_rec
387: , x_rtg_op_unexp_rec => x_old_op_unexp_rec

Line 407: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type

403: * After calling Check_Existence, convert old Common
404: * operation record back to Revised Operation Record
405: *********************************************************************/
406: PROCEDURE Check_Existence
407: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
408: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
409: , x_old_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
410: , x_old_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
411: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 408: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

404: * operation record back to Revised Operation Record
405: *********************************************************************/
406: PROCEDURE Check_Existence
407: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
408: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
409: , x_old_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
410: , x_old_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
411: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
412: , x_return_status IN OUT NOCOPY VARCHAR2

Line 409: , x_old_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type

405: *********************************************************************/
406: PROCEDURE Check_Existence
407: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
408: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
409: , x_old_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
410: , x_old_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
411: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
412: , x_return_status IN OUT NOCOPY VARCHAR2
413: )

Line 410: , x_old_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

406: PROCEDURE Check_Existence
407: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
408: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
409: , x_old_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
410: , x_old_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
411: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
412: , x_return_status IN OUT NOCOPY VARCHAR2
413: )
414: IS

Line 415: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

411: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
412: , x_return_status IN OUT NOCOPY VARCHAR2
413: )
414: IS
415: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
416: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
417: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
418: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
419:

Line 416: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

412: , x_return_status IN OUT NOCOPY VARCHAR2
413: )
414: IS
415: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
416: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
417: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
418: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
419:
420: BEGIN

Line 417: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

413: )
414: IS
415: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
416: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
417: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
418: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
419:
420: BEGIN
421: -- Convert Routing Operation to Common Operation

Line 418: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

414: IS
415: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
416: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
417: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
418: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
419:
420: BEGIN
421: -- Convert Routing Operation to Common Operation
422: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

Line 422: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

418: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
419:
420: BEGIN
421: -- Convert Routing Operation to Common Operation
422: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp
423: ( p_rev_operation_rec => p_rev_operation_rec
424: , p_rev_op_unexp_rec => p_rev_op_unexp_rec
425: , x_com_operation_rec => l_com_operation_rec
426: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 440: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp

436: , x_mesg_token_tbl => x_mesg_token_tbl
437: ) ;
438:
439: -- Convert old Common Opeartion Record back to Routing Operation
440: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp
441: ( p_com_operation_rec => l_old_com_operation_rec
442: , p_com_op_unexp_rec => l_old_com_op_unexp_rec
443: , x_rev_operation_rec => x_old_rev_operation_rec
444: , x_rev_op_unexp_rec => x_old_rev_op_unexp_rec

Line 470: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

466: * with a success status.
467: *********************************************************************/
468:
469: PROCEDURE Check_Existence
470: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
471: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
472: , x_old_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
473: , x_old_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
474: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 471: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

467: *********************************************************************/
468:
469: PROCEDURE Check_Existence
470: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
471: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
472: , x_old_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
473: , x_old_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
474: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
475: , x_return_status IN OUT NOCOPY VARCHAR2

Line 472: , x_old_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

468:
469: PROCEDURE Check_Existence
470: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
471: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
472: , x_old_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
473: , x_old_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
474: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
475: , x_return_status IN OUT NOCOPY VARCHAR2
476: )

Line 473: , x_old_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

469: PROCEDURE Check_Existence
470: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
471: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
472: , x_old_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
473: , x_old_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
474: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
475: , x_return_status IN OUT NOCOPY VARCHAR2
476: )
477: IS

Line 704: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type

700: * Call Check_Required for Common Operation.
701: *
702: *********************************************************************/
703: PROCEDURE Check_Required
704: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
705: , x_return_status IN OUT NOCOPY VARCHAR2
706: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
707: )
708:

Line 710: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

706: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
707: )
708:
709: IS
710: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
711: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
712:
713: p_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
714:

Line 711: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

707: )
708:
709: IS
710: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
711: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
712:
713: p_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
714:
715: BEGIN

Line 713: p_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;

709: IS
710: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
711: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
712:
713: p_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
714:
715: BEGIN
716: -- Convert Routing Operation to Common Operation
717: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

Line 717: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

713: p_op_unexp_rec Bom_Rtg_Pub.Op_Unexposed_Rec_Type ;
714:
715: BEGIN
716: -- Convert Routing Operation to Common Operation
717: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp
718: ( p_rtg_operation_rec => p_operation_rec
719: , p_rtg_op_unexp_rec => p_op_unexp_rec
720: , x_com_operation_rec => l_com_operation_rec
721: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 742: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type

738: * Call Check_Required for Common Operation.
739: *
740: *********************************************************************/
741: PROCEDURE Check_Required
742: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
743: , x_return_status IN OUT NOCOPY VARCHAR2
744: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
745: )
746:

Line 748: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

744: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
745: )
746:
747: IS
748: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
749: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
750:
751: p_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
752:

Line 749: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

745: )
746:
747: IS
748: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
749: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
750:
751: p_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
752:
753: BEGIN

Line 751: p_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;

747: IS
748: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
749: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
750:
751: p_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
752:
753: BEGIN
754: -- Convert Revised Operation to Common Operation
755: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

Line 755: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

751: p_rev_op_unexp_rec Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type ;
752:
753: BEGIN
754: -- Convert Revised Operation to Common Operation
755: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp
756: ( p_rev_operation_rec => p_rev_operation_rec
757: , p_rev_op_unexp_rec => p_rev_op_unexp_rec
758: , x_com_operation_rec => l_com_operation_rec
759: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 782: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

778: * trying to perform. If the required columns are not
779: * filled in, then the record would get an error.
780: ********************************************************************/
781: PROCEDURE Check_Required
782: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
783: , x_return_status IN OUT NOCOPY VARCHAR2
784: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
785: )
786: IS

Line 893: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type

889: * of the operation record in their own entirety. No
890: * cross entity validations will be performed.
891: ********************************************************************/
892: PROCEDURE Check_Attributes
893: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
894: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
895: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
896: , x_return_status IN OUT NOCOPY VARCHAR2
897: )

Line 894: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type

890: * cross entity validations will be performed.
891: ********************************************************************/
892: PROCEDURE Check_Attributes
893: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
894: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
895: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
896: , x_return_status IN OUT NOCOPY VARCHAR2
897: )
898: IS

Line 899: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

895: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
896: , x_return_status IN OUT NOCOPY VARCHAR2
897: )
898: IS
899: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
900: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
901:
902: BEGIN
903: -- Convert Routing Operation to Common Operation

Line 900: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

896: , x_return_status IN OUT NOCOPY VARCHAR2
897: )
898: IS
899: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
900: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
901:
902: BEGIN
903: -- Convert Routing Operation to Common Operation
904: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

Line 904: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

900: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
901:
902: BEGIN
903: -- Convert Routing Operation to Common Operation
904: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp
905: ( p_rtg_operation_rec => p_operation_rec
906: , p_rtg_op_unexp_rec => p_op_unexp_rec
907: , x_com_operation_rec => l_com_operation_rec
908: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 935: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type

931: * of the operation record in their own entirety. No
932: * cross entity validations will be performed.
933: ********************************************************************/
934: PROCEDURE Check_Attributes
935: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
936: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_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: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

932: * cross entity validations will be performed.
933: ********************************************************************/
934: PROCEDURE Check_Attributes
935: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
936: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_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_com_operation_rec Bom_Rtg_Pub.Com_Operation_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_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
942: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
943:
944: BEGIN
945: -- Convert Revised Operation to Common Operation

Line 942: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

938: , x_return_status IN OUT NOCOPY VARCHAR2
939: )
940: IS
941: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
942: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
943:
944: BEGIN
945: -- Convert Revised Operation to Common Operation
946: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

Line 946: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

942: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
943:
944: BEGIN
945: -- Convert Revised Operation to Common Operation
946: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp
947: ( p_rev_operation_rec => p_rev_operation_rec
948: , p_rev_op_unexp_rec => p_rev_op_unexp_rec
949: , x_com_operation_rec => l_com_operation_rec
950: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 982: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

978: * before the procedure returns with a Return_Status
979: * of 'E'.
980: *********************************************************************/
981: PROCEDURE Check_Attributes
982: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
983: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
984: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
985: , x_return_status IN OUT NOCOPY VARCHAR2
986: )

Line 983: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

979: * of 'E'.
980: *********************************************************************/
981: PROCEDURE Check_Attributes
982: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
983: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
984: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
985: , x_return_status IN OUT NOCOPY VARCHAR2
986: )
987: IS

Line 1621: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type

1617: * Call Check_Required for Common.
1618: *
1619: *********************************************************************/
1620: PROCEDURE Check_Conditionally_Required
1621: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1622: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1623: , x_return_status IN OUT NOCOPY VARCHAR2
1624: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1625: )

Line 1622: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type

1618: *
1619: *********************************************************************/
1620: PROCEDURE Check_Conditionally_Required
1621: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1622: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1623: , x_return_status IN OUT NOCOPY VARCHAR2
1624: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1625: )
1626:

Line 1628: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1624: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1625: )
1626:
1627: IS
1628: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1629: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1630:
1631: BEGIN
1632: -- Convert Routing Operation to Common Operation

Line 1629: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1625: )
1626:
1627: IS
1628: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1629: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1630:
1631: BEGIN
1632: -- Convert Routing Operation to Common Operation
1633: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

Line 1633: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

1629: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1630:
1631: BEGIN
1632: -- Convert Routing Operation to Common Operation
1633: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp
1634: ( p_rtg_operation_rec => p_operation_rec
1635: , p_rtg_op_unexp_rec => p_op_unexp_rec
1636: , x_com_operation_rec => l_com_operation_rec
1637: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 1660: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type

1656: * Call Check_Required for Common.
1657: *
1658: *********************************************************************/
1659: PROCEDURE Check_Conditionally_Required
1660: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1661: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1662: , x_return_status IN OUT NOCOPY VARCHAR2
1663: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1664: )

Line 1661: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

1657: *
1658: *********************************************************************/
1659: PROCEDURE Check_Conditionally_Required
1660: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1661: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1662: , x_return_status IN OUT NOCOPY VARCHAR2
1663: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1664: )
1665:

Line 1667: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1663: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1664: )
1665:
1666: IS
1667: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1668: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1669:
1670: BEGIN
1671: -- Convert Revised Operation to Common Operation

Line 1668: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1664: )
1665:
1666: IS
1667: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1668: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1669:
1670: BEGIN
1671: -- Convert Revised Operation to Common Operation
1672: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

Line 1672: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

1668: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1669:
1670: BEGIN
1671: -- Convert Revised Operation to Common Operation
1672: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp
1673: ( p_rev_operation_rec => p_rev_operation_rec
1674: , p_rev_op_unexp_rec => p_rev_op_unexp_rec
1675: , x_com_operation_rec => l_com_operation_rec
1676: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 1699: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

1695: * Purpose : Check Conditionally Required Columns
1696: *
1697: ********************************************************************/
1698: PROCEDURE Check_Conditionally_Required
1699: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1700: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1701: , x_return_status IN OUT NOCOPY VARCHAR2
1702: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1703: )

Line 1700: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

1696: *
1697: ********************************************************************/
1698: PROCEDURE Check_Conditionally_Required
1699: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1700: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1701: , x_return_status IN OUT NOCOPY VARCHAR2
1702: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1703: )
1704: IS

Line 1759: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type

1755: * convert Common record back to Routing Operation Record
1756: *
1757: *********************************************************************/
1758: PROCEDURE Check_NonOperated_Attribute
1759: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1760: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1761: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
1762: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1763: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1760: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type

1756: *
1757: *********************************************************************/
1758: PROCEDURE Check_NonOperated_Attribute
1759: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1760: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1761: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
1762: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1763: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1764: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1761: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type

1757: *********************************************************************/
1758: PROCEDURE Check_NonOperated_Attribute
1759: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1760: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1761: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
1762: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1763: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1764: , x_return_status IN OUT NOCOPY VARCHAR2
1765: )

Line 1762: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type

1758: PROCEDURE Check_NonOperated_Attribute
1759: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
1760: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1761: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
1762: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
1763: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1764: , x_return_status IN OUT NOCOPY VARCHAR2
1765: )
1766: IS

Line 1767: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1763: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1764: , x_return_status IN OUT NOCOPY VARCHAR2
1765: )
1766: IS
1767: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1768: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1769:
1770: BEGIN
1771: -- Convert Routing Operation to Common Operation

Line 1768: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1764: , x_return_status IN OUT NOCOPY VARCHAR2
1765: )
1766: IS
1767: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1768: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1769:
1770: BEGIN
1771: -- Convert Routing Operation to Common Operation
1772: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

Line 1772: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

1768: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1769:
1770: BEGIN
1771: -- Convert Routing Operation to Common Operation
1772: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp
1773: ( p_rtg_operation_rec => p_operation_rec
1774: , p_rtg_op_unexp_rec => p_op_unexp_rec
1775: , x_com_operation_rec => l_com_operation_rec
1776: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 1791: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp

1787: , x_mesg_token_tbl => x_mesg_token_tbl
1788: ) ;
1789:
1790: -- Convert old Eco Opeartion Record back to Routing Operation
1791: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp
1792: ( p_com_operation_rec => l_com_operation_rec
1793: , p_com_op_unexp_rec => l_com_op_unexp_rec
1794: , x_rtg_operation_rec => x_operation_rec
1795: , x_rtg_op_unexp_rec => x_op_unexp_rec

Line 1816: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type

1812: * convert Common record back to Revised Operation Record
1813: *
1814: *********************************************************************/
1815: PROCEDURE Check_NonOperated_Attribute
1816: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1817: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1818: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
1819: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1820: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1817: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

1813: *
1814: *********************************************************************/
1815: PROCEDURE Check_NonOperated_Attribute
1816: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1817: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1818: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
1819: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1820: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1821: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1818: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type

1814: *********************************************************************/
1815: PROCEDURE Check_NonOperated_Attribute
1816: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1817: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1818: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
1819: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1820: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1821: , x_return_status IN OUT NOCOPY VARCHAR2
1822: )

Line 1819: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

1815: PROCEDURE Check_NonOperated_Attribute
1816: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
1817: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1818: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
1819: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
1820: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1821: , x_return_status IN OUT NOCOPY VARCHAR2
1822: )
1823: IS

Line 1824: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1820: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1821: , x_return_status IN OUT NOCOPY VARCHAR2
1822: )
1823: IS
1824: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1825: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1826:
1827: BEGIN
1828: -- Convert Revised Operation to Common Operation

Line 1825: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1821: , x_return_status IN OUT NOCOPY VARCHAR2
1822: )
1823: IS
1824: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1825: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1826:
1827: BEGIN
1828: -- Convert Revised Operation to Common Operation
1829: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

Line 1829: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

1825: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1826:
1827: BEGIN
1828: -- Convert Revised Operation to Common Operation
1829: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp
1830: ( p_rev_operation_rec => p_rev_operation_rec
1831: , p_rev_op_unexp_rec => p_rev_op_unexp_rec
1832: , x_com_operation_rec => l_com_operation_rec
1833: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 1847: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp

1843: , x_mesg_token_tbl => x_mesg_token_tbl
1844: ) ;
1845:
1846: -- Convert the Common record to Revised Operation record
1847: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp
1848: ( p_com_operation_rec => l_com_operation_rec
1849: , p_com_op_unexp_rec => l_com_op_unexp_rec
1850: , x_rev_operation_rec => x_rev_operation_rec
1851: , x_rev_op_unexp_rec => x_rev_op_unexp_rec

Line 1873: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

1869: * and warning messages
1870: *
1871: *********************************************************************/
1872: PROCEDURE Check_NonOperated_Attribute
1873: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1874: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1875: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1876: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1877: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1874: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

1870: *
1871: *********************************************************************/
1872: PROCEDURE Check_NonOperated_Attribute
1873: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1874: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1875: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1876: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1877: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1878: , x_return_status IN OUT NOCOPY VARCHAR2

Line 1875: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

1871: *********************************************************************/
1872: PROCEDURE Check_NonOperated_Attribute
1873: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1874: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1875: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1876: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1877: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1878: , x_return_status IN OUT NOCOPY VARCHAR2
1879: )

Line 1876: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

1872: PROCEDURE Check_NonOperated_Attribute
1873: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
1874: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1875: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
1876: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
1877: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1878: , x_return_status IN OUT NOCOPY VARCHAR2
1879: )
1880: IS

Line 1887: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

1883: l_err_text VARCHAR2(2000) ;
1884: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1885: l_token_tbl Error_Handler.Token_Tbl_Type;
1886:
1887: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1888: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1889:
1890: BEGIN
1891:

Line 1888: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

1884: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1885: l_token_tbl Error_Handler.Token_Tbl_Type;
1886:
1887: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
1888: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
1889:
1890: BEGIN
1891:
1892: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2322: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

2318: * Set Standard Operation infor to exposed and unexposed
2319: * coulumns regarding reference flag
2320: **********************************************************************/
2321: PROCEDURE Check_Ref_Std_Operation
2322: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2323: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2324: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2325: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2326: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type

Line 2323: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

2319: * coulumns regarding reference flag
2320: **********************************************************************/
2321: PROCEDURE Check_Ref_Std_Operation
2322: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2323: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2324: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2325: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2326: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2327: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

Line 2324: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

2320: **********************************************************************/
2321: PROCEDURE Check_Ref_Std_Operation
2322: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2323: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2324: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2325: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2326: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2327: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2328: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

Line 2325: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

2321: PROCEDURE Check_Ref_Std_Operation
2322: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2323: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2324: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2325: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2326: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2327: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2328: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2329: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2326: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type

2322: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2323: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2324: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2325: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2326: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2327: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2328: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2329: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2330: , x_return_status IN OUT NOCOPY VARCHAR2

Line 2327: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

2323: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2324: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2325: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2326: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2327: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2328: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2329: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2330: , x_return_status IN OUT NOCOPY VARCHAR2
2331: )

Line 2328: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

2324: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2325: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2326: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2327: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2328: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2329: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2330: , x_return_status IN OUT NOCOPY VARCHAR2
2331: )
2332: IS

Line 2338: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type;

2334: --l_std_op_found BOOLEAN ; -- Indicate Std OP is found
2335: l_copy_std_op BOOLEAN ; -- Indicate Copy Std Op has been proceeded
2336: l_std_op_invalid BOOLEAN ; -- Indicate Std OP is invalid
2337:
2338: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type;
2339: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;
2340:
2341: -- Error Handlig Variables
2342: l_return_status VARCHAR2(1);

Line 2339: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;

2335: l_copy_std_op BOOLEAN ; -- Indicate Copy Std Op has been proceeded
2336: l_std_op_invalid BOOLEAN ; -- Indicate Std OP is invalid
2337:
2338: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type;
2339: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type;
2340:
2341: -- Error Handlig Variables
2342: l_return_status VARCHAR2(1);
2343: l_err_text VARCHAR2(2000) ;

Line 2752: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type

2748: * Procedure will execute the business logic and will
2749: * also perform any required cross entity validations
2750: *******************************************************************/
2751: PROCEDURE Check_Entity
2752: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2753: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2754: , p_old_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2755: , p_old_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2756: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type

Line 2753: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type

2749: * also perform any required cross entity validations
2750: *******************************************************************/
2751: PROCEDURE Check_Entity
2752: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2753: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2754: , p_old_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2755: , p_old_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2756: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
2757: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type

Line 2754: , p_old_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type

2750: *******************************************************************/
2751: PROCEDURE Check_Entity
2752: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2753: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2754: , p_old_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2755: , p_old_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2756: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
2757: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2758: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2755: , p_old_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type

2751: PROCEDURE Check_Entity
2752: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2753: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2754: , p_old_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2755: , p_old_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2756: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
2757: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2758: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2759: , x_return_status IN OUT NOCOPY VARCHAR2

Line 2756: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type

2752: ( p_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2753: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2754: , p_old_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2755: , p_old_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2756: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
2757: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2758: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2759: , x_return_status IN OUT NOCOPY VARCHAR2
2760: )

Line 2757: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type

2753: , p_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2754: , p_old_operation_rec IN Bom_Rtg_Pub.Operation_Rec_Type
2755: , p_old_op_unexp_rec IN Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2756: , x_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Operation_Rec_Type
2757: , x_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Op_Unexposed_Rec_Type
2758: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2759: , x_return_status IN OUT NOCOPY VARCHAR2
2760: )
2761: IS

Line 2762: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

2758: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2759: , x_return_status IN OUT NOCOPY VARCHAR2
2760: )
2761: IS
2762: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2763: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2764: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2765: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2766:

Line 2763: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

2759: , x_return_status IN OUT NOCOPY VARCHAR2
2760: )
2761: IS
2762: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2763: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2764: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2765: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2766:
2767: BEGIN

Line 2764: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

2760: )
2761: IS
2762: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2763: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2764: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2765: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2766:
2767: BEGIN
2768: -- Convert Routing Operation to Common Operation

Line 2765: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

2761: IS
2762: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2763: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2764: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2765: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2766:
2767: BEGIN
2768: -- Convert Routing Operation to Common Operation
2769: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

Line 2769: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

2765: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2766:
2767: BEGIN
2768: -- Convert Routing Operation to Common Operation
2769: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp
2770: ( p_rtg_operation_rec => p_operation_rec
2771: , p_rtg_op_unexp_rec => p_op_unexp_rec
2772: , x_com_operation_rec => l_com_operation_rec
2773: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 2777: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp

2773: , x_com_op_unexp_rec => l_com_op_unexp_rec
2774: ) ;
2775:
2776: -- Also Convert Old Routing Operation to Old Common Operation
2777: Bom_Rtg_Pub.Convert_RtgOp_To_ComOp
2778: ( p_rtg_operation_rec => p_old_operation_rec
2779: , p_rtg_op_unexp_rec => p_old_op_unexp_rec
2780: , x_com_operation_rec => l_old_com_operation_rec
2781: , x_com_op_unexp_rec => l_old_com_op_unexp_rec

Line 2789: , p_control_rec => Bom_Rtg_Pub.G_DEFAULT_CONTROL_REC

2785: -- Call Check_Entity
2786: Bom_Validate_Op_Seq.Check_Entity
2787: ( p_com_operation_rec => l_com_operation_rec
2788: , p_com_op_unexp_rec => l_com_op_unexp_rec
2789: , p_control_rec => Bom_Rtg_Pub.G_DEFAULT_CONTROL_REC
2790: , p_old_com_operation_rec => l_old_com_operation_rec
2791: , p_old_com_op_unexp_rec => l_old_com_op_unexp_rec
2792: , x_com_operation_rec => l_com_operation_rec
2793: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 2799: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp

2795: , x_mesg_token_tbl => x_mesg_token_tbl
2796: ) ;
2797:
2798: -- Convert the Common record to Routing Record
2799: Bom_Rtg_Pub.Convert_ComOp_To_RtgOp
2800: ( p_com_operation_rec => l_com_operation_rec
2801: , p_com_op_unexp_rec => l_com_op_unexp_rec
2802: , x_rtg_operation_rec => x_operation_rec
2803: , x_rtg_op_unexp_rec => x_op_unexp_rec

Line 2823: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type

2819: * Procedure will execute the business logic and will
2820: * also perform any required cross entity validations
2821: *******************************************************************/
2822: PROCEDURE Check_Entity
2823: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2824: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2825: , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2826: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2827: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type

Line 2824: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

2820: * also perform any required cross entity validations
2821: *******************************************************************/
2822: PROCEDURE Check_Entity
2823: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2824: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2825: , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2826: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2827: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2828: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type

Line 2825: , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type

2821: *******************************************************************/
2822: PROCEDURE Check_Entity
2823: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2824: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2825: , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2826: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2827: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2828: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
2829: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

Line 2826: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

2822: PROCEDURE Check_Entity
2823: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2824: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2825: , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2826: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2827: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2828: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
2829: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2830: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2827: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type

2823: ( p_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2824: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2825: , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2826: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2827: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2828: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
2829: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2830: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2831: , x_return_status IN OUT NOCOPY VARCHAR2

Line 2828: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type

2824: , p_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2825: , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2826: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2827: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2828: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
2829: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2830: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2831: , x_return_status IN OUT NOCOPY VARCHAR2
2832: )

Line 2829: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type

2825: , p_old_rev_operation_rec IN Bom_Rtg_Pub.Rev_Operation_Rec_Type
2826: , p_old_rev_op_unexp_rec IN Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2827: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2828: , x_rev_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Operation_Rec_Type
2829: , x_rev_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Rev_Op_Unexposed_Rec_Type
2830: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2831: , x_return_status IN OUT NOCOPY VARCHAR2
2832: )
2833:

Line 2835: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

2831: , x_return_status IN OUT NOCOPY VARCHAR2
2832: )
2833:
2834: IS
2835: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2836: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2837: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2838: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2839:

Line 2836: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

2832: )
2833:
2834: IS
2835: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2836: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2837: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2838: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2839:
2840: BEGIN

Line 2837: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

2833:
2834: IS
2835: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2836: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2837: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2838: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2839:
2840: BEGIN
2841: -- Convert Revised Operation to Common Operation

Line 2838: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

2834: IS
2835: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2836: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2837: l_old_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2838: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2839:
2840: BEGIN
2841: -- Convert Revised Operation to Common Operation
2842: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

Line 2842: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

2838: l_old_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2839:
2840: BEGIN
2841: -- Convert Revised Operation to Common Operation
2842: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp
2843: ( p_rev_operation_rec => p_rev_operation_rec
2844: , p_rev_op_unexp_rec => p_rev_op_unexp_rec
2845: , x_com_operation_rec => l_com_operation_rec
2846: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 2850: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp

2846: , x_com_op_unexp_rec => l_com_op_unexp_rec
2847: ) ;
2848:
2849: -- Also Convert Old Revised Operation to Old Common Operation
2850: Bom_Rtg_Pub.Convert_EcoOp_To_ComOp
2851: ( p_rev_operation_rec => p_old_rev_operation_rec
2852: , p_rev_op_unexp_rec => p_old_rev_op_unexp_rec
2853: , x_com_operation_rec => l_old_com_operation_rec
2854: , x_com_op_unexp_rec => l_old_com_op_unexp_rec

Line 2861: , p_control_rec => Bom_Rtg_Pub.G_DEFAULT_CONTROL_REC

2857: -- Call Check_Entity
2858: Bom_Validate_Op_Seq.Check_Entity
2859: ( p_com_operation_rec => l_com_operation_rec
2860: , p_com_op_unexp_rec => l_com_op_unexp_rec
2861: , p_control_rec => Bom_Rtg_Pub.G_DEFAULT_CONTROL_REC
2862: , p_old_com_operation_rec => l_old_com_operation_rec
2863: , p_old_com_op_unexp_rec => l_old_com_op_unexp_rec
2864: , x_com_operation_rec => l_com_operation_rec
2865: , x_com_op_unexp_rec => l_com_op_unexp_rec

Line 2871: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp

2867: , x_mesg_token_tbl => x_mesg_token_tbl
2868: ) ;
2869:
2870: -- Convert the Common record to Revised Operation record
2871: Bom_Rtg_Pub.Convert_ComOp_To_EcoOp
2872: ( p_com_operation_rec => l_com_operation_rec
2873: , p_com_op_unexp_rec => l_com_op_unexp_rec
2874: , x_rev_operation_rec => x_rev_operation_rec
2875: , x_rev_op_unexp_rec => x_rev_op_unexp_rec

Line 2896: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

2892: * It will also verify that changes in one column value
2893: * does not invalidate some other columns.
2894: **********************************************************************/
2895: PROCEDURE Check_Entity
2896: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2897: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2898: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2899: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2900: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type

Line 2897: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

2893: * does not invalidate some other columns.
2894: **********************************************************************/
2895: PROCEDURE Check_Entity
2896: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2897: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2898: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2899: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2900: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2901: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

Line 2898: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type

2894: **********************************************************************/
2895: PROCEDURE Check_Entity
2896: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2897: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2898: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2899: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2900: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2901: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2902: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

Line 2899: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

2895: PROCEDURE Check_Entity
2896: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2897: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2898: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2899: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2900: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2901: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2902: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2903: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 2900: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type

2896: ( p_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2897: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2898: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2899: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2900: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2901: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2902: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2903: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2904: , x_return_status IN OUT NOCOPY VARCHAR2

Line 2901: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type

2897: , p_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2898: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2899: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2900: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2901: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2902: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2903: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2904: , x_return_status IN OUT NOCOPY VARCHAR2
2905: )

Line 2902: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type

2898: , p_old_com_operation_rec IN Bom_Rtg_Pub.Com_Operation_Rec_Type
2899: , p_old_com_op_unexp_rec IN Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2900: , p_control_rec IN Bom_Rtg_Pub.Control_Rec_Type
2901: , x_com_operation_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Operation_Rec_Type
2902: , x_com_op_unexp_rec IN OUT NOCOPY Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type
2903: , x_mesg_token_tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2904: , x_return_status IN OUT NOCOPY VARCHAR2
2905: )
2906: IS

Line 2914: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;

2910: l_pto_flag CHAR ; -- PTO flag for Assembly
2911: l_eng_item_flag CHAR ; -- Is assembly an Engineering Item
2912: l_bom_enabled_flag CHAR ; -- Assembly's bom_enabled_flag
2913:
2914: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2915: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2916:
2917: -- Error Handlig Variables
2918: l_return_status VARCHAR2(1);

Line 2915: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;

2911: l_eng_item_flag CHAR ; -- Is assembly an Engineering Item
2912: l_bom_enabled_flag CHAR ; -- Assembly's bom_enabled_flag
2913:
2914: l_com_operation_rec Bom_Rtg_Pub.Com_Operation_Rec_Type ;
2915: l_com_op_unexp_rec Bom_Rtg_Pub.Com_Op_Unexposed_Rec_Type ;
2916:
2917: -- Error Handlig Variables
2918: l_return_status VARCHAR2(1);
2919: l_temp_return_status VARCHAR2(1);

Line 3680: , p_control_rec => Bom_Rtg_Pub.G_DEFAULT_CONTROL_REC

3676: --
3677: Check_Ref_Std_Operation
3678: ( p_com_operation_rec => l_com_operation_rec
3679: , p_com_op_unexp_rec => l_com_op_unexp_rec
3680: , p_control_rec => Bom_Rtg_Pub.G_DEFAULT_CONTROL_REC
3681: , p_old_com_operation_rec => p_old_com_operation_rec
3682: , p_old_com_op_unexp_rec => p_old_com_op_unexp_rec
3683: , x_com_operation_rec => l_com_operation_rec
3684: , x_com_op_unexp_rec => l_com_op_unexp_rec