<?xml version="1.0"?>

<queryset>
   <rdbms><type>postgresql</type><version>7.1</version></rdbms>

<fullquery name="add.insert_category">      
      <querytext>
      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;
	    
      </querytext>
</fullquery>

 
<fullquery name="add.insert_default_category">      
      <querytext>
      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;
		
      </querytext>
</fullquery>

 
<fullquery name="update.insert_category_translation">      
      <querytext>
      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;
		
      </querytext>
</fullquery>

 
<fullquery name="update.update_category_translation">      
      <querytext>
      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;
		
      </querytext>
</fullquery>

 
<fullquery name="delete.delete_category">      
      <querytext>
      FIX ME PLSQL
FIX ME PLSQL

	    begin
	    category__del ( :category_id );
	    end;
	
      </querytext>
</fullquery>

 
<fullquery name="change_parent.change_parent_category">      
      <querytext>
      FIX ME PLSQL
FIX ME PLSQL

	    begin
	    category__change_parent (
				    category_id  => :category_id,
				    tree_id      => :tree_id,
				    parent_id    => :parent_id
				    );
	    end;
	
      </querytext>
</fullquery>

 
<fullquery name="phase_in.phase_in">      
      <querytext>
      FIX ME PLSQL
FIX ME PLSQL

	    begin
	    category__phase_in(:category_id);
	    end;
	
      </querytext>
</fullquery>

 
<fullquery name="phase_out.phase_out">      
      <querytext>
      FIX ME PLSQL
FIX ME PLSQL

	    begin
	    category__phase_out(:category_id);
	    end;
	
      </querytext>
</fullquery>

 
<fullquery name="get_object_context.object_name">      
      <querytext>
      select acs_object__name(:object_id) 
      </querytext>
</fullquery>

 
</queryset>