oracle8.1.6
begin
:1 := category.new (
category_id => :category_id,
locale => :locale,
name => :name,
description => :description,
tree_id => :tree_id,
parent_id => :parent_id,
creation_user => :user_id,
creation_ip => :creation_ip
);
end;
begin
category.new_translation (
category_id => :category_id,
locale => :default_locale,
name => :name,
description => :description,
modifying_user => :user_id,
modifying_ip => :creation_ip
);
end;
begin
category.new_translation (
category_id => :category_id,
locale => :locale,
name => :name,
description => :description,
modifying_user => :user_id,
modifying_ip => :modifying_ip
);
end;
begin
category.edit (
category_id => :category_id,
locale => :locale,
name => :name,
description => :description,
modifying_user => :user_id,
modifying_ip => :modifying_ip
);
end;
begin
category.del ( :category_id );
end;
begin
category.change_parent (
category_id => :category_id,
tree_id => :tree_id,
parent_id => :parent_id
);
end;
begin
category.phase_in(:category_id);
end;
begin
category.phase_out(:category_id);
end;
select acs_object.name(:object_id) from dual