oracle8.1.6 begin acs_permission.grant_permission ( object_id => :cal_item_id, grantee_id => :party_id, privilege => 'cal_item_read' ); end; begin acs_permission.grant_permission ( object_id => :cal_item_id, grantee_id => :party_id, privilege => :permission ); end; begin acs_permission.revoke_permission ( object_id => :cal_item_id, grantee_id => :party_id, privilege => :permission ); end; begin :1 := acs_activity.new ( name => :name, description => :description, creation_user => :creation_user, creation_ip => :creation_ip ); end; begin :1 := timespan.new( start_date => to_date(:start_date,:date_format), end_date => to_date(:end_date,:date_format) ); end; begin :1 := cal_item.new( on_which_calendar => :on_which_calendar, activity_id => :activity_id, timespan_id => :timespan_id, item_type_id => :item_type_id, creation_user => :creation_user, creation_ip => :creation_ip ); end; begin acs_permission.grant_permission ( object_id => :cal_item_id, grantee_id => :grantee_id, privilege => :privilege ); end; begin time_interval.edit ( interval_id => :interval_id, start_date => to_date(:start_date,:date_format), end_date => to_date(:end_date,:date_format) ); end; begin cal_item.delete ( cal_item_id => :cal_item_id ); end; begin cal_item.delete_all ( recurrence_id => :recurrence_id ); end; begin acs_event.recurrence_timespan_edit ( event_id => :event_id, start_date => to_date(:start_date,'YYYY-MM-DD HH24:MI'), end_date => to_date(:end_date,'YYYY-MM-DD HH24:MI') ); end;