select pm_project__new_project_item ( :project_id, :project_name, :project_code, :parent_id, :goal, :description, to_timestamp(:planned_start_date,'YYYY MM DD HH24 MI SS'), to_timestamp(:planned_end_date,'YYYY MM DD HH24 MI SS'), null, null, :ongoing_p, now(), :user_id, :peeraddr, :package_id ); select pm_project__new_project_revision ( :project_item_id, :project_name, :project_code, :parent_id, :goal, :description, to_timestamp(:planned_start_date,'YYYY MM DD HH24 MI SS'), to_timestamp(:planned_end_date,'YYYY MM DD HH24 MI SS'), null, null, :ongoing_p, now(), :user_id, :peeraddr, :package_id ); select item_id as project_item_id, parent_id, project_id, title as project_name, project_code, goal, description, to_char(planned_start_date,'YYYY MM DD') as planned_start_date, to_char(planned_end_date,'YYYY MM DD') as planned_end_date, ongoing_p FROM pm_projectsx where project_id = :project_id