Back to OIM Explorer

dbo.RMB_ZHelperPersonOrg

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.743 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_ZHelperPersonOrg(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      hpo.uid_person,37      hpo.uid_Org,38      139    FROM @DBQueueCurrent x40    JOIN HelperPersonOrg hpo41      ON hpo.UID_Person = x.uid_parameter42    JOIN BaseTree b43      ON hpo.uid_org = b.uid_org44    WHERE45      b.uid_OrgRoot LIKE '____[^V]%'46    IF dbo.QBM_FGIConfigparmValue('QER\Structures\Inherite\Person\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_person,58        p.uid_org59      FROM person p60      JOIN @DBQueueCurrent x61        ON uid_person= 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_PMNTableDelete 'HelperPersonOrg',78      'UID_Person',79      'UID_Org'80      EXEC QBM_PMNTableInsert 'HelperPersonOrg',81      'UID_Person',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_ZHelperPersonOrg (@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 , hpo.uid_person5, hpo.uid_Org, 1 from @DBQueueCurrent x join HelperPersonOrg hpo on hpo.UID_Person = x.uid_parameter  join BaseTree b on hpo.uid_org = b.uid_org where 6b.uid_OrgRoot like '____[^V]%' if dbo.QBM_FGIConfigparmValue('QER\Structures\Inherite\Person\FromOrg') > ' ' begin insert into @SourceData( IsUpcommingContent7, XOriginBefore, XOriginAfter , Element, AssignedElement ) select 1, 0, 1 , p.uid_person, p.uid_org from person p join @DBQueueCurrent x on uid_person=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_PMNTableDelete 'HelperPersonOrg', 'UID_Person', 'UID_Org' exec QBM_PMNTableInsert11 'HelperPersonOrg', 'UID_Person', 'UID_Org' end  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  endLabel:12 return end 13