dbo.QBM_ZPrePropDashBoardDef

1   create   procedure QBM_ZPrePropDashBoardDef (@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 , 0  , 0  , x.GenProcID, isnull(o.PreProcessorCondition,
7N''), o.isDeactivatedByPreProcessor from @DBQueueCurrent x join DialogDashBoardDef o on x.uid_parameter = o.uid_dialogDashBoardDef   update @PrePropHelper
8 set IsDeactivated = dbo.QBM_FGIPrepropConditionDeactiv(h.PreProcessorCondition) from @PrePropHelper h where h.PreProcessorCondition > ' ' and h.IsDeactivated
9 = 0  exec QBM_PSessionContextSet 'GenProcID', @GenProcID update DialogDashBoardDef set IsDeactivatedByPreProcessor = x.isDeactivated, xdateupdated = GetUTCDate
10(), xuserupdated = 'DBScheduler'  from DialogDashBoardDef r join @PrePropHelper x on r.UID_DialogDashBoardDef = x.uid_parameter where r.IsDeactivatedByPreProcessor
11 <> x.IsDeactivated select @CountItems = @@rowcount if @CountItems > 0 begin   exec QBM_PDBQueueInsert_WaitForComp 'DashBoardDef', @GenProcID         declare
12 @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from (select distinct
13 t.UID_QBMTree as UID, x.GenProcID from QBMTree t, @PrePropHelper x where  isnull(UID_QBMTreeParent,'') = '' and x.IsDeactivated <> x.IsDeactivatedOld 
14 and exists (select top 1 1 from QBMTree y where y.uid_dialogDashBoardDef =x.uid_parameter) ) as x exec QBM_PDBQueueInsert_Bulk 'QBM-K-CommonPrepropTree'
15, @DBQueueElements_01 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  endLabel: exec QBM_PSessionContextSet
16 'GenProcID', @GenProcID_R return end 
17