Back to OIM Explorer

dbo.ADS_TATTUDomain

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on ADSDomain. Trigger parent table: ADSDomain

Source: sandbox-db sys.sql_modules

Source size: 1.048 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.

Relations

  • Trigger parent table: ADSDomain

Typed Edges

  • trigger on table ADSDomain Trigger parent table: ADSDomain
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QER_PITShopHelperFill source text reference
  • references source dbo.QER_PITShopHelperFill_Recalc source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL62 lines
1CREATE trigger ADS_TATTUDomain2  ON adsdomain FOR3UPDATE NOT FOR Replication4AS5BEGIN6  DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    IF EXISTS(13      SELECT TOP 1 114      FROM deleted)15    GOTO start16    RETURN start:17    IF18    UPDATE(uid_AERoleOwner)19    BEGIN20      DECLARE @RecalcParameter_01 QBM_YCursorBuffer21      INSERT INTO @RecalcParameter_01(ObjectKey1,22      UID1,23      Ident1)24      SELECT25        i.XobjectKey,26        'TSB-PWODecisionRule-EN',27        'A'28      FROM inserted i29      INSERT INTO @RecalcParameter_01(ObjectKey1,30      UID1,31      Ident1)32      SELECT33        bt.XobjectKey,34        'TSB-PWODecisionRule-SO',35        'A'36      FROM inserted i37      JOIN basetree bt38        ON i.uid_AERoleOwner = bt.UID_Org39      INSERT INTO @RecalcParameter_01(ObjectKey1,40      UID1,41      Ident1)42      SELECT43        bt.XobjectKey,44        'TSB-PWODecisionRule-SO',45        'A'46      FROM deleted d47      JOIN basetree bt48        ON d.uid_AERoleOwner = bt.UID_Org49      EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_01,50        @GenprocID51    END52  END TRY53  BEGIN CATCH54    EXEC QBM_PSessionErrorAdd DEFAULT55    RAISERROR('',56    18,57    1)58      WITH NOWAIT59  END CATCH60  ende:61  RETURN62END
Open raw exported source
SQL ยท Raw8 lines
1    create   trigger ADS_TATTUDomain on adsdomain  for Update not for Replication as begin declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext2('') BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: if update(uid_AERoleOwner3) begin     declare @RecalcParameter_01 QBM_YCursorBuffer insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select i.XobjectKey , 'TSB-PWODecisionRule-EN'4, 'A' from inserted i  insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select bt.XobjectKey, 'TSB-PWODecisionRule-SO', 'A' from inserted i join5 basetree bt on i.uid_AERoleOwner = bt.UID_Org insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select bt.XobjectKey, 'TSB-PWODecisionRule-SO'6, 'A' from deleted d join basetree bt on d.uid_AERoleOwner = bt.UID_Org exec QER_PITShopHelperFill_Recalc @RecalcParameter_01, @GenprocID  end  END TRY7 BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 8