Index: openacs-4/packages/acs-tcl/tcl/apm-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-tcl/tcl/apm-procs-oracle.xql,v
diff -u -N -r1.18 -r1.19
--- openacs-4/packages/acs-tcl/tcl/apm-procs-oracle.xql	7 Aug 2017 23:47:59 -0000	1.18
+++ openacs-4/packages/acs-tcl/tcl/apm-procs-oracle.xql	14 Jun 2018 12:30:58 -0000	1.19
@@ -28,19 +28,6 @@
 </fullquery>
 
  
-<fullquery name="apm_num_instances.apm_num_instances">      
-      <querytext>
-      
-	begin
-	:1 := apm_package.num_instances(
-		package_key => :package_key
-		);
-	end;
-    
-      </querytext>
-</fullquery>
-
- 
 <fullquery name="apm_parameter_register.parameter_register">      
       <querytext>
       
@@ -70,19 +57,7 @@
   </querytext>
 </fullquery>
  
-<fullquery name="apm_parameter_register.apm_parameter_cache_update">      
-      <querytext>
-      
-	select nvl(v.package_id, 0) as package_id, p.parameter_name,
-          decode(v.value_id, null, p.default_value, v.attr_value) as attr_value
-	from apm_parameters p, apm_parameter_values v
-	where p.package_key = :package_key
-	and p.parameter_id = v.parameter_id (+)
-    
-      </querytext>
-</fullquery>
 
- 
 <fullquery name="apm_dependency_add.dependency_add">      
       <querytext>
       
@@ -142,16 +117,6 @@
 </fullquery>
 
  
-<fullquery name="apm_package_version_installed_p.apm_package_version_installed_p">      
-      <querytext>
-      
-	select decode(count(*), 0, 0, 1) from apm_package_versions
-	where package_key = :package_key
-	and version_name = :version_name
-    
-      </querytext>
-</fullquery>
- 
 <fullquery name="apm_package_instance_new.invoke_new">
       <querytext>
       
@@ -177,26 +142,6 @@
   </querytext>
 </fullquery>
 
-<fullquery name="apm_package_url_from_id_mem.apm_package_url_from_id">      
-      <querytext>
-      
-	select site_node.url(min(node_id))
-          from site_nodes 
-         where object_id = :package_id
-    
-      </querytext>
-</fullquery>
-
-<fullquery name="apm_application_new_checkbox.package_types">
-      <querytext>
-        select package_key, pretty_name
-        from apm_package_types
-        where not (apm_package.singleton_p(package_key) = 1 and
-                   apm_package.num_instances(package_key) >= 1)
-        order by pretty_name
-      </querytext>
-</fullquery>
-
   <fullquery name="apm::convert_type.copy_new_params">
     <querytext>
       select apm_parameter_value.new(