1 CREATE OR REPLACE FUNCTION _bomitemsubTrigger() RETURNS TRIGGER AS '
2 -- Copyright (c) 1999-2014 by OpenMFG LLC, d/b/a xTuple.
3 -- See www.xtuple.com/CPAL for the full text of the software license.
7 IF (NOT checkPrivilege(''MaintainBOMs'')) THEN
8 RAISE EXCEPTION ''You do not have privileges to maintain Bills of Material.'';
11 IF (TG_OP = ''DELETE'') THEN
20 DROP TRIGGER bomitemsubTrigger ON bomitemsub;
21 CREATE TRIGGER bomitemsubTrigger BEFORE INSERT OR UPDATE OR DELETE ON bomitemsub FOR EACH ROW EXECUTE PROCEDURE _bomitemsubTrigger();