DBA Data[Home] [Help]

APPS.WMS_PURGE_PVT dependencies on WMS_DEVICE_REQUESTS_HIST

Line 282: delete from wms_device_requests_hist

278:
279: FND_MSG_PUB.DELETE_msg;
280: IF ( p_purge_type = DEVICE OR p_purge_type IS NULL ) THEN
281:
282: delete from wms_device_requests_hist
283: where creation_date < l_date and organization_id = p_orgid;
284: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
285: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
286: FND_MESSAGE.SET_TOKEN('TABLE','WMS_DEVICE_REQUESTS_HIST');

Line 286: FND_MESSAGE.SET_TOKEN('TABLE','WMS_DEVICE_REQUESTS_HIST');

282: delete from wms_device_requests_hist
283: where creation_date < l_date and organization_id = p_orgid;
284: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
285: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
286: FND_MESSAGE.SET_TOKEN('TABLE','WMS_DEVICE_REQUESTS_HIST');
287: FND_MSG_PUB.ADD;
288: END IF; --Added bug#4415994
289: IF ( p_purge_type = LPN OR p_purge_type IS NULL ) THEN
290: -- initialize table delete count variables