select pm_task__new_task_item ( null, :project_item_id, '$task_title($i)', '$description($i)', [project_manager::project::util::datenvl -value [set end_date_$i] -value_if_null "null," -value_if_not_null "to_timestamp('[set end_date_$i]','YYYY MM DD HH24 MI SS'),"] '0', '$estimated_hours_work($i)', '$estimated_hours_work_min($i)', '$estimated_hours_work_max($i)', now(), :user_id, :peeraddr, :package_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 FROM pm_tasks_revisionsx t, cr_items i WHERE t.item_id = :task_id and t.revision_id = i.live_revision