postgresql7.3
select status_id
from pm_task_status
where status_type = 'o'
limit 1
select status_id
from pm_task_status
where status_type = 'c'
limit 1
obviously broken
select package_id from surveys
where survey_id=:object_id
select pm_task__new_task_item (
:project_id,
:title,
:description,
:end_date,
:percent_complete,
:estimated_hours_work,
:estimated_hours_work_min,
:estimated_hours_work_max,
:status_id,
coalesce (:creation_date,current_timestamp),
:creation_user,
:creation_ip,
:package_id)