Index: openacs-4/packages/curriculum-central/tcl/uos-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/curriculum-central/tcl/uos-procs-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/curriculum-central/tcl/uos-procs-postgresql.xql	11 Dec 2005 07:47:40 -0000	1.1
+++ openacs-4/packages/curriculum-central/tcl/uos-procs-postgresql.xql	15 Dec 2005 06:27:41 -0000	1.2
@@ -3,9 +3,13 @@
 <queryset>
    <rdbms><type>postgresql</type><version>7.4</version></rdbms>
 
-   <fullquery name="curriculum_central::uos::get_unit_coordinator::get_assignees.select_unit_coordinators">
+   <fullquery name="curriculum_central::uos::get.select_latest_uos_data">
      <querytext>
-       SELECT staff_id FROM cc_staff
+       SELECT *
+       FROM cc_uos u, cc_uos_revisions r, cr_items i
+       WHERE u.uos_id = :uos_id
+       AND i.item_id = u.uos_id
+       AND r.uos_revision_id = i.latest_revision
      </querytext>
    </fullquery>
 
@@ -15,4 +19,37 @@
      </querytext>
    </fullquery>
 
+   <fullquery name="curriculum_central::uos::new.get_stream_coordinator_ids">
+     <querytext>
+       SELECT DISTINCT coordinator_id FROM cc_stream
+       WHERE package_id = :package_id
+     </querytext>
+   </fullquery>
+
+   <fullquery name="curriculum_central::uos::update.update_uos">
+     <querytext>
+       SELECT cc_uos_revision__new (
+           null,
+           :uos_id,
+	   :uos_code,
+	   :uos_name,
+	   :credit_value,
+	   :semester,
+	   :online_course_content,
+	   :unit_coordinator_id,
+	   :contact_hours,
+	   :assessments,
+	   :core_uos_for,
+	   :recommended_uos_for,
+	   :prerequisites,
+	   :objectives,
+	   :outcomes,
+	   :activity_log,
+	   :activity_log_format,
+	   now(),
+	   :creation_user,
+	   :creation_ip
+       );
+     </querytext>
+   </fullquery>
 </queryset>