Back to OIM Explorer

dbo.QBM_PJobCreate_HOFireEvent_B

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*; References QBM_PJobCreate_HOFireEvent*

Source: sandbox-db sys.sql_modules

Source size: 4.481 characters

Interpretation

Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
Object-layer bridge detected through QBM_PJobCreate helper usage.

Relations

References QBM_PJobCreate*
References QBM_PJobCreate_HOFireEvent*

Typed Edges

references source dbo.QBM_FGISessionErrorRethrow source text reference
references source dbo.QBM_PJobCreate source text reference
references source dbo.QBM_PJobCreate_HOFireEvent source text reference
references source dbo.QBM_PJobCreate_HOFireEvent_L source text reference
references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

1CREATE PROCEDURE QBM_PJobCreate_HOFireEvent_B(2  @objecttype nvarchar(255),3  @whereclause nvarchar(max),4  @EventName nvarchar(256),5  @GenProcID varchar(38),6  @AdditionalObjectKeysAffected QBM_YParameterList READONLY,7  @ConnectionVariables nvarchar(max) = NULL,8  @AuthenticationString nvarchar(max) = NULL,9  @SingleTransaction BIT = 1,10  @p2 nvarchar(1024) = N '',11  @v2 nvarchar(max) = N '',12  @p3 nvarchar(1024) = N '',13  @v3 nvarchar(max) = N '',14  @p4 nvarchar(1024) = N '',15  @v4 nvarchar(max) = N '',16  @p5 nvarchar(1024) = N '',17  @v5 nvarchar(max) = N '',18  @p6 nvarchar(1024) = N '',19  @v6 nvarchar(max) = N '',20  @p7 nvarchar(1024) = N '',21  @v7 nvarchar(max) = N '',22  @p8 nvarchar(1024) = N '',23  @v8 nvarchar(max) = N '',24  @p9 nvarchar(1024) = N '',25  @v9 nvarchar(max) = N '',26  @p10 nvarchar(1024) = N '',27  @v10 nvarchar(max) = N '',28  @p11 nvarchar(1024) = N '',29  @v11 nvarchar(max) = N '',30  @p12 nvarchar(1024) = N '',31  @v12 nvarchar(max) = N '',32  @p13 nvarchar(1024) = N '',33  @v13 nvarchar(max) = N '',34  @p14 nvarchar(1024) = N '',35  @v14 nvarchar(max) = N '',36  @p15 nvarchar(1024) = N '',37  @v15 nvarchar(max) = N '',38  @p16 nvarchar(1024) = N '',39  @v16 nvarchar(max) = N '',40  @p17 nvarchar(1024) = N '',41  @v17 nvarchar(max) = N '',42  @p18 nvarchar(1024) = N '',43  @v18 nvarchar(max) = N '',44  @p19 nvarchar(1024) = N '',45  @v19 nvarchar(max) = N '',46  @p20 nvarchar(1024) = N '',47  @v20 nvarchar(max) = N '',48  @p21 nvarchar(1024) = N '',49  @v21 nvarchar(max) = N '',50  @p22 nvarchar(1024) = N '',51  @v22 nvarchar(max) = N '',52  @p23 nvarchar(1024) = N '',53  @v23 nvarchar(max) = N '',54  @p24 nvarchar(1024) = N '',55  @v24 nvarchar(max) = N '',56  @p25 nvarchar(1024) = N '',57  @v25 nvarchar(max) = N '',58  @p26 nvarchar(1024) = N '',59  @v26 nvarchar(max) = N '',60  @p27 nvarchar(1024) = N '',61  @v27 nvarchar(max) = N '',62  @p28 nvarchar(1024) = N '',63  @v28 nvarchar(max) = N '',64  @p29 nvarchar(1024) = N '',65  @v29 nvarchar(max) = N '',66  @p30 nvarchar(1024) = N '',67  @v30 nvarchar(max) = N '',68  @p31 nvarchar(1024) = N '',69  @v31 nvarchar(max) = N '',70  @isToFreezeOnError BIT = 0,71  @Retries int = 0,72  @priority int = 5,73  @Jobchainname nvarchar(256) = NULL,74  @StartAt datetime = NULL,75  @BasisObjectKey varchar(138) = N '',76  @XUser nvarchar(64) = NULL,77  @WhereClauseAdditional nvarchar(max) = '',78  @checkForExisting BIT = 0,79  @QueueName nvarchar(256) = NULL80)81AS82BEGIN83  DECLARE @XObjectKeysToTransfer QBM_YParameterList84  DECLARE @SQLCmd nvarchar(max)85  SET XACT_ABORT OFF86  BEGIN TRY87    IF EXISTS(88      SELECT TOP 1 189      FROM DialogTable t90      WITH(readpast)91    JOIN DialogColumn c92      WITH(readpast)93      ON t.UID_DialogTable = c.UID_DialogTable94    WHERE95      t.TableName = @objecttype AND c.ColumnName = 'XObjectKey')96    BEGIN97      SELECT98        @SQLCmd = N '99	  select XObjectKey 100		from ' + @objecttype + N '101		where ( ' + @whereclause + N ' )102		order by 1 '103      INSERT INTO @XObjectKeysToTransfer(Parameter1)104      EXEC sp_executeSQL @SQLCmd105      EXEC QBM_PJobCreate_HOFireEvent_L @objecttype,106        @XObjectKeysToTransfer,107        @EventName,108        @GenProcID,109        @AdditionalObjectKeysAffected,110        @ConnectionVariables,111        @AuthenticationString,112        @SingleTransaction,113        @p2,114        @v2,115        @p3,116        @v3,117        @p4,118        @v4,119        @p5,120        @v5,121        @p6,122        @v6,123        @p7,124        @v7,125        @p8,126        @v8,127        @p9,128        @v9,129        @p10,130        @v10,131        @p11,132        @v11,133        @p12,134        @v12,135        @p13,136        @v13,137        @p14,138        @v14,139        @p15,140        @v15,141        @p16,142        @v16,143        @p17,144        @v17,145        @p18,146        @v18,147        @p19,148        @v19,149        @p20,150        @v20,151        @p21,152        @v21,153        @p22,154        @v22,155        @p23,156        @v23,157        @p24,158        @v24,159        @p25,160        @v25,161        @p26,162        @v26,163        @p27,164        @v27,165        @p28,166        @v28,167        @p29,168        @v29,169        @p30,170        @v30,171        @p31,172        @v31,173        @isToFreezeOnError,174        @Retries,175        @priority,176        @Jobchainname,177        @StartAt,178        @BasisObjectKey,179        @XUser,180        @WhereClauseAdditional,181        @checkForExisting,182        @QueueName183    END184    ELSE185    BEGIN186      EXEC QBM_PJobCreate_HOFireEvent @objecttype,187        @whereclause,188        @EventName,189        @GenProcID,190        @AdditionalObjectKeysAffected,191        @ConnectionVariables,192        @AuthenticationString,193        @SingleTransaction,194        @p2,195        @v2,196        @p3,197        @v3,198        @p4,199        @v4,200        @p5,201        @v5,202        @p6,203        @v6,204        @p7,205        @v7,206        @p8,207        @v8,208        @p9,209        @v9,210        @p10,211        @v10,212        @p11,213        @v11,214        @p12,215        @v12,216        @p13,217        @v13,218        @p14,219        @v14,220        @p15,221        @v15,222        @p16,223        @v16,224        @p17,225        @v17,226        @p18,227        @v18,228        @p19,229        @v19,230        @p20,231        @v20,232        @p21,233        @v21,234        @p22,235        @v22,236        @p23,237        @v23,238        @p24,239        @v24,240        @p25,241        @v25,242        @p26,243        @v26,244        @p27,245        @v27,246        @p28,247        @v28,248        @p29,249        @v29,250        @p30,251        @v30,252        @p31,253        @v31,254        @isToFreezeOnError,255        @Retries,256        @priority,257        @Jobchainname,258        @StartAt,259        @BasisObjectKey,260        @XUser,261        @WhereClauseAdditional,262        @checkForExisting,263        @QueueName264    END265  END TRY266  BEGIN CATCH267    EXEC QBM_PSessionErrorAdd DEFAULT268    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()269    RAISERROR(@Rethrow,270    18,271    1)272      WITH NOWAIT273  END CATCH274  ende:275  RETURN276END

Open raw exported source

1  create   procedure QBM_PJobCreate_HOFireEvent_B( @objecttype nvarchar(255),  @whereclause nvarchar(max),  @EventName nvarchar(256),  @GenProcID2 varchar(38) , @AdditionalObjectKeysAffected QBM_YParameterList readonly  , @ConnectionVariables nvarchar(max) = null , @AuthenticationString nvarchar(max3) = null , @SingleTransaction bit = 1 , @p2 nvarchar (1024) = N'', @v2 nvarchar (max) = N'' , @p3 nvarchar (1024) = N'', @v3 nvarchar (max) = N'' , @p44 nvarchar (1024) = N'', @v4 nvarchar (max) = N'' , @p5 nvarchar (1024) = N'', @v5 nvarchar (max) = N'' , @p6 nvarchar (1024) = N'', @v6 nvarchar (max) 5= N'' , @p7 nvarchar (1024) = N'', @v7 nvarchar (max) = N'' , @p8 nvarchar (1024) = N'', @v8 nvarchar (max) = N'' , @p9 nvarchar (1024) = N'', @v9 nvarchar6 (max) = N'' , @p10 nvarchar (1024) = N'', @v10 nvarchar (max) = N'' , @p11 nvarchar (1024) = N'', @v11 nvarchar (max) = N'' , @p12 nvarchar (1024) = N''7, @v12 nvarchar (max) = N'' , @p13 nvarchar (1024) = N'', @v13 nvarchar (max) = N'' , @p14 nvarchar (1024) = N'', @v14 nvarchar (max) = N'' , @p15 nvarchar8 (1024) = N'', @v15 nvarchar (max) = N'' , @p16 nvarchar (1024) = N'', @v16 nvarchar (max) = N'' , @p17 nvarchar (1024) = N'', @v17 nvarchar (max) = N''9 , @p18 nvarchar (1024) = N'', @v18 nvarchar (max) = N'' , @p19 nvarchar (1024) = N'', @v19 nvarchar (max) = N'' , @p20 nvarchar (1024) = N'', @v20 nvarchar10 (max) = N'' , @p21 nvarchar (1024) = N'', @v21 nvarchar (max) = N'' , @p22 nvarchar (1024) = N'', @v22 nvarchar (max) = N'' , @p23 nvarchar (1024) = N''11, @v23 nvarchar (max) = N'' , @p24 nvarchar (1024) = N'', @v24 nvarchar (max) = N'' , @p25 nvarchar (1024) = N'', @v25 nvarchar (max) = N'' , @p26 nvarchar12 (1024) = N'', @v26 nvarchar (max) = N'' , @p27 nvarchar (1024) = N'', @v27 nvarchar (max) = N'' , @p28 nvarchar (1024) = N'', @v28 nvarchar (max) = N''13 , @p29 nvarchar (1024) = N'', @v29 nvarchar (max) = N'' , @p30 nvarchar (1024) = N'', @v30 nvarchar (max) = N'' , @p31 nvarchar (1024) = N'', @v31 nvarchar14 (max) = N'' , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256) = null , @StartAt datetime = null , @BasisObjectKey15 varchar(138) = N'' , @XUser nvarchar(64) = null , @WhereClauseAdditional nvarchar(max) = '' , @checkForExisting bit = 0 , @QueueName nvarchar(256) = null16 ) as begin declare @XObjectKeysToTransfer QBM_YParameterList declare @SQLCmd nvarchar(max)  SET XACT_ABORT OFF BEGIN TRY if exists (select top 1 1 from17 DialogTable t with (readpast) join DialogColumn c with (readpast) on t.UID_DialogTable = c.UID_DialogTable where t.TableName = @objecttype and c.ColumnName18 = 'XObjectKey' ) begin select @SQLCmd = N'19	  select XObjectKey 20		from ' + @objecttype + N'21		where ( ' + @whereclause + N' )22		order by 1 ' insert23 into @XObjectKeysToTransfer(Parameter1) exec sp_executeSQL @SQLCmd exec QBM_PJobCreate_HOFireEvent_L @objecttype, @XObjectKeysToTransfer ,  @EventName24, @GenProcID , @AdditionalObjectKeysAffected  , @ConnectionVariables , @AuthenticationString , @SingleTransaction , @p2, @v2, @p3, @v3, @p4, @v4, @p5, 25@v5, @p6, @v6, @p7, @v7, @p8, @v8, @p9, @v9, @p10, @v10, @p11, @v11, @p12, @v12, @p13, @v13, @p14, @v14, @p15, @v15, @p16, @v16, @p17, @v17, @p18, @v1826, @p19, @v19, @p20, @v20, @p21, @v21, @p22, @v22, @p23, @v23, @p24, @v24, @p25, @v25, @p26, @v26, @p27, @v27, @p28, @v28, @p29, @v29, @p30, @v30, @p31,27 @v31 , @isToFreezeOnError , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey , @XUser , @WhereClauseAdditional , @checkForExisting , 28@QueueName end else begin exec QBM_PJobCreate_HOFireEvent @objecttype, @whereclause ,  @EventName, @GenProcID , @AdditionalObjectKeysAffected  , @ConnectionVariables29 , @AuthenticationString , @SingleTransaction , @p2, @v2, @p3, @v3, @p4, @v4, @p5, @v5, @p6, @v6, @p7, @v7, @p8, @v8, @p9, @v9, @p10, @v10, @p11, @v11,30 @p12, @v12, @p13, @v13, @p14, @v14, @p15, @v15, @p16, @v16, @p17, @v17, @p18, @v18, @p19, @v19, @p20, @v20, @p21, @v21, @p22, @v22, @p23, @v23, @p24, 31@v24, @p25, @v25, @p26, @v26, @p27, @v27, @p28, @v28, @p29, @v29, @p30, @v30, @p31, @v31 , @isToFreezeOnError , @Retries , @priority , @Jobchainname , 32@StartAt , @BasisObjectKey , @XUser , @WhereClauseAdditional , @checkForExisting , @QueueName end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default33 declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 34