USP_DATAFORMTEMPLATE_EDIT_INTERACTION_6

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@EXPECTEDDATE	datetime	IN
@ACTUALDATE	datetime	IN
@FUNDRAISERID	uniqueidentifier	IN
@INTERACTIONTYPECODEID	uniqueidentifier	IN
@OBJECTIVE	nvarchar(100)	IN
@STATUSCODE	tinyint	IN
@COMMENT	nvarchar(max)	IN
@EVENTID	uniqueidentifier	IN
@PARTICIPANTS	xml	IN
@INTERACTIONCATEGORYID	uniqueidentifier	IN
@INTERACTIONSUBCATEGORYID	uniqueidentifier	IN
@SITES	xml	IN
@EXPECTEDSTARTTIME	UDT_HOURMINUTE	IN
@EXPECTEDENDTIME	UDT_HOURMINUTE	IN
@ISALLDAYEVENT	bit	IN
@TIMEZONEENTRYID	uniqueidentifier	IN
@ACTUALSTARTTIME	UDT_HOURMINUTE	IN
@ACTUALENDTIME	UDT_HOURMINUTE	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_INTERACTION_6
(                        
  @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @EXPECTEDDATE datetime,
    @ACTUALDATE datetime,
    @FUNDRAISERID uniqueidentifier,
    @INTERACTIONTYPECODEID uniqueidentifier,
    @OBJECTIVE nvarchar(100),
    @STATUSCODE tinyint,
    @COMMENT nvarchar(max),
    @EVENTID uniqueidentifier,
    @PARTICIPANTS xml,
    @INTERACTIONCATEGORYID uniqueidentifier,
    @INTERACTIONSUBCATEGORYID uniqueidentifier,
    @SITES xml,
    @EXPECTEDSTARTTIME dbo.UDT_HOURMINUTE,
    @EXPECTEDENDTIME dbo.UDT_HOURMINUTE,
    @ISALLDAYEVENT bit, 
    @TIMEZONEENTRYID uniqueidentifier,
    @ACTUALSTARTTIME dbo.UDT_HOURMINUTE,
    @ACTUALENDTIME dbo.UDT_HOURMINUTE
) as begin
    set nocount on;

  declare @LOCATIONID uniqueidentifier;
  declare @OTHERLOCATION nvarchar(300);

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_INTERACTION_5
    @ID = @ID,
    @LOCATIONID = @LOCATIONID output,
    @OTHERLOCATION = @OTHERLOCATION output;

    exec USP_DATAFORMTEMPLATE_EDIT_INTERACTION_7
        @ID,
        @CHANGEAGENTID,
        @EXPECTEDDATE,
        @ACTUALDATE,
        @FUNDRAISERID,
        @INTERACTIONTYPECODEID,
        @OBJECTIVE,
        @STATUSCODE,
        @COMMENT,
        @EVENTID,
        @PARTICIPANTS,
        @INTERACTIONCATEGORYID,
        @INTERACTIONSUBCATEGORYID,
        @SITES,
        @EXPECTEDSTARTTIME,
        @EXPECTEDENDTIME,
        @ISALLDAYEVENT, 
        @TIMEZONEENTRYID,
        @ACTUALSTARTTIME,
        @ACTUALENDTIME,
    @LOCATIONID,
    @OTHERLOCATION
end