DBA Data[Home] [Help]

APPS.WMS_PURGE_PVT dependencies on WMS_LABEL_REQUESTS_HIST

Line 446: delete WMS_LABEL_REQUESTS_HIST

442: FND_MSG_PUB.ADD;
443: END IF; --Added bug#4415994
444: IF ( p_purge_type = LABEL OR p_purge_type IS NULL ) THEN
445:
446: delete WMS_LABEL_REQUESTS_HIST
447: where creation_date < l_date and organization_id = p_orgid;
448: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
449: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
450: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LABEL_REQUESTS_HIST');

Line 450: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LABEL_REQUESTS_HIST');

446: delete WMS_LABEL_REQUESTS_HIST
447: where creation_date < l_date and organization_id = p_orgid;
448: FND_MESSAGE.SET_NAME('INV','INV_TOTAL_ROWS');
449: FND_MESSAGE.SET_TOKEN('ROWS',SQL%ROWCOUNT);
450: FND_MESSAGE.SET_TOKEN('TABLE','WMS_LABEL_REQUESTS_HIST');
451: FND_MSG_PUB.ADD;
452:
453: END IF;
454: