Back to OIM Explorer

dbo.QBM_PJobCreate_HOImportXML

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. References QBM_PJobCreate*

Source: sandbox-db sys.sql_modules

Source size: 3.571 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*

Typed Edges

  • references source dbo.QBM_FGIJobCreateName source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL179 lines
1CREATE PROCEDURE QBM_PJobCreate_HOImportXML(2  @objecttype nvarchar(255),3  @GenProcID varchar(38),4  @ObjectKeysAffected QBM_YParameterList READONLY,5  @p1 nvarchar(1024) = N '',6  @v1 nvarchar(max) = N '',7  @p2 nvarchar(1024) = N '',8  @v2 nvarchar(max) = N '',9  @p3 nvarchar(1024) = N '',10  @v3 nvarchar(max) = N '',11  @p4 nvarchar(1024) = N '',12  @v4 nvarchar(max) = N '',13  @p5 nvarchar(1024) = N '',14  @v5 nvarchar(max) = N '',15  @p6 nvarchar(1024) = N '',16  @v6 nvarchar(max) = N '',17  @p7 nvarchar(1024) = N '',18  @v7 nvarchar(max) = N '',19  @p8 nvarchar(1024) = N '',20  @v8 nvarchar(max) = N '',21  @p9 nvarchar(1024) = N '',22  @v9 nvarchar(max) = N '',23  @p10 nvarchar(1024) = N '',24  @v10 nvarchar(max) = N '',25  @p11 nvarchar(1024) = N '',26  @v11 nvarchar(max) = N '',27  @p12 nvarchar(1024) = N '',28  @v12 nvarchar(max) = N '',29  @p13 nvarchar(1024) = N '',30  @v13 nvarchar(max) = N '',31  @p14 nvarchar(1024) = N '',32  @v14 nvarchar(max) = N '',33  @p15 nvarchar(1024) = N '',34  @v15 nvarchar(max) = N '',35  @p16 nvarchar(1024) = N '',36  @v16 nvarchar(max) = N '',37  @p17 nvarchar(1024) = N '',38  @v17 nvarchar(max) = N '',39  @p18 nvarchar(1024) = N '',40  @v18 nvarchar(max) = N '',41  @p19 nvarchar(1024) = N '',42  @v19 nvarchar(max) = N '',43  @p20 nvarchar(1024) = N '',44  @v20 nvarchar(max) = N '',45  @p21 nvarchar(1024) = N '',46  @v21 nvarchar(max) = N '',47  @p22 nvarchar(1024) = N '',48  @v22 nvarchar(max) = N '',49  @p23 nvarchar(1024) = N '',50  @v23 nvarchar(max) = N '',51  @p24 nvarchar(1024) = N '',52  @v24 nvarchar(max) = N '',53  @p25 nvarchar(1024) = N '',54  @v25 nvarchar(max) = N '',55  @p26 nvarchar(1024) = N '',56  @v26 nvarchar(max) = N '',57  @p27 nvarchar(1024) = N '',58  @v27 nvarchar(max) = N '',59  @p28 nvarchar(1024) = N '',60  @v28 nvarchar(max) = N '',61  @p29 nvarchar(1024) = N '',62  @v29 nvarchar(max) = N '',63  @p30 nvarchar(1024) = N '',64  @v30 nvarchar(max) = N '',65  @p31 nvarchar(1024) = N '',66  @v31 nvarchar(max) = N '',67  @isToFreezeOnError BIT = 0,68  @Retries int = 0,69  @priority int = 5,70  @Jobchainname nvarchar(256) = NULL,71  @StartAt datetime = NULL,72  @BasisObjectKey varchar(138) = N '',73  @XUser nvarchar(64) = NULL,74  @checkForExisting BIT = 0,75  @QueueName nvarchar(256) = NULL76)77AS78BEGIN79  DECLARE @Parameters QBM_YParameterList80  DECLARE @JobChainNameAddOn nvarchar(256)81  SET XACT_ABORT OFF82  BEGIN TRY83    IF @Jobchainname IS NULL84    BEGIN85      SELECT @JobChainNameAddOn = ' handle object import XML for object type ' + @objecttype86      SELECT @Jobchainname =dbo.QBM_FGIJobCreateName(@JobChainNameAddOn)87    END88    INSERT INTO @Parameters(Parameter1,89    ContentFull)90    VALUES('objecttype',91    @objecttype),92    (@p1,93    @v1),94    (@p2,95    @v2),96    (@p3,97    @v3),98    (@p4,99    @v4),100    (@p5,101    @v5),102    (@p6,103    @v6),104    (@p7,105    @v7),106    (@p8,107    @v8),108    (@p9,109    @v9),110    (@p10,111    @v10),112    (@p11,113    @v11),114    (@p12,115    @v12),116    (@p13,117    @v13),118    (@p14,119    @v14),120    (@p15,121    @v15),122    (@p16,123    @v16),124    (@p17,125    @v17),126    (@p18,127    @v18),128    (@p19,129    @v19),130    (@p20,131    @v20),132    (@p21,133    @v21),134    (@p22,135    @v22),136    (@p23,137    @v23),138    (@p24,139    @v24),140    (@p25,141    @v25),142    (@p26,143    @v26),144    (@p27,145    @v27),146    (@p28,147    @v28),148    (@p29,149    @v29),150    (@p30,151    @v30),152    (@p31,153    @v31)154    EXEC QBM_PJobCreate 'VI.JobService.JobComponents.HandleObjectComponent',155    'IMPORTSINGLEXML',156      @Parameters,157      @GenProcID,158      @ObjectKeysAffected,159      @isToFreezeOnError,160      @Retries,161      @priority,162      @Jobchainname,163      @StartAt,164      @BasisObjectKey,165      @XUser,166      @QueueName,167      @checkForExisting168  END TRY169  BEGIN CATCH170    EXEC QBM_PSessionErrorAdd DEFAULT171    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()172    RAISERROR(@Rethrow,173    18,174    1)175      WITH NOWAIT176  END CATCH177  ende:178  RETURN179END
Open raw exported source
SQL ยท Raw24 lines
1 create   procedure QBM_PJobCreate_HOImportXML  ( @objecttype nvarchar(255)  , @GenProcID varchar(38) , @ObjectKeysAffected QBM_YParameterList readOnly2  ,@p1 nvarchar (1024) = N'', @v1 nvarchar (max) = N'' , @p2 nvarchar (1024) = N'', @v2 nvarchar (max) = N'' , @p3 nvarchar (1024) = N'', @v3 nvarchar 3(max) = N'' , @p4 nvarchar (1024) = N'', @v4 nvarchar (max) = N'' , @p5 nvarchar (1024) = N'', @v5 nvarchar (max) = N'' , @p6 nvarchar (1024) = N'', @v64 nvarchar (max) = N'' , @p7 nvarchar (1024) = N'', @v7 nvarchar (max) = N'' , @p8 nvarchar (1024) = N'', @v8 nvarchar (max) = N'' , @p9 nvarchar (1024)5 = N'', @v9 nvarchar (max) = N'' , @p10 nvarchar (1024) = N'', @v10 nvarchar (max) = N'' , @p11 nvarchar (1024) = N'', @v11 nvarchar (max) = N'' , @p126 nvarchar (1024) = N'', @v12 nvarchar (max) = N'' , @p13 nvarchar (1024) = N'', @v13 nvarchar (max) = N'' , @p14 nvarchar (1024) = N'', @v14 nvarchar (max7) = N'' , @p15 nvarchar (1024) = N'', @v15 nvarchar (max) = N'' , @p16 nvarchar (1024) = N'', @v16 nvarchar (max) = N'' , @p17 nvarchar (1024) = N'', @v178 nvarchar (max) = N'' , @p18 nvarchar (1024) = N'', @v18 nvarchar (max) = N'' , @p19 nvarchar (1024) = N'', @v19 nvarchar (max) = N'' , @p20 nvarchar (10249) = N'', @v20 nvarchar (max) = N'' , @p21 nvarchar (1024) = N'', @v21 nvarchar (max) = N'' , @p22 nvarchar (1024) = N'', @v22 nvarchar (max) = N'' , @p2310 nvarchar (1024) = N'', @v23 nvarchar (max) = N'' , @p24 nvarchar (1024) = N'', @v24 nvarchar (max) = N'' , @p25 nvarchar (1024) = N'', @v25 nvarchar (max11) = N'' , @p26 nvarchar (1024) = N'', @v26 nvarchar (max) = N'' , @p27 nvarchar (1024) = N'', @v27 nvarchar (max) = N'' , @p28 nvarchar (1024) = N'', @v2812 nvarchar (max) = N'' , @p29 nvarchar (1024) = N'', @v29 nvarchar (max) = N'' , @p30 nvarchar (1024) = N'', @v30 nvarchar (max) = N'' , @p31 nvarchar (102413) = N'', @v31 nvarchar (max) = N'' , @isToFreezeOnError bit = 0 , @Retries int = 0 , @priority int = 5 , @Jobchainname nvarchar(256) = null , @StartAt 14datetime = null , @BasisObjectKey varchar(138) = N'' , @XUser nvarchar(64) = null , @checkForExisting bit = 0 , @QueueName nvarchar(256) = null ) as begin15 declare @Parameters QBM_YParameterList declare @JobChainNameAddOn nvarchar(256) SET XACT_ABORT OFF BEGIN TRY if @Jobchainname is null begin select @JobChainNameAddOn16 = ' handle object import XML for object type ' + @objecttype select @Jobchainname =dbo.QBM_FGIJobCreateName ( @JobChainNameAddOn) end insert into @Parameters17 (Parameter1, ContentFull) values ('objecttype', @objecttype) , ( @p1 , @v1 ) , ( @p2 , @v2 ) , ( @p3 , @v3 ) , ( @p4 , @v4 ) , ( @p5 , @v5 ) , ( @p6 ,18 @v6 ) , ( @p7 , @v7 ) , ( @p8 , @v8 ) , ( @p9 , @v9 ) , ( @p10 , @v10 ) , ( @p11 , @v11 ) , ( @p12 , @v12 ) , ( @p13 , @v13 ) , ( @p14 , @v14 ) , ( @p1519 , @v15 ) , ( @p16 , @v16 ) , ( @p17 , @v17 ) , ( @p18 , @v18 ) , ( @p19 , @v19 ) , ( @p20 , @v20 ) , ( @p21 , @v21 ) , ( @p22 , @v22 ) , ( @p23 , @v2320 ) , ( @p24 , @v24 ) , ( @p25 , @v25 ) , ( @p26 , @v26 ) , ( @p27 , @v27 ) , ( @p28 , @v28 ) , ( @p29 , @v29 ) , ( @p30 , @v30 ) , ( @p31 , @v31 ) exec21 QBM_PJobCreate 'VI.JobService.JobComponents.HandleObjectComponent' , 'IMPORTSINGLEXML' , @Parameters , @GenProcID , @ObjectKeysAffected , @isToFreezeOnError22 , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey , @XUser , @QueueName , @checkForExisting END TRY BEGIN CATCH exec QBM_PSessionErrorAdd23 default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 24