Back to OIM Explorer

dbo.QER_PRulerDetect_PX

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 1.176 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_FCVStringToList source text reference
  • references source dbo.QBM_FCVStringToListSplitted source text reference
  • references source dbo.QBM_FCVElementToObjectKey1 source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL50 lines
1CREATE PROCEDURE QER_PRulerDetect_PX(2  @uid_PersonWantsOrg varchar(38),3  @UID_QERWorkingStep varchar(38)4)5AS6BEGIN7  DECLARE @WhereClauseMissnutzt nvarchar(max)8  DECLARE @ParameterName nvarchar(256)9  DECLARE @XObjectKeyPWO varchar(138) = dbo.QBM_FCVElementToObjectKey1('PersonWantsOrg',10  '',11  @UID_PersonWantsOrg)12  DECLARE @cmd nvarchar(max)13  SET XACT_ABORT OFF14  BEGIN TRY15    SELECT TOP 1 @WhereClauseMissnutzt = s.WhereClause16    FROM QERWorkingStep s17    WHERE18      s.UID_QERWorkingStep = @UID_QERWorkingStep19    SELECT TOP 1 @ParameterName = s.ParameterName20    FROM dbo.QBM_FCVStringToListSplitted(@WhereClauseMissnutzt,21    char(7),22    1,23    0,24    '') s25    WHERE26      s.OrderNumber = 127    SELECT28      TOP 1 @cmd = CONCAT('select ''',29      ParameterValue,30      ''' as UID_Person     -- der Entscheider31							, null as UID_PWORulerOrigin')32    FROM DialogParameterSet s33    JOIN DialogParameter pa34      ON s.UID_DialogParameterSet = pa.UID_DialogParameterSet35    WHERE36      s.ObjectKeyUsedBy = @XObjectKeyPWO AND pa.ParameterName = @ParameterName37    INSERT INTO #Ruler(UID_Person,38    UID_PWORulerOrigin)39    EXEC sp_executesql @cmd40  END TRY41  BEGIN CATCH42    EXEC QBM_PSessionErrorAdd DEFAULT,43      @cmd44    RAISERROR('',45    18,46    1)47      WITH NOWAIT48  END CATCH49  endLabel:50END
Open raw exported source
SQL ยท Raw10 lines
1   create   procedure QER_PRulerDetect_PX ( @uid_PersonWantsOrg varchar(38) , @UID_QERWorkingStep varchar(38) ) as begin declare @WhereClauseMissnutzt2 nvarchar(max) declare @ParameterName nvarchar(256) declare @XObjectKeyPWO varchar(138) = dbo.QBM_FCVElementToObjectKey1('PersonWantsOrg', '', @UID_PersonWantsOrg3) declare @cmd nvarchar(max) SET XACT_ABORT OFF BEGIN TRY select top 1 @WhereClauseMissnutzt = s.WhereClause from QERWorkingStep s where s.UID_QERWorkingStep4 = @UID_QERWorkingStep select top 1 @ParameterName = s.ParameterName from dbo.QBM_FCVStringToListSplitted(@WhereClauseMissnutzt, char(7), 1, 0, '') s where5 s.OrderNumber = 1  select top 1 @cmd = concat('select ''', ParameterValue, ''' as UID_Person     -- der Entscheider6							, null as UID_PWORulerOrigin'7 ) from DialogParameterSet s join DialogParameter pa on s.UID_DialogParameterSet = pa.UID_DialogParameterSet where s.ObjectKeyUsedBy = @XObjectKeyPWO and8 pa.ParameterName = @ParameterName  insert into #Ruler(UID_Person, UID_PWORulerOrigin) exec sp_executesql @cmd END TRY BEGIN CATCH exec QBM_PSessionErrorAdd9 default ,@cmd RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: end 10