Back to OIM Explorer

dbo.ATT_TURMBPerson

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on Person. Trigger parent table: Person

Source: sandbox-db sys.sql_modules

Source size: 806 characters

Interpretation

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

Relations

  • Trigger parent table: Person

Typed Edges

  • trigger on table Person Trigger parent table: Person
  • 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

SQL50 lines
1CREATE trigger ATT_TURMBPerson2  ON Person FOR3UPDATE NOT FOR Replication4AS5BEGIN6  BEGIN TRY7    IF EXISTS(8      SELECT TOP 1 19      FROM inserted)10    GOTO start11    IF EXISTS(12      SELECT TOP 1 113      FROM deleted)14    GOTO start15    RETURN start:16    DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')17    IF18    UPDATE(uid_Org)19    BEGIN20      DECLARE @RecalcParameter_01 QBM_YCursorBuffer21      INSERT INTO @RecalcParameter_01(ObjectKey1,22      UID1,23      Ident1)24      SELECT25        i.XObjectKey,26        'ATT-PWODecisionRule-MO',27        'A'28      FROM inserted i29      INSERT INTO @RecalcParameter_01(ObjectKey1,30      UID1,31      Ident1)32      SELECT33        i.XObjectKey,34        'ATT-PWODecisionRule-AO',35        'A'36      FROM inserted i37      EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_01,38        @GenprocID39    END40  END TRY41  BEGIN CATCH42    EXEC QBM_PSessionErrorAdd DEFAULT43    RAISERROR('',44    18,45    1)46      WITH NOWAIT47  END CATCH48  ende:49  RETURN50END
Open raw exported source
SQL ยท Raw7 lines
1    create   trigger ATT_TURMBPerson on Person  for Update not for Replication as begin  BEGIN TRY if exists (select top 1 1 from inserted) goto2 start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')   if update(uid_Org3) begin    declare @RecalcParameter_01 QBM_YCursorBuffer insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select i.XObjectKey, 'ATT-PWODecisionRule-MO'4, 'A' from inserted i insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select i.XObjectKey, 'ATT-PWODecisionRule-AO', 'A' from inserted i exec5 QER_PITShopHelperFill_Recalc @RecalcParameter_01, @GenprocID  end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT6 END CATCH ende: return end 7