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_SUB_COMPONENT_UTIL dependencies on BOM_BO_PUB

Line 32: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

28:
29: -- Function Convert_Miss_To_Null
30:
31: FUNCTION Convert_Miss_To_Null
32: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
33: ) RETURN Bom_Bo_Pub.Sub_Component_Rec_Type
34: IS
35: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type := p_sub_component_rec;
36: BEGIN

Line 33: ) RETURN Bom_Bo_Pub.Sub_Component_Rec_Type

29: -- Function Convert_Miss_To_Null
30:
31: FUNCTION Convert_Miss_To_Null
32: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
33: ) RETURN Bom_Bo_Pub.Sub_Component_Rec_Type
34: IS
35: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type := p_sub_component_rec;
36: BEGIN
37:

Line 35: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type := p_sub_component_rec;

31: FUNCTION Convert_Miss_To_Null
32: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
33: ) RETURN Bom_Bo_Pub.Sub_Component_Rec_Type
34: IS
35: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type := p_sub_component_rec;
36: BEGIN
37:
38: /*
39: IF l_sub_component_rec.substitute_component_id = FND_API.G_MISS_NUM THEN

Line 179: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

175: *
176: ********************************************************************/
177:
178: PROCEDURE Update_Row
179: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
180: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
181: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
182: , x_return_status IN OUT NOCOPY VARCHAR2
183: )

Line 180: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

176: ********************************************************************/
177:
178: PROCEDURE Update_Row
179: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
180: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
181: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
182: , x_return_status IN OUT NOCOPY VARCHAR2
183: )
184: IS

Line 186: l_sub_component_rec Bom_Bo_Pub.SUB_COMPONENT_REC_TYPE :=

182: , x_return_status IN OUT NOCOPY VARCHAR2
183: )
184: IS
185: l_processed BOOLEAN;
186: l_sub_component_rec Bom_Bo_Pub.SUB_COMPONENT_REC_TYPE :=
187: p_sub_component_rec;
188: l_return_status VARCHAR2(200);
189: l_err_text VARCHAR2(255);
190: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 309: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

305: * Bom_Substitute_Components table.
306: *
307: ********************************************************************/
308: PROCEDURE Insert_Row
309: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
310: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
311: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
312: , x_return_status IN OUT NOCOPY VARCHAR2
313: )

Line 310: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

306: *
307: ********************************************************************/
308: PROCEDURE Insert_Row
309: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
310: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
311: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
312: , x_return_status IN OUT NOCOPY VARCHAR2
313: )
314: IS

Line 513: , x_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type

509: PROCEDURE Query_Row
510: ( p_substitute_component_id IN NUMBER
511: , p_component_sequence_id IN NUMBER
512: , p_acd_type IN NUMBER
513: , x_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
514: , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
515: , x_return_status IN OUT NOCOPY VARCHAR2
516: )
517: IS

Line 514: , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

510: ( p_substitute_component_id IN NUMBER
511: , p_component_sequence_id IN NUMBER
512: , p_acd_type IN NUMBER
513: , x_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
514: , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
515: , x_return_status IN OUT NOCOPY VARCHAR2
516: )
517: IS
518: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

Line 518: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

514: , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
515: , x_return_status IN OUT NOCOPY VARCHAR2
516: )
517: IS
518: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
519: l_Token_Tbl Error_Handler.Token_Tbl_Type;
520: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
521: BEGIN
522:

Line 601: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

597: --
598:
599: PROCEDURE Lock_Row
600: ( x_return_status IN OUT NOCOPY VARCHAR2
601: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
602: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
603: , x_err_text IN OUT NOCOPY VARCHAR2
604: )
605: IS

Line 602: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type

598:
599: PROCEDURE Lock_Row
600: ( x_return_status IN OUT NOCOPY VARCHAR2
601: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
602: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
603: , x_err_text IN OUT NOCOPY VARCHAR2
604: )
605: IS
606: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

Line 606: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

602: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
603: , x_err_text IN OUT NOCOPY VARCHAR2
604: )
605: IS
606: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
607: l_err_text VARCHAR2(255);
608: BEGIN
609: NULL;
610: END Lock_Row;

Line 613: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

609: NULL;
610: END Lock_Row;
611:
612: PROCEDURE Perform_Writes
613: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
614: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
615: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
616: , x_Return_Status IN OUT NOCOPY VARCHAR2
617: )

Line 614: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

610: END Lock_Row;
611:
612: PROCEDURE Perform_Writes
613: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
614: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
615: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
616: , x_Return_Status IN OUT NOCOPY VARCHAR2
617: )
618: IS

Line 621: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

617: )
618: IS
619: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
620: l_return_status VARCHAR2(1);
621: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
622: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
623: BEGIN
624: l_sub_component_rec := p_sub_component_rec;
625: l_sub_comp_unexp_rec := p_sub_comp_unexp_rec;

Line 622: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

618: IS
619: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
620: l_return_status VARCHAR2(1);
621: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
622: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
623: BEGIN
624: l_sub_component_rec := p_sub_component_rec;
625: l_sub_comp_unexp_rec := p_sub_comp_unexp_rec;
626:

Line 676: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

672: /*
673: ** Procedures for BOM Business Object
674: */
675: FUNCTION Convert_Miss_To_Null
676: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
677: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
678: IS
679: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
680: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

Line 677: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

673: ** Procedures for BOM Business Object
674: */
675: FUNCTION Convert_Miss_To_Null
676: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
677: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
678: IS
679: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
680: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
681: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;

Line 679: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

675: FUNCTION Convert_Miss_To_Null
676: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
677: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
678: IS
679: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
680: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
681: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
682: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;
683: BEGIN

Line 680: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

676: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
677: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
678: IS
679: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
680: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
681: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
682: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;
683: BEGIN
684: --

Line 681: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;

677: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
678: IS
679: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
680: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
681: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
682: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;
683: BEGIN
684: --
685: -- Convert the BOM record

Line 682: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;

678: IS
679: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
680: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
681: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
682: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;
683: BEGIN
684: --
685: -- Convert the BOM record
686: --

Line 687: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp

683: BEGIN
684: --
685: -- Convert the BOM record
686: --
687: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp
688: ( p_bom_sub_component_rec => p_bom_sub_component_rec
689: , x_sub_component_rec => l_sub_component_rec
690: , x_sub_comp_unexp_rec => l_sub_comp_unexp_rec
691: );

Line 700: Bom_Bo_Pub.Convert_EcoSComp_To_BomSComp

696:
697: --
698: -- Convert the ECO record back
699: --
700: Bom_Bo_Pub.Convert_EcoSComp_To_BomSComp
701: ( p_sub_component_rec => l_sub_component_rec
702: , x_bom_sub_component_rec => l_bom_sub_component_rec
703: , x_bom_sub_comp_unexp_rec => l_bom_sub_comp_unexp_rec
704: );

Line 714: , x_bom_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

710: PROCEDURE Query_Row
711: ( p_substitute_component_id IN NUMBER
712: , p_component_sequence_id IN NUMBER
713: , p_acd_type IN NUMBER
714: , x_bom_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
715: , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
716: , x_return_status IN OUT NOCOPY VARCHAR2
717: )
718: IS

Line 715: , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

711: ( p_substitute_component_id IN NUMBER
712: , p_component_sequence_id IN NUMBER
713: , p_acd_type IN NUMBER
714: , x_bom_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
715: , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
716: , x_return_status IN OUT NOCOPY VARCHAR2
717: )
718: IS
719: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

Line 719: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

715: , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
716: , x_return_status IN OUT NOCOPY VARCHAR2
717: )
718: IS
719: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
720: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
721: BEGIN
722:
723: --

Line 720: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

716: , x_return_status IN OUT NOCOPY VARCHAR2
717: )
718: IS
719: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
720: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
721: BEGIN
722:
723: --
724: -- Call Query Row

Line 738: Bom_Bo_Pub.Convert_EcoSComp_To_BomSComp

734:
735: --
736: -- Convert the ECO record before retuning
737: --
738: Bom_Bo_Pub.Convert_EcoSComp_To_BomSComp
739: ( p_sub_component_rec => l_sub_component_rec
740: , p_sub_comp_unexp_rec => l_sub_comp_unexp_rec
741: , x_bom_sub_component_rec => x_bom_sub_component_rec
742: , x_bom_sub_comp_unexp_rec => x_bom_sub_comp_unexp_rec

Line 748: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

744:
745: END Query_Row;
746:
747: PROCEDURE Perform_Writes
748: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
749: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
750: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
751: , x_Return_Status IN OUT NOCOPY VARCHAR2
752: )

Line 749: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

745: END Query_Row;
746:
747: PROCEDURE Perform_Writes
748: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
749: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
750: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
751: , x_Return_Status IN OUT NOCOPY VARCHAR2
752: )
753: IS

Line 754: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

750: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
751: , x_Return_Status IN OUT NOCOPY VARCHAR2
752: )
753: IS
754: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
755: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
756: BEGIN
757: --
758: -- Convert the BOM Record to ECO Record

Line 755: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

751: , x_Return_Status IN OUT NOCOPY VARCHAR2
752: )
753: IS
754: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
755: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
756: BEGIN
757: --
758: -- Convert the BOM Record to ECO Record
759: --

Line 760: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp

756: BEGIN
757: --
758: -- Convert the BOM Record to ECO Record
759: --
760: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp
761: ( p_bom_sub_component_rec => p_bom_sub_component_rec
762: , p_bom_sub_comp_unexp_rec => p_bom_sub_comp_unexp_rec
763: , x_sub_component_rec => l_sub_component_rec
764: , x_sub_comp_unexp_rec => l_sub_comp_unexp_rec