USP_GROUP_COPYPHONE

This stored procedure is used to copy additional phone information from a primary member to a group.

Parameters

Parameter	Parameter Type	Mode
@GROUPID	uniqueidentifier	IN
@MEMBERID	uniqueidentifier	IN
@PHONE_NUMBER	nvarchar(100)	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_GROUP_COPYPHONE
            (
                @GROUPID uniqueidentifier,
                @MEMBERID uniqueidentifier,
                @PHONE_NUMBER nvarchar(100),
                @CHANGEAGENTID uniqueidentifier = null
            )
            as
                set nocount on;

                if @CHANGEAGENTID is null  
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                declare @CURRENTDATE datetime;
                set @CURRENTDATE = getdate();

                declare @STARTTIME dbo.UDT_HOURMINUTE = '';
                declare @ENDTIME dbo.UDT_HOURMINUTE = '';
                declare @COUNTRYID uniqueidentifier = null;

                select 
                    @STARTTIME = STARTTIME,
                    @ENDTIME = ENDTIME,
                    @COUNTRYID = COUNTRYID
                from dbo.PHONE
                where PHONE.CONSTITUENTID = @MEMBERID
                and PHONE.NUMBER = @PHONE_NUMBER

                update dbo.PHONE set 
                    STARTTIME = @STARTTIME,
                    ENDTIME = @ENDTIME,
                    COUNTRYID = isnull(@COUNTRYID, COUNTRYID),
                    CHANGEDBYID = @CHANGEAGENTID,
                    DATECHANGED = @CURRENTDATE
                where PHONE.CONSTITUENTID = @GROUPID
                and PHONE.ISPRIMARY = 1

                return 0;