dbo.ATT_ZAttestationMakeDecisionEX

1     create   procedure ATT_ZAttestationMakeDecisionEX (@SlotNumber int) as begin  declare @UID_AttestationCase varchar(38) declare @GenProcID varchar
2(38) declare @cond nvarchar(max) declare @EventName nvarchar(max) declare @BasisObjectKey varchar(138) declare @SubLevelNumberString varchar(32) declare
3 @UID_AttestationHelper varchar(38) declare @WaitingForEx_30965 varchar(32) = 'waiting for EX' declare @ElementBuffer QBM_YCursorBuffer declare @ElementCount
4 int declare @ElementIndex int BEGIN TRY insert into @ElementBuffer (UID1, UID2, ContentFull, ObjectKey1, Ident1, UID3) select ac.UID_AttestationCase ,
5 p.GenprocID, isnull(ds.WhereClause, N'') , ac.XObjectKey , dbo.QBM_FCVIntToString(ds.SubLevelNumber) , ah.UID_AttestationHelper from QBMDBQueueCurrent
6 p with (readpast) join AttestationCase ac on p.uid_parameter = ac.UID_AttestationCase join AttestationHelper ah on ac.UID_AttestationCase = ah.UID_AttestationCase
7 and ac.decisionlevel = ah.levelnumber join QERWorkingStep ds on ah.UID_QERWorkingStep = ds.UID_QERWorkingStep  where ah.UID_PWODecisionRule = 'ATT-PWODecisionRule-EX'
8 and isnull(ac.isclosed,0) = 0 and p.SlotNumber = @SlotNumber  and isnull(ah.ReasonHead, '') = '' and isnull(ah.Decision, '') = '' select @ElementCount
9 = @@ROWCOUNT select @ElementIndex = 1 while @ElementIndex <= @ElementCount begin select top 1 @UID_AttestationCase = bu.UID1 , @GenProcID = bu.UID2 , 
10@EventName = bu.ContentFull , @BasisObjectKey = bu.ObjectKey1 , @SubLevelNumberString = bu.Ident1 , @UID_AttestationHelper = bu.UID3 from @ElementBuffer
11 bu where bu.ElementIndex = @ElementIndex select @cond = N'UID_AttestationCase = ''' + rtrim(@UID_AttestationCase) + N''''  exec QBM_PJobCreate_HOFireEvent_B
12 'AttestationCase', @cond, @EventName, @GenProcID , @AdditionalObjectKeysAffected = DEFAULT , @checkForExisting = 0 , @BasisObjectKey = @BasisObjectKey
13 , @p2 = '_ParamName1', @v2 = 'SubLevelNumber' , @p3 = '_ParamValue1' , @v3 = @SubLevelNumberString  update AttestationHelper set ReasonHead = @WaitingForEx_30965
14 where UID_AttestationHelper = @UID_AttestationHelper and isnull(ReasonHead, '') = '' select @ElementIndex += 1 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd
15 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 
16