dbo.QBM_ZPrePropSheet

1   create   procedure QBM_ZPrePropSheet (@SlotNumber int) as begin   declare @CountItems int  declare @GenProcID varchar(38) declare @GenProcID_R
2 varchar(38) = dbo.QBM_FGISessionContext('') declare @DBQueueCurrent QBM_YDBQueueCurrent BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter
3, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber
4 = @SlotNumber 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
6 , IsDeactivated , GenProcID , PreProcessorCondition, IsDeactivatedOld)  select x.uid_parameter,  1,  1, x.GenProcID, isnull(os.PreProcessorCondition,N''
7), os.isDeactivatedByPreProcessor from @DBQueueCurrent x join dialogSheet os on x.uid_parameter = os.uid_dialogSheet  update @PrePropHelper set isDeactivatedPrior
8 = 0, IsDeactivated = 0 from @PrePropHelper h where exists (select top 1 1 from QBMTreeHasSheet ths join QBMTree t on ths.uid_QBMTree = t.uid_QBMTree and
9 t.isDeactivatedByPreProcessor = 0 where ths.uid_DialogSheet = h.uid_parameter ) or exists (select top 1 1 from QBMTreeResultHasSheet ths join QBMTreeResult
10 t on ths.uid_QBMTreeResult = t.uid_QBMTreeResult and t.isDeactivatedByPreProcessor = 0 where ths.uid_DialogSheet = h.uid_parameter ) update @PrePropHelper
11 set isDeactivatedPrior = 0, IsDeactivated = 0 from @PrePropHelper h where exists (select top 1 1 from DialogObjectHasSheet ohs join DialogObject o on 
12ohs.UId_dialogObject = o.uid_dialogObject and o.isDeactivatedByPreProcessor = 0 where ohs.uid_DialogSheet = h.uid_parameter )  update @PrePropHelper set
13 IsDeactivated = dbo.QBM_FGIPrepropConditionDeactiv(h.PreProcessorCondition) from @PrePropHelper h where h.PreProcessorCondition > ' ' and h.IsDeactivated
14 = 0    exec QBM_PSessionContextSet 'GenProcID', @GenProcID update DialogSheet set IsDeactivatedByPreProcessor = x.isDeactivated, xdateupdated = GetUTCDate
15(), xuserupdated = 'DBScheduler'  from DialogSheet r join @PrePropHelper x on r.UID_DialogSheet = x.uid_parameter where r.IsDeactivatedByPreProcessor <>
16 x.IsDeactivated select @CountItems = @@rowcount  if @CountItems > 0 begin   exec QBM_PDBQueueInsert_WaitForComp 'Sheet', @GenProcID  end  END TRY BEGIN
17 CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  endLabel: exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R return
18 end 
19