--
-- acs_sc_msg_type__delete/1
--
create or replace function acs_sc_msg_type__delete(
  integer
) returns int4 as $$

declare
    p_msg_type_id		alias for $1;
begin

    delete from acs_sc_msg_types
    where msg_type_id = p_msg_type_id;

    return 0;

end;$$ language plpgsql;


--
-- acs_sc_msg_type__delete/1
--
create or replace function acs_sc_msg_type__delete(
  character varying
) returns int4 as $$

declare
    p_msg_type_name		alias for $1;
    v_msg_type_id		integer;
begin

    v_msg_type_id := acs_sc_msg_type__get_id(p_msg_type_name);

    perform acs_sc_msg_type__delete(v_msg_type_id);

    return v_msg_type_id;

end;$$ language plpgsql;