dbo.QER_ZITShopHelperFill_Recalc

SQL_STORED_PROCEDURE

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

Open formatted source/search result

Parameters

NameTypeOutput
@SlotNumberDummyintno
@dummy1varcharno
@Dummy2varcharno
@GenProcIDDummyvarcharno

Referenced objects

SchemaObjectColumn/minorClass
DialogDBQueueOBJECT_OR_COLUMN
PersonWantsOrgOBJECT_OR_COLUMN
pwodecisionruleOBJECT_OR_COLUMN
PWOHelperPWOOBJECT_OR_COLUMN
QBM_PDBQueueInsert_BulkOBJECT_OR_COLUMN
QBM_PSessionErrorAddOBJECT_OR_COLUMN
QBM_YCursorBufferTYPE
QBM_YDBQueueRawTYPE
QERBufferRecalcDecisionMakerOBJECT_OR_COLUMN
QERWorkingStepOBJECT_OR_COLUMN
dboQBM_FCVStringToBitOBJECT_OR_COLUMN
dboQBM_FGIConfigparmValueOBJECT_OR_COLUMN
dboQER_FCVRuleGUIDToFuncNameReclcOBJECT_OR_COLUMN
dboQER_FGIGenProcIDForPWOOBJECT_OR_COLUMN
dboQER_FGIPWOTaskToUseOBJECT_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.200

inserts DBQueue tasks has TRY/CATCH error handling

Summary: calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into, UPDATE QERBufferRecalcDecisionMaker; reads/joins QERBufferRecalcDecisionMaker, sys, pwodecisionrule, QERWorkingStep, dbo…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop

Declared parameters

ParameterTypeDirection
@SlotNumberDummyintinput
@dummy1varchar(38)input
@Dummy2varchar(38)input
@GenProcIDDummyvarchar(38)input

DML targets

INSERT into UPDATE QERBufferRecalcDecisionMaker

Config/session

Config: Common\ProcessState\UseGenProcIDFromPWO QER\ITShop

Session: None extracted.

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @SlotNumberDummy @dummy1 @Dummy2 @GenProcIDDummy @DebugSwitch @CfgUseGenProcID @PWOTaskToUse @ElementLast @ElementCount @ElementIndex @RulesAndFunctions @FunctionName @SQLCmd @UID_PWODecisionRule @GenProcID @DBQueueElements_01 @ROWCOUNT @IDENTITY @SQLcmd

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.