dbo.QER_ZITShopMakeDecisionEX

SQL_STORED_PROCEDURE

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

Open formatted source/search result

Parameters

NameTypeOutput
@SlotNumberintno

Referenced objects

SchemaObjectColumn/minorClass
personwantsorgOBJECT_OR_COLUMN
PWOHelperPWOOBJECT_OR_COLUMN
QBM_PJobCreate_HOFireEvent_BOBJECT_OR_COLUMN
QBM_PSessionErrorAddOBJECT_OR_COLUMN
QBM_YCursorBufferTYPE
QBMDBQueueCurrentOBJECT_OR_COLUMN
QERWorkingStepOBJECT_OR_COLUMN
dboQBM_FCVIntToStringOBJECT_OR_COLUMN
dboQBM_FCVStringToBitOBJECT_OR_COLUMN
dboQBM_FGIConfigparmValueOBJECT_OR_COLUMN
dboQER_FGIGenProcIDForPWOOBJECT_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.717

creates object-layer jobs via QBM_PJobCreate* fires object-layer event via HOFireEvent has TRY/CATCH error handling

Summary: calls QBM_PJobCreate_HOFireEvent_B, QBM_PSessionErrorAdd; writes INSERT into; reads/joins QBMDBQueueCurrent, personwantsorg, PWOHelperPWO, QERWorkingStep; uses config Common\ProcessState\UseGenProcIDFromPWO

Declared parameters

ParameterTypeDirection
@SlotNumberintinput

DML targets

INSERT into

Config/session

Config: Common\ProcessState\UseGenProcIDFromPWO

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @SlotNumber @UID_Personwantsorg @GenProcID @CfgUseGenProcID @cond @EventName @BasisObjectKey @SubLevelNumberString @ElementBuffer @ElementCount @ElementIndex @ROWCOUNT @uid_personwantsorg @AdditionalObjectKeysAffected @checkForExisting @p2 @v2 @p3 @v3

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.