DBA Data[Home] [Help]

APPS.INV_LABEL dependencies on FND_TIMEZONES_VL

Line 877: SELECT REPLACE(tz_offset(a.timezone_code),':3',':5') INTO l_tz_offset FROM FND_TIMEZONES_VL a WHERE enabled_flag = 'Y' AND fnd_profile.VALUE('CLIENT_TIMEZONE_ID') = upgrade_tz_id;

873: trace('get_date_time_user CLIENT_TIMEZONE_ID:' || fnd_profile.VALUE('CLIENT_TIMEZONE_ID'), TRACE_PROMPT, TRACE_LEVEL);
874: END IF;
875:
876: IF fnd_profile.VALUE('CLIENT_TIMEZONE_ID') IS NOT NULL THEN
877: SELECT REPLACE(tz_offset(a.timezone_code),':3',':5') INTO l_tz_offset FROM FND_TIMEZONES_VL a WHERE enabled_flag = 'Y' AND fnd_profile.VALUE('CLIENT_TIMEZONE_ID') = upgrade_tz_id;
878: IF (l_debug = 1) THEN
879: trace('l_tz_offset:'||l_tz_offset||'...l_db_offset:'||l_db_offset, TRACE_PROMPT, TRACE_LEVEL);
880: END IF;
881: l_tz_offset_hrs := To_Number(SubStr(l_tz_offset,1,3) || '.' || SubStr(l_tz_offset,5,2));