dbo.QER_PITShopProductNodeCreate_b

SQL_STORED_PROCEDURE

Created 2025-06-27T18:01:06.273 · modified 2026-04-14T23:20:38.787 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
`@uid_orgBO`	varchar	no
`@ObjectKeyElements`	QBM_YParameterList	no
`@GenProcID`	varchar	no
`@uid_OrgPR`	varchar	yes

Referenced objects

Schema	Object	Class
	AccProduct	OBJECT_OR_COLUMN
	AccProductGroup	OBJECT_OR_COLUMN
	BaseTree	OBJECT_OR_COLUMN
	BaseTreeAssign	OBJECT_OR_COLUMN
	DialogColumn	OBJECT_OR_COLUMN
	DialogTable	OBJECT_OR_COLUMN
	PWOHelperBoardMethod	OBJECT_OR_COLUMN
	QBM_PJobCreate_HOUpdate	OBJECT_OR_COLUMN
	QBM_PSessionContextSet	OBJECT_OR_COLUMN
	QBM_PSessionErrorAdd	OBJECT_OR_COLUMN
	QBM_VQBMRelation	OBJECT_OR_COLUMN
	QBM_YCursorBuffer	TYPE
	QBM_YParameterList	TYPE
dbo	QBM_FCVBinaryToString	OBJECT_OR_COLUMN
dbo	QBM_FCVElementToObjectKey1	OBJECT_OR_COLUMN
dbo	QBM_FCVObjectkeyToElement	OBJECT_OR_COLUMN
dbo	QBM_FGIIsSimulationMode	OBJECT_OR_COLUMN
dbo	QBM_FGISessionContext	OBJECT_OR_COLUMN
dbo	QBM_FGISessionErrorRethrow	OBJECT_OR_COLUMN
dbo	QER_FGIBitPatternInheritInfo	OBJECT_OR_COLUMN

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:38.787

creates object-layer jobs via QBM_PJobCreate* uses session context values has TRY/CATCH error handling

Summary: calls QBM_PSessionContextSet, QBM_PFESimulationFill, QBM_PJobCreate_HOUpdate, QBM_PSessionErrorAdd; writes INSERT into, INSERT BaseTree, INSERT BaseTreeHasObject, UPDATE ITShopOrg, DELETE BaseTree; reads/joins DialogTable, BaseTreeAssign, DialogColumn, QBM_VQBMRelation, BaseTree…; uses session context XUser, GenProcID

Declared parameters

Parameter	Type	Direction
`@uid_orgBO`	`varchar(38)`	input
`@ObjectKeyElements`	`qbm_yparameterlist`	input
`@GenProcID`	`varchar(38)`	input
`@uid_OrgPR`	`varchar(38)`	OUTPUT

DML targets

INSERT into INSERT BaseTree INSERT BaseTreeHasObject UPDATE ITShopOrg DELETE BaseTree

Called routines

Read/join references

Config/session

Config: None extracted.

Session: XUser GenProcID

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: #Struktur #Struktur1 #struktur

Variables: @uid_orgBO @ObjectKeyElements @GenProcID @uid_OrgPR @IsSimulationMode @LeftViewName @LeftViewPKName @WhereClauseOrg @BasisObjectKey @uid_AccProduct @ident_orgInitial @UID_OrgRoot @SQLCmd @GenProcID_R @XUser_R @DebugSwitch @StringQERFGIBitPatternInheritInfo_Direct @XUser @procid @ElementBufferTables @ElementBufferFall2 @ElementBufferFall4 @ElementBufferJob @ElementCount @ElementIndex @ROWCOUNT @Ident_OrgInitial @SimulationModeBuffer @whereclauseOrg @ObjectKeysAffected @p1 @v1 @uid_accproduct @isToFreezeOnError @Retries @uid_ACCProduct @Rethrow

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.

Referencing object	Relation	Evidence
dbo.QER_PITShop_PRNodesMove	SQL expression dependency	OBJECT_OR_COLUMN
dbo.QER_PITShopProductNodeCheck	SQL expression dependency	OBJECT_OR_COLUMN
dbo.QER_PITShopProductNodeCreate	SQL expression dependency	OBJECT_OR_COLUMN
dbo.QER_PITShop_PRNodesMove	source text reference	uses session context values, has TRY/CATCH error handling
dbo.QER_PITShopProductNodeCheck	source text reference	creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, fires object-layer event via HOFireEvent, uses session context values, has TRY/CATCH error handling
dbo.QER_PITShopProductNodeCreate	source text reference	has TRY/CATCH error handling