--
-- notification_type__new/9
--
create or replace function notification_type__new(
  integer,
  integer,
  character varying,
  character varying,
  character varying,
  timestamp with time zone,
  integer,
  character varying,
  integer
) returns int4 as $$

DECLARE
	p_type_id			alias for $1;
        p_sc_impl_id                    alias for $2;
	p_short_name			alias for $3;
	p_pretty_name			alias for $4;
	p_description			alias for $5;
	p_creation_date			alias for $6;
	p_creation_user			alias for $7;
	p_creation_ip			alias for $8;
	p_context_id			alias for $9;
	v_type_id			integer;
BEGIN
	v_type_id:= acs_object__new (
				    p_type_id,
				    'notification_type',
				    p_creation_date,
				    p_creation_user,
				    p_creation_ip,
				    p_context_id);

      insert into notification_types
      (type_id, sc_impl_id, short_name, pretty_name, description) values
      (v_type_id, p_sc_impl_id, p_short_name, p_pretty_name, p_description);
      
      return v_type_id;
END;
$$ language plpgsql;