CREATE OR REPLACE TRIGGER TRG_CRM_ETAPAPROSP_UPD
AFTER UPDATE ON CRM_ETAPAPROSP
FOR EACH ROW
BEGIN
    INSERT INTO CRM_LOG_ETAPAPROSP (
        NRCANDIDATO,
        NRPARCNEGOCIO,
        NRPARCRESP,
        CDOPERRESP,
        NRSEQETAPA,
        NRORG,
        CRM_NRORGTRAB,
        CDOPERINCLUSAO,
        DTINCLUSAO,
        DTULTATU,
        CDOPERULTATU
    ) VALUES (
        :NEW.NRCANDIDATO,
        :NEW.NRPARCNEGOCIO,
        :NEW.NRPARCRESP,
        :NEW.CDOPERRESP,
        :NEW.NRSEQETAPA,
        :NEW.NRORG,
        :NEW.CRM_NRORGTRAB,
        :NEW.CDOPERINCLUSAO,
        SYSDATE,
        SYSDATE,
        :NEW.CDOPERULTATU
    );
END;