Index: openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql,v
diff -u -r1.19 -r1.20
--- openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql	2 Mar 2004 17:01:47 -0000	1.19
+++ openacs-4/packages/acs-content-repository/sql/oracle/content-item.sql	4 Mar 2004 14:52:35 -0000	1.20
@@ -74,9 +74,7 @@
   data	        in cr_revisions.content%TYPE default null,
   relation_tag  in cr_child_rels.relation_tag%TYPE default null,
   is_live       in char default 'f',
-  storage_type  in cr_items.storage_type%TYPE default 'lob',
-  package_id    in acs_objects.package_id%TYPE default null
-
+  storage_type  in cr_items.storage_type%TYPE default 'lob'
 ) return cr_items.item_id%TYPE
 is
   v_parent_id      cr_items.parent_id%TYPE;
@@ -86,7 +84,6 @@
   v_title	   cr_revisions.title%TYPE;
   v_rel_id	   acs_objects.object_id%TYPE;
   v_rel_tag        cr_child_rels.relation_tag%TYPE;
-  v_package_id     acs_objects.package_id%TYPE;
   v_context_id     acs_objects.context_id%TYPE;
   v_storage_type   cr_items.storage_type%TYPE;
 begin
@@ -111,12 +108,6 @@
     v_parent_id := parent_id;
   end if;
 
-  if package_id is null then
-    v_package_id := acs_object.package_id(content_item.get_root_folder(v_parent_id));
-  else
-    v_package_id := package_id;
-  end if;
-
   -- Determine context_id
   if context_id is null then
     v_context_id := v_parent_id;
@@ -175,9 +166,7 @@
 
   v_item_id := acs_object.new(
       object_id	        => content_item.new.item_id,
-      object_type	=> content_item.new.item_subtype,
-      title             => content_item.new.name,
-      package_id        => v_package_id,
+      object_type	=> content_item.new.item_subtype, 
       context_id        => v_context_id,
       creation_date	=> content_item.new.creation_date, 
       creation_user	=> content_item.new.creation_user, 
@@ -204,8 +193,6 @@
 
     v_rel_id := acs_object.new(
       object_type	=> 'cr_item_child_rel',
-      title		=> v_rel_tag || ': ' || v_parent_id || ' - ' || v_item_id,
-      package_id	=> v_package_id,
       context_id	=> v_parent_id
     );
 
@@ -233,7 +220,6 @@
     v_revision_id := content_revision.new(
         item_id	      => v_item_id,
 	title	      => v_title,
-        package_id    => v_package_id,
 	description   => content_item.new.description,
 	data	      => content_item.new.data,
 	mime_type     => content_item.new.mime_type,
@@ -249,7 +235,6 @@
     v_revision_id := content_revision.new(
 	item_id	      => v_item_id,
 	title	      => v_title,
-        package_id    => v_package_id,
 	description   => content_item.new.description,
 	text	      => content_item.new.text,
 	mime_type     => content_item.new.mime_type,
@@ -649,10 +634,6 @@
     update cr_items
       set name = rename.name
       where item_id = rename.item_id;
-
-    update acs_objects
-      set title = rename.name
-      where object_id = rename.item_id;
   else
     close exists_cur;
     if exists_id <> rename.item_id then
@@ -1252,12 +1233,6 @@
       where item_id = move.item_id;
     end if;
 
-    if name is not null then
-      update acs_objects
-        set title = move.name
-        where object_id = move.item_id;
-    end if;
-
   end if;
 end move;
 
@@ -1609,7 +1584,6 @@
   v_rel_id		integer;
   v_exists		integer;
   v_order_n		cr_item_rels.order_n%TYPE;
-  v_package_id          acs_objects.package_id%TYPE;
 begin
 
   -- check the relationship is valid
@@ -1648,7 +1622,6 @@
       v_exists := 0;
     end;
 
-    v_package_id := acs_object.package_id(relate.item_id);
 
     -- if order_n is null, use rel_id (the order the item was related)
     if relate.order_n is null then
@@ -1663,8 +1636,6 @@
       --dbms_output.put_line( 'creating new relationship...');
       v_rel_id := acs_object.new(
         object_type     => relation_type,
-        title           => relation_tag || ': ' || relate.item_id || ' - ' || relate.object_id,
-        package_id      => v_package_id,
         context_id      => item_id
       );
       insert into cr_item_rels (
@@ -1681,10 +1652,6 @@
         order_n = v_order_n
       where
         rel_id = v_rel_id;
-
-      update acs_objects set
-        title = relate.relation_tag || ': ' || relate.item_id || ' - ' || relate.object_id
-      where object_id = v_rel_id;
     end if;
 
   end if;