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 333: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

329: * Bom_Substitute_Components table.
330: *
331: ********************************************************************/
332: PROCEDURE Insert_Row
333: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
334: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
335: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
336: , x_return_status IN OUT NOCOPY VARCHAR2
337: )

Line 334: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

330: *
331: ********************************************************************/
332: PROCEDURE Insert_Row
333: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
334: , p_Sub_Comp_Unexp_Rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
335: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
336: , x_return_status IN OUT NOCOPY VARCHAR2
337: )
338: IS

Line 549: , x_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type

545: PROCEDURE Query_Row
546: ( p_substitute_component_id IN NUMBER
547: , p_component_sequence_id IN NUMBER
548: , p_acd_type IN NUMBER
549: , x_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
550: , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
551: , x_return_status IN OUT NOCOPY VARCHAR2
552: )
553: IS

Line 550: , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

546: ( p_substitute_component_id IN NUMBER
547: , p_component_sequence_id IN NUMBER
548: , p_acd_type IN NUMBER
549: , x_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
550: , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
551: , x_return_status IN OUT NOCOPY VARCHAR2
552: )
553: IS
554: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

Line 554: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

550: , x_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
551: , x_return_status IN OUT NOCOPY VARCHAR2
552: )
553: IS
554: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
555: l_Token_Tbl Error_Handler.Token_Tbl_Type;
556: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
557: BEGIN
558:

Line 637: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

633: --
634:
635: PROCEDURE Lock_Row
636: ( x_return_status IN OUT NOCOPY VARCHAR2
637: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
638: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
639: , x_err_text IN OUT NOCOPY VARCHAR2
640: )
641: IS

Line 638: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type

634:
635: PROCEDURE Lock_Row
636: ( x_return_status IN OUT NOCOPY VARCHAR2
637: , p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
638: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
639: , x_err_text IN OUT NOCOPY VARCHAR2
640: )
641: IS
642: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

Line 642: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

638: , x_sub_component_rec IN OUT NOCOPY Bom_Bo_Pub.Sub_Component_Rec_Type
639: , x_err_text IN OUT NOCOPY VARCHAR2
640: )
641: IS
642: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
643: l_err_text VARCHAR2(255);
644: BEGIN
645: NULL;
646: END Lock_Row;

Line 649: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type

645: NULL;
646: END Lock_Row;
647:
648: PROCEDURE Perform_Writes
649: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
650: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
651: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
652: , x_Return_Status IN OUT NOCOPY VARCHAR2
653: )

Line 650: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type

646: END Lock_Row;
647:
648: PROCEDURE Perform_Writes
649: ( p_sub_component_rec IN Bom_Bo_Pub.Sub_Component_Rec_Type
650: , p_sub_comp_unexp_rec IN Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type
651: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
652: , x_Return_Status IN OUT NOCOPY VARCHAR2
653: )
654: IS

Line 657: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

653: )
654: IS
655: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
656: l_return_status VARCHAR2(1);
657: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
658: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
659: BEGIN
660: l_sub_component_rec := p_sub_component_rec;
661: l_sub_comp_unexp_rec := p_sub_comp_unexp_rec;

Line 658: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

654: IS
655: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
656: l_return_status VARCHAR2(1);
657: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
658: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
659: BEGIN
660: l_sub_component_rec := p_sub_component_rec;
661: l_sub_comp_unexp_rec := p_sub_comp_unexp_rec;
662:

Line 712: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

708: /*
709: ** Procedures for BOM Business Object
710: */
711: FUNCTION Convert_Miss_To_Null
712: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
713: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
714: IS
715: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
716: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

Line 713: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

709: ** Procedures for BOM Business Object
710: */
711: FUNCTION Convert_Miss_To_Null
712: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
713: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
714: IS
715: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
716: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
717: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;

Line 715: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

711: FUNCTION Convert_Miss_To_Null
712: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
713: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
714: IS
715: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
716: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
717: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
718: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;
719: BEGIN

Line 716: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

712: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
713: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
714: IS
715: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
716: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
717: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
718: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;
719: BEGIN
720: --

Line 717: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;

713: ) RETURN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
714: IS
715: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
716: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
717: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
718: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;
719: BEGIN
720: --
721: -- Convert the BOM record

Line 718: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;

714: IS
715: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
716: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
717: l_bom_sub_component_rec Bom_Bo_Pub.Bom_Sub_Component_Rec_Type;
718: l_bom_sub_comp_unexp_rec Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type;
719: BEGIN
720: --
721: -- Convert the BOM record
722: --

Line 723: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp

719: BEGIN
720: --
721: -- Convert the BOM record
722: --
723: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp
724: ( p_bom_sub_component_rec => p_bom_sub_component_rec
725: , x_sub_component_rec => l_sub_component_rec
726: , x_sub_comp_unexp_rec => l_sub_comp_unexp_rec
727: );

Line 736: Bom_Bo_Pub.Convert_EcoSComp_To_BomSComp

732:
733: --
734: -- Convert the ECO record back
735: --
736: Bom_Bo_Pub.Convert_EcoSComp_To_BomSComp
737: ( p_sub_component_rec => l_sub_component_rec
738: , x_bom_sub_component_rec => l_bom_sub_component_rec
739: , x_bom_sub_comp_unexp_rec => l_bom_sub_comp_unexp_rec
740: );

Line 750: , x_bom_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

746: PROCEDURE Query_Row
747: ( p_substitute_component_id IN NUMBER
748: , p_component_sequence_id IN NUMBER
749: , p_acd_type IN NUMBER
750: , x_bom_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
751: , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
752: , x_return_status IN OUT NOCOPY VARCHAR2
753: )
754: IS

Line 751: , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

747: ( p_substitute_component_id IN NUMBER
748: , p_component_sequence_id IN NUMBER
749: , p_acd_type IN NUMBER
750: , x_bom_Sub_Component_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
751: , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
752: , x_return_status IN OUT NOCOPY VARCHAR2
753: )
754: IS
755: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

Line 755: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

751: , x_bom_Sub_Comp_Unexp_Rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
752: , x_return_status IN OUT NOCOPY VARCHAR2
753: )
754: IS
755: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
756: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
757: BEGIN
758:
759: --

Line 756: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

752: , x_return_status IN OUT NOCOPY VARCHAR2
753: )
754: IS
755: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
756: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
757: BEGIN
758:
759: --
760: -- Call Query Row

Line 774: Bom_Bo_Pub.Convert_EcoSComp_To_BomSComp

770:
771: --
772: -- Convert the ECO record before retuning
773: --
774: Bom_Bo_Pub.Convert_EcoSComp_To_BomSComp
775: ( p_sub_component_rec => l_sub_component_rec
776: , p_sub_comp_unexp_rec => l_sub_comp_unexp_rec
777: , x_bom_sub_component_rec => x_bom_sub_component_rec
778: , x_bom_sub_comp_unexp_rec => x_bom_sub_comp_unexp_rec

Line 784: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type

780:
781: END Query_Row;
782:
783: PROCEDURE Perform_Writes
784: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
785: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
786: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
787: , x_Return_Status IN OUT NOCOPY VARCHAR2
788: )

Line 785: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type

781: END Query_Row;
782:
783: PROCEDURE Perform_Writes
784: ( p_bom_sub_component_rec IN Bom_Bo_Pub.Bom_Sub_Component_Rec_Type
785: , p_bom_sub_comp_unexp_rec IN Bom_Bo_Pub.Bom_Sub_Comp_Unexp_Rec_Type
786: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
787: , x_Return_Status IN OUT NOCOPY VARCHAR2
788: )
789: IS

Line 790: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;

786: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
787: , x_Return_Status IN OUT NOCOPY VARCHAR2
788: )
789: IS
790: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
791: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
792: BEGIN
793: --
794: -- Convert the BOM Record to ECO Record

Line 791: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;

787: , x_Return_Status IN OUT NOCOPY VARCHAR2
788: )
789: IS
790: l_sub_component_rec Bom_Bo_Pub.Sub_Component_Rec_Type;
791: l_sub_comp_unexp_rec Bom_Bo_Pub.Sub_Comp_Unexposed_Rec_Type;
792: BEGIN
793: --
794: -- Convert the BOM Record to ECO Record
795: --

Line 796: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp

792: BEGIN
793: --
794: -- Convert the BOM Record to ECO Record
795: --
796: Bom_Bo_Pub.Convert_BomSComp_To_EcoSComp
797: ( p_bom_sub_component_rec => p_bom_sub_component_rec
798: , p_bom_sub_comp_unexp_rec => p_bom_sub_comp_unexp_rec
799: , x_sub_component_rec => l_sub_component_rec
800: , x_sub_comp_unexp_rec => l_sub_comp_unexp_rec