-- -- category_tree__new_translation/7 -- create or replace function category_tree__new_translation( integer, character varying, character varying, character varying, timestamp with time zone, integer, character varying ) returns int4 as $$ declare p_tree_id alias for $1; p_locale alias for $2; p_tree_name alias for $3; p_description alias for $4; p_modifying_date alias for $5; p_modifying_user alias for $6; p_modifying_ip alias for $7; begin insert into category_tree_translations (tree_id, locale, name, description) values (p_tree_id, p_locale, p_tree_name, p_description); update acs_objects set last_modified = p_modifying_date, modifying_user = p_modifying_user, modifying_ip = p_modifying_ip where object_id = p_tree_id; return 0; end; $$ language plpgsql;