Index: openacs-4/packages/invoices/tcl/offer-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/invoices/tcl/offer-procs.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/invoices/tcl/offer-procs.xql	6 Sep 2005 22:59:05 -0000	1.2
+++ openacs-4/packages/invoices/tcl/offer-procs.xql	19 Sep 2005 21:25:23 -0000	1.3
@@ -97,4 +97,28 @@
       </querytext>
 </fullquery>
 
+<fullquery name="iv::offer::billed_p_not_cached.get_items_count">
+      <querytext>
+	select 
+		count(offer_item_id) 
+	from 	
+		iv_offer_items 
+	where 
+		offer_id = :offer_id
+      </querytext>
+</fullquery>
+
+<fullquery name="iv::offer::billed_p_not_cached.get_billed_items_count">
+      <querytext>
+	select
+		count(i.offer_item_id)
+	from 
+		iv_invoice_items i,
+		iv_offer_items o
+	where
+		i.offer_item_id = o.offer_item_id
+		and o.offer_id = :offer_id
+      </querytext>
+</fullquery>
+
 </queryset>