USP_DATAFORMTEMPLATE_EDIT_EXCHANGECONTACTBATCHROW

Edits the exchange contact batch row .

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.
@CHANGEDBYAPPUSERID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@BIOLOGICALINFORMATION	xml	IN	Biological information
@PHONEINFORMATION	xml	IN	Phone information
@HOMEADDRESSINFORMATION	xml	IN	Exchange home address information
@BUSINESSADDRESSINFORMATION	xml	IN	Exchange business address information
@OTHERADDRESSINFORMATION	xml	IN	Exchange other address information
@EMAILADDRESSINFORMATION	xml	IN	Email address information
@SEQUENCE	int	IN
@CREATENEWBUSINESSADDRESS	bit	IN	Copy existing address information to a new address before updating with the downloaded information
@NEWBUSINESSADDRESSTYPECODEID	uniqueidentifier	IN	New address type
@CREATENEWHOMEADDRESS	bit	IN	Copy existing address information to a new address before updating with the downloaded information
@NEWHOMEADDRESSTYPECODEID	uniqueidentifier	IN	New address type
@CREATENEWOTHERADDRESS	bit	IN	Copy existing address information to a new address before updating with the downloaded information
@NEWOTHERADDRESSTYPECODEID	uniqueidentifier	IN	New address type
@PROCESS	bit	IN	Process
@DONOTMAILBUSINESSADDRESS	bit	IN	Do not mail to new address
@DONOTMAILHOMEADDRESS	bit	IN	Do not mail to new address
@DONOTMAILOTHERADDRESS	bit	IN	Do not mail to new address

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EXCHANGECONTACTBATCHROW
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDBYAPPUSERID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier,
                @BIOLOGICALINFORMATION xml,
                @PHONEINFORMATION xml,
                @HOMEADDRESSINFORMATION xml,
                @BUSINESSADDRESSINFORMATION xml,
                @OTHERADDRESSINFORMATION xml,
                @EMAILADDRESSINFORMATION xml,
                @SEQUENCE int,
                @CREATENEWBUSINESSADDRESS bit,
                @NEWBUSINESSADDRESSTYPECODEID uniqueidentifier, 
                @CREATENEWHOMEADDRESS bit,
                @NEWHOMEADDRESSTYPECODEID uniqueidentifier,
                @CREATENEWOTHERADDRESS bit,
                @NEWOTHERADDRESSTYPECODEID uniqueidentifier,
                @PROCESS bit,
                @DONOTMAILBUSINESSADDRESS bit,
                @DONOTMAILHOMEADDRESS bit,
                @DONOTMAILOTHERADDRESS bit
            )
            as
                set nocount on;

                declare @INFOSOURCECODEID uniqueidentifier;

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EXCHANGECONTACTBATCHROW @ID, @INFOSOURCECODEID = @INFOSOURCECODEID output;

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_EXCHANGECONTACTBATCHROW_2
                        @ID,
                        @CHANGEAGENTID,
                        @CHANGEDBYAPPUSERID,
                        @CONSTITUENTID,
                        @BIOLOGICALINFORMATION,
                        @PHONEINFORMATION,
                        @HOMEADDRESSINFORMATION,
                        @BUSINESSADDRESSINFORMATION,
                        @OTHERADDRESSINFORMATION,
                        @EMAILADDRESSINFORMATION,
                        @SEQUENCE,
                        @CREATENEWBUSINESSADDRESS,
                        @NEWBUSINESSADDRESSTYPECODEID, 
                        @CREATENEWHOMEADDRESS,
                        @NEWHOMEADDRESSTYPECODEID,
                        @CREATENEWOTHERADDRESS,
                        @NEWOTHERADDRESSTYPECODEID,
                        @PROCESS,
                        @DONOTMAILBUSINESSADDRESS,
                        @DONOTMAILHOMEADDRESS,
                        @DONOTMAILOTHERADDRESS,
                        @INFOSOURCECODEID;