eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_PURGE_PVT dependencies on FND_DATE

Line 274: l_date := FND_DATE.canonical_to_date(p_purge_date);

270: IF ((p_purge_date IS NOT NULL OR p_purge_age is not null) AND p_orgid IS NOT NULL) THEN
271: IF ( p_purge_age IS NOT NULL AND p_purge_date IS NULL ) THEN
272: l_date := sysdate -p_purge_age;
273: ELSIF ( p_purge_age IS NULL AND p_purge_date IS NOT NULL ) THEN
274: l_date := FND_DATE.canonical_to_date(p_purge_date);
275: ELSIF ( p_purge_age IS NOT NULL AND p_purge_date IS NOT NULL ) THEN
276: l_date := least(FND_DATE.canonical_to_date(p_purge_date),trunc(sysdate)-p_purge_age);
277: END IF;
278:

Line 276: l_date := least(FND_DATE.canonical_to_date(p_purge_date),trunc(sysdate)-p_purge_age);

272: l_date := sysdate -p_purge_age;
273: ELSIF ( p_purge_age IS NULL AND p_purge_date IS NOT NULL ) THEN
274: l_date := FND_DATE.canonical_to_date(p_purge_date);
275: ELSIF ( p_purge_age IS NOT NULL AND p_purge_date IS NOT NULL ) THEN
276: l_date := least(FND_DATE.canonical_to_date(p_purge_date),trunc(sysdate)-p_purge_age);
277: END IF;
278:
279: FND_MSG_PUB.DELETE_msg;
280: IF ( p_purge_type = DEVICE OR p_purge_type IS NULL ) THEN