QBM_PJobCreate_HOFireEvent_B @BasisObjectType, @WhereClause, @EventName = @event , @GenProcID = @GenProcID, @AdditionalObjectKeysAffected = DEFAULT, @p2 = N'_paramName1', @v2 = N'StopTime', @p3 = N'_paramValue1', @v3 = @StopTimeFull , @p4 …
Open sourceQBM_PJobCreate
Database-to-object-layer bridge used by triggers/procedures to call methods, fire events, and create processing work.
Hot path: Trigger/procedure -> QBM_PJobCreate helper -> object-layer method or event -> JobEventGen/process chain.
Aliases: QBM_PJobCreate QBM_PJobCreate_HOCallMethod QBM_PJobCreate_HOFireEvent
Relation graph
Loading relation graph…
Related Evidence
QBM_PJobCreate_HOFireEvent_L ''@TargetTableView@'', @EntriesToFire, ''' , @EventName , ''', ''@GenProcID'' , @AddonElements , @isToFreezeOnError = 1 ' ) select @SQLCmdInsert = REPLACE(@SQLCmdInsert, '@XObjectKey@', 'dbo.QBM_FCVElementToObj…
Open sourceQBM_PJobCreate_HOFireEvent @objecttype , @Sammler , @EventName , @GenProcID , @ObjectKeysAffected , @ConnectionVariables , @AuthenticationString , @SingleTransaction , @p2, @v2 , @p3, @v3 , @p4, @v4 , @p5, @v5 , @p6, @v6 ,@p7, @v7 , @p8, @…
Open sourceQBM_PJobCreate_HOFireEvent_L ''' , @TargetTable , ''', @EntriesToFire, ''Insert'', ''@GenProcID'' , @AddonElements , @isToFreezeOnError = 1 ' ) end select @SQLCmdInsert = REPLACE(@SQLCmdInsert, '@XObjectKey@', concat('dbo.QBM_FCVElementToO…
Open sourceQBM_PJobCreate_HOFireEvent_L ''' , @TargetTable , ''', @EntriesToFire, ''' , @EventName , ''', ''@GenProcID'' , @AddonElements , @isToFreezeOnError = 1 ' ) end select @SQLCmdInsert = REPLACE(@SQLCmdInsert, '@XObjectKey@', concat('dbo.QBM_F…
Open sourceQBM_PJobCreate_HOFireEvent_B 'AttestationCase', @cond, @EventName, @GenProcID , @AdditionalObjectKeysAffected = DEFAULT , @checkForExisting = 0 , @BasisObjectKey = @BasisObjectKey , @p2 = '_ParamName1', @v2 = 'SubLevelNumber' , @p3 = '_Par…
Open sourceQBM_PJobCreate_HOFireEvent_B 'AttestationHelper', @WhereclauseForMail, 'DecisionRequired' , @GenProcID , @AdditionalObjectKeysAffected = DEFAULT , @checkForExisting = 1 , @priority = 10 , @BasisObjectKey = @ObjectkeyForMail select @Element…
Open sourceQBM_PJobCreate_HOFireEvent_B 'AttestationHelper', @WhereclauseForMail, 'DecisionRequired' , @GenProcID , @AdditionalObjectKeysAffected = DEFAULT , @checkForExisting = 1 , @priority = 10 , @BasisObjectKey = @ObjectkeyForMail select @Element…
Open sourceQBM_PJobCreate_HOFireEvent_B 'AttestationHelper', @WhereclauseForMail, 'Remind', @GenProcID , @AdditionalObjectKeysAffected = DEFAULT , @checkForExisting = 1 , @BasisObjectKey = @ObjectkeyForMail end select @ElementIndex += 1 end update At…
Open sourceQBM_PJobCreate_HOFireEvent 'AttestationPolicy', '1=1' , 'RebuildWhereClause', @GenProcID, @objectKeysAffected = default exec QBM_PDBQueueInsert_Single 'QER-K-DynamicGroupMakeTrigger', '', '', @GenProcID END TRY BEGIN CATCH exec QBM_PSessio…
Open sourceQBM_PJobCreate_HOFireEvent 'AttestationPolicy', '1=1' , 'RebuildWhereClause', @GenProcID, @objectKeysAffected = default exec QBM_PDBQueueInsert_Single 'QER-K-DynamicGroupMakeTrigger', '', '', @GenProcID END TRY BEGIN CATCH exec QBM_PSessio…
Open sourceQBM_PJobCreate_HOFireEvent @objecttype = 'DialogDatabase' , @whereclause = 'IsMainDatabase = 1', @EventName = 'SendMail', @GenProcID = @GenProcID, @ObjectKeysAffected = @AdditionalObjectKeysAffected, @p2 = N'_paramName1' , @v2 = N'pcSubjec…
Open sourceQBM_PJobCreate_HOFireEvent @objecttype = 'DialogDatabase', @whereclause = 'IsMainDatabase = 1' , @EventName = 'SendRichMail', @GenProcID = @GenProcID, @ObjectKeysAffected = @AdditionalObjectKeysAffected, @p2 = N'_paramName1', @v2 = N'pcMai…
Open sourceQBM_PJobCreate_HOFireEvent 'DialogDatabase', 'IsMainDatabase = 1' , 'UpdateSystemSyncs', @GenProcID, @ObjectKeysAffected = default , @Startat = @Starten end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH N…
Open sourceQBM_PJobCreate_HOFireEvent 'DialogDatabase', 'IsMainDatabase = 1' , 'UpdateSystemSyncs', @GenProcID, @ObjectKeysAffected = default , @Startat = @Starten end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH N…
Open sourceQBM_PJobCreate_HOFireEvent 'DialogDatabase' , 'IsMainDatabase = 1', 'UpdateSystemSyncs', @GenProcID, @ObjectKeysAffected = default , @Startat = @Starten end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1…
Open sourceQBM_PJobCreate_HOFireEvent 'DialogDatabase', 'IsMainDatabase = 1', 'UpdateSystemSyncs', @GenProcID, @ObjectKeysAffected = default , @Startat = @Starten end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1)…
Open sourceQBM_PJobCreate_HOFireEvent 'DialogDatabase' , 'IsMainDatabase = 1', 'UpdateSystemSyncs', @GenProcID, @ObjectKeysAffected = default , @Startat = @Starten end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1…
Open sourceQBM_PJobCreate_HOFireEvent 'DialogDeferredOperation', @whereclause, 'EXECUTE', @GenProcid , @ObjectKeysAffected = @ObjectKeysPerRun , @BasisObjectKey = @BasisObjectKey select @ElementIndex += 1 end update DialogDeferredOperation set xtouch…
Open sourceQBM_PJobCreate_HOFireEvent_L 'HelperHeadPerson', @EntriesToFire, 'Insert', @GenProcID , @AdditionalObjectkeysAffected = default , @isToFreezeOnError = 1 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH N…
Open sourceQBM_PJobCreate_HOFireEvent_L 'HelperHeadPerson', @EntriesToFire, 'Insert', @GenProcID , @AdditionalObjectkeysAffected = default , @isToFreezeOnError = 1 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH N…
Open sourceQBM_PJobCreate_HOFireEvent_L 'HelperHeadPerson', @EntriesToFire, 'Insert', @GenProcID , @AdditionalObjectkeysAffected = default , @isToFreezeOnError = 1 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH N…
Open sourceQBM_PJobCreate_HOFireEvent_L 'HelperHeadPerson', @EntriesToFire, 'Insert', @GenProcID , @AdditionalObjectkeysAffected = default , @isToFreezeOnError = 1 end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) WITH N…
Open sourceQBM_PJobCreate_HOFireEvent_L 'ITShopOrg', @EntriesToFire ,'DeletePRNode', @GenProcID , @CheckForExisting = 1 , @AdditionalObjectKeysAffected = DEFAULT select @RowCounterNodeCheck += 1 select @ElementIndex += 1 end select @SQLCmd = string_a…
Open sourceQBM_PJobCreate_HOFireEvent 'JobQueue', @SQLcmd, 'FROZENDETECT', @GenProcID , @ObjectKeysAffected = DEFAULT update @JobQueueShadow set ready2exe = N'FALSE' , IsRecordModified = 1 , IsRecordModifiedExtended = 1 , XDateUpdated = @XDateSpecial…
Open sourceQBM_PJobCreate_HOFireEvent 'JobQueue', @SQLWhereClause, 'OVERLIMITDETECT', @GenProcID = @GenProcID , @ObjectKeysAffected = DEFAULT select @ElementIndex += 1 end end end NachLimitationCount: if exists (select top 1 1 from inserted i where i…
Open sourceQBM_PJobCreate_HOFireEvent 'JobQueue', @SQLWhereClause, 'OVERLIMITWARNING', @GenProcID = @GenProcID , @ObjectKeysAffected = DEFAULT , @checkForExisting = 1 select @ElementIndex += 1 end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd…
Open sourceQBM_PJobCreate_HOFireEvent 'JobQueue', @SQLWhereClause, 'OVERLIMITWARNING', @GenProcID = @GenProcID , @ObjectKeysAffected = DEFAULT , @checkForExisting = 1 select @ElementIndex += 1 end end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd…
Open sourceQBM_PJobCreate_HOFireEvent_L 'PersonHasQERResource', @EntriesToFire_Assign1 , @EventName = 'Assign' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 1 ' , @AdditionalObjectKeysAffected = @Additi…
QBM_PJobCreate_HOFireEvent_L 'PersonHasQERResource', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Additi…
QBM_PJobCreate_HOFireEvent_L 'PersonHasQERResource', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Additi…
QBM_PJobCreate_HOFireEvent_L 'PersonHasTSBAccountDef', @EntriesToFire_Assign1 , @EventName = 'Assign' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 1 ' , @AdditionalObjectKeysAffected = @Addi…
QBM_PJobCreate_HOFireEvent_L 'PersonHasTSBAccountDef', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Addi…
QBM_PJobCreate_HOFireEvent_L 'PersonHasTSBAccountDef', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Addi…
QBM_PJobCreate_HOFireEvent_B 'personwantsorg', @cond, @EventName , @GenProcID , @AdditionalObjectKeysAffected = DEFAULT , @checkForExisting = 0 , @BasisObjectKey = @BasisObjectKey , @p2 = '_ParamName1', @v2 = 'SubLevelNumber' , @p3 = '_Par…
Open sourceQBM_PJobCreate_HOFireEvent_L 'PWOHelperPWO', @ObjectKeysToFire, 'DecisionRequired', @GenProcIDToUse , @priority = 10 , @CheckForExisting = 1 , @StartAt = @StartTemplateAt , @whereclauseAdditional = @WhereclauseForMail , @AdditionalObjectKe…
Open sourceQBM_PJobCreate_HOFireEvent_L 'PWOHelperPWO', @ObjectkeySForMail, 'Remind' , @GenProcID , @priority = 10 , @BasisObjectKey = @ObjectkeyForMail , @CheckForExisting = 1 , @whereclauseAdditional = @WhereclauseForMail , @AdditionalObjectKeysAff…
Open sourceQBM_PJobCreate_HOFireEvent_B 'QBMServer', @QueueWhereClause, 'Checkversion', @GenProcID , @AdditionalObjectKeysAffected = DEFAULT , @QueueName = @QueueName , @checkForExisting = 1 end exec QBM_PSessionContextSet 'GenProcID', @GenProcID exe…
Open sourceQBM_PJobCreate_HOFireEvent_L 'QBMServer', @EntriesToFire ,'DeployTargetChanged', @GenProcID , @CheckForExisting = 1 , @AdditionalObjectKeysAffected = DEFAULT end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) W…
Open sourceQBM_PJobCreate_HOFireEvent_L 'QBMServer', @EntriesToFire ,'DeployTargetChanged', @GenProcID , @CheckForExisting = 1 , @AdditionalObjectKeysAffected = DEFAULT end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default RAISERROR ('', 18, 1) W…
Open sourceQBM_PJobCreate_HOFireEvent 'QBMServer', @WhereClause, 'GetDeployTargets', @GenProcID , @ObjectKeysAffected = DEFAULT , @BasisObjectKey = @BasisObjectKey end end END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar…
Open sourceQBM_PJobCreate_HOFireEvent_B 'RPSSubscription', @SQLcmd , 'GenerateMail', @GenProcID , @AdditionalObjectKeysAffected = DEFAULT , @p2 = N'_paramName1' , @v2 = N'ParameterSet' , @p3 = N'_paramValue1' , @v3 = @UID_DialogParameterSet , @checkF…
Open sourceQBM_PJobCreate_HOFireEvent_L 'UNSAccountBHasUNSGroupB', @EntriesToFire_Assign1 , @EventName = 'Assign' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 1 ' , @AdditionalObjectKeysAffected = @Add…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBHasUNSGroupB', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Add…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBHasUNSGroupB', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Add…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBHasUNSGroupB1', @EntriesToFire_Assign1 , @EventName = 'Assign' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 1 ' , @AdditionalObjectKeysAffected = @Ad…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBHasUNSGroupB1', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Ad…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBHasUNSGroupB1', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Ad…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBHasUNSGroupB2', @EntriesToFire_Assign1 , @EventName = 'Assign' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 1 ' , @AdditionalObjectKeysAffected = @Ad…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBHasUNSGroupB2', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Ad…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBHasUNSGroupB2', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Ad…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBHasUNSGroupB3', @EntriesToFire_Assign1 , @EventName = 'Assign' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 1 ' , @AdditionalObjectKeysAffected = @Ad…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBHasUNSGroupB3', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Ad…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBHasUNSGroupB3', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Ad…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBHasUNSItemB', @EntriesToFire_Assign1 , @EventName = 'Assign' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 1 ' , @AdditionalObjectKeysAffected = @Addi…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBHasUNSItemB', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Addi…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBHasUNSItemB', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Addi…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBInUNSGroupB', @EntriesToFire_Assign1 , @EventName = 'Assign' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 1 ' , @AdditionalObjectKeysAffected = @Addi…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBInUNSGroupB', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Addi…
QBM_PJobCreate_HOFireEvent_L 'UNSAccountBInUNSGroupB', @EntriesToFire_Remove1 , @EventName = 'Remove' , @GenProcID = @GenProcID , @isToFreezeOnError = 1 , @WhereClauseAdditional = ' XIsInEffect = 0 ' , @AdditionalObjectKeysAffected = @Addi…