Back to OIM Explorer

dbo.CPL_ZScheduleStartFill

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. Bulk DBQueue insert -> CPL-K-ComplianceSubRuleFillObject / CPL_ZSubRuleFillObject at line 6; Bulk DBQueue insert -> CPL-K-ComplianceSubRuleFillPerson / CPL_ZSubRuleFillPerson at line 6; Bulk DBQueue insert -> CPL-K-ComplianceSubRuleFillPerson / CPL_ZSubRuleFillPerson at line 9; References QBM_PDBQueueInsert_Bulk

Source: sandbox-db sys.sql_modules

Source size: 1.559 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-ComplianceSubRuleFillObject / CPL_ZSubRuleFillObject at line 6
  • Bulk DBQueue insert -> CPL-K-ComplianceSubRuleFillPerson / CPL_ZSubRuleFillPerson at line 6
  • Bulk DBQueue insert -> CPL-K-ComplianceSubRuleFillPerson / CPL_ZSubRuleFillPerson at line 9
  • References QBM_PDBQueueInsert_Bulk

Typed Edges

  • queues DBQueue task CPL_ZSubRuleFillObject at line 6 Bulk DBQueue insert -> CPL-K-ComplianceSubRuleFillObject / CPL_ZSubRuleFillObject at line 6
  • queues DBQueue task CPL_ZSubRuleFillPerson at line 6 Bulk DBQueue insert -> CPL-K-ComplianceSubRuleFillPerson / CPL_ZSubRuleFillPerson at line 6
  • queues DBQueue task CPL_ZSubRuleFillPerson at line 9 Bulk DBQueue insert -> CPL-K-ComplianceSubRuleFillPerson / CPL_ZSubRuleFillPerson at line 9
  • references source dbo.QBM_PDBQueueInsert_Bulk source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference
  • queues DBQueue task CPL-K-ComplianceSubRuleFillObject -> CPL_ZSubRuleFillObject QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceSubRuleFillObject' , @DBQueueElements_01 declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select r.ui…
  • queues DBQueue task CPL-K-ComplianceSubRuleFillPerson -> CPL_ZSubRuleFillPerson QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceSubRuleFillPerson', @DBQueueElements_02 END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH endLabel: return end

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL76 lines
1CREATE PROCEDURE CPL_ZScheduleStartFill(2  @SlotNumber int3)4AS5BEGIN6  DECLARE @MyName nvarchar(64) = object_name(@@procid)7  DECLARE @DBQueueCurrent QBM_YDBQueueCurrent8  BEGIN TRY9    INSERT INTO @DBQueueCurrent(UID_DialogDBQueue,10    UID_Parameter,11    UID_SubParameter,12    GenProcID)13    SELECT14      UID_DialogDBQueue,15      UID_Parameter,16      UID_SubParameter,17      GenProcID18    FROM QBMDBQueueCurrent cu19      WITH(readpast)20    WHERE21      cu.SlotNumber = @SlotNumber22    IF @@rowcount = 023    BEGIN24      GOTO EndLabel25    END26    DECLARE @DBQueueElements_01 QBM_YDBQueueRaw27    INSERT INTO @DBQueueElements_01(object,28    subobject,29    genprocid)30    SELECT31      x.uid,32      NULL,33      x.GenProcID34    FROM(35    SELECT36      s.uid_complianceSubRule AS uid,37      cu.GenProcID38    FROM ComplianceSubrule s39    JOIN complianceRule r40      ON s.uid_complianceRule = r.uid_complianceRule41    JOIN @DBQueueCurrent cu42      ON cu.UID_Parameter = r.UID_DialogScheduleFill43    WHERE44      r.IsWorkingCopy = 0 AND r.IsInActive = 0 AND r.IsSimpleMode = 1) AS x45    EXEC QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceSubRuleFillObject',46      @DBQueueElements_0147    DECLARE @DBQueueElements_02 QBM_YDBQueueRaw48    INSERT INTO @DBQueueElements_02(object,49    subobject,50    genprocid)51    SELECT52      x.uid,53      NULL,54      x.GenProcID55    FROM(56    SELECT57      r.uid_complianceRule AS uid,58      cu.GenProcID59    FROM complianceRule r60    JOIN @DBQueueCurrent cu61      ON cu.UID_Parameter = r.UID_DialogScheduleFill62    WHERE63      r.IsWorkingCopy = 0 AND r.IsInActive = 0) AS x64    EXEC QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceSubRuleFillPerson',65      @DBQueueElements_0266  END TRY67  BEGIN CATCH68    EXEC QBM_PSessionErrorAdd DEFAULT69    RAISERROR('',70    18,71    1)72      WITH NOWAIT73  END CATCH74  endLabel:75  RETURN76END
Open raw exported source
SQL · Raw11 lines
1  create   procedure CPL_ZScheduleStartFill ( @SlotNumber int ) AS begin declare @MyName nvarchar(64) = object_name(@@procid) declare @DBQueueCurrent2 QBM_YDBQueueCurrent BEGIN TRY insert into @DBQueueCurrent(UID_DialogDBQueue, UID_Parameter, UID_SubParameter, GenProcID) select UID_DialogDBQueue, UID_Parameter3, UID_SubParameter, GenProcID from QBMDBQueueCurrent cu with (readpast) where cu.SlotNumber = @SlotNumber if @@rowcount = 0 begin goto EndLabel end   declare4 @DBQueueElements_01 QBM_YDBQueueRaw insert into @DBQueueElements_01 (object, subobject, genprocid) select x.uid, null, x.GenProcID from ( select s.uid_complianceSubRule5 as uid, cu.GenProcID from ComplianceSubrule s join complianceRule r on s.uid_complianceRule = r.uid_complianceRule join @DBQueueCurrent cu on cu.UID_Parameter6 = r.UID_DialogScheduleFill where r.IsWorkingCopy = 0  and r.IsInActive = 0 and r.IsSimpleMode = 1 ) as x exec QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceSubRuleFillObject'7, @DBQueueElements_01   declare @DBQueueElements_02 QBM_YDBQueueRaw insert into @DBQueueElements_02 (object, subobject, genprocid) select x.uid, null, 8x.GenProcID from ( select r.uid_complianceRule as uid, cu.GenProcID from complianceRule r join @DBQueueCurrent cu on cu.UID_Parameter = r.UID_DialogScheduleFill9 where r.IsWorkingCopy = 0  and r.IsInActive = 0  ) as x exec QBM_PDBQueueInsert_Bulk 'CPL-K-ComplianceSubRuleFillPerson', @DBQueueElements_02 END TRY 10BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH NOWAIT END CATCH  endLabel: return end 11