APPS.WMS_PURGE_PVT dependencies on WMS_LPN_HISTORIES

Line 177: DELETE FROM WMS_LPN_HISTORIES

173: END IF;
174:
175: l_progress := 'Delete all history records for that LPN';
176: FORALL i IN p_lpn_id_table.first..p_lpn_id_table.last
177: DELETE FROM WMS_LPN_HISTORIES
178: WHERE parent_lpn_id = p_lpn_id_table(i)
179: OR lpn_id = p_lpn_id_table(i);
180:
181: IF ( p_purge_count.exists(2) ) THEN

Line 292: l_purge_count(2) := 0; -- WMS_LPN_HISTORIES

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
291: l_purge_count(1) := 0; -- WMS_PACKAGING_HIST
292: l_purge_count(2) := 0; -- WMS_LPN_HISTORIES
293: l_purge_count(3) := 0; -- WMS_LPN_CONTENTS
294: l_purge_count(4) := 0; -- WMS_LICENSE_PLATE_NUMBERS
295: l_purge_count(5) := 0; -- WMS_EPC
296:

Line 409: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_HISTORIES');

405: FND_MSG_PUB.ADD;
406:
407: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
408: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(2));
409: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_HISTORIES');
410: FND_MSG_PUB.ADD;
411:
412: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
413: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(3));