[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SF.net SVN: ledger-smb:[4070] branches/1.3/sql/modules/Company.sql



Revision: 4070
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4070&view=rev
Author:   tshvr
Date:     2011-11-25 10:25:27 +0000 (Fri, 25 Nov 2011)
Log Message:
-----------
function entity_credit_save parm in_language renamed to in_language_code

Modified Paths:
--------------
    branches/1.3/sql/modules/Company.sql

Modified: branches/1.3/sql/modules/Company.sql
===================================================================
--- branches/1.3/sql/modules/Company.sql	2011-11-25 10:08:28 UTC (rev 4069)
+++ branches/1.3/sql/modules/Company.sql	2011-11-25 10:25:27 UTC (rev 4070)
@@ -695,7 +695,7 @@
  ) is
 $$ Saves a company.  Returns the id number of the record stored.$$;
 
-CREATE OR REPLACE FUNCTION entity_credit_save (
+DROP FUNCTION IF EXISTS entity_credit_save (
     in_credit_id int, in_entity_class int,
     in_entity_id int, in_description text,
     in_discount numeric, in_taxincluded bool, in_creditlimit numeric, 
@@ -707,6 +707,20 @@
     in_ar_ap_account_id int,
     in_cash_account_id int,
     in_pay_to_name text,
+    in_taxform_id int);
+
+CREATE OR REPLACE FUNCTION entity_credit_save (
+    in_credit_id int, in_entity_class int,
+    in_entity_id int, in_description text,
+    in_discount numeric, in_taxincluded bool, in_creditlimit numeric, 
+    in_discount_terms int,
+    in_terms int, in_meta_number varchar(32), in_business_id int, 
+    in_language_code varchar(6), in_pricegroup_id int, 
+    in_curr char, in_startdate date, in_enddate date, 
+    in_threshold NUMERIC,
+    in_ar_ap_account_id int,
+    in_cash_account_id int,
+    in_pay_to_name text,
     in_taxform_id int
     
 ) returns INT as $$
@@ -738,7 +752,7 @@
                 cash_account_id = in_cash_account_id,
                 meta_number = t_meta_number,
                 business_id = in_business_id,
-                language_code = in_language,
+                language_code = in_language_code,
                 pricegroup_id = in_pricegroup_id,
                 curr = in_curr,
                 startdate = in_startdate,
@@ -785,7 +799,7 @@
                 in_terms,
                 t_meta_number,
                 in_business_id,
-                in_language,
+                in_language_code,
                 in_pricegroup_id,
                 in_curr,
                 in_startdate,
@@ -810,7 +824,7 @@
     in_discount numeric, in_taxincluded bool, in_creditlimit numeric,
     in_discount_terms int,
     in_terms int, in_meta_number varchar(32), in_business_id int,
-    in_language varchar(6), in_pricegroup_id int,
+    in_language_code varchar(6), in_pricegroup_id int,
     in_curr char, in_startdate date, in_enddate date,
     in_threshold NUMERIC,
     in_ar_ap_account_id int,

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.