APPS.WMS_PURGE_PVT dependencies on WMS_DISPATCHED_TASKS_HISTORY

Line 430: delete from wms_dispatched_tasks_history

426:
427: END IF; --Added bug#4415994
428: IF ( p_purge_type = TASK OR p_purge_type IS NULL ) THEN
429:
430: delete from wms_dispatched_tasks_history
431: where last_update_date < l_date and organization_id = p_orgid ;
432: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
433: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
434: FND_MESSAGE.SET_TOKEN('TABLE','WMS_DISPATCHED_TASKS_HISTORY');

Line 434: FND_MESSAGE.SET_TOKEN('TABLE','WMS_DISPATCHED_TASKS_HISTORY');

430: delete from wms_dispatched_tasks_history
431: where last_update_date < l_date and organization_id = p_orgid ;
432: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
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 ;