dbo.QBM_PMNTableOriginUpdate

SQL_STORED_PROCEDURE

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

Open formatted source/search result

Parameters

NameTypeOutput
@TargetTablevarcharno
@ElementColumnvarcharno
@AssignedElementColumnvarcharno
@RestrictionClausenvarcharno

Referenced objects

SchemaObjectColumn/minorClass
DialogTableOBJECT_OR_COLUMN
QBM_PExecuteSQLWithRetry_LLPOBJECT_OR_COLUMN
QBM_PSessionContextSetOBJECT_OR_COLUMN
QBM_PSessionErrorAddOBJECT_OR_COLUMN
QBM_YCursorBufferTYPE
dboQBM_FCVBinaryToStringOBJECT_OR_COLUMN
dboQBM_FGIBitPatternXOriginOBJECT_OR_COLUMN
dboQBM_FGIColumnExistsOBJECT_OR_COLUMN
dboQBM_FGISessionContextOBJECT_OR_COLUMN
dboQBM_FGISessionErrorRethrowOBJECT_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_PMNTableOriginUpdate (@TargetTable varchar(30) , @ElementColumn varchar(30) , @AssignedElementColumn varchar(30)   , @RestrictionClause
2 nvarchar(max) = '' ) as begin declare @GenProcID varchar(38) declare @SQLCmd nvarchar(max) declare @SQLPattern nvarchar(max) declare @ExistsXIsInEffect
3 bit = 0 declare @ExistsXdate bit = 0 declare @RestrictionClause_intern nvarchar(max) declare @DebugSwitch int = 0 declare @IsCreatePendingChange bit =
4 0 declare @Maske varchar(64) declare @GenProcID_R varchar(38) = dbo.QBM_FGISessionContext('') declare @XUser_R nvarchar(64) = dbo.QBM_FGISessionContext
5('XUser') declare @ElementCount int declare @ElementIndex int declare @MaxWaitTimeForMainOperation float = 5.0 SET XACT_ABORT OFF BEGIN TRY select @IsCreatePendingChange
6 = sign(t.PendingChangeBehavior & 0x01) from DialogTable t where t.TableName = @TargetTable select @Maske = dbo.QBM_FCVBinaryToString( dbo.QBM_FGIBitPatternXOrigin
7('|inherit|', 0), 0) select @ExistsXIsInEffect = dbo.QBM_FGIColumnExists(@TargetTable, 'XIsInEffect') select @ExistsXdate = dbo.QBM_FGIColumnExists(@TargetTable
8, 'XDateInserted') if isnull (@RestrictionClause, '') = '' begin select @RestrictionClause_intern = '' end else begin select @RestrictionClause_intern 
9= concat(' and ( ' , @RestrictionClause , ' ) ') end select @SQLPattern = concat(N'
10 if exists (select top 1 1 
11			from #QBMDeltaOrigin o
12			where o.XOrigin > 0
13			)
14  begin
15   update '
16 , @TargetTable , '
17	set XOrigin = x.XOrigin' , case @ExistsXIsInEffect when 1 then '
18		, XIsInEffect = x.XIsInEffect' else '' end , case @ExistsXdate
19 when 1 then '
20		, XDateUpdated = GetUtcDate()
21		, XUserUpdated = ''' + OBJECT_NAME(@@procid) + '''' else '' end , '
22    from ' , @TargetTable , ' y join #QBMDeltaOrigin x on y.'
23 , @ElementColumn , ' = x.Element
24													and y.' , @AssignedElementColumn , ' = x.AssignedElement
25													and x.GenProcID = ''@GenProcID''
26													and x.XOrigin > 0
27	where (y.XOrigin <> x.XOrigin'
28 , case @ExistsXIsInEffect when 1 then '
29		or y.XIsInEffect <> x.XIsInEffect' else '' end , '  )
30	' , @RestrictionClause_intern , '
31  end
32' ) if @IsCreatePendingChange
33 = 1 begin  select @SQLPattern = concat(@SQLPattern , 'if exists (select top 1 1 
34			from #QBMDeltaOrigin o
35			where o.XOrigin = 0
36			)
37  begin
38   update '
39 , @TargetTable , '
40	set XOrigin = 0' ,  case @ExistsXIsInEffect when 1 then '
41		, XIsInEffect = 0' else '' end , case @ExistsXdate when 1 then '
42		, XDateUpdated = GetUtcDate()
43		, XUserUpdated = '''
44 + OBJECT_NAME(@@procid) + '''' else '' end , '
45    from ' , @TargetTable , ' y join #QBMDeltaOrigin x on y.' , @ElementColumn , ' = x.Element
46													and y.'
47 , @AssignedElementColumn , ' = x.AssignedElement
48													and x.GenProcID = ''@GenProcID''
49													and x.XOrigin = 0
50	where (y.XOrigin & '
51 , @maske , ' > 0 )
52	  ' , @RestrictionClause_intern , '
53  end		
54	' ) end else  begin  select @SQLPattern = concat(@SQLPattern , 'if exists (select top 1 1 
55			from #QBMDeltaOrigin o
56			where o.XOrigin = 0
57			)
58  begin
59   update '
60 , @TargetTable , '
61	set XOrigin = 0 ' , case @ExistsXdate when 1 then '
62		, XDateUpdated = GetUtcDate()
63		, XUserUpdated = ''' + OBJECT_NAME(@@procid
64) + '''' else '' end , ' from ' , @TargetTable , ' y join #QBMDeltaOrigin x on y.' , @ElementColumn , ' = x.Element
65													and y.' , @AssignedElementColumn
66 , ' = x.AssignedElement
67													and x.GenProcID = ''@GenProcID''
68													and x.XOrigin = 0
69--	where (y.XOrigin > 0 )
70	' , @RestrictionClause_intern
71 , '
72  end		
73	' ) end  if @DebugSwitch > 0 begin print @sqlpattern end declare @GenProcIDs_CounOrigin QBM_YCursorBuffer insert into @GenProcIDs_CounOrigin
74 (UID1) select distinct d.GenProcID from #QBMDeltaOrigin d select @ElementCount = @@ROWCOUNT select @ElementIndex = 1 while @ElementIndex <= @ElementCount
75 begin select top 1 @GenProcID = bu.UID1 from @GenProcIDs_CounOrigin bu where bu.ElementIndex = @ElementIndex exec QBM_PSessionContextSet 'GenProcID', 
76@GenProcID select @SQLCmd = REPLACE(@SQLPattern, '@GenProcID', @GenProcID) if @DebugSwitch > 0 begin print @SQLCmd end exec QBM_PExecuteSQLWithRetry_LLP
77 @SQLStatement = @SQLcmd , @LockTimeout_ms = default , @MaxWaitTimeForLock_s = @MaxWaitTimeForMainOperation , @ProcIDForJournal = default , @HandleErrorSilent
78 = 0 select @ElementIndex += 1 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow
79() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH endLabel: exec QBM_PSessionContextSet 'GenProcID', @GenProcID_R exec QBM_PSessionContextSet 'XUser'
80, @XUser_R return end

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.353

uses session context values has TRY/CATCH error handling

Summary: calls QBM_PSessionContextSet, QBM_PExecuteSQLWithRetry_LLP, QBM_PSessionErrorAdd; writes INSERT into; reads/joins DialogTable; uses session context XUser, GenProcID

Declared parameters

ParameterTypeDirection
@TargetTablevarchar(30)input
@ElementColumnvarchar(30)input
@AssignedElementColumnvarchar(30)input
@RestrictionClausenvarcharinput

DML targets

INSERT into

Called routines

Read/join references

SQL dependency metadata

Config/session

Config: None extracted.

Session: XUser GenProcID

DBQueue/tasks

None extracted.

Temp tables / referenced variables

Temp: #QBMDeltaOrigin

Variables: @TargetTable @ElementColumn @AssignedElementColumn @RestrictionClause @GenProcID @SQLCmd @SQLPattern @ExistsXIsInEffect @ExistsXdate @RestrictionClause_intern @DebugSwitch @IsCreatePendingChange @Maske @GenProcID_R @XUser_R @ElementCount @ElementIndex @MaxWaitTimeForMainOperation @procid @maske @sqlpattern @GenProcIDs_CounOrigin @ROWCOUNT @SQLStatement @SQLcmd @LockTimeout_ms @MaxWaitTimeForLock_s @ProcIDForJournal @HandleErrorSilent @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 objectRelationEvidence
dbo.ADS_ZAccountInADSGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.ADS_ZADSMachineInADSGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.ADS_ZContactInADSGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.ADS_ZOrgHasADSGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PA104261FA54379C6160FAE8F6SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PA11AF8D16C61275A2DCFAED6ESQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PA32EFCA6201B15CB29D954994SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PA6BF9FD71303E4D8F82AD2566SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PA72A423016BA139FFC3D8EDFFSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PA98D6CE53656FFB7523357E71SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PACB9B89D5F903FDF8F2FAD40DSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PAD1085733B383217D4E3F0797SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PAD601362D0C4E22FD4721754BSQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PAE14BB3C2EDA7D127BCA29F96SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PD0C461BCE9B1499A948C6DE89SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PD75EFC2994CF76773E86FDA0ASQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PD7750F63D2FE88D966B93F426SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PD85D31B610579F7BE495D13A3SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PD88D54946ECC34815B5EF8AA7SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PDA305E8EEC3AE04AAA39FD671SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PDB81C19C7C55B5C62A0191559SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PDBB056A1F7CFF0CE82AAA3734SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PDBDCABA4BA9EB91B037DD3763SQL expression dependencyOBJECT_OR_COLUMN
dbo.GEN_PDEC582A34382551F1DDFD9799SQL expression dependencyOBJECT_OR_COLUMN
dbo.LDP_ZAccountInLDAPGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.LDP_ZLDPMachineInLDAPGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.LDP_ZOrgHasLDAPGroupSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZHelperHeadOrgSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZHelperHeadPersonSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZOrgHasQERAssignSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZOrgHasQERResourceSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZOrgHasQERReuseSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZOrgHasQERReuseUSSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZPersonHasQERAssignSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZPersonHasQERResourceSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZPersonHasQERReuseSQL expression dependencyOBJECT_OR_COLUMN
dbo.QER_ZPersonHasQERReuseUSSQL expression dependencyOBJECT_OR_COLUMN
dbo.RMS_ZESetHasEntitlementSQL expression dependencyOBJECT_OR_COLUMN
dbo.RMS_ZOrgHasESetSQL expression dependencyOBJECT_OR_COLUMN
dbo.RMS_ZPersonHasESetSQL expression dependencyOBJECT_OR_COLUMN
dbo.RMS_ZWorkDeskHasESetSQL expression dependencyOBJECT_OR_COLUMN
dbo.RPS_ZOrgHasRPSReportSQL expression dependencyOBJECT_OR_COLUMN
dbo.RPS_ZPersonHasRPSReportSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_ZOrgHasTSBAccountDefSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_ZOrgHasUNSGroupBSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_ZOrgHasUNSGroupB1SQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_ZOrgHasUNSGroupB2SQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_ZOrgHasUNSGroupB3SQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_ZPersonHasTSBAccountDefSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_ZUNSAccountBHasUNSItemBSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_ZUNSAccountBInUNSGroupBSQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_ZUNSAccountBInUNSGroupB1SQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_ZUNSAccountBInUNSGroupB2SQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_ZUNSAccountBInUNSGroupB3SQL expression dependencyOBJECT_OR_COLUMN
dbo.TSB_ZUNSGroupBHasUNSItemBSQL expression dependencyOBJECT_OR_COLUMN
dbo.ADS_ZAccountInADSGroupsource text referencehas TRY/CATCH error handling
dbo.ADS_ZADSMachineInADSGroupsource text referencehas TRY/CATCH error handling
dbo.ADS_ZContactInADSGroupsource text referencehas TRY/CATCH error handling
dbo.ADS_ZOrgHasADSGroupsource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.CPL_PComplianceCheckMakeProc_hsource text referencehas TRY/CATCH error handling
dbo.LDP_ZAccountInLDAPGroupsource text referencehas TRY/CATCH error handling
dbo.LDP_ZLDPMachineInLDAPGroupsource text referencehas TRY/CATCH error handling
dbo.LDP_ZOrgHasLDAPGroupsource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.QER_PDynamicGroupMakeProc_hlpsource text referencehas TRY/CATCH error handling
dbo.QER_ZHelperHeadOrgsource text referencehas TRY/CATCH error handling
dbo.QER_ZHelperHeadPersonsource text referencehas TRY/CATCH error handling
dbo.QER_ZOrgHasQERAssignsource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.QER_ZOrgHasQERResourcesource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.QER_ZOrgHasQERReusesource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.QER_ZOrgHasQERReuseUSsource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.QER_ZPersonHasQERAssignsource text referencehas TRY/CATCH error handling
dbo.QER_ZPersonHasQERResourcesource text referencehas TRY/CATCH error handling
dbo.QER_ZPersonHasQERReusesource text referencehas TRY/CATCH error handling
dbo.QER_ZPersonHasQERReuseUSsource text referencehas TRY/CATCH error handling
dbo.RMS_ZESetHasEntitlementsource text referencehas TRY/CATCH error handling
dbo.RMS_ZOrgHasESetsource text referencehas TRY/CATCH error handling
dbo.RMS_ZPersonHasESetsource text referencehas TRY/CATCH error handling
dbo.RMS_ZWorkDeskHasESetsource text referencehas TRY/CATCH error handling
dbo.RPS_ZOrgHasRPSReportsource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.RPS_ZPersonHasRPSReportsource text referencehas TRY/CATCH error handling
dbo.TSB_ZOrgHasTSBAccountDefsource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.TSB_ZOrgHasUNSGroupBsource text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.TSB_ZOrgHasUNSGroupB1source text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.TSB_ZOrgHasUNSGroupB2source text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.TSB_ZOrgHasUNSGroupB3source text referenceinserts DBQueue tasks, has TRY/CATCH error handling
dbo.TSB_ZPersonHasTSBAccountDefsource text referencehas TRY/CATCH error handling
dbo.TSB_ZUNSAccountBHasUNSItemBsource text referencehas TRY/CATCH error handling
dbo.TSB_ZUNSAccountBInUNSGroupBsource text referencehas TRY/CATCH error handling
dbo.TSB_ZUNSAccountBInUNSGroupB1source text referencehas TRY/CATCH error handling
dbo.TSB_ZUNSAccountBInUNSGroupB2source text referencehas TRY/CATCH error handling
dbo.TSB_ZUNSAccountBInUNSGroupB3source text referencehas TRY/CATCH error handling
dbo.TSB_ZUNSGroupBHasUNSItemBsource text referencehas TRY/CATCH error handling