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