postgresql7.1
select acs_permission__grant_permission (
:cal_item_id,
:party_id,
'cal_item_read'
)
select acs_permission__grant_permission (
:cal_item_id,
:party_id,
:permission
)
:cal_item_id,
grantee_id => :party_id,
privilege => :permission
);
end;
-->
select acs_permission__revokke_permission (
:cal_item_id,
:party_id,
:permission
)
select acs_activity__new (
null,
:name,
:description,
'f',
'acs_activity',
now(),
:creation_user,
:creation_ip,
null
)
select timespan__new (
:to_date(:start_date,:date_format),
:to_date(:end_date,:date_format)
)
select cal_item__new (
null,
:on_which_calendar,
null,
null,
:timespan_id,
:activity_id,
null,
'cal_item',
null,
now(),
:creation_user,
:creation_ip
)
select acs_permission__grant_permission (
:cal_item_id,
:grantee_id,
:privilege
)
select time_interval__edit (
:interval_id,
to_date(:start_date,:date_format),
to_date(:end_date,:date_format)
)
select cal_item__delete (
:cal_item_id
)