postgresql7.1
select recurrence__new(:interval_type,
:every_n,
:days_of_week,
:recur_until,
NULL)
select acs_event__insert_instances(:cal_item_id, NULL);
select acs_activity__new (
null,
:name,
:description,
'f',
null,
'acs_activity',
now(),
:creation_user,
:creation_ip,
null
)
select timespan__new (
:start_date::timestamptz,
:end_date::timestamptz
)
select cal_item__new (
null,
:calendar_id,
:name,
null,
null,
null,
:timespan_id,
:activity_id,
null,
'cal_item',
:calendar_id,
now(),
:creation_user,
:creation_ip,
:package_id,
:location,
:related_link_url,
:related_link_text,
:redirect_to_rel_link_p
)
select cal_item__delete (
:cal_item_id
)
select time_interval__edit (
:interval_id,
:start_date::timestamptz,
:end_date::timestamptz
)
select cal_item__delete_all (
:recurrence_id
)
select
acs_event__recurrence_timespan_edit (
:event_id,
:start_date,
:end_date
)
select cal_uid__upsert(:cal_uid, :activity_id, :ical_vars) from dual