[OpenbravoERP-commits] devel/pi: Fixes issue 0019213: When you change the project statu...

[hg]

details:   https://code.openbravo.com/erp/devel/pi/rev/8df306c69e74
changeset: 15085:8df306c69e74
user:      Jon Alegría <jon.alegria <at> openbravo.com>
date:      Tue Jan 10 12:17:03 2012 +0100
summary:   Fixes issue 0019213: When you change the project status to order the
aplication can fail

diffstat:

 src-db/database/model/functions/C_CHANGEPROJECTSTATUSTOORDER.xml |  8 ++++----
 1 files changed, 4 insertions(+), 4 deletions(-)

diffs (39 lines):

diff -r b01a64d17251 -r 8df306c69e74 
src-db/database/model/functions/C_CHANGEPROJECTSTATUSTOORDER.xml
--- a/src-db/database/model/functions/C_CHANGEPROJECTSTATUSTOORDER.xml  Tue Jan 
10 11:00:31 2012 +0100
+++ b/src-db/database/model/functions/C_CHANGEPROJECTSTATUSTOORDER.xml  Tue Jan 
10 12:17:03 2012 +0100
@@ -161,7 +161,7 @@
               (
                 v_PriceList, v_AD_Client_ID, v_AD_Org_ID, 'Y',
                 now(), v_AD_User_ID, now(), v_AD_User_ID,
-                (Cur_SO.value || ' - ' || v_BPName), 
+                SUBSTR((Cur_SO.value || ' - ' || v_BPName), 0, 60), 
                                (Cur_SO.value || ' - ' || v_BPName), 
                                'Y', Cur_SO.C_Currency_ID
               )
@@ -205,7 +205,7 @@
               (
                 v_PriceListVersion, v_AD_Client_ID, v_AD_Org_ID, 'Y',
                 now(), v_AD_User_ID, now(), v_AD_User_ID,
-                (Cur_SO.value || ' - ' ||v_BPName|| ' - ' ||TRUNC(now(), 
'DD')), 
+                (SUBSTR(Cur_SO.value || ' - ' ||v_BPName, 0, 55)|| ' - ' 
||TRUNC(now(), 'DD')), 
                                (Cur_SO.value || ' - ' ||v_BPName|| ' - ' 
||TRUNC(now(), 'DD')), 
                                v_PriceList, v_M_Discountschema_ID,
                 TRUNC(now(), 'DD')
@@ -261,7 +261,7 @@
                 (
                   v_PriceListPO, v_AD_Client_ID, v_AD_Org_ID, 'Y',
                   now(), v_AD_User_ID, now(), v_AD_User_ID,
-                  (Cur_SO.value || ' - ' ||v_SupplierName), 
+                  SUBSTR((Cur_SO.value || ' - ' ||v_SupplierName), 0, 60), 
                      (Cur_SO.value || ' - ' ||v_SupplierName),
                          'N', Cur_SO.C_Currency_ID
                 )
@@ -305,7 +305,7 @@
                 (
                   v_PriceListVersionPO, v_AD_Client_ID, v_AD_Org_ID, 'Y',
                   now(), v_AD_User_ID, now(), v_AD_User_ID,
-                  (Cur_SO.value || ' - ' ||v_SupplierName|| ' - ' 
||TRUNC(now(), 'DD')), 
+                  (SUBSTR(Cur_SO.value || ' - ' ||v_SupplierName, 0, 55)|| ' - 
' ||TRUNC(now(), 'DD')), 
                          (Cur_SO.value || ' - ' ||v_SupplierName||' - ' 
||TRUNC(now(), 'DD')), 
                          v_PriceListPO, v_M_Discountschema_ID,
                   TRUNC(now(), 'DD')

------------------------------------------------------------------------------
Write once. Port to many.
Get the SDK and tools to simplify cross-platform app development. Create 
new or port existing apps to sell to consumers worldwide. Explore the 
Intel AppUpSM program developer opportunity. appdeveloper.intel.com/join
http://p.sf.net/sfu/intel-appdev
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits