dbo.QBM_ZPrePropObject

1     create   procedure QBM_ZPrePropObject (@SlotNumber int) as begin   declare @GenProcID varchar(38) declare @CountItems int  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, isnull(t.isDeactivatedByPreProcessor,0), isnull(t.isDeactivatedByPreProcessor
7,0), x.GenProcID, isnull(o.PreProcessorCondition,N''), o.isDeactivatedByPreProcessor from @DBQueueCurrent x join DialogObject o on x.uid_parameter = o.uid_dialogObject
8 join dialogtable t on o.UID_DialogTable = t.UID_DialogTable  update @PrePropHelper set IsDeactivated = dbo.QBM_FGIPrepropConditionDeactiv(h.PreProcessorCondition
9) from @PrePropHelper h where h.PreProcessorCondition > ' ' and h.IsDeactivated = 0  exec QBM_PSessionContextSet 'GenProcID', @GenProcID update DialogObject
10 set IsDeactivatedByPreProcessor = x.isDeactivated, xdateupdated = GetUTCDate(), xuserupdated = 'DBScheduler'  from DialogObject r join @PrePropHelper 
11x on r.UID_DialogObject = x.uid_parameter where r.IsDeactivatedByPreProcessor <> x.IsDeactivated select @CountItems = @@rowcount if @CountItems > 0 begin
12   exec QBM_PDBQueueInsert_WaitForComp 'Object', @GenProcID    declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject
13, genprocid) select x.uid, null, @GenProcID from (select distinct s.UID_DialogSheet as UID, x.GenProcID from DialogObjectHasSheet sho join @PrePropHelper
14 x on sho.UID_DialogObject = x.uid_parameter and x.IsDeactivated <> x.IsDeactivatedOld join DialogSheet s on sho.uid_DialogSheet = s.uid_dialogSheet ) 
15as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropSheet', @DBQueueElements_01        declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02
16 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select distinct t.UID_QBMTreeResult as UID, x.GenProcID from QBMTreeResult t, @PrePropHelper
17 x where x.IsDeactivated <> x.IsDeactivatedOld  and exists (select top 1 1 from QBMTreeResult y where y.uid_dialogobject = x.uid_parameter) ) as x exec
18 QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropTreeResult', @DBQueueElements_02  end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (''
19, 18, 1) WITH NOWAIT END CATCH  endLabel: exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R return end 
20