lang::user::package_level_locale_not_cached (private)

 lang::user::package_level_locale_not_cached user_id package_id

Defined in packages/acs-lang/tcl/locale-procs.tcl

Get the user's preferred package level locale for a package given by its package id. Will return the empty string if the user has not preference for the package.

Parameters:

user_id
package_id

Partial Call Graph (max 5 caller/called nodes):

Testcases:

No testcase defined.

Source code:

    return [db_string get_user_locale {} -default ""]

XQL Not present:

PostgreSQL, Oracle

Generic XQL file:

<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>

packages/acs-lang/tcl/locale-procs.xql