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;
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;
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;
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;
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;
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
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
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: )
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
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: )
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
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: )
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
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;
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;
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:
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
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
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;
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:
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
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: );
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;
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;
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:
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
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
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
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
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: )
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
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:
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
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
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:
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
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
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: )
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
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:
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
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
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: )
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
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:
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
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