APPS.HXT_TIM_COL_UTIL dependencies on FND_SESSIONS

Line 508: Get the current session date from fnd_sessions.

504:
505:
506: /*******************************************************************
507: get_session_date()
508: Get the current session date from fnd_sessions.
509: ********************************************************************/
510: FUNCTION get_session_date(o_sess_date OUT NOCOPY DATE )RETURN NUMBER
511: IS
512: hold_sess_date DATE;

Line 516: -- Check if there exists a cached value before querying on FND_SESSIONS.

512: hold_sess_date DATE;
513: BEGIN
514:
515: -- Bug 7359347
516: -- Check if there exists a cached value before querying on FND_SESSIONS.
517:
518: IF g_session_date.EXISTS(USERENV('SESSIONID'))
519: THEN
520: o_sess_date := g_session_date(USERENV('SESSIONID'));

Line 524: FROM fnd_sessions

520: o_sess_date := g_session_date(USERENV('SESSIONID'));
521: ELSE
522: SELECT effective_date
523: INTO hold_sess_date
524: FROM fnd_sessions
525: WHERE session_id = USERENV('SESSIONID');
526:
527: o_sess_date := hold_sess_date;
528: -- Bug 7359347

Line 543: -- the global g_session_date table instead of FND_SESSIONS if it exists.

539:
540:
541: -- Bug 7359347
542: -- Following function picks up the session date from
543: -- the global g_session_date table instead of FND_SESSIONS if it exists.
544: -- It would call get_session_date above if the value doesnt exist.
545: -- Subsequently, the returned value is cached.
546:
547: FUNCTION return_session_date