Index: openacs-4/packages/evaluation-portlet/tcl/evaluation-portlet-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation-portlet/tcl/evaluation-portlet-procs-oracle.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/evaluation-portlet/tcl/evaluation-portlet-procs-oracle.xql	7 Apr 2005 18:57:35 -0000	1.2
+++ openacs-4/packages/evaluation-portlet/tcl/evaluation-portlet-procs-oracle.xql	8 Aug 2006 21:26:44 -0000	1.3
@@ -27,4 +27,13 @@
       </querytext>
 </fullquery>
  
+<fullquery name="evaluation_evaluations_portlet::get_package_id_from_key.get_package_id">      
+      <querytext>
+	select dca.package_id 
+	from dotlrn_community_applets dca,apm_packages ap 
+	where community_id=:community_id 
+	and ap.package_id=dca.package_id and ap.package_key=:package_key
+      </querytext>
+</fullquery>
+
 </queryset>