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