Back to OIM Explorer

dbo.ATT_TUPWODecisionMethod

Database TriggerSQL_TRIGGERSandbox DB

Database Trigger on PWODecisionMethod. 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.545 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: PWODecisionMethod

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 PWODecisionMethod Trigger parent table: PWODecisionMethod
  • 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

SQL67 lines
1CREATE trigger ATT_TUPWODecisionMethod2  ON PWODecisionMethod FOR3UPDATE NOT FOR Replication4AS5BEGIN6  DECLARE @QER_Attestation_OnWorkflowAssign 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(UID_SubMethodOrderProduct)21    BEGIN22      SELECT23        @QER_Attestation_OnWorkflowAssign = dbo.QBM_FGIConfigparmValue('QER\Attestation\OnWorkflowAssign')24      IF @QER_Attestation_OnWorkflowAssign 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 PWODecisionMethod m38        JOIN deleted d39          ON m.UID_PWODecisionMethod = d.UID_PWODecisionMethod AND isnull(m.UID_SubMethodOrderProduct, '') <> isnull(d.UID_SubMethodOrderProduct,40        '')41        JOIN QERWorkingMethod wm42          ON wm.UID_PWODecisionSubMethod = d.UID_SubMethodOrderProduct43        JOIN AttestationCase ac44          ON ac.UID_QERWorkingMethod = wm.UID_QERWorkingMethod AND ac.IsClosed = 0) AS x45        IF @QER_Attestation_OnWorkflowAssign = 'RESET'46        BEGIN47          EXEC QBM_PDBQueueInsert_Bulk 'ATT-K-Attestation-RESET',48            @DBQueueElements_0149        END50        IF @QER_Attestation_OnWorkflowAssign = 'ABORT'51        BEGIN52          EXEC QBM_PDBQueueInsert_Bulk 'ATT-K-Attestation-ABORT',53            @DBQueueElements_0154        END55      END56    END57  END TRY58  BEGIN CATCH59    EXEC QBM_PSessionErrorAdd DEFAULT60    RAISERROR('',61    18,62    1)63      WITH NOWAIT64  END CATCH65  ende:66  RETURN67END
Open raw exported source
SQL ยท Raw11 lines
1    create   trigger ATT_TUPWODecisionMethod on PWODecisionMethod for Update not for Replication as begin  declare @QER_Attestation_OnWorkflowAssign2 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(UID_SubMethodOrderProduct) begin select @QER_Attestation_OnWorkflowAssign = dbo.QBM_FGIConfigparmValue4('QER\Attestation\OnWorkflowAssign') if @QER_Attestation_OnWorkflowAssign 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 PWODecisionMethod6 m join deleted d on m.UID_PWODecisionMethod = d.UID_PWODecisionMethod and isnull(m.UID_SubMethodOrderProduct, '') <> isnull(d.UID_SubMethodOrderProduct7, '') join QERWorkingMethod wm on wm.UID_PWODecisionSubMethod = d.UID_SubMethodOrderProduct  join AttestationCase ac on ac.UID_QERWorkingMethod = wm.UID_QERWorkingMethod8 and ac.IsClosed = 0 ) as x if @QER_Attestation_OnWorkflowAssign = 'RESET' begin exec QBM_PDBQueueInsert_Bulk 'ATT-K-Attestation-RESET', @DBQueueElements_019 end if @QER_Attestation_OnWorkflowAssign = 'ABORT' begin exec QBM_PDBQueueInsert_Bulk'ATT-K-Attestation-ABORT', @DBQueueElements_01 end end  end  END 10TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end 11