Back to OIM Explorer

dbo.QBM_PProcessGroupDelete

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 3.101 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_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL125 lines
1CREATE PROCEDURE QBM_PProcessGroupDelete(2  @GenProcIDGroup varchar(38) = ''3)4AS5BEGIN6  DECLARE @WhereClauseDelete nvarchar(2000)7  DECLARE @Processes QBM_YSingleGUID8  DECLARE @XUser nvarchar(64) = object_name(@@procid)9  DECLARE @Xdate datetime = getutcdate()10  SET XACT_ABORT OFF11  BEGIN TRY12    IF @GenProcIDGroup > ' '13    BEGIN14      INSERT INTO @Processes(UID_SingleGuid)15      SELECT p.GenProcID16      FROM Dialogprocess p17        WITH(readpast)18      WHERE19        p.GenProcIDGroup = @GenProcIDGroup20      UPDATE DialogWatchOperation21      SET ReadyForDeleteOrExport = 122      FROM DialogWatchOperation x23      JOIN @Processes p24        ON x.GenProcID = p.UID_SingleGuid option(maxdop 1)25      UPDATE DialogProcessChain26      SET ReadyForDeleteOrExport = 127      FROM DialogProcessChain x28      JOIN @Processes p29        ON x.GenProcID = p.UID_SingleGuid option(maxdop 1)30      UPDATE JobHistory31      SET ReadyForDeleteOrExport = 132      FROM JobHistory x33      JOIN @Processes p34        ON x.GenProcID = p.UID_SingleGuid option(maxdop 1)35      UPDATE DialogProcessSubstitute36      SET ReadyForDeleteOrExport = 137      FROM DialogProcessSubstitute s38      WHERE39        s.GenProcIDOrigin IN(40      SELECT p.GenProcID41      FROM Dialogprocess p42        WITH(readpast)43      WHERE44        p.GenProcIDGroup = @GenProcIDGroup) AND s.ReadyForDeleteOrExport <> 145      UPDATE DialogProcessSubstitute46      SET ReadyForDeleteOrExport = 147      FROM DialogProcessSubstitute s48      WHERE49        s.GenProcIDnew IN(50      SELECT p.GenProcID51      FROM Dialogprocess p52        WITH(readpast)53      WHERE54        p.GenProcIDGroup = @GenProcIDGroup) AND s.ReadyForDeleteOrExport <> 155      UPDATE DialogProcess56      SET ReadyForDeleteOrExport = 157      FROM DialogProcess x58      JOIN @Processes p59        ON x.GenProcID = p.UID_SingleGuid option(maxdop 1)60      GOTO ende61    END62    UPDATE DialogWatchOperation63    SET ReadyForDeleteOrExport = 164    WHERE65      ReadyForDeleteOrExport = 2 AND GenProcID IN(66    SELECT p.GenProcID67    FROM Dialogprocess p68    WHERE69      p.GenProcIDGroup > ' ')70    UPDATE DialogProcessChain71    SET ReadyForDeleteOrExport = 1,72    XDateUpdated = @Xdate,73    XUserUpdated = @XUser74    WHERE75      ReadyForDeleteOrExport = 2 AND GenProcID IN(76    SELECT p.GenProcID77    FROM Dialogprocess p78    WHERE79      p.GenProcIDGroup > ' ')80    UPDATE JobHistory81    SET ReadyForDeleteOrExport = 1,82    XDateUpdated = @Xdate,83    XUserUpdated = @XUser84    WHERE85      ReadyForDeleteOrExport = 2 AND GenProcID IN(86    SELECT p.GenProcID87    FROM Dialogprocess p88    WHERE89      p.GenProcIDGroup > ' ')90    UPDATE DialogProcessSubstitute91    SET ReadyForDeleteOrExport = 192    FROM DialogProcessSubstitute s93    WHERE94      s.GenProcIDOrigin IN(95    SELECT p.GenProcID96    FROM Dialogprocess p97    WHERE98      p.GenProcIDGroup > ' ') AND s.ReadyForDeleteOrExport <> 199    UPDATE DialogProcessSubstitute100    SET ReadyForDeleteOrExport = 1101    FROM DialogProcessSubstitute s102    WHERE103      GenProcIDnew IN(104    SELECT p.GenProcID105    FROM Dialogprocess p106    WHERE107      p.GenProcIDGroup > ' ') AND s.ReadyForDeleteOrExport <> 1108    UPDATE DialogProcess109    SET ReadyForDeleteOrExport = 1,110    XDateUpdated = @Xdate,111    XUserUpdated = @XUser112    WHERE113      ReadyForDeleteOrExport = 2 AND GenProcIDGroup > ' '114  END TRY115  BEGIN CATCH116    EXEC QBM_PSessionErrorAdd DEFAULT117    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()118    RAISERROR(@Rethrow,119    18,120    1)121      WITH NOWAIT122  END CATCH123  ende:124  RETURN125END
Open raw exported source
SQL ยท Raw21 lines
1  create   procedure QBM_PProcessGroupDelete (@GenProcIDGroup varchar(38) = ''  ) as begin declare @WhereClauseDelete nvarchar(2000) declare @Processes2 QBM_YSingleGUID declare @XUser nvarchar(64) = object_name(@@procid) declare @Xdate datetime = getutcdate() SET XACT_ABORT OFF BEGIN TRY if @GenProcIDGroup3 > ' ' begin   insert into @Processes(UID_SingleGuid ) select p.GenProcID from Dialogprocess p with (readpast) where p.GenProcIDGroup = @GenProcIDGroup4                     update DialogWatchOperation set ReadyForDeleteOrExport = 1 from DialogWatchOperation x join @Processes p on x.GenProcID = p.UID_SingleGuid5  option (maxdop 1)                   update DialogProcessChain set ReadyForDeleteOrExport = 1 from DialogProcessChain x join @Processes p on x.GenProcID6 = p.UID_SingleGuid  option (maxdop 1)       update JobHistory set ReadyForDeleteOrExport = 1 from JobHistory x join @Processes p on x.GenProcID = p.UID_SingleGuid7  option (maxdop 1)                  update DialogProcessSubstitute set ReadyForDeleteOrExport = 1 from DialogProcessSubstitute s where s.GenProcIDOrigin8 in (select p.GenProcID from Dialogprocess p with (readpast) where p.GenProcIDGroup = @GenProcIDGroup ) and s.ReadyForDeleteOrExport <> 1 update DialogProcessSubstitute9 set ReadyForDeleteOrExport = 1 from DialogProcessSubstitute s where s.GenProcIDnew in (select p.GenProcID from Dialogprocess p with (readpast) where p.GenProcIDGroup10 = @GenProcIDGroup ) and s.ReadyForDeleteOrExport <> 1  update DialogProcess set ReadyForDeleteOrExport = 1 from DialogProcess x join @Processes p on x.GenProcID11 = p.UID_SingleGuid  option (maxdop 1) goto ende end   update DialogWatchOperation set ReadyForDeleteOrExport = 1 where ReadyForDeleteOrExport = 2 and 12GenProcID in (select p.GenProcID from Dialogprocess p where p.GenProcIDGroup > ' ' )  update DialogProcessChain set ReadyForDeleteOrExport = 1  , XDateUpdated13 = @Xdate , XUserUpdated = @XUser where ReadyForDeleteOrExport = 2 and GenProcID in (select p.GenProcID from Dialogprocess p where p.GenProcIDGroup > ' '14 )  update JobHistory set ReadyForDeleteOrExport = 1  , XDateUpdated = @Xdate , XUserUpdated = @XUser where ReadyForDeleteOrExport = 2 and GenProcID in15 (select p.GenProcID from Dialogprocess p where p.GenProcIDGroup > ' ' )  update DialogProcessSubstitute set ReadyForDeleteOrExport = 1 from DialogProcessSubstitute16 s where s.GenProcIDOrigin in (select p.GenProcID from Dialogprocess p where p.GenProcIDGroup > ' ' ) and s.ReadyForDeleteOrExport <> 1 update DialogProcessSubstitute17 set ReadyForDeleteOrExport = 1 from DialogProcessSubstitute s where GenProcIDnew in (select p.GenProcID from Dialogprocess p where p.GenProcIDGroup > 18' ' ) and s.ReadyForDeleteOrExport <> 1  update DialogProcess set ReadyForDeleteOrExport = 1  , XDateUpdated = @Xdate , XUserUpdated = @XUser where ReadyForDeleteOrExport19 = 2 and GenProcIDGroup > ' ' END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR20 (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 21