postgresql7.1 FIX ME PLSQL FIX ME PLSQL begin category_tree__map( object_id => :object_id, subtree_category_id => :subtree_category_id, tree_id => :tree_id); end; FIX ME PLSQL FIX ME PLSQL begin category_tree__unmap( object_id => :object_id, tree_id => :tree_id); end; FIX ME PLSQL FIX ME PLSQL begin category_tree__copy( source_tree => :source_tree, dest_tree => :dest_tree ); end; FIX ME PLSQL FIX ME PLSQL begin :1 := category_tree__new ( tree_id => :tree_id, tree_name => :name, description => :description, locale => :locale, creation_user => :user_id, creation_ip => :creation_ip, context_id => :context_id ); end; FIX ME PLSQL FIX ME PLSQL begin category_tree__new_translation ( tree_id => :tree_id, tree_name => :name, description => :description, locale => :default_locale, modifying_user => :user_id, modifying_ip => :creation_ip ); end; FIX ME PLSQL FIX ME PLSQL begin category_tree__new_translation ( tree_id => :tree_id, tree_name => :name, description => :description, locale => :locale, modifying_user => :user_id, modifying_ip => :modifying_ip ); end; FIX ME PLSQL FIX ME PLSQL begin category_tree__edit ( tree_id => :tree_id, tree_name => :name, description => :description, locale => :locale, modifying_user => :user_id, modifying_ip => :modifying_ip ); end; FIX ME PLSQL FIX ME PLSQL begin category_tree__del ( :tree_id ); end; select t.pretty_plural, n.object_id, n.object_name, p.package_id, p.instance_name, acs_permission__permission_p(n.object_id, :user_id, 'read') as read_p from category_tree_map m, acs_named_objects n, apm_packages p, apm_package_types t where m.tree_id = :tree_id and n.object_id = m.object_id and p.package_id = n.package_id and t.package_key = p.package_key