Index: openacs-4/packages/cms/www/modules/templates/template-delete-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/www/modules/templates/template-delete-oracle.xql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/cms/www/modules/templates/template-delete-oracle.xql	25 May 2001 23:49:05 -0000	1.1
+++ openacs-4/packages/cms/www/modules/templates/template-delete-oracle.xql	8 Jun 2001 01:44:53 -0000	1.2
@@ -12,5 +12,25 @@
       </querytext>
 </fullquery>
 
+
+<fullquery name="get_status">      
+      <querytext>
+      
+  select 't' from dual 
+    where not exists (
+      select 
+        1 
+      from
+        cr_templates t, acs_objects o
+      where
+        o.object_id = t.template_id
+      and
+        o.context_id = :template_id
+      and not exists (select 1 from cr_revisions 
+                        where revision_id = t.template_id))
+
+      </querytext>
+</fullquery>
+
  
 </queryset>