CREATE TRIGGER DOC_ARGUMENT.CONTR_I_NUMDOC
  AFTER INSERT
  ON DOCUMENT.DOC_ARGUMENT
  REFERENCING NEW AS N FOR EACH ROW
BEGIN  ATOMIC
  -- заполнять исходящий номер символами "б/н". 
       update DOCUMENT.DOC_ARGUMENT set INCOMING_NUMDOC = 'б/н'  
       where  
                    ID = N.ID
            and     BINDING_DATE >= date('2012-05-01') and INCOMING_NUMDOC is  null 
            and     ID_DOCUMENT in (select id from TYPE.DOCUMENT where direction = 'INPUT') 
            and     binding_time <> '00:00:00';      
END;

CREATE OR REPLACE TRIGGER DOC_ARGUMENT.CONTR_I_NUMDOC
  BEFORE INSERT
  ON DOCUMENT.DOC_ARGUMENT
  REFERENCING NEW AS N FOR EACH ROW
  WHEN (EXISTS (
    SELECT 1 FROM TYPE.DOCUMENT D 
    WHERE D.DIRECTION='INPUT' AND D.ID=N.ID_DOCUMENT
    AND N.BINDING_DATE >= date('2012-05-01') and N.INCOMING_NUMDOC is null and N.binding_time <> '00:00:00'
  ))
set INCOMING_NUMDOC = 'б/н'

set INCOMING_NUMDOC = 'б/н'

set INCOMING_NUMDOC = 'б/н'

set N.INCOMING_NUMDOC = 'б/н'