Back to OIM Explorer

dbo.ATT_TRMBIHelperHeadOrg

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on HelperHeadOrg. Trigger parent table: HelperHeadOrg

Source: sandbox-db sys.sql_modules

Source size: 716 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

SQL37 lines
1CREATE trigger ATT_TRMBIHelperHeadOrg2  ON HelperHeadOrg FOR3INSERT NOT FOR replication4AS5BEGIN6  DECLARE @GenProcID varchar(38)7  IF EXISTS(8    SELECT TOP 1 19    FROM inserted)10  GOTO start11  GOTO endLabel start:12  BEGIN TRY13    SELECT @GenProcID = dbo.QBM_FGISessionContext('')14    DECLARE @RecalcParameter_01 QBM_YCursorBuffer15    INSERT INTO @RecalcParameter_01(ObjectKey1,16    UID1,17    Ident1)18    SELECT19      dep.XObjectKey,20      'ATT-PWODecisionRule-MO ',21      'A'22    FROM inserted i23    JOIN BaseTree dep24      ON i.UID_Org = dep.UID_Org AND dep.UID_OrgRoot = '____[^V]%'25    EXEC QER_PITShopHelperFill_Recalc @RecalcParameter_01,26      @GenprocID27  END TRY28  BEGIN CATCH29    EXEC QBM_PSessionErrorAdd DEFAULT30    RAISERROR('',31    18,32    1)33      WITH NOWAIT34  END CATCH35  endLabel:36  RETURN37END
Open raw exported source
SQL ยท Raw6 lines
1 create   trigger ATT_TRMBIHelperHeadOrg on HelperHeadOrg  for insert not for replication as begin  declare @GenProcID varchar(38) if exists (select2 top 1 1 from inserted) goto start goto endLabel start: BEGIN TRY select @GenProcID = dbo.QBM_FGISessionContext('')    declare @RecalcParameter_01 QBM_YCursorBuffer3 insert into @RecalcParameter_01 (ObjectKey1, UID1, Ident1) select dep.XObjectKey, 'ATT-PWODecisionRule-MO ', 'A' from inserted i join BaseTree dep on 4i.UID_Org = dep.UID_Org and dep.UID_OrgRoot = '____[^V]%' exec QER_PITShopHelperFill_Recalc @RecalcParameter_01, @GenprocID END TRY BEGIN CATCH exec QBM_PSessionErrorAdd5 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 6