-- -- category_tree__edit/8 -- create or replace function category_tree__edit( p_tree_id integer, p_locale character varying, p_tree_name character varying, p_description character varying, p_site_wide_p boolean, p_modifying_date timestamp with time zone, p_modifying_user integer, p_modifying_ip character varying ) returns int4 as $$ DECLARE BEGIN update category_trees set site_wide_p = p_site_wide_p where tree_id = p_tree_id; update category_tree_translations set name = p_tree_name, description = p_description where tree_id = p_tree_id and locale = p_locale; 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;