USP_DATAFORMTEMPLATE_ADD_MOBILE_STEP

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@CHANGEAGENTID	uniqueidentifier	IN
@PROSPECTPLANID	uniqueidentifier	IN
@EXPECTEDDATE	datetime	IN
@ACTUALDATE	datetime	IN
@STATUSCODE	tinyint	IN
@OWNERID	uniqueidentifier	IN
@INTERACTIONTYPECODEID	uniqueidentifier	IN
@OBJECTIVE	nvarchar(100)	IN
@PROSPECTPLANSTATUSCODEID	uniqueidentifier	IN
@COMMENT	nvarchar(max)	IN
@ADDITIONALFUNDRAISERS	xml	IN
@PARTICIPANTS	xml	IN
@INTERACTIONCATEGORYID	uniqueidentifier	IN
@INTERACTIONSUBCATEGORYID	uniqueidentifier	IN
@EXPECTEDSTARTTIME	UDT_HOURMINUTE	IN
@EXPECTEDENDTIME	UDT_HOURMINUTE	IN
@TIMEZONEENTRYID	uniqueidentifier	IN
@ISALLDAYEVENT	bit	IN
@ACTUALSTARTTIME	UDT_HOURMINUTE	IN
@ACTUALENDTIME	UDT_HOURMINUTE	IN
@LOCATIONID	uniqueidentifier	IN
@OTHERLOCATION	nvarchar(300)	IN

Definition

Copy



create procedure dbo.USP_DATAFORMTEMPLATE_ADD_MOBILE_STEP
(
  @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