locale-procs.xql

DB Query file
File Contents

<?xml version="1.0"?>
<queryset>

  <fullquery name="lang::system::timezone_utc_offset.system_utc_offset">
     <querytext>
       select cast(
                to_char(
                  current_timestamp at time zone :system_timezone - current_timestamp at time zone 'UTC'
                , 'HH24MI')
              as float) / 100
         from dual
      </querytext>
   </fullquery>

   <fullquery name="lang::system::package_level_locale_not_cached.get_package_locale">      
      <querytext>
        select default_locale
        from   apm_packages
        where  package_id = :package_id
      </querytext>
   </fullquery>

   <fullquery name="lang::system::set_locale.update_system_locale">
      <querytext>
        update apm_packages
        set    default_locale = :locale 
        where  package_id = :package_id
      </querytext>
   </fullquery>

   <fullquery name="lang::user::package_level_locale_not_cached.get_user_locale">      
      <querytext>
        select coalesce(
                 (select locale
                    from ad_locale_user_prefs
                   where user_id = :user_id
                     and package_id = :package_id),

                 (select default_locale
                   from apm_packages
                  where package_id = :package_id)
         ) from dual
      </querytext>
   </fullquery>

   <fullquery name="lang::user::site_wide_locale_not_cached.get_user_site_wide_locale">
      <querytext>
        select locale
        from   user_preferences
        where  user_id = :user_id
      </querytext>
   </fullquery>

    <fullquery name="lang::user::set_locale.set_user_site_wide_locale">
      <querytext>
        update user_preferences
        set    locale = :locale
        where  user_id = :user_id
      </querytext>
   </fullquery>

   <fullquery name="lang::user::set_locale.user_locale_exists_p">
      <querytext>
        select count(*) 
        from   ad_locale_user_prefs 
        where  user_id = :user_id
        and    package_id = :package_id
      </querytext>
   </fullquery>

   <fullquery name="lang::user::set_locale.update_user_locale">
      <querytext>
        update ad_locale_user_prefs 
        set    locale = :locale 
        where  user_id = :user_id 
        and    package_id = :package_id
      </querytext>
   </fullquery>

   <fullquery name="lang::user::set_locale.insert_user_locale">
      <querytext>
         insert into ad_locale_user_prefs (user_id, package_id, locale) 
        values (:user_id, :package_id, :locale)
      </querytext>
   </fullquery>


   <fullquery name="lang::user::set_locale.delete_user_locale">
      <querytext>
        delete 
        from   ad_locale_user_prefs 
        where  user_id = :user_id 
        and    package_id = :package_id
      </querytext>
   </fullquery>

   <fullquery name="lang::user::set_timezone.set_user_timezone">
      <querytext>
        update user_preferences
        set    timezone = :timezone
        where  user_id = :user_id
      </querytext>
   </fullquery>

   <fullquery name="lang::user::timezone_no_cache.select_user_timezone">
      <querytext>
        select timezone
        from   user_preferences
        where  user_id = :user_id
      </querytext>
   </fullquery>

   <fullquery name="lang::system::get_locale_options_not_cached.select_locales">
      <querytext>
       select label, locale
        from   ad_locales
        where  enabled_p = 't'
      </querytext>
   </fullquery>
 

</queryset>
locale-procs.xql

Related Files

File Contents
