Back to OIM Explorer

dbo.CPL_ZComplianceCheckMakeProc

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Single DBQueue insert -> CPL-K-ComplianceCheckForRule / CPL_ZComplianceCheckForRule at line 3; References QBM_PDBQueueInsert_Single

Source: sandbox-db sys.sql_modules

Source size: 701 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Single DBQueue insert -> CPL-K-ComplianceCheckForRule / CPL_ZComplianceCheckForRule at line 3
  • References QBM_PDBQueueInsert_Single

Typed Edges

  • queues DBQueue task CPL_ZComplianceCheckForRule at line 3 Single DBQueue insert -> CPL-K-ComplianceCheckForRule / CPL_ZComplianceCheckForRule at line 3
  • references source dbo.CPL_PComplianceCheckMakeProc_D source text reference
  • references source dbo.CPL_PComplianceCheckMakeProc_h source text reference
  • references source dbo.QBM_PDBQueueInsert_Single source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task CPL-K-ComplianceCheckForRule -> CPL_ZComplianceCheckForRule QBM_PDBQueueInsert_Single 'CPL-K-ComplianceCheckForRule' , @uid_ComplianceRule, '', @GenProcID end else begin exec CPL_PComplianceCheckMakeProc_D @uid_ComplianceRule end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', …

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL36 lines
1CREATE PROCEDURE CPL_ZComplianceCheckMakeProc(2  @SlotNumber int,3  @UID_ComplianceRule varchar(38),4  @Dummy varchar(38),5  @GenProcID varchar(38)6)7AS8BEGIN9  SET XACT_ABORT OFF10  BEGIN TRY11    IF EXISTS(12      SELECT TOP 1 113      FROM ComplianceRule14      WHERE15        uid_complianceRule = @uid_ComplianceRule AND isnull(isInactive, 0) = 0 AND isnull(isWorkingCopy,16    0) = 0)17    BEGIN18      EXEC CPL_PComplianceCheckMakeProc_h @uid_ComplianceRule19      EXEC QBM_PDBQueueInsert_Single 'CPL-K-ComplianceCheckForRule',20        @uid_ComplianceRule,21      '',22        @GenProcID23    END24    ELSE25    BEGIN26      EXEC CPL_PComplianceCheckMakeProc_D @uid_ComplianceRule27    END28  END TRY29  BEGIN CATCH30    EXEC QBM_PSessionErrorAdd DEFAULT31    RAISERROR('',32    18,33    1)34      WITH NOWAIT35  END CATCH36END
Open raw exported source
SQL · Raw6 lines
1    create   procedure CPL_ZComplianceCheckMakeProc (@SlotNumber int , @UID_ComplianceRule varchar(38) , @Dummy varchar(38) , @GenProcID varchar2(38) ) as begin    SET XACT_ABORT OFF BEGIN TRY  if exists (select top 1 1 from ComplianceRule where uid_complianceRule = @uid_ComplianceRule  and isnull3(isInactive,0) = 0 and isnull(isWorkingCopy, 0) = 0 ) begin exec CPL_PComplianceCheckMakeProc_h  @uid_ComplianceRule exec QBM_PDBQueueInsert_Single 'CPL-K-ComplianceCheckForRule'4, @uid_ComplianceRule, '', @GenProcID end else begin exec CPL_PComplianceCheckMakeProc_D  @uid_ComplianceRule end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd5 default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH end 6