Back to OIM Explorer

dbo.ATT_ZAttestationHelperFill_Cfg

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.420 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FGIConfigparmValue source text reference
  • references source dbo.ATT_PAttestationHelperFill source text reference
  • references source dbo.ATT_ZAttestationHelperFill source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL75 lines
1CREATE PROCEDURE ATT_ZAttestationHelperFill_Cfg(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @UID_AttestationCase varchar(38)7  DECLARE @GenProcID varchar(38)8  DECLARE @DebugLevel char(1) = 'W'9  DECLARE @reduce int = 010  DECLARE @ElementBuffer QBM_YCursorBuffer11  DECLARE @ElementCount int12  DECLARE @ElementIndex int13  DECLARE @DBQueueCurrent QBM_YDBQueueCurrent14  BEGIN TRY15    SELECT16      @reduce = CASE dbo.QBM_FGIConfigparmValue('QER\Attestation\ReducedApproverCalculation')17      WHEN 'NoRecalc' THEN18      219      WHEN 'CurrentLevel' THEN20      121    ELSE 022    END23    IF @reduce = 224    BEGIN25      GOTO endLabel26    END27    INSERT INTO @DBQueueCurrent(UID_DialogDBQueue,28    UID_Parameter,29    UID_SubParameter,30    GenProcID)31    SELECT32      UID_DialogDBQueue,33      UID_Parameter,34      UID_SubParameter,35      GenProcID36    FROM QBMDBQueueCurrent cu37      WITH(readpast)38    WHERE39      cu.SlotNumber = @SlotNumber40    IF @@rowcount = 041    BEGIN42      GOTO EndLabel43    END44    INSERT INTO @ElementBuffer(UID1,45    UID2)46    SELECT47      uid_parameter,48      GenprocID49    FROM @DBQueueCurrent p50    SELECT @ElementCount = @@ROWCOUNT51    SELECT @ElementIndex = 152    WHILE @ElementIndex <= @ElementCount53    BEGIN54      SELECT55        TOP 1 @UID_AttestationCase = bu.UID1,56        @GenProcID = bu.UID257      FROM @ElementBuffer bu58      WHERE59        bu.ElementIndex = @ElementIndex60      EXEC ATT_PAttestationHelperFill @UID_AttestationCase,61        @GenprocID,62        @CurrentLevelOnly = @reduce63      SELECT @ElementIndex += 164    END65  END TRY66  BEGIN CATCH67    EXEC QBM_PSessionErrorAdd DEFAULT68    RAISERROR('',69    18,70    1)71      WITH NOWAIT72  END CATCH73  endLabel:74  RETURN75END
Open raw exported source
SQL ยท Raw11 lines
1   create   procedure ATT_ZAttestationHelperFill_Cfg (@SlotNumber int) as begin  declare @UID_AttestationCase varchar(38) declare @GenProcID varchar2(38) declare @DebugLevel char(1) = 'W' declare @reduce int = 0 declare @ElementBuffer QBM_YCursorBuffer declare @ElementCount int declare @ElementIndex3 int declare @DBQueueCurrent QBM_YDBQueueCurrent BEGIN TRY select @reduce = case dbo.QBM_FGIConfigparmValue('QER\Attestation\ReducedApproverCalculation'4) when 'NoRecalc' then 2 when 'CurrentLevel' then 1 else 0 end if @reduce = 2 begin goto endLabel end insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter5, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber6 = @SlotNumber if @@rowcount = 0 begin goto EndLabel end insert into @ElementBuffer (UID1, UID2) select uid_parameter, GenprocID from @DBQueueCurrent p7 select @ElementCount = @@ROWCOUNT select @ElementIndex = 1 while @ElementIndex <= @ElementCount begin select top 1 @UID_AttestationCase = bu.UID1 , @GenProcID8 = bu.UID2 from @ElementBuffer bu where bu.ElementIndex = @ElementIndex exec ATT_PAttestationHelperFill @UID_AttestationCase, @GenprocID, @CurrentLevelOnly9 = @reduce select @ElementIndex += 1 end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return10 end 11