dbo.TSB_ROrgHasTSBAccountDef

1create   procedure TSB_ROrgHasTSBAccountDef (@SlotNumber int) AS begin declare @ObjectKeysToCheck_Projection QBM_YParameterList declare @ObjectKeysToCheck_Jobrunning
2 QBM_YParameterList declare @MyName nvarchar(64) = object_name(@@procid) declare @UID_BasetreeAssignToUse varchar(38) = 'TSB-AsgnBT-TSBAccountDef' declare
3 @DBQueueCurrent QBM_YDBQueueCurrent declare @resetted int BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID
4) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount
5 = 0 begin goto EndLabel end  exec @resetted = QBM_PSlotResetOnMissingItem_L @DBQueueCurrent, 'BaseTree', 'UID_Org', @SlotNumber if @resetted > 0 begin
6 delete  @DBQueueCurrent from @DBQueueCurrent v left outer join QBMDBQueueCurrent cu with (readpast) on v.UID_DialogDBQueue = cu.UID_DialogDBQueue and 
7cu.SlotNumber = @SlotNumber where cu.UID_DialogDBQueue is null end exec @resetted = QER_PSlotResetOnInvalidRoot_L @DBQueueCurrent, @UID_BasetreeAssignToUse
8, @SlotNumber if @resetted > 0 begin delete  @DBQueueCurrent from @DBQueueCurrent v left outer join QBMDBQueueCurrent cu with (readpast) on v.UID_DialogDBQueue
9 = cu.UID_DialogDBQueue and cu.SlotNumber = @SlotNumber where cu.UID_DialogDBQueue is null end  insert into @ObjectKeysToCheck_Jobrunning(Parameter1, Parameter2
10) select cu.UID_Parameter, x.XObjectKey from @DBQueueCurrent cu join BaseTree x on cu.UID_Parameter = x.UID_Org exec @resetted = QBM_PSlotResetWhileJobRun_L
11 @DBQueueCurrent, @@PROCID, @ObjectKeysToCheck_Jobrunning, @SlotNumber = @SlotNumber  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (
12'', 18, 1) WITH NOWAIT END CATCH endLabel: end 
13