Back to OIM Explorer

dbo.QER_POrgRootAssignFill

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.178 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_FCVElementToObjectKey2 source text reference
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

Complete Source

SQL59 lines
1CREATE PROCEDURE QER_POrgRootAssignFill(2  @AutoFill BIT = 03)4AS5BEGIN6  DECLARE @XUser nvarchar(64) = object_name(@@procid)7  DECLARE @XDate datetime = getutcdate()8  SET XACT_ABORT OFF9  BEGIN TRY10    IF @AutoFill = 111    BEGIN12      INSERT INTO OrgRootAssign(UID_OrgRoot,13      UID_BaseTreeAssign,14      IsAssignmentAllowed,15      IsDirectAssignmentAllowed,16      Xdateinserted,17      XDateupdated,18      XUserInserted,19      XUserUpdated,20      XObjectKey)21      SELECT22        r.UID_OrgRoot,23        ba.UID_BaseTreeAssign,24        0,25        0,26        @XDate,27        @XDate,28        @XUser,29        @XUser,30        dbo.QBM_FCVElementToObjectKey2('OrgRootAssign',31        'UID_OrgRoot',32        r.UID_OrgRoot,33        'UID_BaseTreeAssign',34        ba.UID_BaseTreeAssign)35      FROM OrgRoot r CROSS36      JOIN BaseTreeAssign ba37      WHERE38        NOT EXISTS(39      SELECT TOP 1 140      FROM OrgRootAssign a41      WHERE42        a.UID_BaseTreeAssign = ba.UID_BaseTreeAssign AND a.UID_OrgRoot = r.UID_OrgRoot) AND ba.UID_DialogTableElement > ' '43    END44    DELETE OrgRootAssign45    FROM OrgRootAssign oa46    JOIN BaseTreeAssign ba47      ON oa.UID_BaseTreeAssign = ba.UID_BaseTreeAssign48    WHERE49      ba.UID_DialogTableElement IS NULL50  END TRY51  BEGIN CATCH52    EXEC QBM_PSessionErrorAdd DEFAULT53    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()54    RAISERROR(@Rethrow,55    18,56    1)57      WITH NOWAIT58  END CATCH59END
Open raw exported source
SQL ยท Raw9 lines
1   create   procedure QER_POrgRootAssignFill (@AutoFill bit = 0 ) as begin declare @XUser nvarchar(64) = object_name(@@procid) declare @XDate datetime2 = getutcdate() SET XACT_ABORT OFF BEGIN TRY if @AutoFill = 1  begin insert into OrgRootAssign (UID_OrgRoot, UID_BaseTreeAssign, IsAssignmentAllowed, IsDirectAssignmentAllowed3 , Xdateinserted, XDateupdated, XUserInserted, XUserUpdated , XObjectKey) select r.UID_OrgRoot, ba.UID_BaseTreeAssign, 0, 0 , @XDate, @XDate, @XUser, @XUser4 , dbo.QBM_FCVElementToObjectKey2('OrgRootAssign', 'UID_OrgRoot', r.UID_OrgRoot, 'UID_BaseTreeAssign', ba.UID_BaseTreeAssign) from OrgRoot r cross join5 BaseTreeAssign ba where not exists (select top 1 1 from OrgRootAssign a where a.UID_BaseTreeAssign = ba.UID_BaseTreeAssign and a.UID_OrgRoot = r.UID_OrgRoot6 ) and ba.UID_DialogTableElement > ' ' end delete OrgRootAssign  from OrgRootAssign oa join BaseTreeAssign ba on oa.UID_BaseTreeAssign = ba.UID_BaseTreeAssign7 where ba.UID_DialogTableElement is null END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow8() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH end 9