dbo.QBM_PJobCreate_HODelete_B

1  create   procedure QBM_PJobCreate_HODelete_B( @objecttype nvarchar(255),  @whereclause nvarchar(max)  , @GenProcID varchar(38) , @AdditionalObjectKeysAffected
2 QBM_YParameterList readonly  , @ConnectionVariables nvarchar(max) = null , @AuthenticationString nvarchar(max) = null , @SingleTransaction bit = 1 , @isToFreezeOnError
3 bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256) = null , @StartAt datetime = null , @BasisObjectKey varchar(138) = '' , @XUser
4 nvarchar(64) = null , @WhereClauseAdditional nvarchar(max) = '' , @checkForExisting bit = 0 , @QueueName nvarchar(256) = null , @DeepDelete bit = 0  )
5 as begin declare @XObjectKeysToTransfer QBM_YParameterList declare @SQLCmd nvarchar(max)  SET XACT_ABORT OFF BEGIN TRY if exists (select top 1 1 from 
6DialogTable t with (readpast) join DialogColumn c with (readpast) on t.UID_DialogTable = c.UID_DialogTable where t.TableName = @objecttype and c.ColumnName
7 = 'XObjectKey' ) begin select @SQLCmd = N'
8	  select XObjectKey 
9		from ' + @objecttype + N'
10		where ( ' + @whereclause + N' )
11		order by 1 ' insert
12 into @XObjectKeysToTransfer(Parameter1) exec sp_executeSQL @SQLCmd exec QBM_PJobCreate_HODelete_L @objecttype , @XObjectKeysToTransfer , @GenProcID , 
13@AdditionalObjectKeysAffected , @ConnectionVariables , @AuthenticationString , @SingleTransaction , @isToFreezeOnError = @isToFreezeOnError , @Retries 
14= @Retries , @priority = @priority , @Jobchainname = @Jobchainname , @StartAt = @StartAt , @BasisObjectKey = @BasisObjectKey , @XUser = @XUser , @WhereClauseAdditional
15 = @WhereClauseAdditional , @checkForExisting = @checkForExisting , @QueueName = @QueueName , @DeepDelete = @DeepDelete end else begin exec QBM_PJobCreate_HODelete
16 @objecttype , @whereclause , @GenProcID , @AdditionalObjectKeysAffected , @ConnectionVariables , @AuthenticationString , @SingleTransaction , @isToFreezeOnError
17 = @isToFreezeOnError , @Retries = @Retries , @priority = @priority , @Jobchainname = @Jobchainname , @StartAt = @StartAt , @BasisObjectKey = @BasisObjectKey
18 , @XUser = @XUser , @WhereClauseAdditional = @WhereClauseAdditional , @checkForExisting = @checkForExisting , @QueueName = @QueueName , @DeepDelete = 
19@DeepDelete end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow
20, 18, 1) WITH NOWAIT END CATCH ende: return end 
21