Index: openacs-4/packages/acs-messaging/sql/oracle/acs-messaging-packages.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/sql/oracle/acs-messaging-packages.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/acs-messaging/sql/oracle/acs-messaging-packages.sql	2 Mar 2004 17:02:07 -0000	1.5
+++ openacs-4/packages/acs-messaging/sql/oracle/acs-messaging-packages.sql	4 Mar 2004 14:52:44 -0000	1.6
@@ -27,8 +27,7 @@
         creation_user in acs_objects.creation_user%TYPE default null,
         creation_ip   in acs_objects.creation_ip%TYPE   default null,
         object_type   in acs_objects.object_type%TYPE   default 'acs_message',
-        is_live       in char                           default 't',
-        package_id    in acs_objects.package_id%TYPE    default null
+        is_live       in char                           default 't'
     ) return acs_objects.object_id%TYPE;
 
     function edit (
@@ -89,8 +88,7 @@
         creation_user in acs_objects.creation_user%TYPE default null,
         creation_ip   in acs_objects.creation_ip%TYPE   default null,
         is_live       in char                           default 't',
-        storage_type  in cr_items.storage_type%TYPE	default 'file',
-        package_id    in acs_objects.package_id%TYPE    default null
+        storage_type  in cr_items.storage_type%TYPE	default 'file'
     ) return acs_objects.object_id%TYPE;
 
     function edit_file (
@@ -123,8 +121,7 @@
         creation_user in acs_objects.creation_user%TYPE default null,
         creation_ip   in acs_objects.creation_ip%TYPE   default null,
         is_live       in char                           default 't',
-        storage_type  in cr_items.storage_type%TYPE	default 'file',
-        package_id    in acs_objects.package_id%TYPE    default null
+        storage_type  in cr_items.storage_type%TYPE	default 'file'
     ) return acs_objects.object_id%TYPE;
 
     function edit_image (
@@ -154,8 +151,7 @@
         parent_id     in acs_objects.context_id%TYPE,
         creation_date in acs_objects.creation_date%TYPE default sysdate,
         creation_user in acs_objects.creation_user%TYPE default null,
-        creation_ip   in acs_objects.creation_ip%TYPE   default null,
-        package_id    in acs_objects.package_id%TYPE    default null
+        creation_ip   in acs_objects.creation_ip%TYPE   default null
     ) return cr_extlinks.extlink_id%TYPE;
 
     function edit_extlink (
@@ -197,8 +193,7 @@
         creation_user in acs_objects.creation_user%TYPE default null,
         creation_ip   in acs_objects.creation_ip%TYPE   default null,
         object_type   in acs_objects.object_type%TYPE   default 'acs_message',
-        is_live       in char                           default 't',
-        package_id    in acs_objects.package_id%TYPE    default null
+        is_live       in char                           default 't'
     ) return acs_objects.object_id%TYPE
     is
         v_message_id   acs_messages.message_id%TYPE;
@@ -231,8 +226,7 @@
             creation_date  => creation_date,
             creation_user  => creation_user,
             creation_ip    => creation_ip,
-            item_subtype   => object_type,
-            package_id     => package_id
+            item_subtype   => object_type
         );
 
         insert into acs_messages 
@@ -400,8 +394,7 @@
         creation_user in acs_objects.creation_user%TYPE default null,
         creation_ip   in acs_objects.creation_ip%TYPE   default null,
         is_live       in char                           default 't',
-        storage_type  in cr_items.storage_type%TYPE	default 'file',
-        package_id    in acs_objects.package_id%TYPE    default null
+        storage_type  in cr_items.storage_type%TYPE	default 'file'
     ) return acs_objects.object_id%TYPE
     is
         v_file_id      cr_items.item_id%TYPE;
@@ -415,8 +408,7 @@
             creation_date  => creation_date,
             creation_user  => creation_user,
             creation_ip    => creation_ip,
-            storage_type   => storage_type,
-            package_id     => package_id
+            storage_type   => storage_type
         );
 
         -- create an initial revision for the new attachment
@@ -490,8 +482,7 @@
         creation_user  in acs_objects.creation_user%TYPE  default null,
         creation_ip    in acs_objects.creation_ip%TYPE    default null,
         is_live        in char                            default 't',
-        storage_type   in cr_items.storage_type%TYPE      default 'file',
-        package_id    in acs_objects.package_id%TYPE      default null
+        storage_type   in cr_items.storage_type%TYPE      default 'file'
     ) return acs_objects.object_id%TYPE
     is
         v_image_id     cr_items.item_id%TYPE;
@@ -505,8 +496,7 @@
             creation_date  => creation_date,
             creation_user  => creation_user,
             creation_ip    => creation_ip,
-            storage_type   => storage_type,
-            package_id     => package_id
+            storage_type   => storage_type
         );
 
         -- create an initial revision for the new attachment
@@ -590,8 +580,7 @@
         parent_id      in acs_objects.context_id%TYPE,
         creation_date  in acs_objects.creation_date%TYPE  default sysdate,
         creation_user  in acs_objects.creation_user%TYPE  default null,
-        creation_ip    in acs_objects.creation_ip%TYPE    default null,
-        package_id    in acs_objects.package_id%TYPE      default null
+        creation_ip    in acs_objects.creation_ip%TYPE    default null
     ) return cr_extlinks.extlink_id%TYPE
     is
         v_extlink_id  cr_extlinks.extlink_id%TYPE;
@@ -605,8 +594,7 @@
             extlink_id     => new_extlink.extlink_id,   
             creation_date  => new_extlink.creation_date,
             creation_user  => new_extlink.creation_user,
-            creation_ip    => new_extlink.creation_ip,
-            package_id     => new_extlink.package_id
+            creation_ip    => new_extlink.creation_ip 
         );
     end new_extlink;        
     
