CREATE OR REPLACE TRIGGER ATUALIZA_VERIFCONSSOLOL
BEFORE UPDATE OF NRSEQUCONSOL ON ITEMSOLI
FOR EACH ROW
BEGIN
   IF :NEW.NRSEQUCONSOL IS NOT NULL THEN
      UPDATE VERIFCONSSOLOL
         SET VERIFCONSSOLOL.NRSEQUCONSOL  = :NEW.NRSEQUCONSOL
       WHERE VERIFCONSSOLOL.CDFILSOLI     = :OLD.CDFILSOLI
         AND VERIFCONSSOLOL.CDFILLAN      = :OLD.CDFILLAN
         AND VERIFCONSSOLOL.DTPROGENTR    = :OLD.DTPROGENTR
         AND VERIFCONSSOLOL.NRSOLICMP     = :OLD.NRSOLICMP
         AND VERIFCONSSOLOL.CDPRODUTO     = :OLD.CDPRODUTO;
   END IF;
END;
/

-- VERSAO --
BEGIN ATUVEROBJ('ATUALIZA_VERIFCONSSOLOL','5.33.XXX'); END;
/
