DBA Data[Home] [Help]

APPS.WMS_PURGE_PVT dependencies on WMS_EXCEPTIONS

Line 437: delete from wms_exceptions

433: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
434: FND_MESSAGE.SET_TOKEN('TABLE','WMS_DISPATCHED_TASKS_HISTORY');
435: FND_MSG_PUB.ADD;
436:
437: delete from wms_exceptions
438: where creation_date < l_date and organization_id = p_orgid ;
439: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
440: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
441: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EXCEPTIONS');

Line 441: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EXCEPTIONS');

437: delete from wms_exceptions
438: where creation_date < l_date and organization_id = p_orgid ;
439: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
440: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
441: FND_MESSAGE.SET_TOKEN('TABLE','WMS_EXCEPTIONS');
442: FND_MSG_PUB.ADD;
443: END IF; --Added bug#4415994
444: IF ( p_purge_type = LABEL OR p_purge_type IS NULL ) THEN
445: