Back to OIM Explorer

dbo.QER_RITShopMakeDecisionCD

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.839 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_PDBQCS_CurrentMoveSlot source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • references source dbo.QBM_PSlotResetWhileJobRun_L source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL79 lines
1CREATE PROCEDURE QER_RITShopMakeDecisionCD(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @ObjectKeysToCheck_Projection QBM_YParameterList7  DECLARE @ObjectKeysToCheck_Jobrunning QBM_YParameterList8  DECLARE @MyName nvarchar(64) = object_name(@@procid)9  DECLARE @DBQueueCurrent QBM_YDBQueueCurrent10  DECLARE @resetted int11  DECLARE @SlotNumberSource int12  DECLARE @SlotNumberTarget int13  DECLARE @DBQueueToMove QBM_YDBQCSCurrentToMove14  DECLARE @RowsMoved int15  BEGIN TRY16    INSERT INTO @DBQueueCurrent(UID_DialogDBQueue,17    UID_Parameter,18    UID_SubParameter,19    GenProcID)20    SELECT21      UID_DialogDBQueue,22      UID_Parameter,23      UID_SubParameter,24      GenProcID25    FROM QBMDBQueueCurrent cu26      WITH(readpast)27    WHERE28      cu.SlotNumber = @SlotNumber29    IF @@rowcount = 030    BEGIN31      GOTO EndLabel32    END33    DELETE @DBQueueToMove34    INSERT INTO @DBQueueToMove(UID_DialogDBQueue)35    SELECT cul.UID_DialogDBQueue36    FROM @DBQueueCurrent cul37    LEFT38    OUTER39    JOIN PersonWantsOrg pwo40      WITH(readpast)41      ON cul.UID_Parameter = pwo.UID_PersonWantsOrg AND pwo.OrderState IN('OrderProduct',42    'OrderProlongate',43    'OrderUnsubscribe')44    WHERE45      pwo.UID_PersonWantsOrg IS NULL46    IF @@ROWCOUNT > 047    BEGIN48      SELECT @SlotNumberSource = @SlotNumber49      SELECT @SlotnumberTarget = 050      EXEC @RowsMoved = QBM_PDBQCS_CurrentMoveSlot @DBQueueToMove,51        @SlotNumberSource,52        @SlotnumberTarget53      DELETE @DBQueueCurrent54      FROM @DBQueueCurrent cu55      JOIN @DBQueueToMove mo56        ON cu.UID_DialogDBQueue = mo.UID_DialogDBQueue57    END58    INSERT INTO @ObjectKeysToCheck_Jobrunning(Parameter1,59    Parameter2)60    SELECT61      x.UID_PersonWantsOrg,62      x.XObjectKey63    FROM @DBQueueCurrent cu64    JOIN PersonwantsOrg x65      ON cu.UID_Parameter = x.UID_PersonWantsOrg66    EXEC @resetted = QBM_PSlotResetWhileJobRun_L @DBQueueCurrent,67      @@PROCID,68      @ObjectKeysToCheck_Jobrunning,69      @SlotNumber = @SlotNumber70  END TRY71  BEGIN CATCH72    EXEC QBM_PSessionErrorAdd DEFAULT73    RAISERROR('',74    18,75    1)76      WITH NOWAIT77  END CATCH78  endLabel:79END
Open raw exported source
SQL ยท Raw13 lines
1create   procedure QER_RITShopMakeDecisionCD (@SlotNumber int) AS begin declare @ObjectKeysToCheck_Projection QBM_YParameterList declare @ObjectKeysToCheck_Jobrunning2 QBM_YParameterList declare @MyName nvarchar(64) = object_name(@@procid) declare @DBQueueCurrent QBM_YDBQueueCurrent declare @resetted int declare @SlotNumberSource3 int declare @SlotNumberTarget int declare @DBQueueToMove QBM_YDBQCSCurrentToMove declare @RowsMoved int BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue4, UID_Parameter, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast5) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end  delete @DBQueueToMove  insert into @DBQueueToMove(UID_DialogDBQueue) select6 cul.UID_DialogDBQueue from @DBQueueCurrent cul  left outer join PersonWantsOrg pwo with (readpast) on cul.UID_Parameter = pwo.UID_PersonWantsOrg   and7 pwo.OrderState in ('OrderProduct', 'OrderProlongate', 'OrderUnsubscribe') where pwo.UID_PersonWantsOrg is null if @@ROWCOUNT > 0 begin select @SlotNumberSource8 = @SlotNumber  select @SlotnumberTarget = 0 exec @RowsMoved = QBM_PDBQCS_CurrentMoveSlot @DBQueueToMove, @SlotNumberSource, @SlotnumberTarget  delete 9@DBQueueCurrent from @DBQueueCurrent cu join @DBQueueToMove mo on cu.UID_DialogDBQueue = mo.UID_DialogDBQueue end  insert into @ObjectKeysToCheck_Jobrunning10(Parameter1, Parameter2) select x.UID_PersonWantsOrg, x.XObjectKey from @DBQueueCurrent cu join PersonwantsOrg x on cu.UID_Parameter = x.UID_PersonWantsOrg11 exec @resetted = QBM_PSlotResetWhileJobRun_L @DBQueueCurrent, @@PROCID, @ObjectKeysToCheck_Jobrunning, @SlotNumber = @SlotNumber  END TRY BEGIN CATCH 12exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: end 13