fn_resolve_user_by_name


Parameters

Name Type Mode
i_prop_id integer IN
i_user_name text IN
i_only_active boolean IN (DEFAULT true)
user_id integer OUT
user_name citext OUT
active boolean OUT
password text OUT
user_group_id integer OUT
email text OUT
full_name citext OUT
job_position text OUT
mobile text OUT
telephone text OUT
image_url text OUT
work_shift character varying OUT
work_log_id integer OUT
i_prop_code citext IN
i_user_name text IN
i_only_active boolean IN (DEFAULT true)
user_id integer OUT
user_name citext OUT
active boolean OUT
password text OUT
user_group_id integer OUT
email text OUT
full_name citext OUT
job_position text OUT
mobile text OUT
telephone text OUT
image_url text OUT
work_shift character varying OUT
work_log_id integer OUT

Definition