USP_DATAFORMTEMPLATE_ADD_PHONE_COPYTOSPOUSE_PRELOAD

The load procedure used by the edit dataform template "Phone Copy To Spouse Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@PHONEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTID	uniqueidentifier	INOUT	Spouse ID
@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
@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

Definition

Copy



              create procedure dbo.USP_DATAFORMTEMPLATE_ADD_PHONE_COPYTOSPOUSE_PRELOAD
              (
                  @PHONEID uniqueidentifier,
                  @CONSTITUENTID uniqueidentifier = null output,
                  @PHONETYPECODEID uniqueidentifier = null output,
                  @NUMBER nvarchar(100) = null output,
                  @PRIMARY bit = null output,
                  @DONOTCALL bit = null 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

              )
              as
                  set nocount on;

                  exec dbo.USP_PHONE_UPDATE_LOAD 
                    @PHONEID, 
                    @PHONETYPECODEID = @PHONETYPECODEID output,
                    @NUMBER = @NUMBER output, 
                    @PRIMARY = @PRIMARY output, 
                    @DONOTCALL = @DONOTCALL output, 
                    @STARTTIME = @STARTTIME output, 
                    @ENDTIME = @ENDTIME output,
                    @INFOSOURCECODEID = @INFOSOURCECODEID output, 
                    @INFOSOURCECOMMENTS = @INFOSOURCECOMMENTS output, 
                    @COUNTRYID = @COUNTRYID output, 
                    @STARTDATE = @STARTDATE output, 
                    @ENDDATE = @ENDDATE output,
                    @DONOTCALLREASONCODEID = @DONOTCALLREASONCODEID output, 
                    @ISCONFIDENTIAL = @ISCONFIDENTIAL output;

                  declare @CURRENTDATE datetime;
                  set @CURRENTDATE = dbo.UFN_DATE_GETEARLIESTTIME(getdate());

                  select @COUNTRYCODES = dbo.UFN_COUNTRY_GETCOUNTRYCODES_TOITEMLISTXML();

                  select 
                    @CONSTITUENTID = SPOUSE.ID
                  from dbo.PHONE
                  inner join dbo.CONSTITUENT on PHONE.CONSTITUENTID = CONSTITUENT.ID
                  inner join dbo.RELATIONSHIP on CONSTITUENT.ID = RELATIONSHIP.RELATIONSHIPCONSTITUENTID
                  inner join dbo.CONSTITUENT SPOUSE on RELATIONSHIP.RECIPROCALCONSTITUENTID = SPOUSE.ID
                  where
                    PHONE.ID = @PHONEID and
                    RELATIONSHIP.ISSPOUSE = 1;

                  if not exists(select ID from dbo.PHONE where CONSTITUENTID = @CONSTITUENTID and ISPRIMARY = 1)
                  begin
                    set @PRIMARY = 1;
                  end

                  return 0;