select cast( to_char( current_timestamp at time zone :system_timezone - current_timestamp at time zone 'UTC' , 'HH24MI') as float) / 100 from dual select default_locale from apm_packages where package_id = :package_id update apm_packages set default_locale = :locale where package_id = :package_id 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 select locale from user_preferences where user_id = :user_id update user_preferences set locale = :locale where user_id = :user_id select count(*) from ad_locale_user_prefs where user_id = :user_id and package_id = :package_id update ad_locale_user_prefs set locale = :locale where user_id = :user_id and package_id = :package_id insert into ad_locale_user_prefs (user_id, package_id, locale) values (:user_id, :package_id, :locale) delete from ad_locale_user_prefs where user_id = :user_id and package_id = :package_id update user_preferences set timezone = :timezone where user_id = :user_id select timezone from user_preferences where user_id = :user_id select label, locale from ad_locales where enabled_p = 't'