USP_DATAFORMTEMPLATE_EDIT_BATCHINTERACTIONBATCHROW

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.
@SEQUENCE	int	IN	Sequence
@INTERACTIONID	uniqueidentifier	IN	Interaction
@CONSTITUENTID	uniqueidentifier	IN	Constituent lookup ID
@CONSTITUENTNAME	nvarchar(250)	IN	Constituent name
@CUSTOMIDENTIFIER	nvarchar(100)	IN	Interaction lookup ID
@INTERACTIONTYPECODEID	uniqueidentifier	IN	Contact method
@OBJECTIVE	nvarchar(100)	IN	Summary
@FUNDRAISERID	uniqueidentifier	IN	Owner
@EXPECTEDDATE	datetime	IN	Expected date
@ACTUALDATE	datetime	IN	Actual date
@STATUSCODE	tinyint	IN	Status
@COMMENT	nvarchar(max)	IN	Comment
@EVENTID	uniqueidentifier	IN	Event
@PARTICIPANTS	xml	IN	Participants
@INTERACTIONCATEGORYID	uniqueidentifier	IN	Category
@INTERACTIONSUBCATEGORYID	uniqueidentifier	IN	Subcategory
@SITES	xml	IN	Sites

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHINTERACTIONBATCHROW
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @SEQUENCE int,
                @INTERACTIONID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier,
                @CONSTITUENTNAME nvarchar(250),
                @CUSTOMIDENTIFIER nvarchar(100),
                @INTERACTIONTYPECODEID uniqueidentifier,
                @OBJECTIVE nvarchar(100),
                @FUNDRAISERID uniqueidentifier,
                @EXPECTEDDATE datetime,
                @ACTUALDATE datetime,
                @STATUSCODE tinyint,
                @COMMENT nvarchar(max),
                @EVENTID uniqueidentifier,
                @PARTICIPANTS xml,
                @INTERACTIONCATEGORYID uniqueidentifier,
                @INTERACTIONSUBCATEGORYID uniqueidentifier,
                @SITES xml
            ) as
                set nocount on;

                declare @EXPECTEDSTARTTIME dbo.UDT_HOURMINUTE;
                declare    @EXPECTEDENDTIME dbo.UDT_HOURMINUTE;
                declare @TIMEZONEENTRYID uniqueidentifier;
                declare @ACTUALSTARTTIME dbo.UDT_HOURMINUTE;
                declare @ACTUALENDTIME dbo.UDT_HOURMINUTE;

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_BATCHINTERACTIONBATCHROW
                    @ID,
                    @EXPECTEDSTARTTIME = @EXPECTEDSTARTTIME output,
                    @EXPECTEDENDTIME = @EXPECTEDENDTIME output,
                    @TIMEZONEENTRYID = @TIMEZONEENTRYID output,
                    @ACTUALSTARTTIME = @ACTUALSTARTTIME output,
                    @ACTUALENDTIME = @ACTUALENDTIME output

                exec dbo.USP_DATAFORMTEMPLATE_EDIT_BATCHINTERACTIONBATCHROW_2
                        @ID,
                        @CHANGEAGENTID,
                        @SEQUENCE,
                        @INTERACTIONID,
                        @CONSTITUENTID,
                        @CONSTITUENTNAME,
                        @CUSTOMIDENTIFIER,
                        @INTERACTIONTYPECODEID,
                        @OBJECTIVE,
                        @FUNDRAISERID,
                        @EXPECTEDDATE,
                        @ACTUALDATE,
                        @STATUSCODE,
                        @COMMENT,
                        @EVENTID,
                        @PARTICIPANTS,
                        @INTERACTIONCATEGORYID,
                        @INTERACTIONSUBCATEGORYID,
                        @SITES,
                        @EXPECTEDSTARTTIME,
                        @EXPECTEDENDTIME, 
                        @TIMEZONEENTRYID,
                        @ACTUALSTARTTIME,
                        @ACTUALENDTIME

                return 0;