dbo.RMS_TIESetExcludesESet

1CREATE trigger RMS_TIESetExcludesESet2  ON ESetExcludesESet FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @exclusions QBM_YParameterList7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    RETURN start:13    DECLARE @GenProcID varchar(38)14    SELECT @GenProcID = dbo.QBM_FGISessionContext('')15    IF dbo.QBM_FGIConfigparmValue('QER\Structures\Inherite\ESetExclusion') = ''16    BEGIN17      RAISERROR('#LDS#Cannot make a definition because exclusion is not enabled by config parm.|',18      18,19      2)20        WITH nowait21    END22    INSERT INTO @exclusions(Parameter1,23    Parameter2)24    SELECT25      UID_ESet,26      UID_ESetExcluded27    FROM inserted28    EXEC QER_PExclusionCheckCircular @TargetTable = 'ESetExcludesESet',29      @HigherColumn = 'UID_ESet',30      @LowerColumn = 'UID_ESetExcluded',31      @exclusions = @exclusions32    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw33    INSERT INTO @DBQueueElements_01(object,34    subobject,35    genprocid)36    SELECT37      x.uid,38      NULL,39      @GenProcID40    FROM(41    SELECT42      DISTINCT uig.UID_Person AS uid43    FROM(44    SELECT UID_ESet AS UID_ESet45    FROM inserted46    UNION all47    SELECT UID_ESetExcluded48    FROM inserted) AS y49    JOIN PersonHasEset uig50      ON y.UID_ESet = uig.UID_ESet) AS x51    EXEC QBM_PDBQueueInsert_Bulk 'RMS-K-PersonHasESet',52      @DBQueueElements_0153    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw54    INSERT INTO @DBQueueElements_02(object,55    subobject,56    genprocid)57    SELECT58      x.uid,59      NULL,60      @GenProcID61    FROM(62    SELECT63      DISTINCT uig.UID_Org AS uid64    FROM(65    SELECT UID_ESet AS UID_ESet66    FROM inserted67    UNION all68    SELECT UID_ESetExcluded69    FROM inserted) AS y70    JOIN BaseTreeHasEset uig71      ON y.UID_ESet = uig.UID_ESet) AS x72    EXEC QBM_PDBQueueInsert_Bulk 'RMS-K-OrgHasESet',73      @DBQueueElements_0274    DECLARE @DBQueueElements_03 QBM_YDBQueueRaw75    INSERT INTO @DBQueueElements_03(object,76    subobject,77    genprocid)78    SELECT79      x.uid,80      NULL,81      @GenProcID82    FROM(83    SELECT84      DISTINCT uig.UID_WorkDesk AS uid85    FROM(86    SELECT UID_ESet AS UID_ESet87    FROM inserted88    UNION all89    SELECT UID_ESetExcluded90    FROM inserted) AS y91    JOIN WorkDeskHasESet uig92      ON y.UID_ESet = uig.UID_ESet) AS x93    EXEC QBM_PDBQueueInsert_Bulk 'RMS-K-WorkdeskHasESet',94      @DBQueueElements_0395    DECLARE @DBQueueElements_04 QBM_YDBQueueRaw96    INSERT INTO @DBQueueElements_04(object,97    subobject,98    genprocid)99    SELECT100      x.uid,101      NULL,102      @GenProcID103    FROM(104    SELECT uig.UID_ESet AS uid105    FROM(106    SELECT UID_ESet AS UID_ESet107    FROM inserted108    UNION all109    SELECT UID_ESetExcluded110    FROM inserted) AS y111    JOIN ESetHasEntitlement uig112      ON y.UID_ESet = uig.UID_ESet113    UNION114    SELECT115      DISTINCT uig.UID_ESet AS uid116    FROM(117    SELECT UID_ESet AS UID_ESet118    FROM inserted119    UNION all120    SELECT UID_ESetExcluded121    FROM inserted) AS y122    JOIN Eset z123      ON y.UID_ESet = z.UID_ESet124    JOIN ESetHasEntitlement uig125      ON z.XObjectKey = uig.Entitlement) AS x126    EXEC QBM_PDBQueueInsert_Bulk 'RMS-K-ESetHasEntitlement',127      @DBQueueElements_04128  END TRY129  BEGIN CATCH130    EXEC QBM_PSessionErrorAdd DEFAULT131    RAISERROR('',132    18,133    1)134      WITH NOWAIT135  END CATCH136  ende:137  RETURN138END