Back to OIM Explorer

dbo.ATT_TUPWODecisionSubmethod

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on PWODecisionSubMethod. Bulk DBQueue insert -> ATT-K-Attestation-RESET / ATT_ZAttestationReset at line 8; Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 8; Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 9; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

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

  • Bulk DBQueue insert -> ATT-K-Attestation-RESET / ATT_ZAttestationReset at line 8
  • Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 8
  • Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 9
  • References QBM_PDBQueueInsert_Bulk
  • Trigger parent table: PWODecisionSubMethod

Typed Edges

  • queues DBQueue task ATT_ZAttestationReset at line 8 Bulk DBQueue insert -> ATT-K-Attestation-RESET / ATT_ZAttestationReset at line 8
  • queues DBQueue task ATT_ZAttestationAbort at line 8 Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 8
  • queues DBQueue task ATT_ZAttestationAbort at line 9 Bulk DBQueue insert -> ATT-K-Attestation-ABORT / ATT_ZAttestationAbort at line 9
  • trigger on table PWODecisionSubMethod Trigger parent table: PWODecisionSubMethod
  • references source dbo.QBM_FGIConfigparmValue source text reference
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL66 lines
1CREATE trigger ATT_TUPWODecisionSubmethod2  ON PWODecisionSubmethod FOR3UPDATE NOT FOR Replication4AS5BEGIN6  DECLARE @QER_Attestation_OnWorkflowUpdate varchar(16)7  BEGIN TRY8    IF EXISTS(9      SELECT TOP 1 110      FROM inserted)11    GOTO start12    IF EXISTS(13      SELECT TOP 1 114      FROM deleted)15    GOTO start16    RETURN start:17    DECLARE @GenProcID varchar(38)18    SELECT @GenProcID = dbo.QBM_FGISessionContext('')19    IF20    UPDATE(RevisionNumber)21    BEGIN22      SELECT23        @QER_Attestation_OnWorkflowUpdate = dbo.QBM_FGIConfigparmValue('QER\Attestation\OnWorkflowUpdate')24      IF @QER_Attestation_OnWorkflowUpdate IN('RESET',25      'ABORT')26      BEGIN27        DECLARE @DBQueueElements_01 QBM_YDBQueueRaw28        INSERT INTO @DBQueueElements_01(Object,29        SubObject,30        GenProcID)31        SELECT32          x.uid,33          NULL,34          @GenProcID35        FROM(36        SELECT ac.UID_AttestationCase AS uid37        FROM PWODecisionSubmethod sm38        JOIN deleted d39          ON sm.UID_PWODecisionSubMethod = d.UID_PWODecisionSubMethod AND sm.RevisionNumber <> d.RevisionNumber40        JOIN QERWorkingMethod wm41          ON wm.UID_PWODecisionSubMethod = sm.UID_PWODecisionSubMethod42        JOIN AttestationCase ac43          ON ac.UID_QERWorkingMethod = wm.UID_QERWorkingMethod) AS x44        IF @QER_Attestation_OnWorkflowUpdate = 'RESET'45        BEGIN46          EXEC QBM_PDBQueueInsert_Bulk 'ATT-K-Attestation-RESET',47            @DBQueueElements_0148        END49        IF @QER_Attestation_OnWorkflowUpdate = 'ABORT'50        BEGIN51          EXEC QBM_PDBQueueInsert_Bulk 'ATT-K-Attestation-ABORT',52            @DBQueueElements_0153        END54      END55    END56  END TRY57  BEGIN CATCH58    EXEC QBM_PSessionErrorAdd DEFAULT59    RAISERROR('',60    18,61    1)62      WITH NOWAIT63  END CATCH64  ende:65  RETURN66END
Open raw exported source
SQL ยท Raw11 lines
1    create   trigger ATT_TUPWODecisionSubmethod on PWODecisionSubmethod for Update not for Replication as begin  declare @QER_Attestation_OnWorkflowUpdate2 varchar(16) BEGIN TRY if exists (select top 1 1 from inserted) goto start if exists (select top 1 1 from deleted) goto start return start: declare @GenProcID3 varchar(38) select @GenProcID = dbo.QBM_FGISessionContext('')  if update(RevisionNumber) begin select @QER_Attestation_OnWorkflowUpdate = dbo.QBM_FGIConfigparmValue4('QER\Attestation\OnWorkflowUpdate') if @QER_Attestation_OnWorkflowUpdate in ('RESET', 'ABORT') begin declare @DBQueueElements_01 QBM_YDBQueueRaw insert5 into @DBQueueElements_01(Object, SubObject, GenProcID) select x.uid, null, @GenProcID from ( select ac.UID_AttestationCase as uid from PWODecisionSubmethod6 sm join deleted d on sm.UID_PWODecisionSubMethod = d.UID_PWODecisionSubMethod and sm.RevisionNumber <> d.RevisionNumber join QERWorkingMethod wm on wm.UID_PWODecisionSubMethod7 = sm.UID_PWODecisionSubMethod join AttestationCase ac on ac.UID_QERWorkingMethod = wm.UID_QERWorkingMethod ) as x if @QER_Attestation_OnWorkflowUpdate8 = 'RESET' begin exec QBM_PDBQueueInsert_Bulk 'ATT-K-Attestation-RESET', @DBQueueElements_01 end if @QER_Attestation_OnWorkflowUpdate = 'ABORT' begin exec9 QBM_PDBQueueInsert_Bulk 'ATT-K-Attestation-ABORT', @DBQueueElements_01 end end  end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR (''10, 18, 1) WITH NOWAIT END CATCH ende: return end 11