Index: openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-oracle.xql	22 Jul 2001 06:13:37 -0000	1.2
+++ openacs-4/packages/ecommerce/tcl/ecommerce-customer-service-procs-oracle.xql	26 May 2002 04:36:49 -0000	1.3
@@ -1,37 +1,33 @@
 <?xml version="1.0"?>
 
 <queryset>
-   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+  <rdbms>
+    <type>oracle</type>
+    <version>8.1.6</version>
+  </rdbms>
 
-<fullquery name="ec_customer_service_simple_issue.get_ec_issue_seq">      
-      <querytext>
+  <fullquery name="ec_customer_service_simple_issue.get_ec_issue_seq">      
+    <querytext>
       select ec_issue_id_sequence.NEXTVAL from dual
-      </querytext>
-</fullquery>
+    </querytext>
+  </fullquery>
+  
+  <fullquery name="ec_customer_service_simple_issue.customer_service_interaction_insert">      
+    <querytext>
+      insert into ec_customer_serv_interactions
+      (interaction_id, customer_service_rep, user_identification_id, interaction_date, interaction_originator, interaction_type, interaction_headers)
+      values
+      (:interaction_id, :customer_service_rep, :user_identification_id, sysdate, :interaction_originator, :interaction_type, :interaction_headers)
+    </querytext>
+  </fullquery>
+  
+  <fullquery name="ec_customer_service_simple_issue.customer_service_issue_insert">      
+    <querytext>
+      insert into ec_customer_service_issues
+      (issue_id, user_identification_id, order_id, open_date, close_date, closed_by, gift_certificate_id)
+      values
+      (:issue_id, :user_identification_id, :order_id, sysdate, sysdate, :customer_service_rep, :gift_certificate_id)
+    </querytext>
+  </fullquery>
 
- 
-<fullquery name="ec_customer_service_simple_issue.customer_service_interaction_insert">      
-      <querytext>
-      
-	insert into ec_customer_serv_interactions
-	(interaction_id, customer_service_rep, user_identification_id, interaction_date, interaction_originator, interaction_type, interaction_headers)
-	values
-	(:interaction_id, :customer_service_rep, :user_identification_id, sysdate, :interaction_originator, :interaction_type, :interaction_headers)
-    
-      </querytext>
-</fullquery>
-
- 
-<fullquery name="ec_customer_service_simple_issue.customer_service_issue_insert">      
-      <querytext>
-      
-        insert into ec_customer_service_issues
-	(issue_id, user_identification_id, order_id, open_date, close_date, closed_by, gift_certificate_id)
-        values
-	(:issue_id, :user_identification_id, :order_id, sysdate, sysdate, :customer_service_rep, :gift_certificate_id)
-    
-      </querytext>
-</fullquery>
-
- 
 </queryset>