dbo.QER_ZEntitlementSourceMakeProc

SQL_STORED_PROCEDURE

Created 2025-06-27T18:01:07.530 · modified 2026-04-14T23:20:40.333 · source: live DB sys.objects/sys.sql_expression_dependencies.

Open formatted source/search result

Parameters

Name	Type	Output
`@SlotNumber`	int	no
`@dummy1`	varchar	no
`@Dummy2`	varchar	no
`@GenProcIDDummy`	varchar	no

Referenced objects

Schema	Object	Class
	DialogTable	OBJECT_OR_COLUMN
	QBM_PDBQueueCurrentResetNGen	OBJECT_OR_COLUMN
	QBM_PExecuteSQLWithRetry_LLP	OBJECT_OR_COLUMN
	QBM_PSessionErrorAdd	OBJECT_OR_COLUMN
	QBM_YCursorBuffer	TYPE
	QEREntitlementSource	OBJECT_OR_COLUMN
dbo	QBM_FCVStringToIndent	OBJECT_OR_COLUMN
dbo	QBM_FGICodeName	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 QER_ZEntitlementSourceMakeProc (@SlotNumber int , @dummy1 varchar(38) , @Dummy2 varchar(38) , @GenProcIDDummy varchar(38) 
2) as begin declare @DebugSwitch int = 0 declare @FunctionNameWho nvarchar(64) = 'QER_FTEntitlementSourceWho' declare @FunctionNameWhy nvarchar(64) = 'QER_FTEntitlementSourceWhy'
3 declare @FunctionNameWhat nvarchar(64) = 'QER_FTEntitlementSourceWhat' declare @HeaderWho nvarchar(max) = concat('create or alter function dbo.' , @FunctionNameWho
4 , '(
5											@ObjectKeyToInspect varchar(138)
6											)
7	returns @erg table (
8						UID_Person varchar(38) collate database_default
9						)
10 as
11begin
12'
13 ) declare @SubBodyWho nvarchar(max) = '
14	if @ObjectKeyToInspect like ''<Key><T>@TableName@</T>%''
15	 begin
16	  insert into @erg(uid_person)
17	  select /*distinct */ xx.UID_Person
18	   from dbo.@FunctionWhoName (@ObjectKeyToInspect) as xx
19
20	   goto EndLabel
21
22	 end -- @TableName@
23'
24 declare @FooterWho nvarchar(max) = '
25	--insert into @erg(uid_person)
26	--select distinct UID_Person
27	-- from @work
28 endLabel:
29
30 return
31end
32' declare
33 @FunctionWhoPattern nvarchar(max) = '
34create or alter function dbo.@FunctionWhoName (@ObjectKeyToInspect varchar(138)
35									)
36returns table
37 
38as return(
39	  select distinct xx.UID_Person
40	   from (
41@CustomerCode
42			) as xx
43	   where xx.ObjectKeyToInspect = @ObjectKeyToInspect
44)
45'
46 declare @FunctionWhoName varchar(30)  declare @HeaderWhy nvarchar(max) = concat('create or alter function dbo.' , @FunctionNameWhy , '(
47											@UID_Person varchar(38) 
48											, @ObjectKeyToInspect varchar(138)
49											)
50	returns @erg table (
51						ObjectKeyReason1 varchar(138) collate database_default
52						, ObjectKeyReason2 varchar(138) collate database_default
53						)
54 as
55begin
56'
57 ) declare @SubBodyWhy nvarchar(max) = '
58	if @ObjectKeyToInspect like ''<Key><T>@TableName@</T>%''
59	 begin
60	  insert into @erg(ObjectKeyReason1, ObjectKeyReason2)
61	  select distinct xx.ObjectKeyReason1, xx.ObjectKeyReason2
62	   from dbo.@FunctionWhyName (@uid_person, @ObjectKeyToInspect) as xx
63
64	   goto EndLabel
65
66	 end -- @TableName@
67'
68 declare @FooterWhy nvarchar(max) = '
69	--insert into @erg(ObjectKeyReason1, ObjectKeyReason2)
70	--select distinct ObjectKeyReason1, ObjectKeyReason2
71	-- from @work
72
73	EndLabel:
74
75 return
76end
77'
78 declare @FunctionWhyPattern nvarchar(max) = '
79create or alter function dbo.@FunctionWhyName (@UID_Person varchar(38)
80								, @ObjectKeyToInspect varchar(138)

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

has TRY/CATCH error handling

Summary: calls QBM_PExecuteSQLWithRetry_LLP, sp_helptext, QBM_PSessionErrorAdd, QBM_PDBQueueCurrentResetNGen; writes INSERT into; reads/joins dbo, QEREntitlementSource, DialogTable

Declared parameters

Parameter	Type	Direction
`@SlotNumber`	`int`	input
`@dummy1`	`varchar(38)`	input
`@Dummy2`	`varchar(38)`	input
`@GenProcIDDummy`	`varchar(38)`	input

DML targets

INSERT into

Called 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: @SlotNumber @dummy1 @Dummy2 @GenProcIDDummy @DebugSwitch @FunctionNameWho @FunctionNameWhy @FunctionNameWhat @HeaderWho @ObjectKeyToInspect @erg @SubBodyWho @TableName @FunctionWhoName @FooterWho @FunctionWhoPattern @CustomerCode @HeaderWhy @UID_Person @SubBodyWhy @FunctionWhyName @uid_person @FooterWhy @FunctionWhyPattern @HeaderWhat @SubBodyWhat @work @FunctionWhatName @FooterWhat @FunctionWhatPattern @Declares @KlammerAuf @KlammerZu @cmdWho @cmdWhy @cmdWhat @SQLQuery @Ident_QEREntitlementSource @ElementBuffer @ElementCount

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.