dbo.QBM_PProcessGroupDelete

SQL_STORED_PROCEDURE

Created 2025-06-27T17:57:29.333 · modified 2026-04-14T23:20:26.013 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
`@GenProcIDGroup`	varchar	no

Referenced objects

Schema	Object	Class
	Dialogprocess	OBJECT_OR_COLUMN
	DialogProcessChain	OBJECT_OR_COLUMN
	DialogProcessSubstitute	OBJECT_OR_COLUMN
	DialogWatchOperation	OBJECT_OR_COLUMN
	JobHistory	OBJECT_OR_COLUMN
	QBM_PSessionErrorAdd	OBJECT_OR_COLUMN
	QBM_YSingleGUID	TYPE
dbo	QBM_FGISessionErrorRethrow	OBJECT_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_PProcessGroupDelete (@GenProcIDGroup varchar(38) = ''  ) as begin declare @WhereClauseDelete nvarchar(2000) declare @Processes
2 QBM_YSingleGUID declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate() SET XACT_ABORT OFF BEGIN TRY if @GenProcIDGroup
3 > ' ' begin   insert into @Processes(UID_SingleGuid ) select p.GenProcID from Dialogprocess p with (readpast) where p.GenProcIDGroup = @GenProcIDGroup
4                     update DialogWatchOperation set ReadyForDeleteOrExport = 1 from DialogWatchOperation x join @Processes p on x.GenProcID = p.UID_SingleGuid
5  option (maxdop 1)                   update DialogProcessChain set ReadyForDeleteOrExport = 1 from DialogProcessChain x join @Processes p on x.GenProcID
6 = p.UID_SingleGuid  option (maxdop 1)       update JobHistory set ReadyForDeleteOrExport = 1 from JobHistory x join @Processes p on x.GenProcID = p.UID_SingleGuid
7  option (maxdop 1)                  update DialogProcessSubstitute set ReadyForDeleteOrExport = 1 from DialogProcessSubstitute s where s.GenProcIDOrigin
8 in (select p.GenProcID from Dialogprocess p with (readpast) where p.GenProcIDGroup = @GenProcIDGroup ) and s.ReadyForDeleteOrExport <> 1 update DialogProcessSubstitute
9 set ReadyForDeleteOrExport = 1 from DialogProcessSubstitute s where s.GenProcIDnew in (select p.GenProcID from Dialogprocess p with (readpast) where p.GenProcIDGroup
10 = @GenProcIDGroup ) and s.ReadyForDeleteOrExport <> 1  update DialogProcess set ReadyForDeleteOrExport = 1 from DialogProcess x join @Processes p on x.GenProcID
11 = p.UID_SingleGuid  option (maxdop 1) goto ende end   update DialogWatchOperation set ReadyForDeleteOrExport = 1 where ReadyForDeleteOrExport = 2 and 
12GenProcID in (select p.GenProcID from Dialogprocess p where p.GenProcIDGroup > ' ' )  update DialogProcessChain set ReadyForDeleteOrExport = 1  , XDateUpdated
13 = @Xdate , XUserUpdated = @XUser where ReadyForDeleteOrExport = 2 and GenProcID in (select p.GenProcID from Dialogprocess p where p.GenProcIDGroup > ' '
14 )  update JobHistory set ReadyForDeleteOrExport = 1  , XDateUpdated = @Xdate , XUserUpdated = @XUser where ReadyForDeleteOrExport = 2 and GenProcID in
15 (select p.GenProcID from Dialogprocess p where p.GenProcIDGroup > ' ' )  update DialogProcessSubstitute set ReadyForDeleteOrExport = 1 from DialogProcessSubstitute
16 s where s.GenProcIDOrigin in (select p.GenProcID from Dialogprocess p where p.GenProcIDGroup > ' ' ) and s.ReadyForDeleteOrExport <> 1 update DialogProcessSubstitute
17 set ReadyForDeleteOrExport = 1 from DialogProcessSubstitute s where GenProcIDnew in (select p.GenProcID from Dialogprocess p where p.GenProcIDGroup > 
18' ' ) and s.ReadyForDeleteOrExport <> 1  update DialogProcess set ReadyForDeleteOrExport = 1  , XDateUpdated = @Xdate , XUserUpdated = @XUser where ReadyForDeleteOrExport
19 = 2 and GenProcIDGroup > ' ' END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR
20 (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 
21

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

has TRY/CATCH error handling

Summary: calls QBM_PSessionErrorAdd; writes INSERT into, UPDATE DialogWatchOperation, UPDATE DialogProcessChain, UPDATE JobHistory, UPDATE DialogProcessSubstitute…; reads/joins Dialogprocess, DialogWatchOperation, DialogProcessChain, JobHistory, DialogProcessSubstitute…

Declared parameters

Parameter	Type	Direction
`@GenProcIDGroup`	`varchar(38)`	input

DML targets

INSERT into UPDATE DialogWatchOperation UPDATE DialogProcessChain UPDATE JobHistory UPDATE DialogProcessSubstitute UPDATE DialogProcess

Called routines

QBM_PSessionErrorAdd

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: @GenProcIDGroup @WhereClauseDelete @Processes @XUser @procid @Xdate @Rethrow

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.