dbo.QBM_ZDialogSemaphorIncGlobal

SQL_STORED_PROCEDURE

Created 2025-06-27T17:58:58.250 · modified 2026-04-14T23:20:28.830 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

NameTypeOutput
@SlotNumberDummyintno
@ChangeContextvarcharno
@dummyvarcharno
@GenProcIDvarcharno

Referenced objects

SchemaObjectColumn/minorClass
DialogSemaphorOBJECT_OR_COLUMN
QBM_PSessionContextSetOBJECT_OR_COLUMN
QBM_PSessionErrorAddOBJECT_OR_COLUMN
dboQBM_FGISessionContextOBJECT_OR_COLUMN

Source excerpt

First extracted SQL definition lines from the exported source. Use the full source page for complete context.

Open full formatted source

1  create   procedure QBM_ZDialogSemaphorIncGlobal ( @SlotNumberDummy int , @ChangeContext varchar(38)  , @dummy varchar(38)  , @GenProcID varchar
2(38) )as begin  declare @UID_DialogSemaphor varchar(38) declare @XDate datetime = getutcDate() declare @XUser nvarchar(64) = object_name(@@procid) declare
3 @GenProcID_R varchar(38) BEGIN TRY select @GenProcID_R = dbo.QBM_FGISessionContext('') declare @ChangeContext_intern nvarchar(32) select @ChangeContext_intern
4 = upper(@ChangeContext)  if not exists (select top 1 1 from DialogSemaphor where ChangeContext = @ChangeContext_intern ) begin goto ende end exec QBM_PSessionContextSet
5 'GenProcID', @GenProcID update dialogSemaphor set ChangeCounter = ChangeCounter +1 , XDateUpdated = @XDate , XUserUpdated = @XUser where ChangeContext
6 = @ChangeContext_intern             END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  ende: exec QBM_PSessionContextSet
7 'GenProcID', @GenProcID_R return end 
8

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:28.830

uses session context values has TRY/CATCH error handling

Summary: calls QBM_PSessionContextSet, QBM_PSessionErrorAdd; writes UPDATE dialogSemaphor; reads/joins DialogSemaphor; uses session context GenProcID

Declared parameters

ParameterTypeDirection
@SlotNumberDummyintinput
@ChangeContextvarchar(38)input
@dummyvarchar(38)input
@GenProcIDvarchar(38)input

DML targets

UPDATE dialogSemaphor

Called routines

Read/join references

SQL dependency metadata

Config/session

Config: None extracted.

Session: GenProcID

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: None extracted.

Variables: @SlotNumberDummy @ChangeContext @dummy @GenProcID @UID_DialogSemaphor @XDate @XUser @procid @GenProcID_R @ChangeContext_intern

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 objectRelationEvidence
dbo.GEN_T4043DCEB988A4486C4E7C32E7SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T438B1AEC4B542409D1B03F623SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T4402FC38B5C8F2357BCB6F733SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T46053E3A047CA637BAAA41F87SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T47162D448118DBBD8B6C44001SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T478D05609650E1DD981FC7CBDSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T47B29F2998FBAE1E5E5E8C027SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T48082066FDF856309E1433564SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T488AA0C1D59E51A359851E8FBSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T4993CB7E60214AAE747901234SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T4AA6CD8F964E38272A933F89DSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T4AD3C17F83754A03B8BF90AB6SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T4F7746CD21D271FDBA218D52ASQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T508E9221D5B9C0F54AC451EE6SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T509C4EBA4F13C8139182FEDB7SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T5110FB51BA62A2C0FD1305B39SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T512F986898EDEBEF72FCC43A4SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T531318728749FC47509159C8CSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T547FEB7BA666BC9BB81762304SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T55029CA63D7971D63E1F96BAASQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T5612B6ED95A01830D9C2F657ESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T57EF79A1ACD4E2A635F444A69SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T59F794BBD6E6DC71F2DF8C738SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T5BCA54F6F1FD6DAA0C0C0ECB0SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T5DFA1DFCF86799F836817BFF0SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T5FC547C7BA1E6461F29A09065SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T6153A043F30DAD20E2A4FD069SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T6170C3125F8E958F5E9CB73F1SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T62216F0F3800818A407A341E4SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T623E448C1E71E729BA059D8B8SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T62EF1B105D9E9FBFBEB5D7292SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T63BE2F6CD4FEE51CEFE904BA9SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T662D4CE8996AE0B633E3E7F6DSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T66413571EC942E2EFDB4C557DSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T67DDFD12F8BC123556E5D1451SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T695414A334CB42997CDB8E154SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T696B81F6EB5287C7E0A59EA0CSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T6BB3F02737D849522B1E4D081SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_T6E791FDFB477EDB8F704DDD0BSQL expression dependencyOBJECT_OR_COLUMN
dbo.QBM_PTriggerWatchCreatesource text referenceuses session context values, has TRY/CATCH error handling