Back to OIM Explorer

dbo.QER_POrderUnreachableClose

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 2; References QBM_PDBQueueInsert_Single

Source: sandbox-db sys.sql_modules

Source size: 456 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • 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 2
  • References QBM_PDBQueueInsert_Single

Typed Edges

  • queues DBQueue task QBM_ZRecalculate at line 2 Single DBQueue insert -> QBM-K-CommonReCalculate / QBM_ZRecalculate at line 2
  • references source dbo.QBM_FGISessionContext source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task QBM-K-CommonReCalculate -> QBM_ZRecalculate QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QER-K-ShoppingRackCheckDecision', '', @GenProcID END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Reth…

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL21 lines
1CREATE PROCEDURE QER_POrderUnreachableClose2AS3BEGIN4  DECLARE @GenProcID varchar(38)5  SET XACT_ABORT OFF6  BEGIN TRY7    SELECT @GenProcID = dbo.QBM_FGISessionContext('')8    EXEC QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate',9    'QER-K-ShoppingRackCheckDecision',10    '',11      @GenProcID12  END TRY13  BEGIN CATCH14    EXEC QBM_PSessionErrorAdd DEFAULT15    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()16    RAISERROR(@Rethrow,17    18,18    1)19      WITH NOWAIT20  END CATCH21END
Open raw exported source
SQL · Raw4 lines
1   create   procedure QER_POrderUnreachableClose as begin declare @GenProcID varchar(38) SET XACT_ABORT OFF BEGIN TRY select @GenProcID = dbo.QBM_FGISessionContext2('') exec QBM_PDBQueueInsert_Single 'QBM-K-CommonReCalculate', 'QER-K-ShoppingRackCheckDecision', '', @GenProcID END TRY BEGIN CATCH exec QBM_PSessionErrorAdd3 default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH end 4