Index: openacs-4/contrib/packages/project-manager/tcl/role-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/tcl/Attic/role-procs-oracle.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/contrib/packages/project-manager/tcl/role-procs-oracle.xql	22 Oct 2004 04:28:35 -0000	1.1.2.1
@@ -0,0 +1,23 @@
+<?xml version="1.0"?>
+
+<queryset>
+  <rdbms><type>oracle</type><version>8.0</version></rdbms>
+
+  <fullquery name="pm::role::default.get_default">
+    <querytext>
+       SELECT role_id 
+       FROM   pm_roles
+       WHERE  rownum = 1
+    </querytext>
+  </fullquery>
+
+
+  <fullquery name="pm::role::select_list_filter_helper.get_roles">
+    <querytext>
+        SELECT one_line || ' (' || substr(one_line,1,1) || ')' as one_line,
+               role_id
+        FROM pm_roles
+        ORDER BY role_id
+    </querytext>
+  </fullquery>
+</queryset>