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 -N -r1.6 -r1.7
--- openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package-body.sql	21 Dec 2002 22:30:11 -0000	1.6
+++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package-body.sql	17 May 2003 10:08:16 -0000	1.7
@@ -1,6 +1,7 @@
 -- create or replace package body workflow_case
 -- function new
-create function workflow_case__new (integer,varchar,varchar,integer,timestamp with time zone,integer,varchar)
+
+create function workflow_case__new (integer,varchar,varchar,integer,timestamptz,integer,varchar)
 returns integer as '
 declare
   new__case_id                alias for $1;  -- default null  
@@ -855,7 +856,7 @@
 
 
 -- procedure set_case_deadline 
-create function workflow_case__set_case_deadline (integer,varchar,timestamp with time zone)
+create function workflow_case__set_case_deadline (integer,varchar,timestamptz)
 returns integer as '
 declare
   set_case_deadline__case_id		alias for $1;
@@ -986,7 +987,7 @@
 
 -- function execute_time_callback
 create function workflow_case__execute_time_callback (varchar,varchar,integer,varchar)
-returns timestamp as '
+returns timestamptz as '
 declare
   execute_time_callback__callback               alias for $1;  
   execute_time_callback__custom_arg             alias for $2;  
@@ -1016,14 +1017,14 @@
 
 -- function get_task_deadline
 create function workflow_case__get_task_deadline (varchar,varchar,varchar,integer,varchar)
-returns timestamp as '
+returns timestamptz as '
 declare
   get_task_deadline__callback               alias for $1;  
   get_task_deadline__custom_arg             alias for $2;  
   get_task_deadline__attribute_name         alias for $3;  
   get_task_deadline__case_id                alias for $4;  
   get_task_deadline__transition_key         alias for $5;  
-  v_deadline                                timestamp;
+  v_deadline                                timestamptz;
   v_rec                                     record;
   v_str                                     varchar;
 begin
@@ -1070,13 +1071,13 @@
 
 -- function execute_hold_timeout_callback
 create function workflow_case__execute_hold_timeout_callback (varchar,varchar,integer,varchar)
-returns timestamp as '
+returns timestamptz as '
 declare
   execute_hold_timeout_callback__callback               alias for $1;  
   execute_hold_timeout_callback__custom_arg             alias for $2;  
   execute_hold_timeout_callback__case_id                alias for $3;  
   execute_hold_timeout_callback__transition_key         alias for $4;  
-  v_hold_timeout                                        timestamp;
+  v_hold_timeout                                        timestamptz;
   v_rec                                                 record;
   v_str                                                 text;
 begin
@@ -1652,8 +1653,8 @@
   enable_transitions__case_id                alias for $1;  
   v_task_id                                  integer;        
   v_workflow_key                             varchar;  
-  v_trigger_time                             timestamp;     
-  v_deadline_date                            timestamp;     
+  v_trigger_time                             timestamptz;     
+  v_deadline_date                            timestamptz;     
   v_party_from                               integer;       
   v_subject                                  varchar;  
   v_body                                     text; 
@@ -1932,7 +1933,7 @@
   v_transition_key                   varchar(100);  
   v_hold_timeout_callback            varchar(100);  
   v_hold_timeout_custom_arg          varchar(4000); 
-  v_hold_timeout                     timestamp;     
+  v_hold_timeout                     timestamptz;     
   place_rec                          record;
 begin
         PERFORM workflow_case__ensure_task_in_state(start_task__task_id,