dbo.QER_PITShopHelperFillAll
SQL_STORED_PROCEDURE
Created 2025-06-27T18:01:06.570 · modified 2026-04-14T23:20:39.163 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@DecisionRules | nvarchar | no |
@GenProcID | varchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| DialogDBQueue | OBJECT_OR_COLUMN | ||
| PersonWantsOrg | OBJECT_OR_COLUMN | ||
| pwodecisionrule | OBJECT_OR_COLUMN | ||
| PWOHelperPWO | OBJECT_OR_COLUMN | ||
| QBM_PDBQueueInsert_Bulk | OBJECT_OR_COLUMN | ||
| QBM_PSessionErrorAdd | OBJECT_OR_COLUMN | ||
| QBM_YDBQueueRaw | TYPE | ||
| QERWorkingStep | OBJECT_OR_COLUMN | ||
| dbo | QBM_FCVStringToBit | OBJECT_OR_COLUMN | |
| dbo | QBM_FCVStringToList | OBJECT_OR_COLUMN | |
| dbo | QBM_FGIConfigparmValue | OBJECT_OR_COLUMN | |
| dbo | QER_FGIGenProcIDForPWO | OBJECT_OR_COLUMN | |
| dbo | QER_FGIPWOTaskToUse | 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_PITShopHelperFillAll (@DecisionRules nvarchar(2000) , @GenProcID varchar(38) = null ) as begin declare @CfgUseGenProcID 2 bit = dbo.QBM_FCVStringToBit(dbo.QBM_FGIConfigparmValue('Common\ProcessState\UseGenProcIDFromPWO')) declare @PWOTaskToUse varchar(38) = dbo.QER_FGIPWOTaskToUse 3() SET XACT_ABORT OFF BEGIN TRY if isnull(@GenProcID, '') = '' begin select @GenProcID = NEWID() end if dbo.QBM_FGIConfigparmValue('QER\ITShop') = '' begin 4 goto endLabel end if @PWOTaskToUse > ' ' begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid 5) select x.uid, null, x.GenProcID from ( select distinct pwo.UID_PersonWantsOrg as uid , dbo.QER_FGIGenProcIDForPWO(pwo.GenProcID, @GenProcID, @CfgUseGenProcID 6) as GenProcID from pwodecisionrule r join dbo.QBM_FCVStringToList(@DecisionRules, '|', 1, 0 ) pa on r.UID_PWODecisionRule = pa.ParameterValue and r.UsageArea 7 ='I' and r.UID_Task is null join QERWorkingStep ps on ps.UID_PWODecisionRule = r.UID_PWODecisionRule join PersonWantsOrg pwo on ps.UID_QERWorkingMethod 8 = pwo.UID_QERWorkingMethod where pwo.OrderState in ( 'OrderProduct', 'OrderProlongate', 'OrderUnsubscribe' ) or exists ( select top 1 1 from PWOHelperPWO 9 h where h.UID_PersonWantsOrg = pwo.UID_PersonWantsOrg ) ) as x where not exists (select top 1 1 from DialogDBQueue q with (nolock) where q.UID_Task = 10 @PWOTaskToUse and q.Object = x.uid and q.Generation >= 0 ) exec QBM_PDBQueueInsert_Bulk @PWOTaskToUse, @DBQueueElements_01 end END TRY BEGIN CATCH exec 11 QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 12
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.163
inserts DBQueue tasks has TRY/CATCH error handling
Summary: calls QBM_PDBQueueInsert_Bulk, QBM_PSessionErrorAdd; writes INSERT into; reads/joins pwodecisionrule, QBM_FCVStringToList, QERWorkingStep, PersonWantsOrg, PWOHelperPWO…; uses config Common\ProcessState\UseGenProcIDFromPWO, QER\ITShop
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@DecisionRules | nvarchar(2000) | input |
@GenProcID | varchar(38) | input |
DML targets
INSERT intoCalled routines
Read/join references
SQL dependency metadata
Config/session
Config: Common\ProcessState\UseGenProcIDFromPWO QER\ITShop
Session: None extracted.
DBQueue/tasks
None extracted.Temp tables / referenced variables
Temp: None extracted.
Variables: @DecisionRules @GenProcID @CfgUseGenProcID @PWOTaskToUse @DBQueueElements_01
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.CPL_ZAllForPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TCPLUADSContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TCPLUDomain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_TUPerson | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TCPLULDAPContainer | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TCPLULDPDomain | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TCPLUUNSRootB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.CPL_ZAllForPersonInBaseTree | source text reference | inserts DBQueue tasks, has TRY/CATCH error handling |
| dbo.ADS_TCPLUADSContainer | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.ADS_TCPLUDomain | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.CPL_TUPerson | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TCPLULDAPContainer | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TCPLULDPDomain | source text reference | uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TCPLUUNSRootB | source text reference | uses session context values, has TRY/CATCH error handling |