select pm_task__new_task_item ( :task_revision_id, :project_item_id, :title, :description, to_timestamp(:start_date,'YYYY MM DD HH24 MI SS'), to_timestamp(:end_date,'YYYY MM DD HH24 MI SS'), :percent_complete, now(), :user_id, :peeraddr, :package_id ); select pm_project__new_task_revision ( :task_revision_id, :project_item_id, :title, :description, to_timestamp(:start_date,'YYYY MM DD HH24 MI SS'), to_timestamp(:end_date,'YYYY MM DD HH24 MI SS'), :percent_complete, now(), :user_id, :peeraddr, :package_id ); select task_revision_id, title, item_id, description, name, parent_id, to_char(start_date,'YYYY MM DD') as start_date, to_char(end_date,'YYYY MM DD') as end_date, percent_complete FROM pm_tasks_revisionsx WHERE task_revision_id = :task_revision_id