Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/workflow-case-package-head.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/workflow-case-package-head.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/workflow-case-package-head.sql	19 Nov 2001 18:17:46 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/workflow-case-package-head.sql	3 Jan 2002 00:58:44 -0000	1.2
@@ -148,7 +148,14 @@
         transition_key  in wf_transitions.transition_key%TYPE
     );
 
+    -- DRB: I added this function because there appeared to be no way for a
+    -- client to get the task_id without querying the wf_tasks table directly,
+    -- breaking the PL/SQL abstraction.
 
+    function get_task_id (
+        case_id         in wf_cases.case_id%TYPE,
+        transition_key  in wf_transitions.transition_key%TYPE
+    ) return wf_tasks.task_id%TYPE;
 
     /* DBMS_JOBS */
 
