Index: openacs-4/packages/calendar/sql/oracle/upgrade/upgrade-2.10.0d1-2.10.0d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/calendar/sql/oracle/upgrade/upgrade-2.10.0d1-2.10.0d2.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/calendar/sql/oracle/upgrade/upgrade-2.10.0d1-2.10.0d2.sql	22 Apr 2018 18:02:52 -0000	1.1
+++ openacs-4/packages/calendar/sql/oracle/upgrade/upgrade-2.10.0d1-2.10.0d2.sql	30 Apr 2018 13:54:38 -0000	1.2
@@ -1,4 +1,38 @@
+create or replace package cal_item
+as
+        function new (
+                cal_item_id             in cal_items.cal_item_id%TYPE           default null,
+                on_which_calendar       in calendars.calendar_id%TYPE           ,
+                name                    in acs_activities.name%TYPE             default null,
+                description             in acs_activities.description%TYPE      default null,
+                html_p                  in acs_activities.html_p%TYPE           default 'f',
+                status_summary          in acs_activities.status_summary%TYPE   default null,
+                timespan_id             in acs_events.timespan_id%TYPE          default null,
+                activity_id             in acs_events.activity_id%TYPE          default null,  
+                recurrence_id           in acs_events.recurrence_id%TYPE        default null,
+                item_type_id            in cal_items.item_type_id%TYPE default null,
+                object_type             in acs_objects.object_type%TYPE         default 'cal_item',
+                context_id              in acs_objects.context_id%TYPE          default null,
+                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,
+                location                in acs_event.location%TYPE              default null
+        ) return cal_items.cal_item_id%TYPE;
+ 
+          -- delete cal_item
+        procedure del (
+                cal_item_id             in cal_items.cal_item_id%TYPE
+        );
 
+        procedure delete_all (
+                recurrence_id           in acs_events.recurrence_id%TYPE
+        );
+        
+end cal_item;
+/
+show errors;
+
 create or replace package body cal_item
 as
         function new (
