oracle8.1.6 begin category_tree.map( object_id => :object_id, subtree_category_id => :subtree_category_id, tree_id => :tree_id, assign_single_p => :assign_single_p, require_category_p => :require_category_p, widget => :widget); end; begin category_tree.unmap( object_id => :object_id, tree_id => :tree_id); end; begin category_tree.copy( source_tree => :source_tree, dest_tree => :dest_tree ); end; 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; 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; 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; begin category_tree.edit ( tree_id => :tree_id, tree_name => :name, description => :description, locale => :locale, modifying_user => :user_id, modifying_ip => :modifying_ip ); end; begin category_tree.del ( :tree_id ); end; select t.pretty_plural, n.object_id, n.title, 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_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