USP_DATAFORMTEMPLATE_EDITLOAD_PHONE_3

The load procedure used by the edit dataform template "Phone Edit Form 3"

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.
@PHONETYPECODEID	uniqueidentifier	INOUT	Type
@NUMBER	nvarchar(100)	INOUT	Number
@PRIMARY	bit	INOUT	Set as primary phone number
@DONOTCALL	bit	INOUT	Do not call this phone number
@SPOUSENAME	nvarchar(154)	INOUT
@SPOUSEHASMATCHINGPHONE	bit	INOUT
@UPDATEMATCHINGSPOUSEPHONE	bit	INOUT	Update matching phone information for household
@ISHOUSEHOLD	bit	INOUT
@ISHOUSEHOLDMEMBER	bit	INOUT
@UPDATEMATCHINGHOUSEHOLDPHONE	bit	INOUT	Update matching phone numbers in household
@MATCHINGHOUSEHOLDMEMBERS	xml	INOUT	Household members
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@STARTTIME	UDT_HOURMINUTE	INOUT	Call after
@ENDTIME	UDT_HOURMINUTE	INOUT	Call before
@INFOSOURCECODEID	uniqueidentifier	INOUT	Information source
@INFOSOURCECOMMENTS	nvarchar(256)	INOUT	Comments
@COUNTRYID	uniqueidentifier	INOUT	Country
@STARTDATE	date	INOUT	Start date
@ENDDATE	date	INOUT	End date
@DONOTCALLREASONCODEID	uniqueidentifier	INOUT	Reason
@ISCONFIDENTIAL	bit	INOUT	This phone number is confidential
@COUNTRYCODES	xml	INOUT
@CONSTITUENTDATAREVIEWROLLBACKREASONID	uniqueidentifier	INOUT	Reason
@FORCEDPRIMARY	bit	INOUT
@CANEDITPRIMARY	bit	INOUT
@INVALIDFIELDS	nvarchar(256)	INOUT
@ORIGINCODE	tinyint	INOUT	Origin
@SEASONALSTARTDATE	UDT_MONTHDAY	INOUT	Start date
@SEASONALENDDATE	UDT_MONTHDAY	INOUT	End date
@DONOTTEXT	bit	INOUT

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PHONE_3
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @PHONETYPECODEID uniqueidentifier = null output,
                    @NUMBER nvarchar(100) = null output,
                    @PRIMARY bit = null output,
                    @DONOTCALL bit = null output,
                    @SPOUSENAME nvarchar(154) = null output,
                    @SPOUSEHASMATCHINGPHONE bit = null output,
                    @UPDATEMATCHINGSPOUSEPHONE bit = null output,
                    @ISHOUSEHOLD bit = null output,
                    @ISHOUSEHOLDMEMBER bit = null output,
                    @UPDATEMATCHINGHOUSEHOLDPHONE bit = null output,
                    @MATCHINGHOUSEHOLDMEMBERS xml = null output,
                    @TSLONG bigint = 0 output,
                    @STARTTIME dbo.UDT_HOURMINUTE = null output,
                    @ENDTIME dbo.UDT_HOURMINUTE = null output,
                    @INFOSOURCECODEID uniqueidentifier = null output,
                    @INFOSOURCECOMMENTS nvarchar(256) = null output,
                    @COUNTRYID uniqueidentifier = null output,
                    @STARTDATE date = null output,
                    @ENDDATE date = null output,
                    @DONOTCALLREASONCODEID uniqueidentifier = null output,
                    @ISCONFIDENTIAL bit = null output,
                    @COUNTRYCODES xml = null output,
                    @CONSTITUENTDATAREVIEWROLLBACKREASONID uniqueidentifier = null output,    -- used by constituent data review
                    @FORCEDPRIMARY bit = null output,            -- used by constituent data review
                    @CANEDITPRIMARY bit = null output,            -- used by constituent data review
                    @INVALIDFIELDS nvarchar(256) = null output,    -- used by constituent data review
                    @ORIGINCODE tinyint = null output,
                    @SEASONALSTARTDATE dbo.UDT_MONTHDAY = null output,
                    @SEASONALENDDATE dbo.UDT_MONTHDAY = null output,
                    @DONOTTEXT bit = null output
                )
                as
                    set nocount on;

                    -- moved original code in the USP bellow, which is shared with other areas other then constituent phone edit (duplicate search resolution screen
                    exec dbo.USP_PHONE_EDITLOAD @ID, @DATALOADED output, @PHONETYPECODEID output, @NUMBER output, @PRIMARY output, @DONOTCALL output, @SPOUSENAME output, @SPOUSEHASMATCHINGPHONE output,
                    @UPDATEMATCHINGSPOUSEPHONE output, @ISHOUSEHOLD output,@ISHOUSEHOLDMEMBER output, @UPDATEMATCHINGHOUSEHOLDPHONE output, @MATCHINGHOUSEHOLDMEMBERS output, @TSLONG output, 
                    @STARTTIME output, @ENDTIME  output, @INFOSOURCECODEID output, @INFOSOURCECOMMENTS output, @COUNTRYID output, @STARTDATE output, @ENDDATE output, @DONOTCALLREASONCODEID output, 
                    @ISCONFIDENTIAL output, @COUNTRYCODES output, @CONSTITUENTDATAREVIEWROLLBACKREASONID output, @FORCEDPRIMARY output, @CANEDITPRIMARY output, @INVALIDFIELDS output, @ORIGINCODE output,
                    @SEASONALSTARTDATE output, @SEASONALENDDATE output, @DONOTTEXT output;