Back to OIM Explorer

dbo.QER_ZITShopHelperFill_Cfg

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 913 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_FCVIntToString source text reference
  • references source dbo.QBM_FGIConfigparmValue source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QER_PITShopHelperFill source text reference
  • references source dbo.QER_PITShopHelperFill_bulk source text reference
  • references source dbo.QER_ZITShopHelperFill source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL52 lines
1CREATE PROCEDURE QER_ZITShopHelperFill_Cfg(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @uid_personwantsorg varchar(38)7  DECLARE @GenProcID varchar(38)8  DECLARE @MyName nvarchar(64) = object_name(@@procid)9  DECLARE @reduce int = 010  DECLARE @PWOsToFill QBM_YParameterlist11  BEGIN TRY12    SELECT13      @reduce = CASE dbo.QBM_FGIConfigparmValue('QER\ITShop\ReducedApproverCalculation')14      WHEN 'NoRecalc' THEN15      216      WHEN 'CurrentLevel' THEN17      118    ELSE 019    END20    IF @reduce = 221    BEGIN22      GOTO endLabel23    END24    INSERT INTO @PWOsToFill(Parameter1,25    Parameter2,26    Parameter3,27    HasContentFull)28    SELECT29      cu.UID_Parameter,30      cu.GenProcID,31      dbo.QBM_FCVIntToString(@reduce),32      033    FROM QBMDBQueueCurrent cu34      WITH(readpast)35    WHERE36      cu.SlotNumber = @SlotNumber37    IF @@rowcount = 038    BEGIN39      GOTO EndLabel40    END41    EXEC QER_PITShopHelperFill_bulk @PWOsToFill42  END TRY43  BEGIN CATCH44    EXEC QBM_PSessionErrorAdd DEFAULT45    RAISERROR('',46    18,47    1)48      WITH NOWAIT49  END CATCH50  endLabel:51  RETURN52END
Open raw exported source
SQL ยท Raw7 lines
1   create   procedure QER_ZITShopHelperFill_Cfg (@SlotNumber int) as begin  declare @uid_personwantsorg varchar(38) declare @GenProcID varchar(382) declare @MyName nvarchar(64) = object_name(@@procid) declare @reduce int = 0 declare @PWOsToFill QBM_YParameterlist      BEGIN TRY select @reduce = case3 dbo.QBM_FGIConfigparmValue('QER\ITShop\ReducedApproverCalculation') when 'NoRecalc' then 2 when 'CurrentLevel' then 1 else 0 end if @reduce = 2 begin 4goto endLabel end  insert into @PWOsToFill(Parameter1, Parameter2, Parameter3, HasContentFull) select cu.UID_Parameter, cu.GenProcID, dbo.QBM_FCVIntToString5(@reduce), 0 from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end exec QER_PITShopHelperFill_bulk6 @PWOsToFill  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end 7