select calendar_id
from calendars
where private_p = 'f' and package_id = :community_package_id
select cal_item_id
from evaluation_cal_task_map
where task_item_id = :item_id
update cr_revisions
set content = :filename,
mime_type = :mime_type,
content_length = :content_length
where revision_id = :revision_id
insert into evaluation_cal_task_map (
task_item_id,
cal_item_id
) values
(
:item_id,
:cal_item_id
)
select task_id from evaluation_tasks where task_id=:task_id and due_date is null
update evaluation_tasks set points=:points,perfect_score=:perfect_score,relative_weight=:relative_weight,forums_related_p=:forums_related_p where task_id=:revision_id