DBA Data[Home] [Help]

APPS.BOM_VALIDATE_REF_DESIGNATOR dependencies on BOM_BO_PUB

Line 223: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

219:
220: PROCEDURE Check_Entity
221: ( x_return_status IN OUT NOCOPY VARCHAR2
222: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
223: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
224: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
225: )
226: IS
227: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 224: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

220: PROCEDURE Check_Entity
221: ( x_return_status IN OUT NOCOPY VARCHAR2
222: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
223: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
224: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
225: )
226: IS
227: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
228: l_temp_var NUMBER := 0;

Line 774: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

770:
771: PROCEDURE Check_Attributes
772: ( x_return_status IN OUT NOCOPY VARCHAR2
773: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
774: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
775: )
776: IS
777: l_token_tbl Error_Handler.Token_tbl_Type;
778: l_Mesg_token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 855: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

851:
852: PROCEDURE Check_Entity_Delete
853: ( x_return_status IN OUT NOCOPY VARCHAR2
854: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
855: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
856: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
857: )
858: IS
859: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 856: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

852: PROCEDURE Check_Entity_Delete
853: ( x_return_status IN OUT NOCOPY VARCHAR2
854: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
855: , p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
856: , p_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
857: )
858: IS
859: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
860: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 997: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

993: * will return the old record in the old entity parameters
994: * with a success status.
995: ****************************************************************************/
996: PROCEDURE Check_Existence
997: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
998: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
999: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
1000: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
1001: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 998: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

994: * with a success status.
995: ****************************************************************************/
996: PROCEDURE Check_Existence
997: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
998: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
999: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
1000: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
1001: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1002: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 999: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type

995: ****************************************************************************/
996: PROCEDURE Check_Existence
997: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
998: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
999: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
1000: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
1001: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1002: , x_Return_Status IN OUT NOCOPY VARCHAR2
1003: )

Line 1000: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

996: PROCEDURE Check_Existence
997: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
998: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
999: , x_old_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Designator_Rec_Type
1000: , x_old_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
1001: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1002: , x_Return_Status IN OUT NOCOPY VARCHAR2
1003: )
1004: IS

Line 1082: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

1078:
1079: END Check_Existence;
1080:
1081: PROCEDURE Check_Lineage
1082: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
1083: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
1084: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1085: , x_Return_Status IN OUT NOCOPY VARCHAR2
1086: )

Line 1083: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

1079: END Check_Existence;
1080:
1081: PROCEDURE Check_Lineage
1082: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
1083: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
1084: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1085: , x_Return_Status IN OUT NOCOPY VARCHAR2
1086: )
1087: IS

Line 1133: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type

1129:
1130: END CHECK_LINEAGE;
1131:
1132: PROCEDURE CHECK_ACCESS
1133: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
1134: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
1135: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1136: , x_Return_Status IN OUT NOCOPY VARCHAR2
1137: )

Line 1134: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type

1130: END CHECK_LINEAGE;
1131:
1132: PROCEDURE CHECK_ACCESS
1133: ( p_ref_designator_rec IN Bom_Bo_Pub.Ref_Designator_Rec_Type
1134: , p_ref_desg_unexp_rec IN Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type
1135: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1136: , x_Return_Status IN OUT NOCOPY VARCHAR2
1137: )
1138: IS

Line 1200: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

1196: */
1197: PROCEDURE Check_Entity
1198: ( x_return_status IN OUT NOCOPY VARCHAR2
1199: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1200: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1201: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1202: )
1203: IS
1204: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

Line 1201: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

1197: PROCEDURE Check_Entity
1198: ( x_return_status IN OUT NOCOPY VARCHAR2
1199: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1200: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1201: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1202: )
1203: IS
1204: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1205: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

Line 1204: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

1200: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1201: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1202: )
1203: IS
1204: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1205: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1206: BEGIN
1207: --Convert the BOM Record to ECO
1208:

Line 1205: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

1201: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1202: )
1203: IS
1204: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1205: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1206: BEGIN
1207: --Convert the BOM Record to ECO
1208:
1209: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

Line 1209: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

1205: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1206: BEGIN
1207: --Convert the BOM Record to ECO
1208:
1209: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg
1210: ( p_bom_ref_designator_rec => p_bom_ref_designator_rec
1211: , p_bom_ref_desg_unexp_rec => p_bom_ref_desg_unexp_rec
1212: , x_ref_designator_rec => l_Ref_designator_rec
1213: , x_ref_Desg_unexp_rec => l_ref_desg_unexp_rec

Line 1231: , p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

1227:
1228: PROCEDURE Check_Attributes
1229: ( x_return_status IN OUT NOCOPY VARCHAR2
1230: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1231: , p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1232: )
1233: IS
1234: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1235: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

Line 1234: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

1230: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1231: , p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1232: )
1233: IS
1234: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1235: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1236: BEGIN
1237: --Convert the BOM Record to ECO
1238:

Line 1235: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

1231: , p_Bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1232: )
1233: IS
1234: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1235: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1236: BEGIN
1237: --Convert the BOM Record to ECO
1238:
1239: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

Line 1239: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

1235: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1236: BEGIN
1237: --Convert the BOM Record to ECO
1238:
1239: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg
1240: ( p_bom_ref_designator_rec => p_bom_ref_designator_rec
1241: , x_ref_designator_rec => l_Ref_designator_rec
1242: , x_ref_Desg_unexp_rec => l_ref_desg_unexp_rec
1243: );

Line 1259: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

1255:
1256: PROCEDURE Check_Entity_Delete
1257: ( x_return_status IN OUT NOCOPY VARCHAR2
1258: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1259: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1260: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1261: )
1262: IS
1263: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

Line 1260: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

1256: PROCEDURE Check_Entity_Delete
1257: ( x_return_status IN OUT NOCOPY VARCHAR2
1258: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1259: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1260: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1261: )
1262: IS
1263: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1264: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

Line 1263: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

1259: , p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1260: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1261: )
1262: IS
1263: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1264: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1265: BEGIN
1266: --Convert the BOM Record to ECO
1267:

Line 1264: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

1260: , p_bom_Ref_Desg_Unexp_Rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1261: )
1262: IS
1263: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1264: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1265: BEGIN
1266: --Convert the BOM Record to ECO
1267:
1268: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

Line 1268: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

1264: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1265: BEGIN
1266: --Convert the BOM Record to ECO
1267:
1268: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg
1269: ( p_bom_ref_designator_rec => p_bom_ref_designator_rec
1270: , p_bom_ref_desg_unexp_rec => p_bom_ref_desg_unexp_rec
1271: , x_ref_designator_rec => l_Ref_designator_rec
1272: , x_ref_Desg_unexp_rec => l_ref_desg_unexp_rec

Line 1287: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

1283:
1284: END Check_Entity_Delete;
1285:
1286: PROCEDURE Check_Existence
1287: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1288: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1289: , x_old_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1290: , x_old_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1291: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

Line 1288: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

1284: END Check_Entity_Delete;
1285:
1286: PROCEDURE Check_Existence
1287: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1288: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1289: , x_old_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1290: , x_old_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1291: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1292: , x_Return_Status IN OUT NOCOPY VARCHAR2

Line 1289: , x_old_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

1285:
1286: PROCEDURE Check_Existence
1287: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1288: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1289: , x_old_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1290: , x_old_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1291: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1292: , x_Return_Status IN OUT NOCOPY VARCHAR2
1293: )

Line 1290: , x_old_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

1286: PROCEDURE Check_Existence
1287: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1288: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1289: , x_old_bom_ref_designator_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1290: , x_old_bom_ref_desg_unexp_rec IN OUT NOCOPY Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1291: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1292: , x_Return_Status IN OUT NOCOPY VARCHAR2
1293: )
1294: IS

Line 1295: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

1291: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1292: , x_Return_Status IN OUT NOCOPY VARCHAR2
1293: )
1294: IS
1295: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1296: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1297: l_old_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
1298: l_old_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1299:

Line 1296: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

1292: , x_Return_Status IN OUT NOCOPY VARCHAR2
1293: )
1294: IS
1295: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1296: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1297: l_old_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
1298: l_old_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1299:
1300: BEGIN

Line 1297: l_old_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;

1293: )
1294: IS
1295: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1296: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1297: l_old_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
1298: l_old_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1299:
1300: BEGIN
1301: --Convert the BOM Record to ECO

Line 1298: l_old_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

1294: IS
1295: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1296: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1297: l_old_ref_designator_rec Bom_Bo_Pub.Ref_Designator_Rec_Type;
1298: l_old_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1299:
1300: BEGIN
1301: --Convert the BOM Record to ECO
1302:

Line 1303: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

1299:
1300: BEGIN
1301: --Convert the BOM Record to ECO
1302:
1303: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg
1304: ( p_bom_ref_designator_rec => p_bom_ref_designator_rec
1305: , p_bom_ref_desg_unexp_rec => p_bom_ref_desg_unexp_rec
1306: , x_ref_designator_rec => l_Ref_designator_rec
1307: , x_ref_Desg_unexp_rec => l_ref_desg_unexp_rec

Line 1325: Bom_Bo_Pub.Convert_EcoDesg_To_BomDesg

1321: , x_mesg_token_tbl => x_mesg_token_tbl
1322: );
1323:
1324: -- Convert ECO Record to BOM before returning
1325: Bom_Bo_Pub.Convert_EcoDesg_To_BomDesg
1326: ( p_ref_designator_rec => l_old_ref_designator_rec
1327: , p_ref_desg_unexp_rec => l_old_ref_desg_unexp_rec
1328: , x_bom_ref_designator_rec => x_old_bom_ref_designator_rec
1329: , x_bom_ref_desg_unexp_rec => x_old_bom_ref_desg_unexp_rec

Line 1335: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.bom_Ref_Designator_Rec_Type

1331:
1332: END Check_Existence;
1333:
1334: PROCEDURE Check_Lineage
1335: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.bom_Ref_Designator_Rec_Type
1336: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.bom_Ref_Desg_Unexp_Rec_Type
1337: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1338: , x_Return_Status IN OUT NOCOPY VARCHAR2
1339: )

Line 1336: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.bom_Ref_Desg_Unexp_Rec_Type

1332: END Check_Existence;
1333:
1334: PROCEDURE Check_Lineage
1335: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.bom_Ref_Designator_Rec_Type
1336: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.bom_Ref_Desg_Unexp_Rec_Type
1337: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1338: , x_Return_Status IN OUT NOCOPY VARCHAR2
1339: )
1340: IS

Line 1341: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

1337: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1338: , x_Return_Status IN OUT NOCOPY VARCHAR2
1339: )
1340: IS
1341: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1342: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1343: BEGIN
1344: --Convert the BOM Record to ECO
1345:

Line 1342: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

1338: , x_Return_Status IN OUT NOCOPY VARCHAR2
1339: )
1340: IS
1341: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1342: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1343: BEGIN
1344: --Convert the BOM Record to ECO
1345:
1346: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

Line 1346: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

1342: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1343: BEGIN
1344: --Convert the BOM Record to ECO
1345:
1346: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg
1347: ( p_bom_ref_designator_rec => p_bom_ref_designator_rec
1348: , p_bom_ref_desg_unexp_rec => p_bom_ref_desg_unexp_rec
1349: , x_ref_designator_rec => l_Ref_designator_rec
1350: , x_ref_Desg_unexp_rec => l_ref_desg_unexp_rec

Line 1364: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type

1360:
1361: END Check_Lineage;
1362:
1363: PROCEDURE CHECK_ACCESS
1364: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1365: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1366: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1367: , x_Return_Status IN OUT NOCOPY VARCHAR2
1368: )

Line 1365: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type

1361: END Check_Lineage;
1362:
1363: PROCEDURE CHECK_ACCESS
1364: ( p_bom_ref_designator_rec IN Bom_Bo_Pub.Bom_Ref_Designator_Rec_Type
1365: , p_bom_ref_desg_unexp_rec IN Bom_Bo_Pub.Bom_Ref_Desg_Unexp_Rec_Type
1366: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1367: , x_Return_Status IN OUT NOCOPY VARCHAR2
1368: )
1369: IS

Line 1370: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;

1366: , x_Mesg_Token_Tbl IN OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1367: , x_Return_Status IN OUT NOCOPY VARCHAR2
1368: )
1369: IS
1370: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1371: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1372: BEGIN
1373: --Convert the BOM Record to ECO
1374:

Line 1371: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;

1367: , x_Return_Status IN OUT NOCOPY VARCHAR2
1368: )
1369: IS
1370: l_ref_designator_rec Bom_Bo_Pub.Ref_Designator_rec_Type;
1371: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1372: BEGIN
1373: --Convert the BOM Record to ECO
1374:
1375: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

Line 1375: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg

1371: l_ref_desg_unexp_rec Bom_Bo_Pub.Ref_Desg_Unexposed_Rec_Type;
1372: BEGIN
1373: --Convert the BOM Record to ECO
1374:
1375: Bom_Bo_Pub.Convert_Bomdesg_To_EcoDesg
1376: ( p_bom_ref_designator_rec => p_bom_ref_designator_rec
1377: , p_bom_ref_desg_unexp_rec => p_bom_ref_desg_unexp_rec
1378: , x_ref_designator_rec => l_Ref_designator_rec
1379: , x_ref_Desg_unexp_rec => l_ref_desg_unexp_rec