Index: openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs-oracle.xql,v
diff -u -r1.1 -r1.1.10.1
--- openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs-oracle.xql	9 Oct 2001 04:57:37 -0000	1.1
+++ openacs-4/packages/acs-service-contract/tcl/acs-service-contract-procs-oracle.xql	3 Dec 2003 22:19:05 -0000	1.1.10.1
@@ -10,6 +10,35 @@
 </querytext>
 </fullquery>
 
+<fullquery name="acs_sc_get_alias.get_alias">
+<querytext>
+	select 
+	    element_name, 
+	    acs_sc_msg_type.get_name(element_msg_type_id) as element_msg_type_name,
+	    element_msg_type_isset_p,
+	    element_pos
+	from acs_sc_msg_type_elements
+	where msg_type_id = :operation_outputtype_id
+	order by element_pos asc
+</querytext>
+</fullquery>
+
+
+<fullquery name="acs_sc_proc.get_operation_definition">
+<querytext>
+	select 
+	    operation_desc,
+	    operation_iscachable_p,
+	    operation_nargs,
+	    operation_inputtype_id,
+	    operation_outputtype_id
+	from acs_sc_operations
+	where contract_name = :contract
+	and operation_name = :operation
+</querytext>
+</fullquery>
+
+
 <fullquery name="acs_sc_proc.operation_inputtype_element">
 <querytext>
 	select