SELECT p.item_id as project_item_id, p.parent_id, p.project_id, p.title as project_name, p.project_code, p.goal, p.description, p.status_id, to_char(p.planned_start_date,'YYYY MM DD') as planned_start_date, to_char(p.planned_end_date,'YYYY MM DD') as planned_end_date, p.ongoing_p FROM pm_projectsx p WHERE p.item_id = :project_item_id and p.project_id = :project_id SELECT current_timestamp FROM pm_projects 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, :status_id, 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, :status_id, now(), :user_id, :peeraddr, :package_id ); SELECT p.item_id as project_item_id FROM pm_projectsx p WHERE p.project_id = :project_id SELECT description, status_id FROM pm_project_status ORDER BY status_type desc, description asc