dbo.QER_ZHelperPersonOrg
SQL_STORED_PROCEDURE
Created 2025-06-27T18:01:07.423 · modified 2026-04-14T23:20:40.183 · source: live DB sys.objects/sys.sql_expression_dependencies.
Parameters
| Name | Type | Output |
|---|---|---|
@SlotNumber | int | no |
Referenced objects
| Schema | Object | Column/minor | Class |
|---|---|---|---|
| BaseTree | OBJECT_OR_COLUMN | ||
| HelperPersonOrg | OBJECT_OR_COLUMN | ||
| person | OBJECT_OR_COLUMN | ||
| QBM_PDBQueueCalculateDelta | OBJECT_OR_COLUMN | ||
| QBM_PMNTableDelete | OBJECT_OR_COLUMN | ||
| QBM_PMNTableInsert | OBJECT_OR_COLUMN | ||
| QBM_PSessionErrorAdd | OBJECT_OR_COLUMN | ||
| QBM_YDataForDelta | TYPE | ||
| QBM_YDBQueueCurrent | TYPE | ||
| QBMDBQueueCurrent | OBJECT_OR_COLUMN | ||
| dbo | QBM_FGIConfigparmValue | 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_ZHelperPersonOrg (@SlotNumber int ) AS begin declare @Sourcedata QBM_YDataForDelta , @CountDeltaQantity int , @CountDeltaOrigin 2 int declare @DBQueueCurrent QBM_YDBQueueCurrent BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select 3 UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount 4 = 0 begin goto EndLabel end insert into @SourceData( IsUpcommingContent, XOriginAfter , Element, AssignedElement, XOriginBefore ) select 0, 0 , hpo.uid_person 5, hpo.uid_Org, 1 from @DBQueueCurrent x join HelperPersonOrg hpo on hpo.UID_Person = x.uid_parameter join BaseTree b on hpo.uid_org = b.uid_org where 6b.uid_OrgRoot like '___-V-%' if dbo.QBM_FGIConfigparmValue('QER\Structures\Inherite\Person\FromDepartment') > ' ' begin insert into @SourceData( IsUpcommingContent 7, XOriginBefore, XOriginAfter , Element, AssignedElement ) select 1, 0, 1 , p.uid_person, p.uid_Department from person p join @DBQueueCurrent x on uid_person= 8 x.uid_parameter where p.uid_Department > ' ' end if dbo.QBM_FGIConfigparmValue('QER\Structures\Inherite\Person\FromLocality') > ' ' begin insert into 9@SourceData( IsUpcommingContent, XOriginBefore, XOriginAfter , Element, AssignedElement ) select 1, 0, 1 , p.uid_person, p.uid_Locality from person p join 10 @DBQueueCurrent x on uid_person= x.uid_parameter where p.uid_Locality > ' ' end if dbo.QBM_FGIConfigparmValue('QER\Structures\Inherite\Person\FromProfitCenter' 11) > ' ' begin insert into @SourceData( IsUpcommingContent, XOriginBefore, XOriginAfter , Element, AssignedElement ) select 1, 0, 1 , p.uid_person, p.uid_ProfitCenter 12 from person p join @DBQueueCurrent x on uid_person= x.uid_parameter where p.uid_ProfitCenter > ' ' end exec QBM_PDBQueueCalculateDelta @SourceData, @DeltaQuantity 13 = 0, @DeltaDelete = 1, @DeltaInsert = 1, @DeltaOrigin = 0, @CountDeltaQantity = @CountDeltaQantity output , @CountDeltaOrigin = @CountDeltaOrigin output 14 , @UseIsInEffect = 0 , @SlotNumber = @SlotNumber , @DBQueueCurrentExtern = @DBQueueCurrent if @CountDeltaQantity > 0 begin exec QBM_PMNTableDelete 'HelperPersonOrg' 15, 'UID_Person', 'UID_Org' exec QBM_PMNTableInsert 'HelperPersonOrg', 'UID_Person', 'UID_Org' end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default 16 RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 17
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.183
has TRY/CATCH error handling
Summary: calls QBM_PDBQueueCalculateDelta, QBM_PMNTableDelete, QBM_PMNTableInsert, QBM_PSessionErrorAdd; writes INSERT into; reads/joins QBMDBQueueCurrent, HelperPersonOrg, BaseTree, person; uses config QER\Structures\Inherite\Person\FromDepartment, QER\Structures\Inherite\Person\FromLocality, QER\Structures\Inherite\Person\FromProfitCenter
Declared parameters
| Parameter | Type | Direction |
|---|---|---|
@SlotNumber | int | input |
DML targets
INSERT intoRead/join references
SQL dependency metadata
Config/session
Config: QER\Structures\Inherite\Person\FromDepartment QER\Structures\Inherite\Person\FromLocality QER\Structures\Inherite\Person\FromProfitCenter
Session: None extracted.
DBQueue/tasks
None extracted.Temp tables / referenced variables
Temp: None extracted.
Variables: @SlotNumber @Sourcedata @CountDeltaQantity @CountDeltaOrigin @DBQueueCurrent @rowcount @SourceData @DeltaQuantity @DeltaDelete @DeltaInsert @DeltaOrigin @UseIsInEffect @DBQueueCurrentExtern
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.