USP_DATAFORMTEMPLATE_ADD_STEP_2

The save procedure used by the add dataform template "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
@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_STEP_2
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
  @PROSPECTPLANID uniqueidentifier,
  @EXPECTEDDATE datetime,
  @ACTUALDATE datetime = null,
  @STATUSCODE tinyint = 0,
  @OWNERID uniqueidentifier = null,
  @INTERACTIONTYPECODEID uniqueidentifier = null,
  @OBJECTIVE nvarchar(100) = '',
  @PROSPECTPLANSTATUSCODEID uniqueidentifier = null,
  @COMMENT nvarchar(max) = '',
  @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