DBA Data[Home] [Help]

APPS.ICX_CLEAN dependencies on FND_SESSION_VALUES

Line 56: /* Delete rows older than 12 hours. FND_SESSION_VALUES table should be

52: where to_number(to_char(DATESTAMP,'SSSSS'))
53: < to_number(to_char(SYSDATE,'SSSSS')) - (1 * 60 * 60);
54: commit;
55:
56: /* Delete rows older than 12 hours. FND_SESSION_VALUES table should be
57: purged when ICX_SESSIONS table is purged. */
58:
59: delete fnd_session_values
60: where to_number(to_char(TIMESTAMP,'SSSSS'))

Line 59: delete fnd_session_values

55:
56: /* Delete rows older than 12 hours. FND_SESSION_VALUES table should be
57: purged when ICX_SESSIONS table is purged. */
58:
59: delete fnd_session_values
60: where to_number(to_char(TIMESTAMP,'SSSSS'))
61: < to_number(to_char(SYSDATE,'SSSSS')) - (12 * 60 * 60);
62: commit;
63: