Remove Qty parameter from M_RESERVATION_POST and M_RESERVE_STOCK_AUTO default tip
authorUnai Martirena <unai.martirena@openbravo.com>
Thu, 05 May 2016 18:36:37 +0200
changeset 28834 a504afa60379
parent 28833 aace3293b8d7
Remove Qty parameter from M_RESERVATION_POST and M_RESERVE_STOCK_AUTO

They are not needed any more. The qty of the reservation is changed in java processes, so we don't need to change in the Stored Procedures
src-db/database/model/functions/M_RESERVATION_POST.xml
src-db/database/model/functions/M_RESERVE_STOCK_AUTO.xml
--- a/src-db/database/model/functions/M_RESERVATION_POST.xml	Mon Mar 21 17:45:33 2016 +0100
+++ b/src-db/database/model/functions/M_RESERVATION_POST.xml	Thu May 05 18:36:37 2016 +0200
@@ -13,9 +13,6 @@
       <parameter name="p_user_id" type="VARCHAR" mode="in">
         <default/>
       </parameter>
-      <parameter name="p_qty" type="NUMERIC" mode="in">
-        <default><![CDATA[NULL]]></default>
-      </parameter>
       <body><![CDATA[/*************************************************************************
 * The contents of this file are subject to the Openbravo  Public  License
 * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
@@ -420,7 +417,7 @@
 
   IF (v_resaction = 'PR') THEN
     -- ADD RESERVED STOCK
-    M_RESERVE_STOCK_AUTO(v_reservation_id, v_user_id, v_message, p_qty);
+    M_RESERVE_STOCK_AUTO(v_reservation_id, v_user_id, v_message);
   END IF;
 
   /* Do not process reservation's with no lines
--- a/src-db/database/model/functions/M_RESERVE_STOCK_AUTO.xml	Mon Mar 21 17:45:33 2016 +0100
+++ b/src-db/database/model/functions/M_RESERVE_STOCK_AUTO.xml	Thu May 05 18:36:37 2016 +0200
@@ -10,9 +10,6 @@
       <parameter name="p_reservedqty" type="NUMERIC" mode="out">
         <default/>
       </parameter>
-      <parameter name="p_qty" type="NUMERIC" mode="in">
-        <default><![CDATA[NULL]]></default>
-      </parameter>
       <body><![CDATA[/*************************************************************************
 * The contents of this file are subject to the Openbravo  Public  License
 * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
@@ -90,10 +87,6 @@
   
   v_pendingqty := v_pendingtoreserveqty;
   
-  IF (p_qty IS NOT NULL) THEN
-    v_pendingqty := p_qty;
-  END IF;
-  
   FOR cur_stock IN (
     SELECT sp.quantity, sp.m_storage_detail_id, w.isallocated
     FROM m_stock_proposed sp