Back to OIM Explorer

dbo.ATT_TUHelperHeadOrg

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on HelperHeadOrg. Trigger parent table: HelperHeadOrg

Source: sandbox-db sys.sql_modules

Source size: 1.198 characters

Interpretation

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

Relations

  • Trigger parent table: HelperHeadOrg

Typed Edges

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

SQL55 lines
1CREATE trigger ATT_TUHelperHeadOrg2  ON HelperHeadOrg FOR3UPDATE NOT FOR Replication4AS5BEGIN6  BEGIN TRY7    IF EXISTS(8      SELECT TOP 1 19      FROM deleted)10    GOTO start11    RETURN start:12    DECLARE @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')13    IF14    UPDATE(XOrigin)15    BEGIN16      DECLARE @RecalcParameter_01 QBM_YCursorBuffer17      INSERT INTO @RecalcParameter_01(ObjectKey1,18      UID1,19      Ident1)20      SELECT21        bt.XObjectKey,22        v.Regel,23        'A'24      FROM deleted d25      JOIN HelperHeadOrg a26        ON a.UID_Org = d.UID_Org AND a.UID_PersonHead = d.UID_PersonHead AND dbo.QBM_FGIXOriginChanged_Effect(d.XOrigin,27      a.XOrigin,28      1,29      1) = 130      JOIN BaseTree bt31        ON d.UID_Org = bt.UID_Org32      JOIN(33      VALUES('ATT-PWODecisionRule-PM', 'QER-V-ProfitCenter'),34      ('ATT-PWODecisionRule-OM', '____[^V]%'),35      ('ATT-PWODecisionRule-RM', '%'),36      ('ATT-PWODecisionRule-RR', '%'),37      ('ATT-PWODecisionRule-LM', 'QER-V-Locality'),38      ('ATT-PWODecisionRule-DM', 'QER-V-Department'),39      ('ATT-PWODecisionRule-ED', 'QER-V-Department')) AS v(Regel,40      RootMuster)41        ON bt.UID_OrgRoot LIKE v.RootMuster42      EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_01,43        @GenprocID44    END45  END TRY46  BEGIN CATCH47    EXEC QBM_PSessionErrorAdd DEFAULT48    RAISERROR('',49    18,50    1)51      WITH NOWAIT52  END CATCH53  ende:54  RETURN55END
Open raw exported source
SQL ยท Raw9 lines
1create   trigger ATT_TUHelperHeadOrg on HelperHeadOrg  for update not for Replication as begin  BEGIN TRY if exists (select top 1 1 from deleted2) goto start return start: declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext('') if update(XOrigin) begin    declare @RecalcParameter_01 QBM_YCursorBuffer3 insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select bt.XObjectKey, v.Regel, 'A' from deleted d join HelperHeadOrg a on a.UID_Org = d.UID_Org4 and a.UID_PersonHead = d.UID_PersonHead and dbo.QBM_FGIXOriginChanged_Effect(d.XOrigin, a.XOrigin, 1, 1) = 1 join BaseTree bt on d.UID_Org = bt.UID_Org5 join (values ('ATT-PWODecisionRule-PM', 'QER-V-ProfitCenter') , ('ATT-PWODecisionRule-OM', '____[^V]%') , ('ATT-PWODecisionRule-RM', '%') , ('ATT-PWODecisionRule-RR'6, '%') , ('ATT-PWODecisionRule-LM', 'QER-V-Locality') , ('ATT-PWODecisionRule-DM', 'QER-V-Department') , ('ATT-PWODecisionRule-ED', 'QER-V-Department')7 ) as v (Regel, RootMuster) on bt.UID_OrgRoot like v.RootMuster exec QER_PITShopHelperFill_Recalc @RecalcParameter_01, @GenprocID  end  END TRY BEGIN CATCH8 exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 9