Index: openacs-4/packages/acs-api-browser/www/plsql-subprograms-all.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-api-browser/www/plsql-subprograms-all.tcl,v
diff -u -r1.4.28.1 -r1.4.28.2
--- openacs-4/packages/acs-api-browser/www/plsql-subprograms-all.tcl	10 Sep 2015 08:21:11 -0000	1.4.28.1
+++ openacs-4/packages/acs-api-browser/www/plsql-subprograms-all.tcl	27 Oct 2015 22:57:53 -0000	1.4.28.2
@@ -17,13 +17,7 @@
 # Organize the subprograms under three headings: FUNCTION, PROCEDURE,
 # and PACKAGE.
 
-db_multirow all_subprograms all_subprograms {
-    select object_type as type, object_name as name
-    from user_objects
-    where object_type in ('PACKAGE', 'PROCEDURE', 'FUNCTION')
-    order by
-    decode(object_type, 'PACKAGE', 0, 'PROCEDURE', 1, 'FUNCTION', 2) asc
-}
+db_multirow all_subprograms all_subprograms {}
 
 db_release_unused_handles
 ad_return_template