postgresql7.1
FIX ME PLSQL
FIX ME PLSQL
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;
FIX ME PLSQL
FIX ME PLSQL
begin
category__new_translation (
category_id => :category_id,
locale => :default_locale,
name => :name,
description => :description,
modifying_user => :user_id,
modifying_ip => :creation_ip
);
end;
FIX ME PLSQL
FIX ME PLSQL
begin
category__new_translation (
category_id => :category_id,
locale => :locale,
name => :name,
description => :description,
modifying_user => :user_id,
modifying_ip => :modifying_ip
);
end;
FIX ME PLSQL
FIX ME PLSQL
begin
category__edit (
category_id => :category_id,
locale => :locale,
name => :name,
description => :description,
modifying_user => :user_id,
modifying_ip => :modifying_ip
);
end;
FIX ME PLSQL
FIX ME PLSQL
begin
category__del ( :category_id );
end;
FIX ME PLSQL
FIX ME PLSQL
begin
category__change_parent (
category_id => :category_id,
tree_id => :tree_id,
parent_id => :parent_id
);
end;
FIX ME PLSQL
FIX ME PLSQL
begin
category__phase_in(:category_id);
end;
FIX ME PLSQL
FIX ME PLSQL
begin
category__phase_out(:category_id);
end;
select acs_object__name(:object_id)