APPS.WMS_PURGE_PVT dependencies on WMS_PACKAGING_HIST

Line 164: DELETE FROM WMS_PACKAGING_HIST

160: x_return_status := fnd_api.g_ret_sts_success;
161:
162: l_progress := 'Delete from packaging history of all content packages';
163: FORALL i IN p_lpn_id_table.first..p_lpn_id_table.last
164: DELETE FROM WMS_PACKAGING_HIST
165: WHERE rowid in ( SELECT rowid FROM WMS_PACKAGING_HIST
166: START WITH parent_lpn_id = p_lpn_id_table(i)
167: CONNECT BY parent_package_id = PRIOR package_id );
168:

Line 165: WHERE rowid in ( SELECT rowid FROM WMS_PACKAGING_HIST

161:
162: l_progress := 'Delete from packaging history of all content packages';
163: FORALL i IN p_lpn_id_table.first..p_lpn_id_table.last
164: DELETE FROM WMS_PACKAGING_HIST
165: WHERE rowid in ( SELECT rowid FROM WMS_PACKAGING_HIST
166: START WITH parent_lpn_id = p_lpn_id_table(i)
167: CONNECT BY parent_package_id = PRIOR package_id );
168:
169: IF ( p_purge_count.exists(1) ) THEN

Line 291: l_purge_count(1) := 0; -- WMS_PACKAGING_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
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

Line 404: FND_MESSAGE.SET_TOKEN('TABLE','WMS_PACKAGING_HIST');

400: CLOSE LPNS_FOR_PURGE;
401:
402: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
403: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(1));
404: FND_MESSAGE.SET_TOKEN('TABLE','WMS_PACKAGING_HIST');
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));