postgresql7.1 select pm_project__new_project_item ( :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, :organization_id, current_timestamp, :creation_user, :creation_ip, :package_id ); select item_id, content_type from cr_items where parent_id = :project_item_id select sum(t.actual_hours_worked) as actual_hours_completed, sum(t.estimated_hours_work) as estimated_hours_total, to_char(current_timestamp,'J') as today_j from pm_tasks_revisionsx t, cr_items i where t.item_id in ([join $task_list ", "]) and i.live_revision = t.revision_id select t.actual_hours_worked as worked, t.estimated_hours_work as to_work, t.item_id as my_iid, to_char(end_date,'J') as task_deadline_j from pm_tasks_revisionsx t, cr_items i where t.item_id in ([join $task_list ", "]) and i.live_revision = t.revision_id select d.dependency_id, d.task_id as task_item_id, d.parent_task_id, d.dependency_type from pm_task_dependency d where d.task_id in ([join $task_list ", "]) select to_char(planned_start_date,'J') as start_date_j, to_char(planned_end_date,'J') as end_date_j from pm_projects where project_id = (select live_revision from cr_items where item_id = :project_item_id) update pm_projects set actual_hours_completed = :actual_hours_completed, estimated_hours_total = :estimated_hours_total, earliest_finish_date = 'J[expr floor([set max_earliest_finish])]', latest_finish_date = 'J[expr ceil([set min_latest_start])]' where project_id = (select live_revision from cr_items where item_id = :project_item_id) select parent_id from cr_items where item_id = :my_item_id select pm_project__get_root_folder (:package_id, 'f') update pm_tasks_revisions set earliest_start = 'J[expr ceil( [set earliest_start($task_item)])]', earliest_finish = 'J[expr ceil( [set earliest_finish($task_item)])]', latest_start = 'J[expr floor([set latest_start($task_item)])]', latest_finish = 'J[expr floor([set latest_finish($task_item)])]' where task_revision_id = (select live_revision from cr_items where item_id = :task_item)