details: /erp/devel/pi/rev/145b78161715
changeset: 8556:145b78161715
user: Sathiyan Sivaprakasam <sathiyan.sivaprakasam <at> openbravo.com>
date: Mon Oct 18 12:59:43 2010 +0530
summary: Fixes Issue 14745: Hide \"Filter By Organization\" field in Document
Definition window and clean up on activity trigger
diffstat:
src-db/database/model/triggers/C_ACTIVITY_TRG.xml | 28 +----------------------
src-db/database/sourcedata/AD_FIELD.xml | 7 ++---
2 files changed, 4 insertions(+), 31 deletions(-)
diffs (101 lines):
diff -r d7eaf56e7879 -r 145b78161715
src-db/database/model/triggers/C_ACTIVITY_TRG.xml
--- a/src-db/database/model/triggers/C_ACTIVITY_TRG.xml Mon Oct 18 09:18:36
2010 +0200
+++ b/src-db/database/model/triggers/C_ACTIVITY_TRG.xml Mon Oct 18 12:59:43
2010 +0530
@@ -32,14 +32,7 @@
-- for Translation
-- and TreeNode
IF INSERTING THEN
- -- Create TreeNode --
- -- get AD_Tree_ID + ParentID
- --SELECT c.AD_Tree_Menu_ID, n.Node_ID
- -- INTO v_xTree_ID, v_xParent_ID
- -- FROM AD_CLIENTINFO c, AD_TREENODE n -- AD_TreeNodeMM n
- -- WHERE c.AD_Tree_Menu_ID=n.AD_Tree_ID
- -- AND n.Parent_ID IS NULL
- --AND c.AD_Client_ID=:NEW.AD_Client_ID;
+ -- get AD_Tree_ID and ParentID
SELECT AD_TREE_ID,
0
INTO v_xTree_ID,
@@ -47,11 +40,9 @@
FROM AD_TREE
WHERE treetype='AY'
AND AD_Client_ID=:NEW.AD_Client_ID;
- -- DBMS_OUTPUT.PUT_LINE('Tree='||v_xTree_ID||'
Node='||:new.AD_Menu_ID||' Parent='||v_xParent_ID);
-- Insert into TreeNode
INSERT
INTO AD_TREENODE
- -- AD_TreeNodeMM
(
AD_TreeNode_Id, AD_Client_ID, AD_Org_ID, IsActive,
Created, CreatedBy, Updated,
@@ -74,36 +65,19 @@
;
-- Summary Nodes first
END IF;
- -- Inserting
- -- AD_Ref_List update trigger
- -- synchronize name,...
IF UPDATING THEN
IF((COALESCE(:OLD.NAME, '.') <> COALESCE(:NEW.NAME, '.')
OR COALESCE(:OLD.Description, '.') <> COALESCE(:NEW.Description, '.')
OR COALESCE(:OLD.IsActive, '.') <> COALESCE(:NEW.IsActive, '.')))
THEN
IF(:OLD.IsActive!=:NEW.IsActive) THEN
- -- get AD_Tree_ID + ParentID
- --SELECT c.AD_Tree_Menu_ID, n.Node_ID
- --INTO v_xTree_ID, v_xParent_ID
- --FROM AD_CLIENTINFO c, AD_TREENODE n -- AD_TreeNodeMM n
- --WHERE c.AD_Tree_Menu_ID=n.AD_Tree_ID
- -- AND n.Parent_ID IS NULL
- --AND c.AD_Client_ID=:NEW.AD_Client_ID;
- -- Update
UPDATE AD_TREENODE
- -- AD_TreeNodeMM
SET IsActive=:NEW.IsActive
WHERE AD_Tree_ID=v_xTree_ID
AND Node_ID=:NEW.C_ACTIVITY_ID;
END IF;
END IF;
END IF;
- -- Updating
-/*EXCEPTION
-WHEN NO_DATA_FOUND THEN
- RAISE_APPLICATION_ERROR(-20002, 'AD_AccountingRpt_Element InsertTrigger
Error: No ClientInfo or parent TreeNode') ;
- */
END C_ACTIVITY_TRG
]]></body>
</trigger>
diff -r d7eaf56e7879 -r 145b78161715 src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml Mon Oct 18 09:18:36 2010 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml Mon Oct 18 12:59:43 2010 +0530
@@ -36129,7 +36129,7 @@
<!--3125--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
<!--3125--> <DISPLAYLENGTH><![CDATA[10]]></DISPLAYLENGTH>
<!--3125--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--3125--> <SEQNO><![CDATA[200]]></SEQNO>
+<!--3125--> <SEQNO><![CDATA[190]]></SEQNO>
<!--3125--> <ISSAMELINE><![CDATA[Y]]></ISSAMELINE>
<!--3125--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
<!--3125--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -119419,10 +119419,9 @@
<!--800641--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
<!--800641--> <AD_TAB_ID><![CDATA[167]]></AD_TAB_ID>
<!--800641--> <AD_COLUMN_ID><![CDATA[800476]]></AD_COLUMN_ID>
-<!--800641--> <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--800641--> <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
<!--800641--> <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
<!--800641--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--800641--> <SEQNO><![CDATA[190]]></SEQNO>
<!--800641--> <ISSAMELINE><![CDATA[Y]]></ISSAMELINE>
<!--800641--> <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
<!--800641--> <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -203046,7 +203045,7 @@
<!--AFCAC02426F149D0B1F71C6923057A5E-->
<ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
<!--AFCAC02426F149D0B1F71C6923057A5E-->
<DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
<!--AFCAC02426F149D0B1F71C6923057A5E--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--AFCAC02426F149D0B1F71C6923057A5E--> <SEQNO><![CDATA[210]]></SEQNO>
+<!--AFCAC02426F149D0B1F71C6923057A5E--> <SEQNO><![CDATA[200]]></SEQNO>
<!--AFCAC02426F149D0B1F71C6923057A5E--> <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
<!--AFCAC02426F149D0B1F71C6923057A5E-->
<ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
<!--AFCAC02426F149D0B1F71C6923057A5E-->
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
------------------------------------------------------------------------------
Download new Adobe(R) Flash(R) Builder(TM) 4
The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly
Flex(R) Builder(TM)) enable the development of rich applications that run
across multiple browsers and platforms. Download your free trials today!
http://p.sf.net/sfu/adobe-dev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
