Index: openacs-4/packages/acs-service-contract/acs-service-contract.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/acs-service-contract.info,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-service-contract/acs-service-contract.info	21 Oct 2001 18:16:34 -0000	1.3
+++ openacs-4/packages/acs-service-contract/acs-service-contract.info	31 Jan 2002 03:04:32 -0000	1.4
@@ -19,7 +19,6 @@
 
         <files>
             <file type="package_spec" path="acs-service-contract.info"/>
-            <file path="acs-service-contract.info~"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/acs-sc-msg-types-create.sql"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/acs-sc-msg-types-drop.sql"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/acs-sc-object-types-create.sql"/>
@@ -52,12 +51,21 @@
             <file type="tcl_init" path="tcl/acs-service-contract-init.tcl"/>
             <file type="query_file" db_type="oracle" path="tcl/acs-service-contract-procs-oracle.xql"/>
             <file type="tcl_procs" path="tcl/acs-service-contract-procs.tcl"/>
+            <file type="query_file" db_type="oracle" path="www/binding-install-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/binding-install-postgresql.xql"/>
             <file type="tcl_util" path="www/binding-install.tcl"/>
+            <file type="query_file" db_type="oracle" path="www/binding-uninstall-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/binding-uninstall-postgresql.xql"/>
             <file type="tcl_util" path="www/binding-uninstall.tcl"/>
             <file type="documentation" path="www/doc/index.html"/>
+            <file type="documentation" path="www/doc/index.stx"/>
+            <file type="documentation" path="www/doc/index.xml"/>
             <file type="documentation" path="www/doc/notes.html"/>
+            <file type="query_file" db_type="oracle" path="www/index-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/index-postgresql.xql"/>
             <file path="www/index.adp"/>
             <file type="tcl_util" path="www/index.tcl"/>
+            <file type="query_file" path="www/index.xql"/>
         </files>
         <parameters>
         <!-- No version parameters -->
Index: openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-packages-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-packages-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-packages-create.sql	9 Oct 2001 05:41:20 -0000	1.4
+++ openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-packages-create.sql	31 Jan 2002 03:04:32 -0000	1.5
@@ -14,7 +14,7 @@
 
    function get_name (
        contract_id	in acs_sc_contracts.contract_id%TYPE
-   ) return acs_sc_contracts.contract_id%TYPE;
+   ) return acs_sc_contracts.contract_name%TYPE;
 
    procedure delete (
        contract_name	in acs_sc_contracts.contract_name%TYPE default null,
@@ -165,7 +165,7 @@
 
    function get_name (
        contract_id	in acs_sc_contracts.contract_id%TYPE
-   ) return acs_sc_contracts.contract_id%TYPE
+   ) return acs_sc_contracts.contract_name%TYPE
    is
        v_contract_name	acs_sc_contracts.contract_name%TYPE;
    begin
Index: openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-tables-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-tables-create.sql	9 Oct 2001 05:37:38 -0000	1.2
+++ openacs-4/packages/acs-service-contract/sql/oracle/acs-sc-tables-create.sql	31 Jan 2002 03:04:32 -0000	1.3
@@ -82,14 +82,3 @@
 			      references acs_sc_impls(impl_id)
 			      on delete cascade
 );
-
-
-
-
-
-
-
-
-
-
-
Index: openacs-4/packages/acs-service-contract/www/binding-install-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/binding-install-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/binding-install-oracle.xql	31 Jan 2002 03:04:32 -0000	1.1
@@ -0,0 +1,15 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="binding_install">      
+      <querytext>
+         begin
+           select acs_sc_binding.new(:contract_id,:impl_id)
+         end;
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/acs-service-contract/www/binding-install-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/binding-install-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/binding-install-postgresql.xql	31 Jan 2002 03:04:32 -0000	1.1
@@ -0,0 +1,13 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="binding_install">      
+      <querytext>
+         select acs_sc_binding__new(:contract_id,:impl_id)
+      </querytext>
+</fullquery>
+ 
+</queryset>
+
Index: openacs-4/packages/acs-service-contract/www/binding-uninstall-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/binding-uninstall-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/binding-uninstall-oracle.xql	31 Jan 2002 03:04:32 -0000	1.1
@@ -0,0 +1,15 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="binding_uninstall">      
+      <querytext>
+         begin
+           select acs_sc_binding.delete(:contract_id,:impl_id)
+         end;
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/acs-service-contract/www/binding-uninstall-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/binding-uninstall-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/binding-uninstall-postgresql.xql	31 Jan 2002 03:04:32 -0000	1.1
@@ -0,0 +1,13 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="file_select">      
+      <querytext>
+         select acs_sc_binding__delete(:contract_id,:impl_id)
+      </querytext>
+</fullquery>
+ 
+</queryset>
+
Index: openacs-4/packages/acs-service-contract/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/index-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/index-oracle.xql	31 Jan 2002 03:04:32 -0000	1.1
@@ -0,0 +1,19 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="valid_installed_binding">      
+      <querytext>
+        select 
+            contract_id,
+            impl_id,
+            acs_sc_contract.get_name(contract_id) as contract_name,
+            acs_sc_impl.get_name(impl_id) as impl_name
+        from
+            acs_sc_bindings
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/acs-service-contract/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/index-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/index-postgresql.xql	31 Jan 2002 03:04:32 -0000	1.1
@@ -0,0 +1,19 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="valid_installed_binding">      
+      <querytext>
+        select 
+            contract_id,
+            impl_id,
+            acs_sc_contract__get_name(contract_id) as contract_name,
+            acs_sc_impl__get_name(impl_id) as impl_name
+        from
+            acs_sc_bindings
+      </querytext>
+</fullquery>
+ 
+</queryset>
+
Index: openacs-4/packages/acs-service-contract/www/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/www/index.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-service-contract/www/index.xql	31 Jan 2002 03:04:32 -0000	1.1
@@ -0,0 +1,27 @@
+<?xml version="1.0"?>
+
+<queryset>
+
+<fullquery name="valid_uninstalled_binding">      
+   <querytext>
+     select contract_id, contract_name, impl_name,impl_id 
+     from valid_uninstalled_bindings;
+   </querytext>
+</fullquery>
+
+<fullquery name="invalid_uninstalled_binding">      
+   <querytext>
+      select contract_id, contract_name, impl_name,impl_id 
+      from invalid_uninstalled_bindings;
+   </querytext>
+</fullquery>
+
+<fullquery name="orphan_implementation">      
+   <querytext>
+      select impl_id, impl_name, impl_contract_name  
+      from orphan_implementations
+   </querytext>
+</fullquery>
+ 
+</queryset>
+