script p0329

EXECUTE [BaseIntegradora].[dbo].[wfSP_Inserir_CRM_Proposta_SESI_SENAI] {Processo.Codigo}

EXECUTE [BaseIntegradora].[dbo].[wfSP_INSERIR_CRM_SERVICOS] {Processo.Codigo}

DECLARE @Instancia int = {Processo.Codigo}
DECLARE @Qnt int = (SELECT COUNT(CodFlowFormFieldLog) FROM orquestrabpm.dbo.wfVWFLOW_FORM_FIELD_LOG WHERE DsFieldName = 'situacaoFinanceira' AND CodFlow = 563 AND CodFlowExecute = @Instancia AND DsFormFieldValue = 'Inadimplente')
IF @Qnt > 0
	BEGIN
		UPDATE orquestrabpm.dbo.wfVWFLOW_FORM_FIELD_LOG SET DsFormFieldValue = 'Inadimplente' WHERE DsFieldName = 'financeiroAgrup' AND CodFlow = 563 AND CodFlowExecute = @Instancia
	END
ELSE 
	BEGIN
		UPDATE orquestrabpm.dbo.wfVWFLOW_FORM_FIELD_LOG SET DsFormFieldValue = 'Adimplente' WHERE DsFieldName = 'financeiroAgrup' AND CodFlow = 563 AND CodFlowExecute = @Instancia
	END