drop PROCEDURE if EXISTS sp_alm_sendGuiaRemision_modificar;
DELIMITER $$
CREATE  PROCEDURE `sp_alm_sendGuiaRemision_modificar`(IN `idP` INT)
    NO SQL
BEGIN

UPDATE tec_send_invoice_gr SET estado = 0 WHERE referral_guide_id = idP;

END$$
DELIMITER ;