<?xml version="1.0"?>
<queryset>
  <fullquery name="project_query">
    <querytext>
        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.customer_id,
        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 HH24:MI:SS') as planned_end_date,
 	p.ongoing_p,
	p.dform
        FROM
 	pm_projectsx p
        WHERE 
        p.item_id    = :project_item_id and
        p.project_id = :project_id 
    </querytext>
  </fullquery>

  <fullquery name="do_nothing">
    <querytext>
        SELECT
        current_timestamp
    </querytext>
  </fullquery>

  <fullquery name="get_customer_id">
    <querytext>
	select customer_id
	from pm_projects
	where project_id = :project_id
    </querytext>
  </fullquery>

  <fullquery name="get_status_codes">
    <querytext>
	SELECT
        description, status_id
	FROM
	pm_project_status
        ORDER BY
        status_type desc, description asc
    </querytext>
  </fullquery>

</queryset>