dbo.QER_PITShopOrderMove_bulk

SQL_STORED_PROCEDURE

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

Open formatted source/search result

Parameters

Name	Type	Output
`@pwos`	QBM_YParameterList	no

Referenced objects

Schema	Object	Class
	AccProduct	OBJECT_OR_COLUMN
	BaseTree	OBJECT_OR_COLUMN
	BaseTreeAssign	OBJECT_OR_COLUMN
	DialogTable	OBJECT_OR_COLUMN
	OrgRootAssign	OBJECT_OR_COLUMN
	Person	OBJECT_OR_COLUMN
	PersonInBaseTree	OBJECT_OR_COLUMN
	PersonWantsOrg	OBJECT_OR_COLUMN
	pwodecisionHistory	OBJECT_OR_COLUMN
	PWOHelperPWO	OBJECT_OR_COLUMN
	QBM_PExecuteSQLMulti	OBJECT_OR_COLUMN
	QBM_PJobCreate_HOCallMethod_L	OBJECT_OR_COLUMN
	QBM_PSessionContextSet	OBJECT_OR_COLUMN
	QBM_PSessionErrorAdd	OBJECT_OR_COLUMN
	QBM_YCursorbuffer	TYPE
	QBM_YParameterList	TYPE
	QER_PGIQERWorkingMethod	OBJECT_OR_COLUMN
	QER_PITShopHelperFill_bulk	OBJECT_OR_COLUMN
	QERAssign	OBJECT_OR_COLUMN
	QERWorkingStep	OBJECT_OR_COLUMN
dbo	QBM_FCVElementToObjectKey1	OBJECT_OR_COLUMN
dbo	QBM_FCVElementToObjectKey2	OBJECT_OR_COLUMN
dbo	QBM_FCVStringToBit	OBJECT_OR_COLUMN
dbo	QBM_FGIBitPatternXOrigin	OBJECT_OR_COLUMN
dbo	QBM_FGIColumnExistsInSchema	OBJECT_OR_COLUMN
dbo	QBM_FGIConfigparmValue	OBJECT_OR_COLUMN
dbo	QBM_FGISessionContext	OBJECT_OR_COLUMN
dbo	QER_FCVObjectkeyToBaseTree	OBJECT_OR_COLUMN
dbo	QER_FGIGenProcIDForPWO	OBJECT_OR_COLUMN
dbo	QER_FGIITShopNewPersonOrdered	OBJECT_OR_COLUMN
dbo	QER_FTITShopNewProductNode	OBJECT_OR_COLUMN

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.987

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

Summary: calls QBM_PSessionContextSet, QER_PGIQERWorkingMethod, QBM_PExecuteSQLMulti, QBM_PJobCreate_HOCallMethod_L, QER_PITShopHelperFill_bulk…; writes INSERT into, INSERT pwodecisionHistory, INSERT PersonInBaseTree, UPDATE PersonInBaseTree, UPDATE personwantsorg…; reads/joins PersonWantsOrg, DialogTable, BaseTreeAssign, BaseTree, AccProduct…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop\ReplaceAssignmentRequestOnLeaveCU; uses session context XUser, GenProcID

Declared parameters

Parameter	Type	Direction
`@pwos`	`qbm_yparameterlist`	input

DML targets

INSERT into INSERT pwodecisionHistory INSERT PersonInBaseTree UPDATE PersonInBaseTree UPDATE personwantsorg UPDATE PersonWantsOrg DELETE PersonInBaseTree DELETE PWOHelperPWO

Called routines

Read/join references

Config/session

Config: Common\ProcessState\UseGenProcIDFromPWO QER\ITShop\ReplaceAssignmentRequestOnLeaveCU

Session: XUser GenProcID

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: #LDS #Move #Product #Assignment

Variables: @pwos @PwoToMove @HistorySammler @InsertHistorySammler @XUser @procid @jetzt @DescriptionForHistory @AbortWhereAddOn @GenProcID_R @XUser_R @UID_PwodecisionMethodNew @UID_QERWorkingMethod @Orderstate @ElementCount @ElementIndex @ElementLast @CfgUseGenProcID @QBM_BitPatternXOrigin_Direct @QBM_BitPatternXOrigin_Direct_inv @GenProcIDImZyklus @pwoToAbort @UID_PersonWantsOrg @SQLCmd @DebugSwitch @PWOsToFill @AdditionalObjectKeysAffected @rowcount @ElementOrderState @ROWCOUNT @IDENTITY @ElementSatetement @PROCID @GenProcIDs @param1 @Retries @checkForExisting @WhereClauseAdditional @GenProcIDsAbort @param2

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_PITShopOrderMove	SQL expression dependency	OBJECT_OR_COLUMN
dbo.QER_PITShopProductNodeCheck	SQL expression dependency	OBJECT_OR_COLUMN
dbo.QER_PITShopProductNodeMove	SQL expression dependency	OBJECT_OR_COLUMN
dbo.QER_ZITShopMemberDelete	SQL expression dependency	OBJECT_OR_COLUMN
dbo.QER_PITShopOrderMove	source text reference	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_PITShopProductNodeMove	source text reference	uses session context values, has TRY/CATCH error handling
dbo.QER_ZITShopMemberDelete	source text reference	has TRY/CATCH error handling