Back to OIM Explorer

dbo.ATT_TIHelperHeadOrg

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on HelperHeadOrg. Trigger parent table: HelperHeadOrg

Source: sandbox-db sys.sql_modules

Source size: 1.068 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_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_TIHelperHeadOrg2  ON HelperHeadOrg 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      bt.XObjectKey,19      v.Regel,20      'A'21    FROM inserted i22    JOIN BaseTree bt23      ON i.UID_Org = bt.UID_Org24    JOIN(25    VALUES('ATT-PWODecisionRule-PM', 'QER-V-ProfitCenter'),26    ('ATT-PWODecisionRule-OM', '____[^V]%'),27    ('ATT-PWODecisionRule-RM', '%'),28    ('ATT-PWODecisionRule-RR', '%'),29    ('ATT-PWODecisionRule-LM', 'QER-V-Locality'),30    ('ATT-PWODecisionRule-DM', 'QER-V-Department'),31    ('ATT-PWODecisionRule-ED', 'QER-V-Department')) AS v(Regel,32    RootMuster)33      ON bt.UID_OrgRoot LIKE v.RootMuster34    EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_01,35      @GenprocID36  END TRY37  BEGIN CATCH38    EXEC QBM_PSessionErrorAdd DEFAULT39    IF @@TRANCOUNT > 040    BEGIN41      ROLLBACK TRANSACTION;42    END43    RAISERROR('',44    18,45    1)46      WITH NOWAIT47  END CATCH48  ende:49  RETURN50END
Open raw exported source
SQL ยท Raw8 lines
1    create   trigger ATT_TIHelperHeadOrg on HelperHeadOrg  for Insert not for Replication as begin  BEGIN TRY if exists (select top 1 1 from inserted2) goto start return start: declare @GenProcID varchar(38) = dbo.QBM_FGISessionContext('')    declare @RecalcParameter_01 QBM_YCursorBuffer insert into 3@RecalcParameter_01 (ObjectKey1, UID1, Ident1) select bt.XObjectKey, v.Regel, 'A' from inserted i join BaseTree bt on i.UID_Org = bt.UID_Org join (values4 ('ATT-PWODecisionRule-PM', 'QER-V-ProfitCenter') , ('ATT-PWODecisionRule-OM', '____[^V]%') , ('ATT-PWODecisionRule-RM', '%') , ('ATT-PWODecisionRule-RR'5, '%') , ('ATT-PWODecisionRule-LM', 'QER-V-Locality') , ('ATT-PWODecisionRule-DM', 'QER-V-Department') , ('ATT-PWODecisionRule-ED', 'QER-V-Department')6 ) as v (Regel, RootMuster) on bt.UID_OrgRoot like v.RootMuster exec QER_PITShopHelperFill_Recalc @RecalcParameter_01, @GenprocID  END TRY BEGIN CATCH 7exec QBM_PSessionErrorAdd default if @@TRANCOUNT > 0 BEGIN ROLLBACK TRANSACTION; END RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 8