Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/sample-article-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/sample-article-create.sql,v diff -u -N -r1.4 -r1.5 --- openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/sample-article-create.sql 19 Nov 2001 18:17:46 -0000 1.4 +++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/oracle/sample-article-create.sql 9 Feb 2002 02:33:35 -0000 1.5 @@ -265,15 +265,18 @@ task_id in number, custom_arg in varchar2, party_to in integer, - party_from in out integer, - subject in out varchar2, - body in out varchar2 + party_from in integer, + subject in varchar2, + body in varchar2 ) is v_deadline_pretty varchar2(400); v_object_name varchar2(4000); v_transition_name wf_transitions.transition_name%TYPE; v_name varchar2(1000); + v_subject varchar2; + v_body varchar2; + v_request_id integer; begin select to_char(ta.deadline,'Mon fmDDfm, YYYY HH24:MI:SS'), acs_object.name(c.object_id), @@ -287,8 +290,8 @@ and tr.workflow_key = c.workflow_key and tr.transition_key = ta.transition_key; - subject := 'Assignment: '||v_transition_name||' '||v_object_name; - body := 'Dear '||acs_object.name(party_to)||' + v_subject := 'Assignment: '||v_transition_name||' '||v_object_name; + v_body := 'Dear '||acs_object.name(party_to)||' '||' Today, you have been assigned to a task. '||' @@ -300,6 +303,12 @@ body := body ||'Deadline: '||v_deadline_pretty||' '; end if; + v_request_id := acs_mail_nt.post_request ( + party_from => party_from, + party_to => party_to, + subject => v_subject, + message => v_body + ); end notification; end wf_article_callback;