Back to OIM Explorer

dbo.CPL_ZScheduleStartCheckRule

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Bulk DBQueue insert -> CPL-K-ComplianceCheckForRule / CPL_ZComplianceCheckForRule at line 4; References QBM_PDBQueueInsert_Bulk

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.
  • DBQueue relation detected. Follow the task procedure and referenced-by list for async processing.

Relations

  • Bulk DBQueue insert -> CPL-K-ComplianceCheckForRule / CPL_ZComplianceCheckForRule at line 4
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task CPL_ZComplianceCheckForRule at line 4 Bulk DBQueue insert -> CPL-K-ComplianceCheckForRule / CPL_ZComplianceCheckForRule at line 4
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task CPL-K-ComplianceCheckForRule -> CPL_ZComplianceCheckForRule QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceCheckForRule', @DBQueueElements_01 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH ende: return end

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL38 lines
1CREATE PROCEDURE CPL_ZScheduleStartCheckRule(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @MyName nvarchar(64) = object_name(@@procid)7  BEGIN TRY8    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw9    INSERT INTO @DBQueueElements_01(object,10    subobject,11    genprocid)12    SELECT13      x.uid,14      NULL,15      x.GenProcID16    FROM(17    SELECT18      r.uid_complianceRule AS uid,19      cu.GenProcID20    FROM complianceRule r21    JOIN QBMDBQueueCurrent cu22      WITH(readpast)23      ON cu.UID_Parameter = r.UID_DialogScheduleCheck24    WHERE25      r.IsWorkingCopy = 0 AND r.IsInActive = 0 AND cu.SlotNumber = @SlotNumber) AS x26    EXEC QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceCheckForRule',27      @DBQueueElements_0128  END TRY29  BEGIN CATCH30    EXEC QBM_PSessionErrorAdd DEFAULT31    RAISERROR('',32    18,33    1)34      WITH NOWAIT35  END CATCH36  ende:37  RETURN38END
Open raw exported source
SQL ยท Raw6 lines
1  create   procedure CPL_ZScheduleStartCheckRule ( @SlotNumber int ) AS begin declare @MyName nvarchar(64) = object_name(@@procid) BEGIN TRY   declare2 @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select r.uid_complianceRule3 as uid, cu.GenProcID from complianceRule r join QBMDBQueueCurrent cu with (readpast) on cu.UID_Parameter = r.UID_DialogScheduleCheck where r.IsWorkingCopy4 = 0  and r.IsInActive = 0 and cu.SlotNumber = @SlotNumber ) as x exec QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceCheckForRule', @DBQueueElements_01 END 5TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  ende: return end 6