Fórum Integração entre Sistemas #478606

DECLARE
  STATUS VARCHAR2(1);
  RAMAL  VARCHAR (1);
BEGIN

    SELECT FG_INATIVO
           INTO STATUS FROM PMUSUARIOS@dblink
           WHERE CD_USUARIO_EXT = :NEW.GRU_ST_RAMAL;
           
     
    IF STATUS = 'N' AND :OLD.GRU_CH_STATUS = 'A' THEN           
            UPDATE PMUSUARIOS@dblink
                  SET FG_INATIVO = 'S'
            WHERE CD_USUARIO_EXT = :NEW.GRU_ST_RAMAL;

    ELSE       
    IF STATUS = 'S' AND :OLD.GRU_CH_STATUS = 'I' THEN   
            UPDATE PMUSUARIOS@dblink
                  SET FG_INATIVO = 'N'
            WHERE CD_USUARIO_EXT = :NEW.GRU_ST_RAMAL;

    END IF;
    END IF;
                              
END;