TOTVS CRM | SFA - 12.1.2501
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
postusuarioemail(integer, character varying, integer, character varying)
Parameters
Name
Type
Mode
idusuario
integer
IN
email
character varying
IN
idnpadrao
integer
IN
externalid
character varying
IN
Definition
declare idusuario_ integer; internalid integer; begin if idnpadrao is null then RAISE EXCEPTION 'idnpadrao = %', idnpadrao USING HINT = 'Field idnpadrao must be not null'; end if; select into idusuario_ usuario.idusuario from usuario where usuario.idusuario = PostUsuarioEmail.idusuario ; IF NOT FOUND THEN RAISE EXCEPTION 'idusuario = %', idusuario USING HINT = 'There is no idusuario in usuario'; end if; insert into usuarioemail (idusuarioemail,email,idnpadrao,idusuario,codigoerp) values (nextval('seqpkusuarioemail'),email,idnpadrao,idusuario,externalid) returning idusuarioemail into internalid; return query select internalid; END;