-- -- notification_delivery_method__new/8 -- create or replace function notification_delivery_method__new( integer, integer, character varying, character varying, timestamp with time zone, integer, character varying, integer ) returns int4 as $$ declare p_delivery_method_id alias for $1; p_sc_impl_id alias for $2; p_short_name alias for $3; p_pretty_name alias for $4; p_creation_date alias for $5; p_creation_user alias for $6; p_creation_ip alias for $7; p_context_id alias for $8; v_delivery_method_id integer; begin v_delivery_method_id := acs_object__new( p_delivery_method_id, 'notification_delivery_method', p_creation_date, p_creation_user, p_creation_ip, p_context_id ); insert into notification_delivery_methods (delivery_method_id, sc_impl_id, short_name, pretty_name) values (v_delivery_method_id, p_sc_impl_id, p_short_name, p_pretty_name); return v_delivery_method_id; end; $$ language plpgsql;