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 */