dbo.QER_PITShopHelperFill_Recalc
SQL_STORED_PROCEDURE
Created 2025-06-27T18:01:06.793 · modified 2026-04-14T23:20:39.340 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@Parameter | QBM_YCursorBuffer | no |
@GenProcID | varchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| PWODecisionRule | OBJECT_OR_COLUMN | ||
| QBM_PDBQueueInsert_single | OBJECT_OR_COLUMN | ||
| QBM_PSessionErrorAdd | OBJECT_OR_COLUMN | ||
| QBM_YCursorBuffer | TYPE | ||
| QERBufferRecalcDecisionMaker | 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 QER_PITShopHelperFill_Recalc (@Parameter QBM_YCursorBuffer readonly , @GenProcID varchar(38) = null ) as begin SET XACT_ABORT 2 OFF BEGIN TRY if isnull(@GenProcID, '') = '' begin select @GenProcID = NEWID() end insert into QERBufferRecalcDecisionMaker (UID_PWODecisionRule, ObjectKey 3, UsageArea, ProcessState, GenProcID) select distinct p.UID1, p.ObjectKey1, p.Ident1, 0, @GenProcID from @Parameter p join PWODecisionRule r on p.UID1 4= r.UID_PWODecisionRule where not exists ( select top 1 1 from QERBufferRecalcDecisionMaker m with (readpast) where m.UID_PWODecisionRule = p.UID1 and 5m.ObjectKey = p.ObjectKey1 and m.ProcessState = 0 ) if exists (select top 1 1 from @Parameter where Ident1 = 'I') begin exec QBM_PDBQueueInsert_single 6'QER-K-ShoppingRackPWOHelperPWO-Rec', null, null, @GenProcID end if exists (select top 1 1 from @Parameter where Ident1 = 'A') begin exec QBM_PDBQueueInsert_single 7 'ATT-K-AttestationHelper-Rec', null, null, @GenProcID end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END 8CATCH endLabel: return end 9
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:39.340
inserts DBQueue tasks has TRY/CATCH error handling
Summary: calls QBM_PDBQueueInsert_single, QBM_PSessionErrorAdd; writes INSERT QERBufferRecalcDecisionMaker; reads/joins PWODecisionRule, QERBufferRecalcDecisionMaker
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@Parameter | qbm_ycursorbuffer | input |
@GenProcID | varchar(38) | input |
DML targets
INSERT QERBufferRecalcDecisionMakerCalled routines
Read/join references
SQL dependency metadata
Config/session
Config: None extracted.
Session: None extracted.
DBQueue/tasks
None extracted.Temp tables / referenced variables
Temp: None extracted.
Variables: @Parameter @GenProcID
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.ATT_ZAllForPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_ZAllForPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_ZAllForPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TATTUADSAccount | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TATTUADSContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TATTUADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TATTUDomain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUADSContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUAdsGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TUDomain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ARS_TATTUADSAccount | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ARS_TATTUAdsGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ARS_TUAccProduct | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ARS_TUADSAccount | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ARS_TUAdsGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TDAttestationPolicyHasAppr | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TIAttestationPolicyHasAppr | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TIHelperHeadOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TIHelperHeadPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TRMBDHelperHeadOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TRMBIHelperHeadOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUAccProduct | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUAccProductGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUAttestationPolicy | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUDialogParameter | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUHardware | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUHelperHeadOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUHelperHeadPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUQERResource | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUQERReuse | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TUQERReuseUS | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_TURMBPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TATTULDAPAccount | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TATTULDAPContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TATTULDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TATTULDPDomain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TULDAPContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TULDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TULDPDomain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TDBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIHelperHeadOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIHelperHeadPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUAccProduct | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUHelperHeadOrg | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUHelperHeadPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERResource | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERReuse | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TUQERReuseUS | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMB_TUPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TATTUESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TATTUPersonHasESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TUESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_TATTURPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_TURPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TATTUTSBAccountDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TATTUUNSAccountB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TATTUUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TATTUUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TATTUUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TATTUUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TATTUUNSRootB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUTSBAccountDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TUUNSRootB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ATT_ZAllForPersonInBaseTree | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.CPL_ZAllForPersonInBaseTree | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.QER_ZAllForPersonInBaseTree | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, has TRY/CATCH error handling |
| dbo.ADS_TATTUADSAccount | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TATTUADSContainer | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TATTUADSGroup | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TATTUDomain | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TUADSContainer | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TUAdsGroup | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TUDomain | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ARS_TATTUADSAccount | source text reference | has TRY/CATCH error handling |
| dbo.ARS_TATTUAdsGroup | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ARS_TUAccProduct | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ARS_TUADSAccount | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ARS_TUAdsGroup | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TDAttestationPolicyHasAppr | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TIAttestationPolicyHasAppr | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TIHelperHeadOrg | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TIHelperHeadPerson | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TRMBDHelperHeadOrg | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TRMBIHelperHeadOrg | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUAccProduct | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUAccProductGroup | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUAttestationPolicy | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUDialogParameter | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUHardware | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUHelperHeadOrg | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUHelperHeadPerson | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUPerson | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUQERAssign | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUQERResource | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUQERReuse | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TUQERReuseUS | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ATT_TURMBPerson | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TATTULDAPAccount | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TATTULDAPContainer | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TATTULDAPGroup | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TATTULDPDomain | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TULDAPContainer | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TULDAPGroup | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TULDPDomain | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TDBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIHelperHeadOrg | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIHelperHeadPerson | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUAccProduct | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUHelperHeadOrg | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUHelperHeadPerson | source text reference | creates object-layer jobs via QBM_PJobCreate*, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUPerson | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, calls object-layer method via HOCallMethod, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUQERAssign | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUQERResource | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUQERReuse | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TUQERReuseUS | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMB_TUPerson | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TATTUESet | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TATTUPersonHasESet | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TUESet | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RPS_TATTURPSReport | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.RPS_TURPSReport | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TATTUTSBAccountDef | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TATTUUNSAccountB | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TATTUUNSGroupB | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TATTUUNSGroupB1 | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TATTUUNSGroupB2 | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TATTUUNSGroupB3 | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TATTUUNSRootB | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUTSBAccountDef | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB1 | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB2 | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSGroupB3 | source text reference | creates object-layer jobs via QBM_PJobCreate*, inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TUUNSRootB | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |