Back to OIM Explorer

dbo.QER_TIHelperHeadPerson

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on HelperHeadPerson. Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 4; References QBM_PDBQueueInsert_Single; Trigger parent table: HelperHeadPerson

Source: sandbox-db sys.sql_modules

Source size: 857 characters

Interpretation

  • Database trigger. Treat parent table and enqueue/object-layer calls as the main relation points.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 4
  • References QBM_PDBQueueInsert_Single
  • Trigger parent table: HelperHeadPerson

Typed Edges

  • queues DBQueue task QBM_ZRecalculate at line 4 Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 4
  • trigger on table HelperHeadPerson Trigger parent table: HelperHeadPerson
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PDBQueueInsert_Single 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

SQL47 lines
1CREATE trigger QER_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)13    SELECT @GenProcID = dbo.QBM_FGISessionContext('')14    DECLARE @RecalcParameter QBM_YCursorBuffer15    INSERT INTO @RecalcParameter(UID1,16    ObjectKey1,17    Ident1)18    SELECT19      'QER-PWODecisionRule-CM',20      e.XObjectKey,21      'I'22    FROM(23    SELECT i.UID_Person24    FROM inserted i) x25    JOIN Person e26      ON x.UID_Person = e.UID_Person27    EXEC QER_PITShopHelperFill_Recalc @RecalcParameter,28      @GenprocID29    EXEC QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate',30    'QER-K-ShoppingRackPWODecisionMaker',31    '',32      @GenProcID33  END TRY34  BEGIN CATCH35    EXEC QBM_PSessionErrorAdd DEFAULT36    IF @@TRANCOUNT > 037    BEGIN38      ROLLBACK TRANSACTION;39    END40    RAISERROR('',41    18,42    1)43      WITH NOWAIT44  END CATCH45  ende:46  RETURN47END
Open raw exported source
SQL ยท Raw7 lines
1    create   trigger QER_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) select @GenProcID = dbo.QBM_FGISessionContext('') declare @RecalcParameter QBM_YCursorBuffer3 insert into @RecalcParameter (UID1, ObjectKey1, Ident1) select 'QER-PWODecisionRule-CM', e.XObjectKey, 'I' from (select i.UID_Person from inserted i )4 x join Person e on x.UID_Person = e.UID_Person exec QER_PITShopHelperFill_Recalc @RecalcParameter, @GenprocID exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate'5, 'QER-K-ShoppingRackPWODecisionMaker', '', @GenProcID END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default if @@TRANCOUNT > 0 BEGIN ROLLBACK TRANSACTION;6  END RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 7