Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/sample-article-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/sample-article-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/sample-article-create.sql	13 Apr 2001 13:36:02 -0000	1.4
+++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/sample-article-create.sql	14 May 2001 23:16:08 -0000	1.5
@@ -186,9 +186,11 @@
   v_object_name                       text;
   v_transition_name                   wf_transitions.transition_name%TYPE;
   v_name                              varchar(1000);
+  v_subject                           text default '''';
+  v_body                              text default '''';
 begin
         select to_char(ta.deadline,''Mon fmDDfm, YYYY HH24:MI:SS''),
-               acs_object.name(c.object_id),
+               acs_object__name(c.object_id),
                tr.transition_name
         into   v_deadline_pretty,
                v_object_name, 
@@ -199,10 +201,10 @@
         and    tr.workflow_key = c.workflow_key
         and    tr.transition_key = ta.transition_key;
 
-	notification__subject := ''Assignment: '' || v_transition_name || '' '' || 
-                   v_object_name;
+	v_subject := ''Assignment: '' || v_transition_name || '' '' || 
+                     v_object_name;
 
-	notification__body := ''Dear '' || acs_object__name(notification__party_to) || ''
+	v_body := ''Dear '' || acs_object__name(notification__party_to) || ''
 '' || ''
 Today, you have been assigned to a task.
 '' || ''
@@ -211,7 +213,7 @@
 '';
 
         if v_deadline_pretty != '''' then
-           notification__ body := notification__body || ''Deadline: '' || v_deadline_pretty || ''
+           v_body := v_body || ''Deadline: '' || v_deadline_pretty || ''
 '';
         end if;
 
