USP_DATAFORMTEMPLATE_ADD_STEPCOMPLETED_2

The save procedure used by the add dataform template "Completed Step Add Form 2".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@PROSPECTPLANID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@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
@DOCUMENTATIONTYPE	int	IN	Documentation
@ADDITIONALFUNDRAISERS	xml	IN	Additional fundraisers
@PARTICIPANTS	xml	IN	Participants
@INTERACTIONCATEGORYID	uniqueidentifier	IN	Category
@INTERACTIONSUBCATEGORYID	uniqueidentifier	IN	Subcategory
@EXPECTEDSTARTTIME	UDT_HOURMINUTE	IN	Expected start time
@EXPECTEDENDTIME	UDT_HOURMINUTE	IN	Expected end time
@TIMEZONEENTRYID	uniqueidentifier	IN	Time zone
@ISALLDAYEVENT	bit	IN
@ACTUALSTARTTIME	UDT_HOURMINUTE	IN	Actual start time
@ACTUALENDTIME	UDT_HOURMINUTE	IN	Actual end time
@LOCATIONID	uniqueidentifier	IN
@OTHERLOCATION	nvarchar(300)	IN

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_STEPCOMPLETED_2
          (
            @ID uniqueidentifier = null output,
            @CHANGEAGENTID uniqueidentifier = null,
            @PROSPECTPLANID uniqueidentifier,
            @EXPECTEDDATE datetime,
            @ACTUALDATE datetime = null,
            @STATUSCODE tinyint = 2,
            @OWNERID uniqueidentifier = null,
            @INTERACTIONTYPECODEID uniqueidentifier = null,
            @OBJECTIVE nvarchar(100) = '',
            @PROSPECTPLANSTATUSCODEID uniqueidentifier = null,
            @COMMENT nvarchar(max) = '',
            @DOCUMENTATIONTYPE int = null,
            @ADDITIONALFUNDRAISERS xml = null,
            @PARTICIPANTS xml = null,
            @INTERACTIONCATEGORYID uniqueidentifier = null,
            @INTERACTIONSUBCATEGORYID uniqueidentifier = null,
            @EXPECTEDSTARTTIME dbo.UDT_HOURMINUTE = '',
            @EXPECTEDENDTIME dbo.UDT_HOURMINUTE = '',
            @TIMEZONEENTRYID uniqueidentifier = null,
            @ISALLDAYEVENT bit = 1,
            @ACTUALSTARTTIME dbo.UDT_HOURMINUTE = '',
            @ACTUALENDTIME dbo.UDT_HOURMINUTE = '',
            @LOCATIONID uniqueidentifier = null,
            @OTHERLOCATION nvarchar(300) = ''
          ) as begin
            set nocount on;

            declare @LOCATION nvarchar(300) = '';
            set @LOCATION = dbo.UFN_INTERACTION_GETSINGLELINELOCATION(@LOCATIONID, @OTHERLOCATION);

            exec dbo.USP_STEP_ADD @ID output, @CHANGEAGENTID, @PROSPECTPLANID, @EXPECTEDDATE, @ACTUALDATE, @STATUSCODE, @OWNERID, 
              @INTERACTIONTYPECODEID, @OBJECTIVE, @PROSPECTPLANSTATUSCODEID, @COMMENT, @ADDITIONALFUNDRAISERS, @PARTICIPANTS, 
              @INTERACTIONSUBCATEGORYID, @EXPECTEDSTARTTIME, @EXPECTEDENDTIME, @TIMEZONEENTRYID, @ISALLDAYEVENT, @ACTUALSTARTTIME,
              @ACTUALENDTIME, @LOCATION;

            return 0;
          end