Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE PROCEDURE CODATA."PR_INSERT_SIS_016"()
- returns void
- language plpgsql
- as $$
- declare
- EmpresaFilial record;
- BEGIN
- for EmpresaFilial in (SELECT DISTINCT(cd_empresa), cd_filial FROM CODATA.tb_sis_016)
- loop
- INSERT INTO CODATA.TB_SIS_016 (CD_EMPRESA,CD_FILIAL,CD_FASE,NM_FASE,FL_ATIVO,FL_STATUS_PROT,ID_FUNCIONARIO) VALUES (v_empresa_filial.cd_empresa, v_empresa_filial.cd_filial, '344','ATENDIMENTO DA SOLICITAÇÃO','S','F','1');
- INSERT INTO CODATA.TB_SIS_016 (CD_EMPRESA,CD_FILIAL,CD_FASE,NM_FASE,FL_ATIVO,FL_STATUS_PROT,ID_FUNCIONARIO) VALUES (v_empresa_filial.cd_empresa, v_empresa_filial.cd_filial, '345','NEGAÇÃO','S','N','1');
- end loop;
- END;
- $$
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement