--
-- acs_object_type__pretty_name/1
--
create or replace function acs_object_type__pretty_name(
  character varying
) returns varchar as $$

declare
  pretty_name__object_type            alias for $1;  
  v_pretty_name                       acs_object_types.pretty_name%TYPE;
begin
    select t.pretty_name into v_pretty_name
      from acs_object_types t
     where t.object_type = pretty_name__object_type;

    return v_pretty_name;
   
end;$$ language plpgsql;