dbo.QER_TUPersonHasQERReuse

1create   trigger QER_TUPersonHasQERReuse on PersonHasQERReuse  for Update not for Replication as begin  BEGIN TRY if exists (select top 1 1 from
2 inserted) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext
3('') if update(XOrigin) begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, 
4null, @GenProcID from ( select distinct d.UID_Person as uid from deleted d join PersonHasQERReuse dd on d.XObjectKey = dd.XObjectKey where dbo.QBM_FGIXOriginChanged_Except2
5(d.XOrigin, dd.XOrigin) = 1  ) as x exec QBM_PDBQueueInsert_Bulk 'QER-K-PersonHasQERReuse', @DBQueueElements_01 end  if update(XIsInEffect) or update(XOrigin
6) begin declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, @GenProcID from 
7( select distinct a.UID_Person as uid from PersonHasQERReuse a join deleted d on a.XObjectKey = d.XObjectKey where dbo.QBM_FGIXOriginChanged_Effect(d.XOrigin
8, a.XOrigin, d.XIsInEffect, a.XIsInEffect) = 1 or dbo.QER_FCVXOriginToInheritInfo(d.XOrigin) <> dbo.QER_FCVXOriginToInheritInfo(a.XOrigin) ) as x exec 
9QBM_PDBQueueInsert_Bulk 'QER-K-PersonHasObject', @DBQueueElements_02 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH
10 NOWAIT END CATCH ende: return end 
11