dbo.RMS_TIESetExcludesESet

1  create   trigger RMS_TIESetExcludesESet on ESetExcludesESet  for Insert not for Replication as begin  declare @exclusions QBM_YParameterList BEGIN
2 TRY if exists (select top 1 1 from inserted) goto start return start: declare @GenProcID varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')
3 if dbo.QBM_FGIConfigparmValue('QER\Structures\Inherite\ESetExclusion') = ''  begin raiserror( '#LDS#Cannot make a definition because exclusion is not enabled by config parm.|'
4, 18, 2) with nowait end insert into @exclusions (Parameter1, Parameter2) select UID_ESet, UID_ESetExcluded from inserted exec QER_PExclusionCheckCircular
5 @TargetTable = 'ESetExcludesESet' , @HigherColumn = 'UID_ESet' , @LowerColumn = 'UID_ESetExcluded' , @exclusions = @exclusions declare @DBQueueElements_01
6 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct uig.UID_Person as
7 uid from ( select UID_ESet as UID_ESet from inserted union all select UID_ESetExcluded from inserted ) as y join PersonHasEset uig on y.UID_ESet = uig.UID_ESet
8  ) as x exec QBM_PDBQueueInsert_Bulk 'RMS-K-PersonHasESet', @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02
9 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select distinct uig.UID_Org as uid from ( select UID_ESet as UID_ESet from inserted
10 union all select UID_ESetExcluded from inserted ) as y join BaseTreeHasEset uig on y.UID_ESet = uig.UID_ESet  ) as x exec QBM_PDBQueueInsert_Bulk 'RMS-K-OrgHasESet'
11, @DBQueueElements_02 declare @DBQueueElements_03 QBM_YDBQueueRaw insert into @DBQueueElements_03 (object, subobject, genprocid) select x.uid, null, @GenProcID
12 from ( select distinct uig.UID_WorkDesk as uid from ( select UID_ESet as UID_ESet from inserted union all select UID_ESetExcluded from inserted ) as y
13 join WorkDeskHasESet uig on y.UID_ESet = uig.UID_ESet  ) as x exec QBM_PDBQueueInsert_Bulk 'RMS-K-WorkdeskHasESet', @DBQueueElements_03 declare @DBQueueElements_04
14 QBM_YDBQueueRaw insert into @DBQueueElements_04 (object, subobject, genprocid) select x.uid, null, @GenProcID from ( select uig.UID_ESet as uid from (
15 select UID_ESet as UID_ESet from inserted union all select UID_ESetExcluded from inserted ) as y join ESetHasEntitlement uig on y.UID_ESet = uig.UID_ESet
16 union select distinct uig.UID_ESet as uid from ( select UID_ESet as UID_ESet from inserted union all select UID_ESetExcluded from inserted ) as y join
17 Eset z on y.UID_ESet = z.UID_ESet join ESetHasEntitlement uig on z.XObjectKey = uig.Entitlement ) as x exec QBM_PDBQueueInsert_Bulk 'RMS-K-ESetHasEntitlement'
18, @DBQueueElements_04 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 
19