dbo.QBM_PJobCreate_SendRMail

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', @p3
6 = 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 = @Senderaddress
8 , @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  , @QueueName
10 = @QueueName , @XUser = @Xuserinserted , @StartAt = @StartAt END TRY BEGIN CATCH exec QBM_PSessionErrorAdd default declare @Rethrow varchar(1000) = dbo.QBM_FGISessionErrorRethrow
11() RAISERROR (@Rethrow, 18, 1) WITH NOWAIT END CATCH ende: return end 
12