Back to OIM Explorer

dbo.ATT_TIHelperHeadPerson

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on HelperHeadPerson. Trigger parent table: HelperHeadPerson

Source: sandbox-db sys.sql_modules

Source size: 870 characters

Interpretation

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

Relations

  • Trigger parent table: HelperHeadPerson

Typed Edges

  • trigger on table HelperHeadPerson Trigger parent table: HelperHeadPerson
  • references source dbo.QBM_FCVElementToObjectKey1 source text reference
  • 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

SQL45 lines
1CREATE trigger ATT_TIHelperHeadPerson2  ON HelperHeadPerson FOR3INSERT NOT FOR Replication4AS5BEGIN6  BEGIN TRY7    IF EXISTS(8      SELECT TOP 1 19      FROM inserted)10    GOTO start11    RETURN start:12    DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')13    DECLARE @RecalcParameter_01 QBM_YCursorBuffer14    INSERT INTO @RecalcParameter_01(ObjectKey1,15    UID1,16    Ident1)17    SELECT18      dbo.QBM_FCVElementToObjectKey1('Person',19      '',20      i.UID_Person),21      v.UID_PWODecisionRule,22      'A'23    FROM inserted i CROSS24    JOIN(25    VALUES('ATT-PWODecisionRule-CM'),26    ('ATT-PWODecisionRule-EM'),27    ('ATT-PWODecisionRule-XM'),28    ('ATT-PWODecisionRule-AM')) AS v(UID_PWODecisionRule)29    EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_01,30      @GenprocID31  END TRY32  BEGIN CATCH33    EXEC QBM_PSessionErrorAdd DEFAULT34    IF @@TRANCOUNT > 035    BEGIN36      ROLLBACK TRANSACTION;37    END38    RAISERROR('',39    18,40    1)41      WITH NOWAIT42  END CATCH43  ende:44  RETURN45END
Open raw exported source
SQL ยท Raw7 lines
1    create   trigger ATT_TIHelperHeadPerson on HelperHeadPerson  for Insert not for Replication as begin  BEGIN TRY if exists (select top 1 1 from2 inserted) goto start return start: declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')    declare @RecalcParameter_01 QBM_YCursorBuffer insert3 into @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select dbo.QBM_FCVElementToObjectKey1('Person', '', i.UID_Person), v.UID_PWODecisionRule, 'A' from4 inserted i cross join (values ('ATT-PWODecisionRule-CM') , ('ATT-PWODecisionRule-EM') , ('ATT-PWODecisionRule-XM') , ('ATT-PWODecisionRule-AM') ) as v5 (UID_PWODecisionRule) exec QER_PITShopHelperFill_Recalc @RecalcParameter_01, @GenprocID  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default if @@TRANCOUNT6 > 0 BEGIN ROLLBACK TRANSACTION; END RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 7