Index: openacs-4/contrib/obsolete-packages/ticket-tracker/sql/oracle/ticket-tracker-packages.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/ticket-tracker/sql/oracle/ticket-tracker-packages.sql,v diff -u -r1.4 -r1.5 --- openacs-4/contrib/obsolete-packages/ticket-tracker/sql/oracle/ticket-tracker-packages.sql 13 Aug 2001 21:31:07 -0000 1.4 +++ openacs-4/contrib/obsolete-packages/ticket-tracker/sql/oracle/ticket-tracker-packages.sql 10 Oct 2001 03:43:18 -0000 1.5 @@ -796,6 +796,7 @@ ) is v_url varchar2(1000); + v_request_id integer; cursor ticket_cur is select tt.ticket_id, tt.subject, @@ -818,12 +819,24 @@ end if; close ticket_cur; - party_from := ttracker_util.notification_sender(ticket_rec.package_id); + party_from := ttracker_util.notification_sender(ticket_rec.package_id); subject := 'Ticket #'||ticket_rec.ticket_id||' -- '||custom_arg; body := 'Subject: '||ticket_rec.subject||' '||'To do: '||custom_arg||' '||'Manage via: '||ttracker_util.workflow_url||'task?task_id='||task_id; + -- notification call moved from acs-workflow to here + -- to retain consistency with postgres version + + v_request_id := acs_mail_nt.post_request ( + party_from => notification.party_from, + party_to => notification.party_to, + expand_group => 'f' , + subject => notification.subject, + message => notification.body, + max_retries => 0 + ); + end notification; procedure notify_admin (