Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package-body.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package-body.sql,v diff -u -r1.1 -r1.2 --- openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package-body.sql 19 Nov 2001 18:20:33 -0000 1.1 +++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package-body.sql 24 Dec 2001 02:50:17 -0000 1.2 @@ -1449,10 +1449,9 @@ end;' language 'plpgsql'; +-- The next two functions are called periodically by a scheduled Tcl script. - - /* This procedure should be scheduled to run as a dbms_job. */ -create function sweep_timed_transitions () returns integer as ' +create function workflow_case__sweep_timed_transitions () returns integer as ' declare v_journal_id integer; trans_rec record; @@ -1498,8 +1497,7 @@ end;' language 'plpgsql'; - /* This procedure should be scheduled to run as a dbms_job. */ -create function sweep_hold_timeout () returns integer as ' +create function workflow_case__sweep_hold_timeout () returns integer as ' declare v_journal_id integer; task_rec record; @@ -1535,7 +1533,7 @@ end loop; - returns 0; + return 0; end;' language 'plpgsql'; -- procedure notify_assignee