CREATE OR REPLACE 
TRIGGER DATA_PROPOSTA
BEFORE UPDATE ON SOLISERV FOR EACH ROW
BEGIN
   IF (:NEW.CDFASETRAM = '050') OR (:NEW.CDFASETRAM = '073') THEN
      IF (:NEW.DTSOLIORCA IS NULL) AND (:NEW.IDSOLIORCA = 'S') THEN
         :NEW.DTSOLIORCA := TRUNC(SYSDATE);
      END IF;
   END IF;
END;
/

-- VERSAO --
BEGIN ATUVEROBJ('DATA_PROPOSTA','4.11.033'); END;
/

