Back to OIM Explorer

dbo.CPL_PComplianceCheckMakeProc_D

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure.

Source: sandbox-db sys.sql_modules

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

References

Referenced By

Complete Source

SQL31 lines
1CREATE PROCEDURE CPL_PComplianceCheckMakeProc_D(2  @uid_ComplianceRule varchar(38)3)4AS5BEGIN6  DECLARE @SQLcmd nvarchar(max)7  DECLARE @Procname nvarchar(1000)8  SET XACT_ABORT OFF9  BEGIN TRY10    SELECT11      @procname = dbo.CPL_FCVRuleGuidToProcName(@uid_complianceRule,12      'Rule')13    EXEC QBM_PProcedureDrop @procname14    SELECT15      @procname = dbo.CPL_FCVRuleGuidToProcName(@uid_complianceRule,16      'Person')17    EXEC QBM_PProcedureDrop @procname18    SELECT19      @procname = dbo.CPL_FCVRuleGuidToProcName(@uid_complianceRule,20      'ITShopOrder')21    EXEC QBM_PProcedureDrop @procname22  END TRY23  BEGIN CATCH24    EXEC QBM_PSessionErrorAdd DEFAULT25    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()26    RAISERROR(@Rethrow,27    18,28    1)29      WITH NOWAIT30  END CATCH31END
Open raw exported source
SQL ยท Raw6 lines
1           create   procedure CPL_PComplianceCheckMakeProc_D  (@uid_ComplianceRule varchar(38)) as begin declare @SQLcmd nvarchar(max) declare @Procname2 nvarchar(1000) SET XACT_ABORT OFF BEGIN TRY select @procname = dbo.CPL_FCVRuleGuidToProcName(@uid_complianceRule, 'Rule') exec QBM_PProcedureDrop @procname3 select @procname = dbo.CPL_FCVRuleGuidToProcName(@uid_complianceRule, 'Person') exec QBM_PProcedureDrop @procname select @procname = dbo.CPL_FCVRuleGuidToProcName4(@uid_complianceRule, 'ITShopOrder') exec QBM_PProcedureDrop @procname END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(10005) = dbo.QBM_FGISessionErrorRethrow() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH end 6