USP_DATAFORMTEMPLATE_EDIT_NAMEFORMATPARAMETER2

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@INDIVIDUALADDRESSEES	xml	IN	Use format defined on individual's record
@ADDRESSEEFUNCTIONID	uniqueidentifier	IN	Otherwise, use this format
@INDIVIDUALSALUTATIONS	xml	IN	Use format defined on individual's record
@SALUTATIONFUNCTIONID	uniqueidentifier	IN	Otherwise, use this format
@ORGANIZATIONADDRESSEES	xml	IN	Use format defined on contact's record
@CONTACTADDRESSEEFUNCTIONID	uniqueidentifier	IN	Otherwise, use this format
@ORGANIZATIONSALUTATIONS	xml	IN	Use format defined on contact's record
@ORGSALUTATIONCODE	tinyint	IN	ORGSALUTATIONCODE
@CONTACTSALUTATIONFUNCTIONID	uniqueidentifier	IN	Otherwise, use this format
@CONTACTSALUTATIONOPTIONCODE	tinyint	IN	If contact is not available, use
@CUSTOMNAME	nvarchar(100)	IN	Custom name
@GROUPADDRESSEES	xml	IN	Use format defined on primary member's record
@GROUPADDRESSEEFUNCTIONID	uniqueidentifier	IN	Otherwise, use this format
@GROUPSALUTATIONCODE	tinyint	IN	GROUPSALUTATIONCODE
@GROUPSALUTATIONS	xml	IN	Use format defined on primary member's record
@GROUPSALUTATIONFUNCTIONID	uniqueidentifier	IN	Otherwise, use this format
@GROUPNOCONTACTOPTIONCODE	tinyint	IN	If member is not available, use
@GROUPNOCONTACTCUSTOMNAME	nvarchar(100)	IN	Custom name
@JOINTRULETYPECODE	tinyint	IN	JOINTRULETYPECODE
@JOINTSELECTIONID	uniqueidentifier	IN	Joint selection criteria
@JOINTSELECTIONBOTHRULETYPECODE	tinyint	IN	If both constituents are found in the selection, use the following
@JOINTSELECTIONNEITHERRULETYPECODE	tinyint	IN	If neither constituents are found in the selection, use the following
@SITEID	uniqueidentifier	IN	Site
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_NAMEFORMATPARAMETER2]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @NAME nvarchar(100),
  @DESCRIPTION nvarchar(255),
  @INDIVIDUALADDRESSEES xml,
  @ADDRESSEEFUNCTIONID uniqueidentifier,
  @INDIVIDUALSALUTATIONS xml,
  @SALUTATIONFUNCTIONID uniqueidentifier,
  @ORGANIZATIONADDRESSEES xml,
  @CONTACTADDRESSEEFUNCTIONID uniqueidentifier,
  @ORGANIZATIONSALUTATIONS xml,
  @ORGSALUTATIONCODE tinyint,
  @CONTACTSALUTATIONFUNCTIONID uniqueidentifier,
  @CONTACTSALUTATIONOPTIONCODE tinyint,
  @CUSTOMNAME nvarchar(100),
  @GROUPADDRESSEES xml,
  @GROUPADDRESSEEFUNCTIONID uniqueidentifier,
  @GROUPSALUTATIONCODE tinyint,
  @GROUPSALUTATIONS xml,
  @GROUPSALUTATIONFUNCTIONID uniqueidentifier,
  @GROUPNOCONTACTOPTIONCODE tinyint,
  @GROUPNOCONTACTCUSTOMNAME nvarchar(100),
  @JOINTRULETYPECODE tinyint,
  @JOINTSELECTIONID uniqueidentifier,
  @JOINTSELECTIONBOTHRULETYPECODE tinyint,
  @JOINTSELECTIONNEITHERRULETYPECODE tinyint,
  @SITEID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier = null
)
as
  set nocount on;

  declare @JOINTEXCLUDESPOUSE bit;
  declare @JOINTSPOUSESMAILEDSEPARATELY bit;

  exec dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_NAMEFORMATPARAMETER2]
    @ID = @ID,
    @JOINTEXCLUDESPOUSE = @JOINTEXCLUDESPOUSE output,
    @JOINTSPOUSESMAILEDSEPARATELY = @JOINTSPOUSESMAILEDSEPARATELY output;

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_NAMEFORMATPARAMETER2_2]
    @ID,
    @CHANGEAGENTID,
    @NAME,
    @DESCRIPTION,
    @INDIVIDUALADDRESSEES,
    @ADDRESSEEFUNCTIONID,
    @INDIVIDUALSALUTATIONS,
    @SALUTATIONFUNCTIONID,
    @ORGANIZATIONADDRESSEES,
    @CONTACTADDRESSEEFUNCTIONID,
    @ORGANIZATIONSALUTATIONS,
    @ORGSALUTATIONCODE,
    @CONTACTSALUTATIONFUNCTIONID,
    @CONTACTSALUTATIONOPTIONCODE,
    @CUSTOMNAME,
    @GROUPADDRESSEES,
    @GROUPADDRESSEEFUNCTIONID,
    @GROUPSALUTATIONCODE,
    @GROUPSALUTATIONS,
    @GROUPSALUTATIONFUNCTIONID,
    @GROUPNOCONTACTOPTIONCODE,
    @GROUPNOCONTACTCUSTOMNAME,
    @JOINTRULETYPECODE,
    @JOINTSELECTIONID,
    @JOINTSELECTIONBOTHRULETYPECODE,
    @JOINTSELECTIONNEITHERRULETYPECODE,
    @SITEID,
    @CURRENTAPPUSERID,
    @JOINTEXCLUDESPOUSE,
    @JOINTSPOUSESMAILEDSEPARATELY;

  return 0;