oracle9.2 select status_id from pm_project_status where status_type = 'o' and rownum = 1 select status_id from pm_project_status where status_type = 'c' and rownum = 1 select pm_project.get_root_folder (:package_id, 'f') from dual SELECT party_id FROM pm_project_assignment WHERE project_id = :project_item_id and party_id = :party_id and rownum = 1 begin :1 := 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, :logger_project, :ongoing_p, :status_id, :organization_id, sysdate, :creation_user, :creation_ip, :package_id ); end; begin :1 := pm_project.new_project_item ( :project_name, :project_code, :parent_id, :goal, :description, :mime_type, to_timestamp(:planned_start_date,'YYYY MM DD HH24 MI SS'), to_timestamp(:planned_end_date,'YYYY MM DD HH24 MI SS'), null, null, :logger_project, :ongoing_p, :status_id, :organization_id, current_timestamp, :creation_user, :creation_ip, :package_id ); end;