dbo.QER_PAssignmentCheckValid
SQL_STORED_PROCEDURE
Created 2025-06-27T18:01:04.773 · modified 2026-04-14T23:20:36.550 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@UID_BaseTreeAssign | varchar | no |
@Parameters | QBM_YParameterList | no |
@GenProcID | varchar | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| BaseTree | OBJECT_OR_COLUMN | ||
| OrgRootAssign | OBJECT_OR_COLUMN | ||
| QBM_PSessionErrorAdd | OBJECT_OR_COLUMN | ||
| QBM_YparameterList | TYPE | ||
| dbo | QBM_FGIBitPatternXOrigin | OBJECT_OR_COLUMN | |
| dbo | QBM_FGISessionContext | 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.
1 create procedure QER_PAssignmentCheckValid (@UID_BaseTreeAssign varchar(38) , @Parameters QBM_YparameterList readonly , @GenProcID varchar 2(38) ) as begin declare @QBM_BitPatternXOrigin_Direct int = dbo.QBM_FGIBitPatternXOrigin('|Direct|', 0) SET XACT_ABORT OFF BEGIN TRY if dbo.QBM_FGISessionContext 3 ('Transport') = '' begin if exists ( select top 1 1 from @Parameters i join BaseTree b on i.Parameter1 = b.UID_Org left outer join OrgRootAssign r on 4 b.uid_orgroot = r.uid_orgroot and r.UID_BaseTreeAssign = @UID_BaseTreeAssign where isnull(r.IsAssignmentAllowed, 0) = 0 or (isnull(r.IsDirectAssignmentAllowed 5, 0) = 0 and convert(int, i.Parameter2) & @QBM_BitPatternXOrigin_Direct > 0 ) ) begin set XACT_ABORT ON raiserror( '#LDS#Cannot make assignment because not permitted according to OrgRootAssign information.|' 6, 18, 1) with nowait end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() 7 RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: 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:36.550
uses session context values has TRY/CATCH error handling
Summary: calls QBM_PSessionErrorAdd; reads/joins BaseTree, OrgRootAssign; uses session context Transport
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@UID_BaseTreeAssign | varchar(38) | input |
@Parameters | qbm_yparameterlist | input |
@GenProcID | varchar(38) | input |
DML targets
None extracted.Called routines
Read/join references
SQL dependency metadata
Config/session
Config: None extracted.
Session: Transport
DBQueue/tasks
None extracted.Temp tables / referenced variables
Temp: #LDS #Cannot
Variables: @UID_BaseTreeAssign @Parameters @GenProcID @QBM_BitPatternXOrigin_Direct @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.
| Referencing object | Relation | Evidence |
|---|---|---|
| dbo.ADS_TIBaseTreeHasADSGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.LDP_TIBaseTreeHasLDAPGroup | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIBaseTreeHasQERAssign | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIBaseTreeHasQERResource | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIBaseTreeHasQERReuse | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIBaseTreeHasQERReuseUS | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIHardwareInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIPersonInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.QER_TIWorkDeskInBaseTree | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RMS_TIBaseTreeHasESet | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.RPS_TIBaseTreeHasRPSReport | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIBaseTreeHasTSBAccountDef | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIBaseTreeHasUNSGroupB | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIBaseTreeHasUNSGroupB1 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIBaseTreeHasUNSGroupB2 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.TSB_TIBaseTreeHasUNSGroupB3 | SQL expression dependency | OBJECT_OR_COLUMN |
| dbo.ADS_TIBaseTreeHasADSGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.LDP_TIBaseTreeHasLDAPGroup | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIBaseTreeHasQERAssign | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIBaseTreeHasQERResource | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIBaseTreeHasQERReuse | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIBaseTreeHasQERReuseUS | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIHardwareInBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIPersonInBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.QER_TIWorkDeskInBaseTree | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RMS_TIBaseTreeHasESet | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.RPS_TIBaseTreeHasRPSReport | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIBaseTreeHasTSBAccountDef | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIBaseTreeHasUNSGroupB | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIBaseTreeHasUNSGroupB1 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIBaseTreeHasUNSGroupB2 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |
| dbo.TSB_TIBaseTreeHasUNSGroupB3 | source text reference | inserts DBQueue tasks, uses session context values, has TRY/CATCH error handling |