ad_window_trl_trg.sql

Java写的ERP系统

CREATE OR REPLACE TRIGGER AD_Window_Trl_Trg
AFTER UPDATE OF Name, Description, Help
	ON AD_Window_Trl
FOR EACH ROW
DECLARE
/*************************************************************************
 * The contents of this file are subject to the Compiere License.  You may
 * obtain a copy of the License at    http://www.compiere.org/license.html
 * Software is on an  "AS IS" basis,  WITHOUT WARRANTY OF ANY KIND, either
 * express or implied. See the License for details. Code: Compiere ERP+CRM
 * Copyright (C) 1999-2002 Jorg Janke, ComPiere, Inc. All Rights Reserved.
 *************************************************************************
 * $Id: AD_Window_Trl_Trg.sql,v 1.4 2003/02/18 03:33:22 jjanke Exp $
 ***
 * Title:	Window Trl Changes
 * Description:
 *			- Update Translation in Menu + Workflow
 ************************************************************************/
BEGIN
	--	Update Menu
	UPDATE	AD_Menu_Trl t
	  SET	Name = :new.Name,
			Description = :new.Description
	WHERE	AD_Language = :new.AD_Language
	  AND EXISTS (SELECT * FROM AD_Menu m 
			WHERE m.AD_Menu_ID=t.AD_Menu_ID AND m.AD_Window_ID=:new.AD_Window_ID);
	--	Update Workflow
	UPDATE	AD_WF_Node_Trl t
	  SET	Name = :new.Name,
			Description = :new.Description,
			Help = :new.Help
	WHERE	AD_Language = :new.AD_Language
	  AND EXISTS (SELECT * FROM AD_WF_Node n 
			WHERE n.AD_WF_Node_ID=t.AD_WF_Node_ID AND n.AD_Window_ID=:new.AD_Window_ID
			  AND n.IsCentrallyMaintained='Y');
	--
END AD_Window_Trl_Trg;
/