dbo.QER_ZITShopRepairClosed
SQL_STORED_PROCEDURE
Created 2025-06-27T18:01:06.720 · modified 2026-04-14T23:20:39.240 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@Slotnumber | int | no |
@UID_PersonWantsOrg | varchar | no |
@Dummy | varchar | no |
@GenProcID | varchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| Delegation | OBJECT_OR_COLUMN | ||
| PersonWantsOrg | OBJECT_OR_COLUMN | ||
| QBM_PSessionContextSet | OBJECT_OR_COLUMN | ||
| QBM_PSessionErrorAdd | OBJECT_OR_COLUMN | ||
| QER_VPWOPersonPropertyReset | OBJECT_OR_COLUMN | ||
| dbo | QBM_FCVStringToBit | OBJECT_OR_COLUMN | |
| dbo | QBM_FGIConfigparmValue | OBJECT_OR_COLUMN | |
| dbo | QBM_FGISessionContext | OBJECT_OR_COLUMN | |
| dbo | QER_FGIGenProcIDForPWO | 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_ZITShopRepairClosed ( @Slotnumber int , @UID_PersonWantsOrg varchar(38) , @Dummy varchar(38) , @GenProcID varchar(38) 2 ) AS begin declare @XUser nvarchar(64) = object_name(@@procid) declare @XDate datetime = getutcdate() declare @SetUIDPersonOrdered int , @SetUIDPersonInserted 3 int , @SetUIDPersonHead int , @SetDisplayPersonOrdered int , @SetDisplayPersonInserted int , @SetDisplayPersonHead int declare @UID_DelegationToDelete 4 varchar(38) declare @CfgUseGenProcID bit = dbo.QBM_FCVStringToBit(dbo.QBM_FGIConfigparmValue('Common\ProcessState\UseGenProcIDFromPWO')) declare @GenProcID_R 5 varchar(38) = dbo.QBM_FGISessionContext('') declare @GenProcIDToUse varchar(38) BEGIN TRY select top 1 @SetUIDPersonOrdered = r.SetUIDPersonOrdered , 6@SetUIDPersonInserted = r.SetUIDPersonInserted , @SetUIDPersonHead = r.SetUIDPersonHead , @SetDisplayPersonOrdered = r.SetDisplayPersonOrdered , @SetDisplayPersonInserted 7 = r.SetDisplayPersonInserted , @SetDisplayPersonHead = r.SetDisplayPersonHead , @GenProcIDToUse = dbo.QER_FGIGenProcIDForPWO(r.GenProcID, @GenProcID, 8@CfgUseGenProcID) , @UID_DelegationToDelete = r.UID_DelegationToDelete from QER_VPWOPersonPropertyReset r where r.UID_PersonWantsOrg = @UID_PersonWantsOrg 9 exec QBM_PSessionContextSet 'GenProcID', @GenProcIDToUse if @SetUIDPersonOrdered = 1 begin update PersonWantsOrg set UID_PersonOrdered = null , XDateUpdated 10 = @XDate , XUserUpdated = @XUser where UID_PersonWantsOrg = @UID_PersonWantsOrg end if @SetUIDPersonInserted = 1 begin update PersonWantsOrg set UID_PersonInserted 11 = null , XDateUpdated = @XDate , XUserUpdated = @XUser where UID_PersonWantsOrg = @UID_PersonWantsOrg end if @SetUIDPersonHead = 1 begin update PersonWantsOrg 12 set UID_PersonHead = null , XDateUpdated = @XDate , XUserUpdated = @XUser where UID_PersonWantsOrg = @UID_PersonWantsOrg end if @SetDisplayPersonOrdered 13 = 1 begin update PersonWantsOrg set DisplayPersonOrdered = null , XDateUpdated = @XDate , XUserUpdated = @XUser where UID_PersonWantsOrg = @UID_PersonWantsOrg 14 end if @SetDisplayPersonInserted = 1 begin update PersonWantsOrg set DisplayPersonInserted = null , XDateUpdated = @XDate , XUserUpdated = @XUser where 15 UID_PersonWantsOrg = @UID_PersonWantsOrg end if @SetDisplayPersonHead = 1 begin update PersonWantsOrg set DisplayPersonHead = null , XDateUpdated = @XDate 16 , XUserUpdated = @XUser where UID_PersonWantsOrg = @UID_PersonWantsOrg end if @UID_DelegationToDelete > ' ' begin delete Delegation where UID_Delegation 17 = @UID_DelegationToDelete end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: exec QBM_PSessionContextSet 18 'GenProcID', @GenProcID_R return end 19
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.240
uses session context values has TRY/CATCH error handling
Summary: calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes UPDATE PersonWantsOrg, DELETE Delegation; reads/joins QER_VPWOPersonPropertyReset; uses config Common\ProcessState\UseGenProcIDFromPWO; uses session context GenProcID
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@Slotnumber | int | input |
@UID_PersonWantsOrg | varchar(38) | input |
@Dummy | varchar(38) | input |
@GenProcID | varchar(38) | input |
DML targets
UPDATE PersonWantsOrg DELETE DelegationCalled routines
Read/join references
SQL dependency metadata
Config/session
Config: Common\ProcessState\UseGenProcIDFromPWO
Session: GenProcID
DBQueue/tasks
None extracted.Temp tables / referenced variables
Temp: None extracted.
Variables: @Slotnumber @UID_PersonWantsOrg @Dummy @GenProcID @XUser @procid @XDate @SetUIDPersonOrdered @SetUIDPersonInserted @SetUIDPersonHead @SetDisplayPersonOrdered @SetDisplayPersonInserted @SetDisplayPersonHead @UID_DelegationToDelete @CfgUseGenProcID @GenProcID_R @GenProcIDToUse
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.