dbo.ATT_ZAttestationWzParmPreProp

1    create   procedure ATT_ZAttestationWzParmPreProp (@SlotNumber int) as begin  declare @GenProcID varchar(38) declare @GenProcID_R varchar(38)
2 = dbo.QBM_FGISessionContext('') declare @DBQueueCurrent QBM_YDBQueueCurrent BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter
3, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber
4 if @@rowcount = 0 begin goto EndLabel end select @GenProcID = max(GenProcID) from @DBQueueCurrent where GenProcID > ' ' if isnull(@Genprocid, '') = ''
5 begin select @GenProcID = newid() end declare @PrePropHelper QBM_YPrepropHelper insert into @PrePropHelper (uid_parameter , isDeactivatedPrior , IsDeactivated
6 , GenProcID , PreProcessorCondition, IsDeactivatedOld) select x.uid_parameter, isnull(t.isDeactivatedByPreProcessor,0), isnull(t.isDeactivatedByPreProcessor
7,0), x.GenProcID, isnull(c.PreProcessorCondition,N''), c.isDeactivatedByPreProcessor from @DBQueueCurrent x join AttestationWizardParm c on x.uid_parameter
8 = c.uid_AttestationWizardParm join AttestationObject t on c.UID_AttestationObject = t.UID_AttestationObject  update @PrePropHelper set IsDeactivated =
9 dbo.QBM_FGIPrepropConditionDeactiv(h.PreProcessorCondition) from @PrePropHelper h where h.PreProcessorCondition > ' ' and h.IsDeactivated = 0      exec
10 QBM_PSessionContextSet 'GenProcID', @GenProcID update AttestationWizardParm set IsDeactivatedByPreProcessor = x.isDeactivated, xdateupdated = GetUTCDate
11(), xuserupdated = 'DBScheduler'  from AttestationWizardParm r join @PrePropHelper x on r.UID_AttestationWizardParm = x.uid_parameter where r.IsDeactivatedByPreProcessor
12 <> x.IsDeactivated END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  endLabel: exec QBM_PSessionContextSet
13 'GenProcID', @GenProcID_R return end 
14