Back to OIM Explorer

dbo.ATT_ZAttestationAbort

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. HOCallMethod -> AttestationCase.Abort at line 3; References QBM_PJobCreate*; References QBM_PJobCreate_HOCallMethod*

Source: sandbox-db sys.sql_modules

Source size: 917 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • Object-layer bridge detected through QBM_PJobCreate helper usage.

Relations

  • HOCallMethod -> AttestationCase.Abort at line 3
  • References QBM_PJobCreate*
  • References QBM_PJobCreate_HOCallMethod*

Typed Edges

  • calls object method AttestationCase.Abort HOCallMethod -> AttestationCase.Abort at line 3
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HOCallMethod source text reference
  • references source dbo.QBM_PJobCreate_HOCallMethod_B source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL38 lines
1CREATE PROCEDURE ATT_ZAttestationAbort(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @GenProcID varchar(38)7  DECLARE @SQLCmd nvarchar(max)8  BEGIN TRY9    SELECT TOP 1 @GenProcID = cu.GenprocID10    FROM QBMDBQueueCurrent cu11      WITH(readpast)12    WHERE13      cu.SlotNumber = @Slotnumber14    SELECT15      @SQLcmd = N 'UID_AttestationCase in (select UID_Parameter from QBMDBQueueCurrent with (readpast) where slotnumber = ' + str(@SlotNumber16      ) + ' ) '17    EXEC QBM_PJobCreate_HOCallMethod_B @objecttype = 'AttestationCase',18      @whereclause = @SQLcmd,19      @save = 1,20      @MethodName = 'Abort',21      @GenProcID = @GenprocID,22      @AdditionalObjectKeysAffected = DEFAULT,23      @param1 = '#LDS#Automatic system approval: workflow has changed.|',24      @Retries = 3,25      @isToFreezeOnError = 1,26      @checkForExisting = 1,27      @WhereClauseAdditional = ' IsClosed = 0 '28  END TRY29  BEGIN CATCH30    EXEC QBM_PSessionErrorAdd DEFAULT31    RAISERROR('',32    18,33    1)34      WITH NOWAIT35  END CATCH36  endLabel:37  RETURN38END
Open raw exported source
SQL ยท Raw7 lines
1   create   procedure ATT_ZAttestationAbort (@SlotNumber int)  as begin  declare @GenProcID varchar(38) declare @SQLCmd nvarchar(max) BEGIN TRY 2select top 1 @GenProcID = cu.GenprocID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @Slotnumber select @SQLcmd = N'UID_AttestationCase in (select UID_Parameter from QBMDBQueueCurrent with (readpast) where slotnumber = '3 + str(@SlotNumber) + ' ) ' exec QBM_PJobCreate_HOCallMethod_B @objecttype = 'AttestationCase' , @whereclause = @SQLcmd , @save = 1 , @MethodName = 'Abort'4 , @GenProcID = @GenprocID , @AdditionalObjectKeysAffected = DEFAULT , @param1 = '#LDS#Automatic system approval: workflow has changed.|' , @Retries = 53 , @isToFreezeOnError = 1  , @checkForExisting = 1 , @WhereClauseAdditional = ' IsClosed = 0 '  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default 6RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  endLabel: return end 7