USP_DATAFORM_EDITSAVE_MAILPREFERENCE_5

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@MAILTYPECODE	tinyint	IN
@ACKNOWLEDGEMENTID	uniqueidentifier	IN
@CORRESPONDENCEID	uniqueidentifier	IN
@PLEDGEREMINDERID	uniqueidentifier	IN
@BUSINESSUNITCODEID	uniqueidentifier	IN
@CATEGORYCODEID	uniqueidentifier	IN
@EVENTCATEGORYCODEID	uniqueidentifier	IN
@SITEID	uniqueidentifier	IN
@CORRESPONDENCECODEID	uniqueidentifier	IN
@RECEIPTTYPECODE	int	IN
@SENDMAIL	bit	IN
@DELIVERYMETHODCODE	tinyint	IN
@CONTACTTYPES	xml	IN
@ADDRESSID	uniqueidentifier	IN
@EMAILADDRESSID	uniqueidentifier	IN
@USESEASONALADDRESS	bit	IN
@COMMENTS	nvarchar(500)	IN
@GROUPCONTACTS	xml	IN
@PURPOSEID	uniqueidentifier	IN
@DONOTSENDOTHERCHANNEL	bit	IN
@ISNOPREFERENCE	bit	IN

Definition

Copy



CREATE procedure USP_DATAFORM_EDITSAVE_MAILPREFERENCE_5
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier,
  @MAILTYPECODE tinyint,
  @ACKNOWLEDGEMENTID uniqueidentifier,
  @CORRESPONDENCEID uniqueidentifier,
  @PLEDGEREMINDERID uniqueidentifier,
  @BUSINESSUNITCODEID uniqueidentifier,
  @CATEGORYCODEID uniqueidentifier,
  @EVENTCATEGORYCODEID uniqueidentifier,
  @SITEID uniqueidentifier,
  @CORRESPONDENCECODEID uniqueidentifier,
  @RECEIPTTYPECODE int,
  @SENDMAIL bit,
  @DELIVERYMETHODCODE tinyint,
  @CONTACTTYPES xml,
  @ADDRESSID uniqueidentifier,
  @EMAILADDRESSID uniqueidentifier,
  @USESEASONALADDRESS bit,
  @COMMENTS nvarchar(500),
  @GROUPCONTACTS xml,
  @PURPOSEID uniqueidentifier,
  @DONOTSENDOTHERCHANNEL bit,
  @ISNOPREFERENCE bit
)

as
  set nocount on;

  declare @LINKEDCONSTITUENTSOLICITCODEID uniqueidentifier;
  declare @HASINHERITEDCONSENT bit;
  declare @SOURCEEVIDENCECODEID uniqueidentifier;
  declare @SOURCEFILE nvarchar(260);
  declare @PRIVACYPOLICY nvarchar(260);
  declare @SUPPORTINGINFORMATION nvarchar(max);
  declare @CONSENTSTATEMENT nvarchar(max);

  exec dbo.USP_DATAFORM_EDITLOAD_MAILPREFERENCE_3
    @ID = @ID,
    @LINKEDCONSTITUENTSOLICITCODEID = @LINKEDCONSTITUENTSOLICITCODEID output,
    @HASINHERITEDCONSENT = @HASINHERITEDCONSENT output,
    @SOURCEEVIDENCECODEID = @SOURCEEVIDENCECODEID output,
    @SOURCEFILE = @SOURCEFILE output,
    @PRIVACYPOLICY = @PRIVACYPOLICY output,
    @SUPPORTINGINFORMATION = @SUPPORTINGINFORMATION output,
    @CONSENTSTATEMENT = @CONSENTSTATEMENT output;

  exec dbo.USP_DATAFORM_EDITSAVE_MAILPREFERENCE_6
    @ID,
    @CHANGEAGENTID,
    @MAILTYPECODE,
    @ACKNOWLEDGEMENTID,
    @CORRESPONDENCEID,
    @PLEDGEREMINDERID,
    @BUSINESSUNITCODEID,
    @CATEGORYCODEID,
    @EVENTCATEGORYCODEID,
    @SITEID,
    @CORRESPONDENCECODEID,
    @RECEIPTTYPECODE,
    @SENDMAIL,
    @DELIVERYMETHODCODE,
    @CONTACTTYPES,
    @ADDRESSID,
    @EMAILADDRESSID,
    @USESEASONALADDRESS,
    @COMMENTS,
    @GROUPCONTACTS,
    @PURPOSEID,
    @DONOTSENDOTHERCHANNEL,
    @ISNOPREFERENCE,
    @LINKEDCONSTITUENTSOLICITCODEID,
    @HASINHERITEDCONSENT,
    @SOURCEEVIDENCECODEID,
    @SOURCEFILE,
    @PRIVACYPOLICY,
    @SUPPORTINGINFORMATION,
    @CONSENTSTATEMENT;

  return 0;