Back to OIM Explorer

dbo.QBM_PF3416818676AABF8BABD3AB_

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. HOFireEvent -> .@EventName at line 22; References QBM_PJobCreate*; References QBM_PJobCreate_HOFireEvent*

Source: sandbox-db sys.sql_modules

Source size: 4.129 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

  • HOFireEvent -> .@EventName at line 22
  • References QBM_PJobCreate*
  • References QBM_PJobCreate_HOFireEvent*

Typed Edges

  • references source dbo.QBM_FCVParameter1AsOneInClause source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HOFireEvent source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL213 lines
1CREATE PROCEDURE QBM_PF3416818676AABF8BABD3AB_(2  @Portion int,3  @AllObjectKeysIn QBM_YObjectKeyAndPortion READONLY,4  @objecttype nvarchar(255),5  @EventName nvarchar(256),6  @GenProcID varchar(38),7  @AdditionalObjectKeysAffected QBM_YParameterList READONLY,8  @ConnectionVariables nvarchar(max) = NULL,9  @AuthenticationString nvarchar(max) = NULL,10  @SingleTransaction BIT = 1,11  @p2 nvarchar(1024) = N '',12  @v2 nvarchar(max) = N '',13  @p3 nvarchar(1024) = N '',14  @v3 nvarchar(max) = N '',15  @p4 nvarchar(1024) = N '',16  @v4 nvarchar(max) = N '',17  @p5 nvarchar(1024) = N '',18  @v5 nvarchar(max) = N '',19  @p6 nvarchar(1024) = N '',20  @v6 nvarchar(max) = N '',21  @p7 nvarchar(1024) = N '',22  @v7 nvarchar(max) = N '',23  @p8 nvarchar(1024) = N '',24  @v8 nvarchar(max) = N '',25  @p9 nvarchar(1024) = N '',26  @v9 nvarchar(max) = N '',27  @p10 nvarchar(1024) = N '',28  @v10 nvarchar(max) = N '',29  @p11 nvarchar(1024) = N '',30  @v11 nvarchar(max) = N '',31  @p12 nvarchar(1024) = N '',32  @v12 nvarchar(max) = N '',33  @p13 nvarchar(1024) = N '',34  @v13 nvarchar(max) = N '',35  @p14 nvarchar(1024) = N '',36  @v14 nvarchar(max) = N '',37  @p15 nvarchar(1024) = N '',38  @v15 nvarchar(max) = N '',39  @p16 nvarchar(1024) = N '',40  @v16 nvarchar(max) = N '',41  @p17 nvarchar(1024) = N '',42  @v17 nvarchar(max) = N '',43  @p18 nvarchar(1024) = N '',44  @v18 nvarchar(max) = N '',45  @p19 nvarchar(1024) = N '',46  @v19 nvarchar(max) = N '',47  @p20 nvarchar(1024) = N '',48  @v20 nvarchar(max) = N '',49  @p21 nvarchar(1024) = N '',50  @v21 nvarchar(max) = N '',51  @p22 nvarchar(1024) = N '',52  @v22 nvarchar(max) = N '',53  @p23 nvarchar(1024) = N '',54  @v23 nvarchar(max) = N '',55  @p24 nvarchar(1024) = N '',56  @v24 nvarchar(max) = N '',57  @p25 nvarchar(1024) = N '',58  @v25 nvarchar(max) = N '',59  @p26 nvarchar(1024) = N '',60  @v26 nvarchar(max) = N '',61  @p27 nvarchar(1024) = N '',62  @v27 nvarchar(max) = N '',63  @p28 nvarchar(1024) = N '',64  @v28 nvarchar(max) = N '',65  @p29 nvarchar(1024) = N '',66  @v29 nvarchar(max) = N '',67  @p30 nvarchar(1024) = N '',68  @v30 nvarchar(max) = N '',69  @p31 nvarchar(1024) = N '',70  @v31 nvarchar(max) = N '',71  @isToFreezeOnError BIT = 0,72  @Retries int = 0,73  @priority int = 5,74  @Jobchainname nvarchar(256) = NULL,75  @StartAt datetime = NULL,76  @BasisObjectKey varchar(138) = N '',77  @XUser nvarchar(64) = NULL,78  @WhereClauseAdditional nvarchar(max) = '',79  @checkForExisting BIT = 0,80  @QueueName nvarchar(256) = NULL81)82AS83BEGIN84  DECLARE @ObjectKeys_Part QBM_YParameterList85  DECLARE @Sammler nvarchar(max)86  DECLARE @ObjectKeysAffected QBM_YParameterList87  SET XACT_ABORT OFF88  BEGIN TRY89    INSERT INTO @ObjectKeys_Part(Parameter1)90    SELECT i.Objectkey91    FROM @AllObjectKeysIn i92    WHERE93      i.Portion = @Portion94    IF @@ROWCOUNT = 095    BEGIN96      GOTO endLabel97    END98    SELECT99      @sammler = CONCAT('XObjectKey in ',100      dbo.QBM_FCVParameter1AsOneInClause(@ObjectKeys_Part))101    IF NOT EXISTS(102      SELECT TOP 1 1103      FROM @AdditionalObjectKeysAffected104      WHERE105        Parameter1 > ' ' AND Parameter2 IS NULL)106    BEGIN107      INSERT INTO @ObjectKeysAffected(Parameter1)108      SELECT a.Parameter1109      FROM @AdditionalObjectKeysAffected a110      JOIN @ObjectKeys_Part s111        ON a.Parameter2 = s.Parameter1112      UNION113      SELECT Parameter1114      FROM @ObjectKeys_Part115    END116    ELSE117    BEGIN118      INSERT INTO @ObjectKeysAffected(Parameter1)119      SELECT a.Parameter1120      FROM @AdditionalObjectKeysAffected a121      UNION122      SELECT Parameter1123      FROM @ObjectKeys_Part124    END125    EXEC QBM_PJobCreate_HOFireEvent @objecttype,126      @Sammler,127      @EventName,128      @GenProcID,129      @ObjectKeysAffected,130      @ConnectionVariables,131      @AuthenticationString,132      @SingleTransaction,133      @p2,134      @v2,135      @p3,136      @v3,137      @p4,138      @v4,139      @p5,140      @v5,141      @p6,142      @v6,143      @p7,144      @v7,145      @p8,146      @v8,147      @p9,148      @v9,149      @p10,150      @v10,151      @p11,152      @v11,153      @p12,154      @v12,155      @p13,156      @v13,157      @p14,158      @v14,159      @p15,160      @v15,161      @p16,162      @v16,163      @p17,164      @v17,165      @p18,166      @v18,167      @p19,168      @v19,169      @p20,170      @v20,171      @p21,172      @v21,173      @p22,174      @v22,175      @p23,176      @v23,177      @p24,178      @v24,179      @p25,180      @v25,181      @p26,182      @v26,183      @p27,184      @v27,185      @p28,186      @v28,187      @p29,188      @v29,189      @p30,190      @v30,191      @p31,192      @v31,193      @isToFreezeOnError,194      @Retries,195      @priority,196      @Jobchainname,197      @StartAt,198      @BasisObjectKey,199      @XUser,200      @WhereClauseAdditional,201      @checkForExisting,202      @QueueName203  END TRY204  BEGIN CATCH205    EXEC QBM_PSessionErrorAdd DEFAULT206    RAISERROR('',207    18,208    1)209      WITH NOWAIT210  END CATCH211  endLabel:212  RETURN213END
Open raw exported source
SQL ยท Raw28 lines
1create   procedure QBM_PF3416818676AABF8BABD3AB_ ( @Portion int , @AllObjectKeysIn QBM_YObjectKeyAndPortion readonly  , @objecttype nvarchar(2552),      @EventName nvarchar(256),  @GenProcID varchar(38) , @AdditionalObjectKeysAffected QBM_YParameterList readonly     , @ConnectionVariables nvarchar3(max) = null , @AuthenticationString nvarchar(max) = null , @SingleTransaction bit = 1 , @p2 nvarchar (1024) = N'', @v2 nvarchar (max) = N'' , @p3 nvarchar4 (1024) = N'', @v3 nvarchar (max) = N'' , @p4 nvarchar (1024) = N'', @v4 nvarchar (max) = N'' , @p5 nvarchar (1024) = N'', @v5 nvarchar (max) = N'' , @p65 nvarchar (1024) = N'', @v6 nvarchar (max) = N'' , @p7 nvarchar (1024) = N'', @v7 nvarchar (max) = N'' , @p8 nvarchar (1024) = N'', @v8 nvarchar (max) 6= N'' , @p9 nvarchar (1024) = N'', @v9 nvarchar (max) = N'' , @p10 nvarchar (1024) = N'', @v10 nvarchar (max) = N'' , @p11 nvarchar (1024) = N'', @v11 7nvarchar (max) = N'' , @p12 nvarchar (1024) = N'', @v12 nvarchar (max) = N'' , @p13 nvarchar (1024) = N'', @v13 nvarchar (max) = N'' , @p14 nvarchar (10248) = N'', @v14 nvarchar (max) = N'' , @p15 nvarchar (1024) = N'', @v15 nvarchar (max) = N'' , @p16 nvarchar (1024) = N'', @v16 nvarchar (max) = N'' , @p179 nvarchar (1024) = N'', @v17 nvarchar (max) = N'' , @p18 nvarchar (1024) = N'', @v18 nvarchar (max) = N'' , @p19 nvarchar (1024) = N'', @v19 nvarchar (max10) = N'' , @p20 nvarchar (1024) = N'', @v20 nvarchar (max) = N'' , @p21 nvarchar (1024) = N'', @v21 nvarchar (max) = N'' , @p22 nvarchar (1024) = N'', @v2211 nvarchar (max) = N'' , @p23 nvarchar (1024) = N'', @v23 nvarchar (max) = N'' , @p24 nvarchar (1024) = N'', @v24 nvarchar (max) = N'' , @p25 nvarchar (102412) = N'', @v25 nvarchar (max) = N'' , @p26 nvarchar (1024) = N'', @v26 nvarchar (max) = N'' , @p27 nvarchar (1024) = N'', @v27 nvarchar (max) = N'' , @p2813 nvarchar (1024) = N'', @v28 nvarchar (max) = N'' , @p29 nvarchar (1024) = N'', @v29 nvarchar (max) = N'' , @p30 nvarchar (1024) = N'', @v30 nvarchar (max14) = N'' , @p31 nvarchar (1024) = N'', @v31 nvarchar (max) = N'' , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar15(256) = null , @StartAt datetime = null , @BasisObjectKey varchar(138) = N'' , @XUser nvarchar(64) = null , @WhereClauseAdditional nvarchar(max) = '' ,16 @checkForExisting bit = 0 , @QueueName nvarchar(256) = null ) as begin declare @ObjectKeys_Part QBM_YParameterList declare @Sammler nvarchar(max) declare17 @ObjectKeysAffected QBM_YParameterList SET XACT_ABORT OFF BEGIN TRY insert into @ObjectKeys_Part(Parameter1) select i.Objectkey from @AllObjectKeysIn 18i where i.Portion = @Portion if @@ROWCOUNT = 0 begin goto endLabel end select @sammler = concat('XObjectKey in ' , dbo.QBM_FCVParameter1AsOneInClause(@ObjectKeys_Part19) )  if not exists (select top 1 1 from @AdditionalObjectKeysAffected where Parameter1 > ' ' and Parameter2 is null ) begin insert into @ObjectKeysAffected20(Parameter1) select a.Parameter1 from @AdditionalObjectKeysAffected a join @ObjectKeys_Part s on a.Parameter2 = s.Parameter1 union select Parameter1 from21 @ObjectKeys_Part end else begin  insert into @ObjectKeysAffected(Parameter1) select a.Parameter1 from @AdditionalObjectKeysAffected a union select Parameter122 from @ObjectKeys_Part end exec QBM_PJobCreate_HOFireEvent @objecttype , @Sammler , @EventName  , @GenProcID , @ObjectKeysAffected , @ConnectionVariables23 , @AuthenticationString , @SingleTransaction  , @p2, @v2 , @p3, @v3 , @p4, @v4 , @p5, @v5 , @p6, @v6 ,@p7, @v7 , @p8, @v8 , @p9, @v9 , @p10, @v10 , @p1124, @v11 , @p12, @v12 , @p13, @v13 , @p14, @v14 , @p15, @v15 , @p16, @v16 ,@p17, @v17 , @p18, @v18 , @p19, @v19 , @p20, @v20 , @p21, @v21 , @p22, @v22 , 25@p23, @v23 , @p24, @v24 , @p25, @v25 , @p26, @v26 , @p27, @v27 , @p28, @v28 , @p29, @v29 , @p30, @v30 , @p31, @v31 , @isToFreezeOnError , @Retries , @priority26 , @Jobchainname , @StartAt , @BasisObjectKey , @XUser , @WhereClauseAdditional , @checkForExisting , @QueueName END TRY BEGIN CATCH exec QBM_PSessionErrorAdd27 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 28