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