TOTVS CRM | SFA - 12.1.2501
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
postlocaltelefone(integer, character varying, integer, character varying)
Parameters
Name
Type
Mode
idlocal
integer
IN
telefone
character varying
IN
idnpadrao
integer
IN
externalid
character varying
IN
Definition
declare idparceiro_ integer; idlocal_ 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 idparceiro_,idlocal_ idparceiro,parceirolocal.idlocal from parceirolocal where parceirolocal.idlocal = PostLocalTelefone.idlocal ; IF NOT FOUND THEN RAISE EXCEPTION 'idlocal = %', idlocal USING HINT = 'There is no idlocal in local'; end if; insert into localtelefone (idlocaltelefone,telefone,idnpadrao,idlocal,idparceiro,idnexportadoerp,codigoerp) values (nextval('seqpklocaltelefone'),telefone,idnpadrao,idlocal,idparceiro_,1,externalid) returning idlocaltelefone into internalid; return query select internalid; END;