Back to OIM Explorer

dbo.ATT_ZHelperAttestationPolicy

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

Source size: 744 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.ATT_P600B8EB3A312074D1A10A4A_ source text reference
  • references source dbo.ATT_PAttestationCaseDeleteOld source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL37 lines
1CREATE PROCEDURE ATT_ZHelperAttestationPolicy(2  @SlotNumber int,3  @uid_AttestationPolicy varchar(38),4  @dummy1 varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  DECLARE @lauf int10  SET XACT_ABORT OFF11  BEGIN TRY12    IF NOT EXISTS(13      SELECT TOP 1 114      FROM AttestationPolicy p15      WHERE16        p.UID_AttestationPolicy = @uid_AttestationPolicy AND p.IsInActive = 1)17    BEGIN18      GOTO ende19    END20    SELECT @lauf = 121    WHILE @lauf > 022    BEGIN23      EXEC @lauf = ATT_P600B8EB3A312074D1A10A4A_ @uid_AttestationPolicy24    END25    EXEC ATT_PAttestationCaseDeleteOld @uid_AttestationPolicy26  END TRY27  BEGIN CATCH28    EXEC QBM_PSessionErrorAdd DEFAULT29    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()30    RAISERROR(@Rethrow,31    18,32    1)33      WITH NOWAIT34  END CATCH35  ende:36  RETURN37END
Open raw exported source
SQL ยท Raw6 lines
1create   procedure ATT_ZHelperAttestationPolicy ( @SlotNumber int , @uid_AttestationPolicy varchar(38) , @dummy1 varchar(38) , @GenProcID varchar2(38) ) AS begin declare @lauf int SET XACT_ABORT OFF BEGIN TRY if not exists (select top 1 1 from AttestationPolicy p where p.UID_AttestationPolicy = @uid_AttestationPolicy3 and p.IsInActive = 1 ) begin goto ende end  select @lauf = 1 while @lauf > 0 begin exec @lauf = ATT_P600B8EB3A312074D1A10A4A_ @uid_AttestationPolicy  4            end   exec ATT_PAttestationCaseDeleteOld @uid_AttestationPolicy  END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar5(1000) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH  ende:  return end 6