Index: openacs-4/packages/invoices/www/offer-accept-2.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/www/offer-accept-2.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/invoices/www/offer-accept-2.xql	11 Oct 2005 15:23:29 -0000	1.3
+++ openacs-4/packages/invoices/www/offer-accept-2.xql	27 Dec 2005 18:45:40 -0000	1.4
@@ -23,4 +23,14 @@
       </querytext>
 </fullquery>
 
+<fullquery name="set_publish_status">
+      <querytext>
+
+    update cr_items
+    set publish_status = 'expired'
+    where item_id = (select item_id from cr_revisions where revision_id = :file_ids)
+
+      </querytext>
+</fullquery>
+
 </queryset>