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

Line 212: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

208:
209: PROCEDURE Check_Entity
210: ( x_return_status IN OUT NOCOPY VARCHAR2
211: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
212: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
213: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
214: )
215: IS
216: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 213: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

209: PROCEDURE Check_Entity
210: ( x_return_status IN OUT NOCOPY VARCHAR2
211: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
212: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
213: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
214: )
215: IS
216: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
217: l_temp_var NUMBER := 0;

Line 686: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

682:
683: PROCEDURE Check_Attributes
684: ( x_return_status IN OUT NOCOPY VARCHAR2
685: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
686: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
687: )
688: IS
689: l_token_tbl Error_Handler.Token_tbl_Type;
690: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 767: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

763:
764: PROCEDURE Check_Entity_Delete
765: ( x_return_status IN OUT NOCOPY VARCHAR2
766: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
767: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
768: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
769: )
770: IS
771: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 768: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

764: PROCEDURE Check_Entity_Delete
765: ( x_return_status IN OUT NOCOPY VARCHAR2
766: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
767: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
768: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
769: )
770: IS
771: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
772: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 838: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

834: * will return the old record in the old entity parameters
835: * with a success status.
836: ****************************************************************************/
837: PROCEDURE Check_Existence
838: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
839: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
840: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
841: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
842: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 839: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

835: * with a success status.
836: ****************************************************************************/
837: PROCEDURE Check_Existence
838: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
839: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
840: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
841: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
842: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
843: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 840: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type

836: ****************************************************************************/
837: PROCEDURE Check_Existence
838: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
839: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
840: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
841: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
842: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
843: , x_Return_Status IN OUT NOCOPY VARCHAR2
844: )

Line 841: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

837: PROCEDURE Check_Existence
838: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
839: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
840: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
841: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
842: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
843: , x_Return_Status IN OUT NOCOPY VARCHAR2
844: )
845: IS

Line 923: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

919:
920: END Check_Existence;
921:
922: PROCEDURE Check_Lineage
923: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
924: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
925: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
926: , x_Return_Status IN OUT NOCOPY VARCHAR2
927: )

Line 924: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

920: END Check_Existence;
921:
922: PROCEDURE Check_Lineage
923: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
924: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
925: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
926: , x_Return_Status IN OUT NOCOPY VARCHAR2
927: )
928: IS

Line 974: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

970:
971: END CHECK_LINEAGE;
972:
973: PROCEDURE CHECK_ACCESS
974: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
975: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
976: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
977: , x_Return_Status IN OUT NOCOPY VARCHAR2
978: )

Line 975: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

971: END CHECK_LINEAGE;
972:
973: PROCEDURE CHECK_ACCESS
974: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
975: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
976: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
977: , x_Return_Status IN OUT NOCOPY VARCHAR2
978: )
979: IS

Line 1041: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

1037: */
1038: PROCEDURE Check_Entity
1039: ( x_return_status IN OUT NOCOPY VARCHAR2
1040: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1041: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1042: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1043: )
1044: IS
1045: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

Line 1042: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

1038: PROCEDURE Check_Entity
1039: ( x_return_status IN OUT NOCOPY VARCHAR2
1040: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1041: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1042: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1043: )
1044: IS
1045: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1046: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

Line 1045: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

1041: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1042: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1043: )
1044: IS
1045: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1046: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1047: BEGIN
1048: --Convert the BOM Record to ECO
1049:

Line 1046: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

1042: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1043: )
1044: IS
1045: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1046: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1047: BEGIN
1048: --Convert the BOM Record to ECO
1049:
1050: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

Line 1050: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

1046: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1047: BEGIN
1048: --Convert the BOM Record to ECO
1049:
1050: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg
1051: ( p_bom_ref_designator_rec => p_bom_ref_designator_rec
1052: , p_bom_ref_desg_unexp_rec => p_bom_ref_desg_unexp_rec
1053: , x_ref_designator_rec => l_Ref_designator_rec
1054: , x_ref_Desg_unexp_rec => l_ref_desg_unexp_rec

Line 1072: , p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

1068:
1069: PROCEDURE Check_Attributes
1070: ( x_return_status IN OUT NOCOPY VARCHAR2
1071: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1072: , p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1073: )
1074: IS
1075: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1076: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

Line 1075: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

1071: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1072: , p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1073: )
1074: IS
1075: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1076: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1077: BEGIN
1078: --Convert the BOM Record to ECO
1079:

Line 1076: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

1072: , p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1073: )
1074: IS
1075: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1076: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1077: BEGIN
1078: --Convert the BOM Record to ECO
1079:
1080: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

Line 1080: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

1076: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1077: BEGIN
1078: --Convert the BOM Record to ECO
1079:
1080: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg
1081: ( p_bom_ref_designator_rec => p_bom_ref_designator_rec
1082: , x_ref_designator_rec => l_Ref_designator_rec
1083: , x_ref_Desg_unexp_rec => l_ref_desg_unexp_rec
1084: );

Line 1100: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

1096:
1097: PROCEDURE Check_Entity_Delete
1098: ( x_return_status IN OUT NOCOPY VARCHAR2
1099: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1100: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1101: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1102: )
1103: IS
1104: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

Line 1101: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

1097: PROCEDURE Check_Entity_Delete
1098: ( x_return_status IN OUT NOCOPY VARCHAR2
1099: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1100: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1101: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1102: )
1103: IS
1104: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1105: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

Line 1104: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

1100: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1101: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1102: )
1103: IS
1104: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1105: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1106: BEGIN
1107: --Convert the BOM Record to ECO
1108:

Line 1105: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

1101: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1102: )
1103: IS
1104: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1105: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1106: BEGIN
1107: --Convert the BOM Record to ECO
1108:
1109: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

Line 1109: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

1105: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1106: BEGIN
1107: --Convert the BOM Record to ECO
1108:
1109: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg
1110: ( p_bom_ref_designator_rec => p_bom_ref_designator_rec
1111: , p_bom_ref_desg_unexp_rec => p_bom_ref_desg_unexp_rec
1112: , x_ref_designator_rec => l_Ref_designator_rec
1113: , x_ref_Desg_unexp_rec => l_ref_desg_unexp_rec

Line 1128: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

1124:
1125: END Check_Entity_Delete;
1126:
1127: PROCEDURE Check_Existence
1128: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1129: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1130: , x_old_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1131: , x_old_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1132: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1129: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

1125: END Check_Entity_Delete;
1126:
1127: PROCEDURE Check_Existence
1128: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1129: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1130: , x_old_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1131: , x_old_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1132: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1133: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 1130: , x_old_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

1126:
1127: PROCEDURE Check_Existence
1128: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1129: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1130: , x_old_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1131: , x_old_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1132: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1133: , x_Return_Status IN OUT NOCOPY VARCHAR2
1134: )

Line 1131: , x_old_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

1127: PROCEDURE Check_Existence
1128: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1129: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1130: , x_old_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1131: , x_old_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1132: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1133: , x_Return_Status IN OUT NOCOPY VARCHAR2
1134: )
1135: IS

Line 1136: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

1132: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1133: , x_Return_Status IN OUT NOCOPY VARCHAR2
1134: )
1135: IS
1136: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1137: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1138: l_old_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
1139: l_old_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1140:

Line 1137: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

1133: , x_Return_Status IN OUT NOCOPY VARCHAR2
1134: )
1135: IS
1136: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1137: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1138: l_old_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
1139: l_old_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1140:
1141: BEGIN

Line 1138: l_old_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;

1134: )
1135: IS
1136: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1137: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1138: l_old_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
1139: l_old_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1140:
1141: BEGIN
1142: --Convert the BOM Record to ECO

Line 1139: l_old_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

1135: IS
1136: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1137: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1138: l_old_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
1139: l_old_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1140:
1141: BEGIN
1142: --Convert the BOM Record to ECO
1143:

Line 1144: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

1140:
1141: BEGIN
1142: --Convert the BOM Record to ECO
1143:
1144: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg
1145: ( p_bom_ref_designator_rec => p_bom_ref_designator_rec
1146: , p_bom_ref_desg_unexp_rec => p_bom_ref_desg_unexp_rec
1147: , x_ref_designator_rec => l_Ref_designator_rec
1148: , x_ref_Desg_unexp_rec => l_ref_desg_unexp_rec

Line 1166: Bom_Bo_Pub.Convert_EcoDesg_To_BomDesg

1162: , x_mesg_token_tbl => x_mesg_token_tbl
1163: );
1164:
1165: -- Convert ECO Record to BOM before returning
1166: Bom_Bo_Pub.Convert_EcoDesg_To_BomDesg
1167: ( p_ref_designator_rec => l_old_ref_designator_rec
1168: , p_ref_desg_unexp_rec => l_old_ref_desg_unexp_rec
1169: , x_bom_ref_designator_rec => x_old_bom_ref_designator_rec
1170: , x_bom_ref_desg_unexp_rec => x_old_bom_ref_desg_unexp_rec

Line 1176: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.bom_Ref_Designator_Rec_Type

1172:
1173: END Check_Existence;
1174:
1175: PROCEDURE Check_Lineage
1176: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.bom_Ref_Designator_Rec_Type
1177: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.bom_Ref_Desg_Unexp_Rec_Type
1178: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1179: , x_Return_Status IN OUT NOCOPY VARCHAR2
1180: )

Line 1177: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.bom_Ref_Desg_Unexp_Rec_Type

1173: END Check_Existence;
1174:
1175: PROCEDURE Check_Lineage
1176: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.bom_Ref_Designator_Rec_Type
1177: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.bom_Ref_Desg_Unexp_Rec_Type
1178: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1179: , x_Return_Status IN OUT NOCOPY VARCHAR2
1180: )
1181: IS

Line 1182: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

1178: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1179: , x_Return_Status IN OUT NOCOPY VARCHAR2
1180: )
1181: IS
1182: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1183: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1184: BEGIN
1185: --Convert the BOM Record to ECO
1186:

Line 1183: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

1179: , x_Return_Status IN OUT NOCOPY VARCHAR2
1180: )
1181: IS
1182: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1183: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1184: BEGIN
1185: --Convert the BOM Record to ECO
1186:
1187: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

Line 1187: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

1183: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1184: BEGIN
1185: --Convert the BOM Record to ECO
1186:
1187: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg
1188: ( p_bom_ref_designator_rec => p_bom_ref_designator_rec
1189: , p_bom_ref_desg_unexp_rec => p_bom_ref_desg_unexp_rec
1190: , x_ref_designator_rec => l_Ref_designator_rec
1191: , x_ref_Desg_unexp_rec => l_ref_desg_unexp_rec

Line 1205: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

1201:
1202: END Check_Lineage;
1203:
1204: PROCEDURE CHECK_ACCESS
1205: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1206: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1207: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1208: , x_Return_Status IN OUT NOCOPY VARCHAR2
1209: )

Line 1206: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

1202: END Check_Lineage;
1203:
1204: PROCEDURE CHECK_ACCESS
1205: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1206: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1207: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1208: , x_Return_Status IN OUT NOCOPY VARCHAR2
1209: )
1210: IS

Line 1211: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

1207: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1208: , x_Return_Status IN OUT NOCOPY VARCHAR2
1209: )
1210: IS
1211: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1212: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1213: BEGIN
1214: --Convert the BOM Record to ECO
1215:

Line 1212: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

1208: , x_Return_Status IN OUT NOCOPY VARCHAR2
1209: )
1210: IS
1211: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1212: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1213: BEGIN
1214: --Convert the BOM Record to ECO
1215:
1216: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

Line 1216: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

1212: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1213: BEGIN
1214: --Convert the BOM Record to ECO
1215:
1216: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg
1217: ( p_bom_ref_designator_rec => p_bom_ref_designator_rec
1218: , p_bom_ref_desg_unexp_rec => p_bom_ref_desg_unexp_rec
1219: , x_ref_designator_rec => l_Ref_designator_rec
1220: , x_ref_Desg_unexp_rec => l_ref_desg_unexp_rec