539:
540: ----------------------------------------------------------------------------
541: -- Get information for timezone conversion
542: ----------------------------------------------------------------------------
543: l_server_timezone_id := fnd_profile.value('SERVER_TIMEZONE_ID');
544: l_client_timezone_id := fnd_profile.value('CLIENT_TIMEZONE_ID');
545: l_date_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');
546:
547: ----------------------------------------------------------------------------
540: ----------------------------------------------------------------------------
541: -- Get information for timezone conversion
542: ----------------------------------------------------------------------------
543: l_server_timezone_id := fnd_profile.value('SERVER_TIMEZONE_ID');
544: l_client_timezone_id := fnd_profile.value('CLIENT_TIMEZONE_ID');
545: l_date_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');
546:
547: ----------------------------------------------------------------------------
548: -- creating SELECT,FROM and WHERE clause strings when the reporting view is
541: -- Get information for timezone conversion
542: ----------------------------------------------------------------------------
543: l_server_timezone_id := fnd_profile.value('SERVER_TIMEZONE_ID');
544: l_client_timezone_id := fnd_profile.value('CLIENT_TIMEZONE_ID');
545: l_date_format := fnd_profile.value('ICX_DATE_FORMAT_MASK');
546:
547: ----------------------------------------------------------------------------
548: -- creating SELECT,FROM and WHERE clause strings when the reporting view is
549: -- defined for an Event Class.