Back to OIM Explorer

dbo.RMB_ZHelperWorkDeskOrg

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.763 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.QBM_PDBQueueCalculateDelta source text reference
  • references source dbo.QBM_PMNTableDelete source text reference
  • references source dbo.QBM_PMNTableInsert source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL94 lines
1CREATE PROCEDURE RMB_ZHelperWorkDeskOrg(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @Sourcedata QBM_YDataForDelta,7  @CountDeltaQantity int,8  @CountDeltaOrigin int9  DECLARE @DBQueueCurrent QBM_YDBQueueCurrent10  BEGIN TRY11    INSERT INTO @DBQueueCurrent(UID_DialogDBQueue,12    UID_Parameter,13    UID_SubParameter,14    GenProcID)15    SELECT16      UID_DialogDBQueue,17      UID_Parameter,18      UID_SubParameter,19      GenProcID20    FROM QBMDBQueueCurrent cu21      WITH(readpast)22    WHERE23      cu.SlotNumber = @SlotNumber24    IF @@rowcount = 025    BEGIN26      GOTO EndLabel27    END28    INSERT INTO @SourceData(IsUpcommingContent,29    XOriginAfter,30    Element,31    AssignedElement,32    XOriginBefore)33    SELECT34      0,35      0,36      hwo.uid_WorkDesk,37      hwo.uid_Org,38      139    FROM @DBQueueCurrent x40    JOIN HelperWorkDeskOrg hwo41      ON uid_WorkDesk = x.uid_parameter42    JOIN BaseTree b43      ON hwo.uid_org = b.uid_org44    WHERE45      b.uid_OrgRoot LIKE '____[^V]%'46    IF dbo.QBM_FGIConfigparmValue('QER\Structures\Inherite\WorkDesk\FromOrg') > ' '47    BEGIN48      INSERT INTO @SourceData(IsUpcommingContent,49      XOriginBefore,50      XOriginAfter,51      Element,52      AssignedElement)53      SELECT54        1,55        0,56        1,57        p.uid_WorkDesk,58        p.uid_org59      FROM WorkDesk p60      JOIN @DBQueueCurrent x61        ON uid_WorkDesk= x.uid_parameter62      WHERE63        p.uid_org > ' '64    END65    EXEC QBM_PDBQueueCalculateDelta @SourceData,66      @DeltaQuantity = 0,67      @DeltaDelete = 1,68      @DeltaInsert = 1,69      @DeltaOrigin = 0,70      @CountDeltaQantity = @CountDeltaQantity OUTPUT,71      @CountDeltaOrigin = @CountDeltaOrigin OUTPUT,72      @UseIsInEffect = 0,73      @SlotNumber = @SlotNumber,74      @DBQueueCurrentExtern = @DBQueueCurrent75    IF @CountDeltaQantity > 076    BEGIN77      EXEC QBM_PMNTableInsert 'HelperWorkDeskOrg',78      'UID_WorkDesk',79      'UID_Org'80      EXEC QBM_PMNTableDelete 'HelperWorkDeskOrg',81      'UID_WorkDesk',82      'UID_Org'83    END84  END TRY85  BEGIN CATCH86    EXEC QBM_PSessionErrorAdd DEFAULT87    RAISERROR('',88    18,89    1)90      WITH NOWAIT91  END CATCH92  endLabel:93  RETURN94END
Open raw exported source
SQL ยท Raw13 lines
1    create   procedure RMB_ZHelperWorkDeskOrg (@SlotNumber int) AS begin declare @Sourcedata QBM_YDataForDelta , @CountDeltaQantity int , @CountDeltaOrigin2 int declare @DBQueueCurrent QBM_YDBQueueCurrent BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select3 UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount4 = 0 begin goto EndLabel end  insert into @SourceData( IsUpcommingContent, XOriginAfter , Element, AssignedElement, XOriginBefore ) select 0, 0 , hwo.uid_WorkDesk5, hwo.uid_Org, 1 from @DBQueueCurrent x join HelperWorkDeskOrg hwo on uid_WorkDesk = x.uid_parameter  join BaseTree b on hwo.uid_org = b.uid_org where 6b.uid_OrgRoot like '____[^V]%' if dbo.QBM_FGIConfigparmValue('QER\Structures\Inherite\WorkDesk\FromOrg') > ' ' begin insert into @SourceData( IsUpcommingContent7, XOriginBefore, XOriginAfter , Element, AssignedElement ) select 1, 0, 1 , p.uid_WorkDesk, p.uid_org from WorkDesk p join @DBQueueCurrent x on uid_WorkDesk=8 x.uid_parameter where p.uid_org > ' ' end exec QBM_PDBQueueCalculateDelta @SourceData, @DeltaQuantity = 0, @DeltaDelete = 1, @DeltaInsert = 1, @DeltaOrigin9 = 0, @CountDeltaQantity = @CountDeltaQantity output , @CountDeltaOrigin = @CountDeltaOrigin output , @UseIsInEffect = 0 , @SlotNumber = @SlotNumber , 10@DBQueueCurrentExtern = @DBQueueCurrent if @CountDeltaQantity > 0 begin exec QBM_PMNTableInsert 'HelperWorkDeskOrg', 'UID_WorkDesk', 'UID_Org' exec QBM_PMNTableDelete11 'HelperWorkDeskOrg', 'UID_WorkDesk', 'UID_Org' end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH 12 endLabel: return end 13