mht_brerp10
.adempiere
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
cof_receber_leitura_em_massa(integer, character varying)
Parameters
Name
Type
Mode
p_inout_id
integer
IN
p_leituraemmassa
character varying
IN
Definition
DECLARE v_return CHARACTER VARYING; a_count integer; BEGIN UPDATE m_inout SET COF_leituraEmMassa = p_leituraemmassa WHERE m_inout_id = p_inout_id; GET DIAGNOSTICS a_count = ROW_COUNT; IF (a_count = 1) THEN v_return := ' Leituras enviadas com sucesso!'; ELSE v_return := ' Erro ao enviar leituras.'; END IF; RETURN v_return; END;