USP_DATAFORMTEMPLATE_EDIT_CONTACTREPORT

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.
@ACTUALDATE	datetime	IN	Actual date
@OWNERID	uniqueidentifier	IN	Owner
@INTERACTIONTYPECODEID	uniqueidentifier	IN	Contact Method
@OBJECTIVE	nvarchar(100)	IN	Objective
@PROSPECTPLANSTATUSCODEID	uniqueidentifier	IN	Stage
@COMMENT	nvarchar(max)	IN	Comment
@ADDITIONALFUNDRAISERS	xml	IN	Additional solicitors
@PARTICIPANTS	xml	IN	Participants
@INTERACTIONCATEGORYID	uniqueidentifier	IN	Category
@INTERACTIONSUBCATEGORYID	uniqueidentifier	IN	Subcategory

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CONTACTREPORT
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @ACTUALDATE datetime,
                @OWNERID uniqueidentifier,
                @INTERACTIONTYPECODEID uniqueidentifier,
                @OBJECTIVE nvarchar(100),
                @PROSPECTPLANSTATUSCODEID uniqueidentifier,
                @COMMENT nvarchar(max),
                @ADDITIONALFUNDRAISERS xml,
                @PARTICIPANTS xml,
                @INTERACTIONCATEGORYID uniqueidentifier,
                @INTERACTIONSUBCATEGORYID uniqueidentifier
            ) as begin
                set nocount on;

                declare @ACTUALSTARTTIME dbo.UDT_HOURMINUTE;
                declare @ACTUALENDTIME dbo.UDT_HOURMINUTE;

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONTACTREPORT
                    @ID = @ID,
                    @ACTUALSTARTTIME = @ACTUALSTARTTIME output,
                    @ACTUALENDTIME = @ACTUALENDTIME output

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_CONTACTREPORT_2
                    @ID,
                    @CHANGEAGENTID,
                    @ACTUALDATE,
                    @OWNERID,
                    @INTERACTIONTYPECODEID,
                    @OBJECTIVE,
                    @PROSPECTPLANSTATUSCODEID,
                    @COMMENT,
                    @ADDITIONALFUNDRAISERS,
                    @PARTICIPANTS,
                    @INTERACTIONCATEGORYID,
                    @INTERACTIONSUBCATEGORYID,
                    @ACTUALSTARTTIME,
                    @ACTUALENDTIME
                return 0;
            end