--
-- acs_sc_msg_type__get_name/1
--
create or replace function acs_sc_msg_type__get_name(
  integer
) returns varchar as $$

declare
    p_msg_type_id		alias for $1;
    v_msg_type_name		varchar;
begin

    select msg_type_name into v_msg_type_name
    from acs_sc_msg_types
    where msg_type_id = p_msg_type_id;
   
    return v_msg_type_name;

end;$$ language plpgsql;