select pm_task__new_task_revision (
:task_id,
:project_item_id,
:task_title,
:description,
[project_manager::project::util::datenvl -value $end_date -value_if_null "null," -value_if_not_null "to_timestamp('$end_date','YYYY MM DD HH24 MI SS'),"]
:percent_complete,
:estimated_hours_work,
:estimated_hours_work_min,
:estimated_hours_work_max,
:actual_hours_worked,
now(),
:user_id,
:peeraddr,
:package_id
);
SELECT
t.parent_id as project_item_id
FROM
pm_tasks_revisionsx t, cr_items i
WHERE
i.item_id = t.item_id and
t.revision_id = i.live_revision and
t.item_id = :task_id
select
t.task_revision_id,
t.title as task_title,
t.item_id,
t.description,
t.name,
t.parent_id,
to_char(t.end_date,'YYYY MM DD') as end_date,
t.percent_complete,
t.estimated_hours_work,
t.estimated_hours_work_min,
t.estimated_hours_work_max,
t.actual_hours_worked
FROM
pm_tasks_revisionsx t, cr_items i
WHERE
t.item_id = :task_id and
t.revision_id = i.live_revision