USP_DATAFORMTEMPLATE_EDIT_STEP_4

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.
@EXPECTEDDATE	datetime	IN	Expected date
@ACTUALDATE	datetime	IN	Actual date
@STATUSCODE	tinyint	IN	Status
@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 fundraisers
@PARTICIPANTS	xml	IN	Participants
@INTERACTIONCATEGORYID	uniqueidentifier	IN	Category
@INTERACTIONSUBCATEGORYID	uniqueidentifier	IN	Subcategory

Definition

Copy



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

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

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_STEP_4
        @ID = @ID,
        @EXPECTEDSTARTTIME = @EXPECTEDSTARTTIME output,
        @EXPECTEDENDTIME = @EXPECTEDENDTIME output,
        @ISALLDAYEVENT = @ISALLDAYEVENT output, 
        @TIMEZONEENTRYID = @TIMEZONEENTRYID output,
        @ACTUALSTARTTIME = @ACTUALSTARTTIME output,
        @ACTUALENDTIME = @ACTUALENDTIME output;

    exec USP_DATAFORMTEMPLATE_EDIT_STEP_5
        @ID,
        @CHANGEAGENTID,
        @EXPECTEDDATE,
        @ACTUALDATE,
        @STATUSCODE,
        @OWNERID,
        @INTERACTIONTYPECODEID,
        @OBJECTIVE,
        @PROSPECTPLANSTATUSCODEID,
        @COMMENT,
        @ADDITIONALFUNDRAISERS,
        @PARTICIPANTS,
        @INTERACTIONCATEGORYID,
        @INTERACTIONSUBCATEGORYID,
        @EXPECTEDSTARTTIME,
        @EXPECTEDENDTIME,
        @ISALLDAYEVENT, 
        @TIMEZONEENTRYID,
        @ACTUALSTARTTIME,
        @ACTUALENDTIME;

    return 0;