Back to OIM Explorer

dbo.QBM_PJobCreate_SendRMail

Stored ProcedureSQL_STORED_PROCEDURESandbox DB

Stored Procedure. HOFireEvent -> DialogDatabase.SendRichMail at line 4; References QBM_PJobCreate*; References QBM_PJobCreate_HOFireEvent*

Source: sandbox-db sys.sql_modules

Source size: 1.653 characters

Interpretation

  • Database routine. Review parameters, called procedures, DBQueue inserts, and QBM_PJobCreate helper calls before assuming side effects.
  • Object-layer bridge detected through QBM_PJobCreate helper usage.

Relations

  • HOFireEvent -> DialogDatabase.SendRichMail at line 4
  • References QBM_PJobCreate*
  • References QBM_PJobCreate_HOFireEvent*

Typed Edges

  • fires event DialogDatabase.SendRichMail HOFireEvent -> DialogDatabase.SendRichMail at line 4
  • references source dbo.QBM_FGISessionErrorRethrow source text reference
  • references source dbo.QBM_PJobCreate source text reference
  • references source dbo.QBM_PJobCreate_HOFireEvent source text reference
  • references source dbo.QBM_PSessionErrorAdd source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL69 lines
1CREATE PROCEDURE QBM_PJobCreate_SendRMail(2  @uid_DialogRichMail varchar(38),3  @BasisObject varchar(138) = N '',4  @Address nvarchar(2000) = N '',5  @Senderaddress nvarchar(255) = N '',6  @cc nvarchar(2000) = N '',7  @Bcc nvarchar(2000) = N '',8  @StartAt datetime = NULL,9  @priority int = 1,10  @Xuserinserted nvarchar(64) = N '',11  @GenProcID varchar(38) = N '',12  @AdditionalObjectKeysAffected QBM_YParameterList READONLY,13  @checkForExisting BIT = 0,14  @QueueName nvarchar(256) = NULL15)16AS17BEGIN18  SET XACT_ABORT OFF19  BEGIN TRY20    EXEC QBM_PJobCreate_HOFireEvent @objecttype = 'DialogDatabase',21      @whereclause = 'IsMainDatabase = 1',22      @EventName = 'SendRichMail',23      @GenProcID = @GenProcID,24      @ObjectKeysAffected = @AdditionalObjectKeysAffected,25      @p2 = N '_paramName1',26      @v2 = N 'pcMailID',27      @p3 = N '_paramValue1',28      @v3 = @uid_DialogRichMail,29      @p4 = N '_paramName2',30      @v4 = N 'pcBaseObject',31      @p5 = N '_paramValue2',32      @v5 = @BasisObject,33      @p6 = N '_paramName3',34      @v6 = N 'pcAddress',35      @p7 = N '_paramValue3',36      @v7 = @Address,37      @p8 = N '_paramName4',38      @v8 = N 'pcSenderaddress',39      @p9 = N '_paramValue4',40      @v9 = @Senderaddress,41      @p10 = N '_paramName5',42      @v10 = N 'pccc',43      @p11 = N '_paramValue5',44      @v11 = @cc,45      @p12 = N '_paramName6',46      @v12 = N 'pcBcc',47      @p13 = N '_paramValue6',48      @v13 = @Bcc,49      @p14 = N '_paramName7',50      @v14 = N 'pcAttachment',51      @p15 = N '_paramValue7',52      @v15 = N '',53      @Priority = 12,54      @checkForExisting = @checkForExisting,55      @QueueName = @QueueName,56      @XUser = @Xuserinserted,57      @StartAt = @StartAt58  END TRY59  BEGIN CATCH60    EXEC QBM_PSessionErrorAdd DEFAULT61    DECLARE @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow()62    RAISERROR(@Rethrow,63    18,64    1)65      WITH NOWAIT66  END CATCH67  ende:68  RETURN69END
Open raw exported source
SQL ยท Raw12 lines
1 create   procedure QBM_PJobCreate_SendRMail ( @uid_DialogRichMail varchar(38), @BasisObject varchar(138) = N'', @Address nvarchar (2000) = N'',2 @Senderaddress nvarchar(255) = N'', @cc nvarchar(2000) = N'', @Bcc nvarchar(2000) = N'', @StartAt datetime = NULL , @priority int = 1, @Xuserinserted 3nvarchar(64) = N'', @GenProcID varchar(38) = N'', @AdditionalObjectKeysAffected QBM_YParameterList readonly  ,@checkForExisting bit = 0   , @QueueName 4nvarchar(256) = null )as begin SET XACT_ABORT OFF BEGIN TRY exec QBM_PJobCreate_HOFireEvent @objecttype = 'DialogDatabase', @whereclause = 'IsMainDatabase = 1'5, @EventName = 'SendRichMail', @GenProcID = @GenProcID, @ObjectKeysAffected = @AdditionalObjectKeysAffected, @p2 = N'_paramName1', @v2 = N'pcMailID', @p36 = N'_paramValue1', @v3 = @uid_DialogRichMail, @p4 = N'_paramName2', @v4 = N'pcBaseObject' , @p5 = N'_paramValue2' , @v5 = @BasisObject , @p6 = N'_paramName3'7, @v6 = N'pcAddress' , @p7 = N'_paramValue3', @v7 = @Address , @p8 = N'_paramName4', @v8 = N'pcSenderaddress' , @p9 = N'_paramValue4', @v9 = @Senderaddress8 , @p10 = N'_paramName5', @v10 = N'pccc' , @p11 = N'_paramValue5', @v11 = @cc , @p12 = N'_paramName6', @v12 = N'pcBcc' , @p13 = N'_paramValue6', @v13 =9 @Bcc , @p14 = N'_paramName7', @v14 = N'pcAttachment' , @p15 = N'_paramValue7', @v15 = N'' , @Priority = 12, @checkForExisting = @checkForExisting  , @QueueName10 = @QueueName , @XUser = @Xuserinserted , @StartAt = @StartAt END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow11() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 12