TOTVS CRM | SFA - 12.1.2501

Parameters

Name	Type	Mode
internalid	integer	IN
idusuario	integer	IN
email	character varying	IN
idnpadrao	integer	IN
externalid	character varying	IN

Definition

/*declare	
	idusuarioemail_ integer;*/
begin  		 
	if idnpadrao is null then 
		RAISE EXCEPTION 'idnpadrao = %', idnpadrao
      		USING HINT = 'Field idnpadrao must be not null';
    end if; 		

	/*select into idusuarioemail_ 
		usuarioemail.idusuarioemail from usuarioemail where idusuarioemail = internalid ;
	IF NOT FOUND THEN 
		RAISE EXCEPTION 'idusuarioemail = %', internalid
      		USING HINT = 'There is no idusuarioemail in usuarioemail';
    end if;*/ 	 

	update usuarioemail set 
		idusuario = case when PutUsuarioEmail.idusuario = -99999 then usuarioemail.idusuario else PutUsuarioEmail.idusuario end, 
		email = case when PutUsuarioEmail.email = 'NOVALUEWS' then usuarioemail.email else PutUsuarioEmail.email end, 
		idnpadrao = case when PutUsuarioEmail.idnpadrao = -99999 then usuarioemail.idnpadrao else PutUsuarioEmail.idnpadrao end, 
		codigoerp = case when Putusuarioemail.externalid = 'NOVALUEWS' then codigoerp else Putusuarioemail.externalid end 
	where idusuarioemail = internalid ;

	return query select internalid;
END;

putusuarioemail(integer, integer, character varying, integer, character varying)

Parameters

Definition