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 -N -r1.7 -r1.8
--- openacs-4/contrib/obsolete-packages/ticket-tracker/sql/oracle/ticket-tracker-packages.sql	20 Nov 2001 19:42:30 -0000	1.7
+++ openacs-4/contrib/obsolete-packages/ticket-tracker/sql/oracle/ticket-tracker-packages.sql	9 Feb 2002 02:33:36 -0000	1.8
@@ -790,13 +790,17 @@
         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_request_id integer;
         v_url           varchar2(1000);
         v_request_id    integer;
+        v_body          varchar2;
+        v_subject       varchar2;
+        v_party_from    parties.party_id%TYPE;
         cursor ticket_cur is
             select tt.ticket_id,
                    tt.subject,
@@ -819,21 +823,20 @@
         end if;
         close ticket_cur;
 	
-        party_from := ttracker_util.notification_sender(ticket_rec.package_id);
-        subject := 'Ticket #'||ticket_rec.ticket_id||' -- '||custom_arg;
-        body := 'Subject: '||ticket_rec.subject||'
+        v_party_from := ttracker_util.notification_sender(ticket_rec.package_id);
+        v_subject := 'Ticket #'||ticket_rec.ticket_id||' -- '||custom_arg;
+        v_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_from => v_party_from,
             party_to => notification.party_to,
-            expand_group => 'f' ,
-            subject => notification.subject,
-            message => notification.body,
+            subject => v_subject,
+            message => v_body,
             max_retries => 0
         );