USP_DATAFORMTEMPLATE_EDITLOAD_EXCHANGECONTACTBATCHROW

The load procedure used by the edit dataform template "Exchange Contact Batch Row Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@CHANGEDBYAPPUSERID	uniqueidentifier	INOUT
@APPUSERNAME	nvarchar(250)	INOUT	Changed by
@CONSTITUENTID	uniqueidentifier	INOUT
@CONSTITUENTNAME	nvarchar(300)	INOUT	Constituent
@BIOLOGICALINFORMATION	xml	INOUT	Biological information
@PHONEINFORMATION	xml	INOUT	Phone information
@HOMEADDRESSINFORMATION	xml	INOUT	Exchange home address information
@BUSINESSADDRESSINFORMATION	xml	INOUT	Exchange business address information
@OTHERADDRESSINFORMATION	xml	INOUT	Exchange other address information
@EMAILADDRESSINFORMATION	xml	INOUT	Email address information
@SEQUENCE	int	INOUT
@CREATENEWBUSINESSADDRESS	bit	INOUT	Copy existing address information to a new address before updating with the downloaded information
@NEWBUSINESSADDRESSTYPECODEID	uniqueidentifier	INOUT	New address type
@CREATENEWHOMEADDRESS	bit	INOUT	Copy existing address information to a new address before updating with the downloaded information
@NEWHOMEADDRESSTYPECODEID	uniqueidentifier	INOUT	New address type
@CREATENEWOTHERADDRESS	bit	INOUT	Copy existing address information to a new address before updating with the downloaded information
@NEWOTHERADDRESSTYPECODEID	uniqueidentifier	INOUT	New address type
@PROCESS	bit	INOUT	Process
@DONOTMAILBUSINESSADDRESS	bit	INOUT	Do not mail to new address
@DONOTMAILHOMEADDRESS	bit	INOUT	Do not mail to new address
@DONOTMAILOTHERADDRESS	bit	INOUT	Do not mail to new address
@INFOSOURCECODEID	uniqueidentifier	INOUT	Information source

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_EXCHANGECONTACTBATCHROW
                        (
                            @ID uniqueidentifier,
                            @DATALOADED bit = 0 output,
                            @CHANGEDBYAPPUSERID uniqueidentifier = null output,
                            @APPUSERNAME nvarchar(250) = null output,
                            @CONSTITUENTID uniqueidentifier = null output,
                            @CONSTITUENTNAME nvarchar(300) = null output,
                            @BIOLOGICALINFORMATION xml = null output,
                            @PHONEINFORMATION xml = null output,
                            @HOMEADDRESSINFORMATION xml = null output,
                            @BUSINESSADDRESSINFORMATION xml = null output,
                            @OTHERADDRESSINFORMATION xml = null output,
                            @EMAILADDRESSINFORMATION xml = null output,
                            @SEQUENCE int = null output,
                            @CREATENEWBUSINESSADDRESS bit = null output,
                            @NEWBUSINESSADDRESSTYPECODEID uniqueidentifier = null output, 
                            @CREATENEWHOMEADDRESS bit = null output,
                            @NEWHOMEADDRESSTYPECODEID uniqueidentifier = null output,
                            @CREATENEWOTHERADDRESS bit = null output,
                            @NEWOTHERADDRESSTYPECODEID uniqueidentifier = null output,
                            @PROCESS bit = null output,
                            @DONOTMAILBUSINESSADDRESS bit = null output,
                            @DONOTMAILHOMEADDRESS bit = null output,
                            @DONOTMAILOTHERADDRESS bit = null output,
                            @INFOSOURCECODEID uniqueidentifier = null output
                        )
                        as
                        begin
                            set nocount on;                                                        

                            begin try
                                select
                                    @ID = ID,
                                    @DATALOADED = 1,
                                    @CHANGEDBYAPPUSERID = CHANGEDBYAPPUSERID,
                                    @APPUSERNAME = dbo.UFN_APPUSER_GETNAME(CHANGEDBYAPPUSERID),
                                    @CONSTITUENTID = CONSTITUENTID,
                                    @CONSTITUENTNAME = dbo.UFN_CONSTITUENT_BUILDNAME(CONSTITUENTID),
                                    @BIOLOGICALINFORMATION = BIOLOGICALINFORMATION,
                                    @PHONEINFORMATION = PHONEINFORMATION,
                                    @HOMEADDRESSINFORMATION = HOMEADDRESSINFORMATION,
                                    @BUSINESSADDRESSINFORMATION = BUSINESSADDRESSINFORMATION,
                                    @OTHERADDRESSINFORMATION = OTHERADDRESSINFORMATION,
                                    @EMAILADDRESSINFORMATION = EMAILADDRESSINFORMATION,
                                    @SEQUENCE = SEQUENCE,
                                    @CREATENEWBUSINESSADDRESS = CREATENEWBUSINESSADDRESS,
                                    @NEWBUSINESSADDRESSTYPECODEID = NEWBUSINESSADDRESSTYPECODEID,
                                    @CREATENEWHOMEADDRESS = CREATENEWHOMEADDRESS,
                                    @NEWHOMEADDRESSTYPECODEID = NEWHOMEADDRESSTYPECODEID,
                                    @CREATENEWOTHERADDRESS = CREATENEWOTHERADDRESS,
                                    @NEWOTHERADDRESSTYPECODEID = NEWOTHERADDRESSTYPECODEID,
                                    @PROCESS = PROCESS,
                                    @DONOTMAILBUSINESSADDRESS = DONOTMAILBUSINESSADDRESS,
                                    @DONOTMAILHOMEADDRESS = DONOTMAILHOMEADDRESS,
                                    @DONOTMAILOTHERADDRESS = DONOTMAILOTHERADDRESS,
                                    @INFOSOURCECODEID = INFOSOURCECODEID
                                from
                                    dbo.EXCHANGECONTACTBATCH
                                where
                                    EXCHANGECONTACTBATCH.ID = @ID;
                            end try
                            begin catch
                                exec dbo.USP_RAISE_ERROR;    
                                return 1;
                            end catch 

                            return 0;
                        end