dbo.RPS_TIBaseTreeHasRPSReport

1CREATE trigger RPS_TIBaseTreeHasRPSReport2  ON BaseTreeHasRPSReport FOR3INSERT NOT FOR Replication4AS5BEGIN6  DECLARE @QBM_BitPatternXOrigin_Direct int = dbo.QBM_FGIBitPatternXOrigin('|Direct|',7  0)8  DECLARE @QBM_BitPatternXOrigin_Inherit_inv int = dbo.QBM_FGIBitPatternXOrigin('|Inherit|',9  1)10  BEGIN TRY11    IF EXISTS(12      SELECT TOP 1 113      FROM inserted)14    GOTO start15    RETURN start:16    DECLARE @GenProcID varchar(38)17    SELECT @GenProcID = dbo.QBM_FGISessionContext('')18    DECLARE @AssignCheckValues QBM_YparameterList19    INSERT INTO @AssignCheckValues(Parameter1,20    Parameter2)21    SELECT22      i.UID_Org,23      i.XOrigin24    FROM inserted i25    EXEC QER_PAssignmentCheckValid 'RPS-AsgnBT-RPSReport',26      @AssignCheckValues,27      @GenProcID28    IF EXISTS(29      SELECT TOP 1 130      FROM inserted i31      JOIN RPSReport p32        ON i.UID_RPSReport = p.UID_RPSReport AND p.isInactive = 133      JOIN BaseTree b34        ON i.uid_org = b.uid_org AND(b.uid_orgroot < 'QER-V-ITShopOrg' OR b.uid_orgroot > 'QER-V-ITShopOrg'))35    BEGIN36      RAISERROR('#LDS#Assignment cannot take place, because the object to be assigned is disabled.|',37      18,38      3)39        WITH nowait40    END41    DECLARE @ITShopInfo nvarchar(2)42    IF EXISTS(43      SELECT TOP 1 144      FROM inserted i45      JOIN BaseTree dest46        ON i.uid_org = dest.uid_Org47      JOIN RPSReport elem48        ON i.uid_RPSReport = elem.uid_RPSReport49      WHERE50        dbo.QER_FGIITShopFlagCombineValid(dest.XObjectKey, NULL, NULL, elem.XObjectKey, elem.IsForITShop,51    elem.IsITShopOnly) = 0 AND i.XOrigin & @QBM_BitPatternXOrigin_Direct > 0)52    BEGIN53      RAISERROR('#LDS#Assignment is not permitted due to the combination of IT Shop flags.|',54      18,55      2)56        WITH nowait57    END58    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw59    INSERT INTO @DBQueueElements_01(object,60    subobject,61    genprocid)62    SELECT63      x.uid,64      x.subobject,65      @GenProcID66    FROM(67    SELECT68      DISTINCT i.uid_org AS uid,69      'RPS-K-OrgHasRPSReport' AS subobject70    FROM inserted i71    WHERE72      i.XOrigin & @QBM_BitPatternXOrigin_Inherit_inv > 0) AS x73    EXEC QBM_PDBQueueInsert_Bulk 'QER-K-AllChildrenOfOrg',74      @DBQueueElements_0175    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw76    INSERT INTO @DBQueueElements_02(object,77    subobject,78    genprocid)79    SELECT80      x.uid,81      NULL,82      @GenProcID83    FROM(84    SELECT85      DISTINCT i.uid_org AS uid86    FROM inserted i87    JOIN BaseTree b88      ON i.uid_Org = b.uid_org89    WHERE90      b.ITShopInfo = 'BO' AND i.XIsInEffect = 1) AS x91    EXEC QBM_PDBQueueInsert_Bulk 'QER-K-OrgAutoChild',92      @DBQueueElements_0293    DECLARE @DBQueueElements_03 QBM_YDBQueueRaw94    INSERT INTO @DBQueueElements_03(object,95    subobject,96    genprocid)97    SELECT98      x.uid,99      NULL,100      @GenProcID101    FROM(102    SELECT103      DISTINCT i.uid_org AS uid104    FROM inserted i105    WHERE106      i.XIsInEffect = 1) AS x107    EXEC QBM_PDBQueueInsert_Bulk 'RPS-K-BaseTreeHasObject',108      @DBQueueElements_03109    DECLARE @DBQueueElements_04 QBM_YDBQueueRaw110    INSERT INTO @DBQueueElements_04(object,111    subobject,112    genprocid)113    SELECT114      x.uid,115      NULL,116      @GenProcID117    FROM(118    SELECT119      DISTINCT hpo.uid_person AS uid120    FROM inserted i121    JOIN(122    SELECT123      pio.uid_person, pio.uid_org124    FROM personinBaseTree pio125    WHERE126      pio.XOrigin > 0127    UNION all128    SELECT129      uid_person, uid_org130    FROM helperPersonOrg) hpo131      ON hpo.uid_org = i.uid_org132    WHERE133      i.XIsInEffect = 1) AS x134    EXEC QBM_PDBQueueInsert_Bulk 'RPS-K-PersonHasRPSReport',135      @DBQueueElements_04136  END TRY137  BEGIN CATCH138    EXEC QBM_PSessionErrorAdd DEFAULT139    RAISERROR('',140    18,141    1)142      WITH NOWAIT143  END CATCH144  ende:145  RETURN146END