-- -- 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;