details: https://code.openbravo.com/erp/stable/2.50/rev/a671596b2291
changeset: 9796:a671596b2291
user: Ioritz Cia <ioritz.cia <at> openbravo.com>
date: Fri Jan 27 15:42:35 2012 +0100
summary: Backout of changeset d4fc63700072. Fix for issue 19561.
diffstat:
src-db/database/model/triggers/C_PROJECT_TRG.xml | 16 ++--------------
src-db/database/model/triggers/M_PRODUCT_TRG.xml | 10 ----------
src-db/database/model/triggers/M_WAREHOUSE_TRG.xml | 11 -----------
3 files changed, 2 insertions(+), 35 deletions(-)
diffs (81 lines):
diff -r 8429ab9833a4 -r a671596b2291
src-db/database/model/triggers/C_PROJECT_TRG.xml
--- a/src-db/database/model/triggers/C_PROJECT_TRG.xml Tue Jan 17 12:53:59
2012 +0100
+++ b/src-db/database/model/triggers/C_PROJECT_TRG.xml Fri Jan 27 15:42:35
2012 +0100
@@ -31,7 +31,6 @@
************************************************************************/
v_Tree_ID VARCHAR2(32);
v_Parent_ID VARCHAR2(32);
- v_count NUMBER;
--
TYPE RECORD IS REF CURSOR;
Cur_Defaults RECORD;
@@ -111,19 +110,8 @@
)
;
ELSIF (UPDATING) THEN
-
- IF(COALESCE(:old.AD_ORG_ID, '0') <> COALESCE(:new.AD_ORG_ID, '0')) THEN
- SELECT COUNT(*) INTO V_COUNT FROM C_PROJECTLINE WHERE C_PROJECT_ID =
:NEW.C_PROJECT_ID;
- IF(V_COUNT > 0) THEN
- SELECT COUNT(*) INTO V_COUNT FROM C_PROJECTLINE WHERE C_PROJECT_ID =
:NEW.C_PROJECT_ID AND
AD_ISORGINCLUDED(:NEW.AD_ORG_ID,AD_ORG_ID,:NEW.AD_CLIENT_ID) <> -1;
- IF(V_COUNT = 0) THEN
- RAISE_APPLICATION_ERROR(-20000, '@orgnizationHeaderCheck@') ;
- END IF;
- END IF;
- END IF;
-
- UPDATE C_PROJECT_ACCT SET AD_ORG_ID = :new.AD_ORG_ID
- WHERE C_PROJECT_ID = :new.C_PROJECT_ID;
+ UPDATE C_PROJECT_ACCT SET AD_ORG_ID = :new.AD_ORG_ID
+ WHERE C_PROJECT_ID = :new.C_PROJECT_ID;
END IF;
-- Summary Nodes first
EXCEPTION
diff -r 8429ab9833a4 -r a671596b2291
src-db/database/model/triggers/M_PRODUCT_TRG.xml
--- a/src-db/database/model/triggers/M_PRODUCT_TRG.xml Tue Jan 17 12:53:59
2012 +0100
+++ b/src-db/database/model/triggers/M_PRODUCT_TRG.xml Fri Jan 27 15:42:35
2012 +0100
@@ -48,16 +48,6 @@
END IF;
IF (UPDATING) THEN
- IF(COALESCE(:old.AD_ORG_ID, '0') <> COALESCE(:new.AD_ORG_ID, '0')) THEN
- SELECT COUNT(*) INTO V_COUNT FROM M_PRODUCTPRICE WHERE M_PRODUCT_ID =
:NEW.M_PRODUCT_ID;
- IF(V_COUNT > 0) THEN
- SELECT COUNT(*) INTO V_COUNT FROM M_PRODUCTPRICE WHERE M_PRODUCT_ID =
:NEW.M_PRODUCT_ID AND
AD_ISORGINCLUDED(:NEW.AD_ORG_ID,AD_ORG_ID,:NEW.AD_CLIENT_ID) <> -1;
- IF(V_COUNT = 0) THEN
- RAISE_APPLICATION_ERROR(-20000, '@orgnizationHeaderCheck@') ;
- END IF;
- END IF;
- END IF;
-
UPDATE M_PRODUCT_ACCT SET AD_ORG_ID = :new.AD_ORG_ID
WHERE M_PRODUCT_ID = :new.M_PRODUCT_ID;
diff -r 8429ab9833a4 -r a671596b2291
src-db/database/model/triggers/M_WAREHOUSE_TRG.xml
--- a/src-db/database/model/triggers/M_WAREHOUSE_TRG.xml Tue Jan 17
12:53:59 2012 +0100
+++ b/src-db/database/model/triggers/M_WAREHOUSE_TRG.xml Fri Jan 27
15:42:35 2012 +0100
@@ -28,7 +28,6 @@
TYPE RECORD IS REF CURSOR;
Cur_Defaults RECORD;
- v_count NUMBER;
BEGIN
@@ -72,16 +71,6 @@
;
END LOOP;
ELSIF (UPDATING) THEN
- IF(COALESCE(:old.AD_ORG_ID, '0') <> COALESCE(:new.AD_ORG_ID, '0')) THEN
- SELECT COUNT(*) INTO V_COUNT FROM M_LOCATOR WHERE M_WAREHOUSE_ID =
:NEW.M_WAREHOUSE_ID;
- IF(V_COUNT > 0) THEN
- SELECT COUNT(*) INTO V_COUNT FROM M_LOCATOR WHERE M_WAREHOUSE_ID =
:NEW.M_WAREHOUSE_ID AND
AD_ISORGINCLUDED(:NEW.AD_ORG_ID,AD_ORG_ID,:NEW.AD_CLIENT_ID) <> -1;
- IF(V_COUNT = 0) THEN
- RAISE_APPLICATION_ERROR(-20000, '@orgnizationHeaderCheck@') ;
- END IF;
- END IF;
- END IF;
-
UPDATE M_WAREHOUSE_ACCT SET AD_ORG_ID = :new.AD_ORG_ID
WHERE M_WAREHOUSE_ID = :new.M_WAREHOUSE_ID;
END IF;
------------------------------------------------------------------------------
Try before you buy = See our experts in action!
The most comprehensive online learning library for Microsoft developers
is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
Metro Style Apps, more. Free future releases when you subscribe now!
http://p.sf.net/sfu/learndevnow-dev2
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
