dbo.QER_PQEREntitlementSourceDef

SQL_STORED_PROCEDURE

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

Open formatted source/search result

Parameters

Name	Type	Output
`@ModuleName`	varchar	no
`@TableName`	varchar	no
`@GUID_Extern`	varchar	no
`@Ident_QEREntitlementSource`	nvarchar	no
`@SQLQuery`	nvarchar	no

Referenced objects

Schema	Object	Class
	DialogTable	OBJECT_OR_COLUMN
	QBM_PSessionErrorAdd	OBJECT_OR_COLUMN
	QEREntitlementSource	OBJECT_OR_COLUMN
dbo	QBM_FCVElementToObjectKey1	OBJECT_OR_COLUMN
dbo	QBM_FCVGuidToTransfer	OBJECT_OR_COLUMN
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 QER_PQEREntitlementSourceDef ( @ModuleName varchar(3) , @TableName varchar(30) , @GUID_Extern varchar(38) , @Ident_QEREntitlementSource
2 nvarchar(64) , @SQLQuery nvarchar(max) ) as begin declare @uid_dialogtable varchar(38) declare @UID_QEREntitlementSource varchar(38) SET XACT_ABORT OFF
3 BEGIN TRY select @uid_dialogtable = null select top 1 @uid_dialogtable = t.UID_DialogTable from DialogTable t where t.TableName = @TableName if @uid_dialogtable
4 is null begin raiserror ('#LDS#TableNotFound|', 18, 1) with nowait end select @UID_QEREntitlementSource = dbo.QBM_FCVGuidToTransfer(@GUID_Extern, @Modulename
5) if not exists (select top 1 1 from QEREntitlementSource es where es.UID_QEREntitlementSource = @UID_QEREntitlementSource ) begin insert into QEREntitlementSource
6 (UID_QEREntitlementSource, UID_DialogTable, Ident_QEREntitlementSource, SQLQuery , XDateInserted, XDateUpdated, XUserInserted, XUserUpdated , XObjectKey
7 ) select @UID_QEREntitlementSource, @uid_dialogtable, @Ident_QEREntitlementSource, @SQLQuery , GETUTCDATE(), GETUTCDATE(), OBJECT_NAME(@@procid), OBJECT_NAME
8(@@procid) , dbo.QBM_FCVElementToObjectKey1('QEREntitlementSource', 'UID_QEREntitlementSource', @UID_QEREntitlementSource) end else begin update QEREntitlementSource
9 set Ident_QEREntitlementSource = @Ident_QEREntitlementSource , SQLQuery = @SQLQuery , xdateupdated = GETUTCDATE() where UID_QEREntitlementSource = @UID_QEREntitlementSource
10 and (ISNULL(Ident_QEREntitlementSource, '') <> @Ident_QEREntitlementSource or ISNULL(sqlquery, '') <> @SQLQuery ) end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd
11 default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: 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:40.420

has TRY/CATCH error handling

Summary: calls QBM_PSessionErrorAdd; writes INSERT QEREntitlementSource, UPDATE QEREntitlementSource; reads/joins DialogTable, QEREntitlementSource

Declared parameters

Parameter	Type	Direction
`@ModuleName`	`varchar(3)`	input
`@TableName`	`varchar(30)`	input
`@GUID_Extern`	`varchar(38)`	input
`@Ident_QEREntitlementSource`	`nvarchar(64)`	input
`@SQLQuery`	`nvarchar`	input

DML targets

INSERT QEREntitlementSource UPDATE QEREntitlementSource

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: #LDS #TableNotFound

Variables: @ModuleName @TableName @GUID_Extern @Ident_QEREntitlementSource @SQLQuery @uid_dialogtable @UID_QEREntitlementSource @Modulename @procid @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.