APPS.INV_PROCESS_TEMP dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 1325: FROM MTL_SERIAL_NUMBERS_TEMP

1321: else
1322: BEGIN
1323: SELECT 1
1324: INTO l_dummy
1325: FROM MTL_SERIAL_NUMBERS_TEMP
1326: WHERE TRANSACTION_TEMP_ID = txnrec.transaction_temp_id
1327: AND rownum < 2;
1328: EXCEPTION
1329: WHEN NO_DATA_FOUND THEN

Line 1336: DELETE FROM MTL_SERIAL_NUMBERS_TEMP

1332: END;
1333: end if;
1334: else
1335: if txnrec.transaction_temp_id IS NOT NULL then
1336: DELETE FROM MTL_SERIAL_NUMBERS_TEMP
1337: WHERE TRANSACTION_TEMP_ID = txnrec.transaction_temp_id;
1338: end if;
1339: end if;
1340: else

Line 1449: FROM MTL_SERIAL_NUMBERS_TEMP

1445: txnrec.transaction_action_id = 1) then
1446: BEGIN
1447: SELECT 1
1448: INTO l_dummy
1449: FROM MTL_SERIAL_NUMBERS_TEMP
1450: WHERE TRANSACTION_TEMP_ID = txnrec.transaction_temp_id
1451: AND rownum < 2;
1452: EXCEPTION
1453: WHEN NO_DATA_FOUND THEN

Line 1481: DELETE FROM MTL_SERIAL_NUMBERS_TEMP

1477: return 0;
1478: END;
1479: else
1480: if(lotrec.SERIAL_TRANSACTION_TEMP_ID IS NOT NULL) then
1481: DELETE FROM MTL_SERIAL_NUMBERS_TEMP
1482: WHERE TRANSACTION_TEMP_ID = lotrec.SERIAL_TRANSACTION_TEMP_ID;
1483: lotrec.SERIAL_TRANSACTION_TEMP_ID := NULL;
1484: end if;
1485: end if;