dbo.QBM_PJobCreate_HOImportXML
SQL_STORED_PROCEDURE
Created 2025-06-27T18:01:00.097 · modified 2026-04-14T23:20:31.563 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@objecttype | nvarchar | no |
@GenProcID | varchar | no |
@ObjectKeysAffected | QBM_YParameterList | no |
@p1 | nvarchar | no |
@v1 | nvarchar | no |
@p2 | nvarchar | no |
@v2 | nvarchar | no |
@p3 | nvarchar | no |
@v3 | nvarchar | no |
@p4 | nvarchar | no |
@v4 | nvarchar | no |
@p5 | nvarchar | no |
@v5 | nvarchar | no |
@p6 | nvarchar | no |
@v6 | nvarchar | no |
@p7 | nvarchar | no |
@v7 | nvarchar | no |
@p8 | nvarchar | no |
@v8 | nvarchar | no |
@p9 | nvarchar | no |
@v9 | nvarchar | no |
@p10 | nvarchar | no |
@v10 | nvarchar | no |
@p11 | nvarchar | no |
@v11 | nvarchar | no |
@p12 | nvarchar | no |
@v12 | nvarchar | no |
@p13 | nvarchar | no |
@v13 | nvarchar | no |
@p14 | nvarchar | no |
@v14 | nvarchar | no |
@p15 | nvarchar | no |
@v15 | nvarchar | no |
@p16 | nvarchar | no |
@v16 | nvarchar | no |
@p17 | nvarchar | no |
@v17 | nvarchar | no |
@p18 | nvarchar | no |
@v18 | nvarchar | no |
@p19 | nvarchar | no |
@v19 | nvarchar | no |
@p20 | nvarchar | no |
@v20 | nvarchar | no |
@p21 | nvarchar | no |
@v21 | nvarchar | no |
@p22 | nvarchar | no |
@v22 | nvarchar | no |
@p23 | nvarchar | no |
@v23 | nvarchar | no |
@p24 | nvarchar | no |
@v24 | nvarchar | no |
@p25 | nvarchar | no |
@v25 | nvarchar | no |
@p26 | nvarchar | no |
@v26 | nvarchar | no |
@p27 | nvarchar | no |
@v27 | nvarchar | no |
@p28 | nvarchar | no |
@v28 | nvarchar | no |
@p29 | nvarchar | no |
@v29 | nvarchar | no |
@p30 | nvarchar | no |
@v30 | nvarchar | no |
@p31 | nvarchar | no |
@v31 | nvarchar | no |
@isToFreezeOnError | bit | no |
@Retries | int | no |
@priority | int | no |
@Jobchainname | nvarchar | no |
@StartAt | datetime | no |
@BasisObjectKey | varchar | no |
@XUser | nvarchar | no |
@checkForExisting | bit | no |
@QueueName | nvarchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| QBM_PJobCreate | OBJECT_OR_COLUMN | ||
| QBM_PSessionErrorAdd | OBJECT_OR_COLUMN | ||
| QBM_YParameterList | TYPE | ||
| dbo | QBM_FGIJobCreateName | OBJECT_OR_COLUMN | |
| dbo | QBM_FGISessionErrorRethrow | OBJECT_OR_COLUMN |
Source excerpt
First extracted SQL definition lines from the exported source. Use the full source page for complete context.
1 create procedure QBM_PJobCreate_HOImportXML ( @objecttype nvarchar(255) , @GenProcID varchar(38) , @ObjectKeysAffected QBM_YParameterList readOnly 2 ,@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'', @v6 4 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'' , @p12 6 nvarchar (1024) = N'', @v12 nvarchar (max) = N'' , @p13 nvarchar (1024) = N'', @v13 nvarchar (max) = N'' , @p14 nvarchar (1024) = N'', @v14 nvarchar (max 7) = N'' , @p15 nvarchar (1024) = N'', @v15 nvarchar (max) = N'' , @p16 nvarchar (1024) = N'', @v16 nvarchar (max) = N'' , @p17 nvarchar (1024) = N'', @v17 8 nvarchar (max) = N'' , @p18 nvarchar (1024) = N'', @v18 nvarchar (max) = N'' , @p19 nvarchar (1024) = N'', @v19 nvarchar (max) = N'' , @p20 nvarchar (1024 9) = N'', @v20 nvarchar (max) = N'' , @p21 nvarchar (1024) = N'', @v21 nvarchar (max) = N'' , @p22 nvarchar (1024) = N'', @v22 nvarchar (max) = N'' , @p23 10 nvarchar (1024) = N'', @v23 nvarchar (max) = N'' , @p24 nvarchar (1024) = N'', @v24 nvarchar (max) = N'' , @p25 nvarchar (1024) = N'', @v25 nvarchar (max 11) = N'' , @p26 nvarchar (1024) = N'', @v26 nvarchar (max) = N'' , @p27 nvarchar (1024) = N'', @v27 nvarchar (max) = N'' , @p28 nvarchar (1024) = N'', @v28 12 nvarchar (max) = N'' , @p29 nvarchar (1024) = N'', @v29 nvarchar (max) = N'' , @p30 nvarchar (1024) = N'', @v30 nvarchar (max) = N'' , @p31 nvarchar (1024 13) = 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 begin 15 declare @Parameters QBM_YParameterList declare @JobChainNameAddOn nvarchar(256) SET XACT_ABORT OFF BEGIN TRY if @Jobchainname is null begin select @JobChainNameAddOn 16 = ' handle object import XML for object type ' + @objecttype select @Jobchainname =dbo.QBM_FGIJobCreateName ( @JobChainNameAddOn) end insert into @Parameters 17 (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 ) , ( @p15 19 , @v15 ) , ( @p16 , @v16 ) , ( @p17 , @v17 ) , ( @p18 , @v18 ) , ( @p19 , @v19 ) , ( @p20 , @v20 ) , ( @p21 , @v21 ) , ( @p22 , @v22 ) , ( @p23 , @v23 20 ) , ( @p24 , @v24 ) , ( @p25 , @v25 ) , ( @p26 , @v26 ) , ( @p27 , @v27 ) , ( @p28 , @v28 ) , ( @p29 , @v29 ) , ( @p30 , @v30 ) , ( @p31 , @v31 ) exec 21 QBM_PJobCreate 'VI.JobService.JobComponents.HandleObjectComponent' , 'IMPORTSINGLEXML' , @Parameters , @GenProcID , @ObjectKeysAffected , @isToFreezeOnError 22 , @Retries , @priority , @Jobchainname , @StartAt , @BasisObjectKey , @XUser , @QueueName , @checkForExisting END TRY BEGIN CATCH exec QBM_PSessionErrorAdd 23 default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 24
Module relation graph
Loading module relation graph…
Source-derived context
Generated from exported SQL module definitions plus read-only sandbox sys.objects/sys.parameters/sys.sql_expression_dependencies metadata. This is factual source evidence, not a semantic guess.
provenance: SQL definition export provenance: sandbox DB metadata modified: 2026-04-14T23:20:31.563
creates object-layer jobs via QBM_PJobCreate* has TRY/CATCH error handling
Summary: calls QBM_PJobCreate, QBM_PSessionErrorAdd; writes INSERT into
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@objecttype | nvarchar(255) | input |
@GenProcID | varchar(38) | input |
@ObjectKeysAffected | qbm_yparameterlist | input |
@p1 | nvarchar(1024) | input |
@v1 | nvarchar | input |
@p2 | nvarchar(1024) | input |
@v2 | nvarchar | input |
@p3 | nvarchar(1024) | input |
@v3 | nvarchar | input |
@p4 | nvarchar(1024) | input |
@v4 | nvarchar | input |
@p5 | nvarchar(1024) | input |
@v5 | nvarchar | input |
@p6 | nvarchar(1024) | input |
@v6 | nvarchar | input |
@p7 | nvarchar(1024) | input |
@v7 | nvarchar | input |
@p8 | nvarchar(1024) | input |
@v8 | nvarchar | input |
@p9 | nvarchar(1024) | input |
@v9 | nvarchar | input |
@p10 | nvarchar(1024) | input |
@v10 | nvarchar | input |
@p11 | nvarchar(1024) | input |
@v11 | nvarchar | input |
@p12 | nvarchar(1024) | input |
@v12 | nvarchar | input |
@p13 | nvarchar(1024) | input |
@v13 | nvarchar | input |
@p14 | nvarchar(1024) | input |
@v14 | nvarchar | input |
@p15 | nvarchar(1024) | input |
@v15 | nvarchar | input |
@p16 | nvarchar(1024) | input |
@v16 | nvarchar | input |
@p17 | nvarchar(1024) | input |
@v17 | nvarchar | input |
@p18 | nvarchar(1024) | input |
@v18 | nvarchar | input |
@p19 | nvarchar(1024) | input |
@v19 | nvarchar | input |
@p20 | nvarchar(1024) | input |
@v20 | nvarchar | input |
@p21 | nvarchar(1024) | input |
@v21 | nvarchar | input |
@p22 | nvarchar(1024) | input |
@v22 | nvarchar | input |
@p23 | nvarchar(1024) | input |
@v23 | nvarchar | input |
@p24 | nvarchar(1024) | input |
@v24 | nvarchar | input |
@p25 | nvarchar(1024) | input |
@v25 | nvarchar | input |
@p26 | nvarchar(1024) | input |
@v26 | nvarchar | input |
@p27 | nvarchar(1024) | input |
@v27 | nvarchar | input |
@p28 | nvarchar(1024) | input |
@v28 | nvarchar | input |
@p29 | nvarchar(1024) | input |
@v29 | nvarchar | input |
@p30 | nvarchar(1024) | input |
@v30 | nvarchar | input |
@p31 | nvarchar(1024) | input |
@v31 | nvarchar | input |
@isToFreezeOnError | bit | input |
@Retries | int | input |
@priority | int | input |
@Jobchainname | nvarchar(256) | input |
@StartAt | datetime | input |
@BasisObjectKey | varchar(138) | input |
@XUser | nvarchar(64) | input |
@checkForExisting | bit | input |
@QueueName | nvarchar(256) | input |
DML targets
INSERT intoCalled routines
Read/join references
None extracted.
SQL dependency metadata
Config/session
Config: None extracted.
Session: None extracted.
DBQueue/tasks
None extracted.Temp tables / referenced variables
Temp: None extracted.
Variables: @objecttype @GenProcID @ObjectKeysAffected @p1 @v1 @p2 @v2 @p3 @v3 @p4 @v4 @p5 @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 @v18 @p19
Referenced by / reverse dependencies
Generated from live DB metadata, FK rows, and exported SQL dependency/source extraction. This is factual linkage evidence, not inferred behavior.
No reverse dependencies extracted.