details: https://code.openbravo.com/erp/devel/pi/rev/0f26e49c3593
changeset: 20300:0f26e49c3593
user: Javier Etxarri <javier.echarri <at> openbravo.com>
date: Thu May 09 12:11:33 2013 +0200
summary: Fixes issue 23754: Goods receipt lines can not be deleted in Oracle
diffstat:
src-db/database/model/triggers/M_INOUTLINE_TRG.xml | 7 -------
src-db/database/model/triggers/M_INOUT_TRG_PROV.xml | 19 ++-----------------
2 files changed, 2 insertions(+), 24 deletions(-)
diffs (48 lines):
diff -r 1143dac7c18c -r 0f26e49c3593
src-db/database/model/triggers/M_INOUTLINE_TRG.xml
--- a/src-db/database/model/triggers/M_INOUTLINE_TRG.xml Thu May 09
11:52:52 2013 +0530
+++ b/src-db/database/model/triggers/M_INOUTLINE_TRG.xml Thu May 09
12:11:33 2013 +0200
@@ -42,13 +42,6 @@
IF AD_isTriggerEnabled()='N' THEN RETURN;
END IF;
- --We need to check if we need to delete or not the column c_order_id in table
m_inout
- --we are going to delete only if all the related lines with the order has
been deleted. For this reason we need to launch
- --the m_inout trigger to check. Related to issue 22508
- IF (DELETING) THEN
- Update m_inout set description=description where m_inout_id =
:old.m_inout_id;
- END IF;
-
IF (INSERTING) THEN
IF (:NEW.M_PRODUCT_ID IS NOT NULL) THEN
SELECT C_UOM_ID INTO v_UOM_ID FROM M_PRODUCT WHERE
M_PRODUCT_ID=:NEW.M_PRODUCT_ID;
diff -r 1143dac7c18c -r 0f26e49c3593
src-db/database/model/triggers/M_INOUT_TRG_PROV.xml
--- a/src-db/database/model/triggers/M_INOUT_TRG_PROV.xml Thu May 09
11:52:52 2013 +0530
+++ b/src-db/database/model/triggers/M_INOUT_TRG_PROV.xml Thu May 09
12:11:33 2013 +0200
@@ -56,25 +56,10 @@
RAISE_APPLICATION_ERROR(-20000, '@20501@') ;
ELSIF (V_COUNT <> 0) THEN
RAISE_APPLICATION_ERROR(-20000, '@20632@') ;
- ELSE
- UPDATE M_MATCHINV SET DATETRX = :NEW.DATEACCT WHERE
M_INOUTLINE_ID IN (SELECT MI.M_INOUTLINE_ID FROM M_INOUTLINE MI WHERE
MI.M_INOUT_ID = :old.M_INOUT_ID);
+ ELSE
+ UPDATE M_MATCHINV SET DATETRX = :NEW.DATEACCT WHERE M_INOUTLINE_ID IN
(SELECT MI.M_INOUTLINE_ID FROM M_INOUTLINE MI WHERE MI.M_INOUT_ID =
:old.M_INOUT_ID);
END IF;
END IF;
-
-
- If (:Old.C_Order_Id Is Not Null) Then
- SELECT count(*)
- Into V_Count
- FROM c_orderline col
- WHERE col.c_order_id = :old.c_order_id
- AND col.c_orderline_id IN (
- SELECT c_orderline_id
- FROM m_inoutline
- WHERE m_inout_id = :old.m_inout_id);
- If (V_Count = 0) Then
- :new.c_order_id := null;
- END IF;
- END IF;
END IF;
END M_INOUT_TRG_PROV
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and
their applications. This 200-page book is written by three acclaimed
leaders in the field. The early access version is available now.
Download your free book today! http://p.sf.net/sfu/neotech_d2d_may
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
