Index: openacs-4/packages/invoices/www/offer-ae-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/www/offer-ae-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/invoices/www/offer-ae-postgresql.xql	16 Aug 2005 20:04:34 -0000	1.1
+++ openacs-4/packages/invoices/www/offer-ae-postgresql.xql	6 Sep 2005 23:01:24 -0000	1.2
@@ -24,4 +24,35 @@
       </querytext>
 </fullquery>
 
+<fullquery name="set_finish_date">
+      <querytext>
+      
+	    update iv_offers
+	    set finish_date = to_timestamp(:finish_date_list,'YYYY MM DD HH24 MI SS')
+	    where offer_id = :new_offer_rev_id
+    
+      </querytext>
+</fullquery>
+
+<fullquery name="set_accepted_date">
+      <querytext>
+      
+	    update iv_offers
+	    set accepted_date = now()
+	    where offer_id = :new_offer_rev_id
+	    and accepted_date is null
+    
+      </querytext>
+</fullquery>
+
+<fullquery name="set_project_deadline">
+      <querytext>
+      
+		update pm_projects
+		set planned_end_date = to_timestamp(:finish_date_list,'YYYY MM DD HH24 MI SS')
+		where project_id = :project_rev_id
+    
+      </querytext>
+</fullquery>
+
 </queryset>