[OpenbravoERP-commits] devel/pi: Commit for Database consistency failure.

[hg]

details:   /erp/devel/pi/rev/161d540df8db
changeset: 7884:161d540df8db
user:      Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
date:      Thu Jul 15 08:14:47 2010 +0530
summary:   Commit for Database consistency failure.

diffstat:

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

diffs (21 lines):

diff -r 8b98f543308c -r 161d540df8db 
src-db/database/model/functions/C_ORDER_POST1.xml
--- a/src-db/database/model/functions/C_ORDER_POST1.xml Wed Jul 14 19:09:09 
2010 +0530
+++ b/src-db/database/model/functions/C_ORDER_POST1.xml Thu Jul 15 08:14:47 
2010 +0530
@@ -353,7 +353,7 @@
                 v_QtyOrderPO:=NULL;
               END IF;
               IF(v_DocStatus<>'IP' OR v_DocAction<>'CO') THEN
-               M_UPDATE_STORAGE_PENDING(v_Client_ID, v_Org_ID, v_UpdatedBy, 
Cur_ResLine.M_Product_ID, Cur_ResLine.M_Warehouse_ID, 
Cur_ResLine.M_AttributeSetInstance_ID, Cur_ResLine.C_UOM_ID, 
Cur_ResLine.M_PRODUCT_UOM_ID, v_QtySO, v_QtyOrderSO, v_QtyPO, v_QtyOrderPO) ;
+               M_UPDATE_STORAGE_PENDING(v_Client_ID, v_Org_ID, v_UpdatedBy, 
Cur_ResLine.M_Product_ID, Cur_ResLine.M_Warehouse_ID, 
Cur_ResLine.M_AttributeSetInstance_ID, Cur_ResLine.C_UOM_ID, 
Cur_ResLine.M_PRODUCT_UOM_ID, v_QtySO, v_QtyOrderSO, v_QtyPO, v_QtyOrderPO) ;
               END IF;
             END LOOP;
           -- Set reserved quantity to 0
@@ -987,7 +987,7 @@
     END IF;
    END IF;
    IF(v_DocStatus<>'IP' OR v_DocAction<>'CO') THEN
-               M_UPDATE_STORAGE_PENDING(v_Client_ID, v_Org_ID, v_UpdatedBy, 
Cur_ResLine.M_Product_ID, Cur_ResLine.M_Warehouse_ID, 
Cur_ResLine.M_AttributeSetInstance_ID,
+        M_UPDATE_STORAGE_PENDING(v_Client_ID, v_Org_ID, v_UpdatedBy, 
Cur_ResLine.M_Product_ID, Cur_ResLine.M_Warehouse_ID, 
Cur_ResLine.M_AttributeSetInstance_ID,
           Cur_ResLine.C_UOM_ID, Cur_ResLine.M_PRODUCT_UOM_ID, v_QtySO, 
v_QtyOrderSO, v_QtyPO, v_QtyOrderPO);
     END IF;
    DBMS_OUTPUT.PUT_LINE('Reserved Warehouse=' || Cur_ResLine.M_Warehouse_ID || 
', Product=' || Cur_ResLine.M_Product_ID || ', Attrib=' || 
Cur_ResLine.M_AttributeSetInstance_ID || ', Qty=' || v_QtySO || '/' || v_QtyPO);

------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits