APPS.WMS_PURGE_PVT dependencies on WMS_LPN_CONTENTS

Line 189: DELETE FROM WMS_LPN_CONTENTS

185: END IF;
186:
187: l_progress := 'Delete all contents for that LPN';
188: FORALL i IN p_lpn_id_table.first..p_lpn_id_table.last
189: DELETE FROM WMS_LPN_CONTENTS
190: WHERE parent_lpn_id = p_lpn_id_table(i);
191:
192: IF ( p_purge_count.exists(3) ) THEN
193: p_purge_count(3) := NVL(p_purge_count(3), 0) + SQL%ROWCOUNT;

Line 293: l_purge_count(3) := 0; -- WMS_LPN_CONTENTS

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:
297: OPEN LPNS_FOR_PURGE;

Line 414: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_CONTENTS');

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));
414: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LPN_CONTENTS');
415: FND_MSG_PUB.ADD;
416:
417: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
418: FND_MESSAGE.SET_TOKEN('ROWS', l_purge_count(4));