details: https://code.openbravo.com/erp/devel/pi/rev/be00599a33b8
changeset: 23012:be00599a33b8
user: Rafa de Miguel <rafael.demiguel <at> openbravo.com>
date: Mon May 12 12:26:29 2014 +0200
summary: Fixed issue: 26509: Is not possible to modify a external module
field on table FIN_PAYMENT_DETAIL
diffstat:
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_FIN_PMT_DETAIL_CHECK_TRG.xml
| 15 ++++++++--
1 files changed, 12 insertions(+), 3 deletions(-)
diffs (25 lines):
diff -r 9fa863bf7f35 -r be00599a33b8
modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_FIN_PMT_DETAIL_CHECK_TRG.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_FIN_PMT_DETAIL_CHECK_TRG.xml
Mon May 12 11:45:41 2014 +0200
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/triggers/APRM_FIN_PMT_DETAIL_CHECK_TRG.xml
Mon May 12 12:26:29 2014 +0200
@@ -41,9 +41,18 @@
WHERE FIN_Payment_ID=v_FIN_Payment_ID;
IF (UPDATING) THEN
- IF (v_Processed='Y') THEN
- RAISE_APPLICATION_ERROR(-20000, '@20501@');
- END IF;
+ IF(v_Processed='Y' AND ((COALESCE(:OLD.FIN_PAYMENT_ID, '0') <>
COALESCE(:NEW.FIN_PAYMENT_ID, '0'))
+ OR(COALESCE(:OLD.AMOUNT, 0) <> COALESCE(:NEW.AMOUNT, 0))
+ OR(COALESCE(:OLD.REFUND, '.') <> COALESCE(:NEW.REFUND, '.'))
+ OR(COALESCE(:OLD.WRITEOFFAMT, 0) <> COALESCE(:NEW.WRITEOFFAMT, 0))
+ OR(COALESCE(:OLD.C_GLITEM_ID, '0') <> COALESCE(:NEW.C_GLITEM_ID, '0'))
+ OR(COALESCE(:OLD.ISPREPAYMENT, '.') <> COALESCE(:NEW.ISPREPAYMENT, '.'))
+ OR(COALESCE(:OLD.FIN_PAYMENT_DETAIL_ID, '0') <>
COALESCE(:NEW.FIN_PAYMENT_DETAIL_ID, '0'))
+ OR(COALESCE(:OLD.AD_ORG_ID, '0') <> COALESCE(:NEW.AD_ORG_ID, '0'))
+ OR(COALESCE(:OLD.AD_CLIENT_ID, '0') <> COALESCE(:NEW.AD_CLIENT_ID, '0'))
+ )) THEN
+ RAISE_APPLICATION_ERROR(-20000, '@20501@') ;
+ END IF;
END IF;
IF((DELETING OR INSERTING) AND v_Processed='Y') THEN
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
