USP_DATAFORMTEMPLATE_ADD_MKTMARKETINGPLANITEM

The save procedure used by the add dataform template "Marketing Plan Item Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@PARENTMARKETINGPLANITEMID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@LEVEL	int	IN	Level
@MARKETINGPLANID	uniqueidentifier	IN	Marketing plan ID
@NAME	nvarchar(100)	IN	Name
@APPEALID	nvarchar(20)	IN	Appeal ID
@GOALS	nvarchar(max)	IN	Goals
@PLANITEMCATEGORYCODEID	uniqueidentifier	IN	Category
@STARTDATE	UDT_FUZZYDATE	IN	Start date
@ENDDATE	UDT_FUZZYDATE	IN	End date

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTMARKETINGPLANITEM]
(
  @ID uniqueidentifier = null output,
  @CURRENTAPPUSERID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @PARENTMARKETINGPLANITEMID uniqueidentifier,
  @LEVEL integer = null,
  @MARKETINGPLANID uniqueidentifier = null,
  @NAME nvarchar(100) = '',
  @APPEALID nvarchar(20) = '',
  @GOALS nvarchar(max) = '',
  @PLANITEMCATEGORYCODEID uniqueidentifier = null,
  @STARTDATE dbo.[UDT_FUZZYDATE] = null,
  @ENDDATE dbo.[UDT_FUZZYDATE] = null
)
as
  set nocount on;

  declare @CURRENTDATE datetime;
  declare @BASECURRENCYID uniqueidentifier;

  if @ID is null set @ID = newid();

  if @CHANGEAGENTID is null
    exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

  set @CURRENTDATE = getdate();

  select @BASECURRENCYID = [BASECURRENCYID] from dbo.[MKTMARKETINGPLAN] where [ID] = @MARKETINGPLANID;

  begin try
    -- create the plan item

    insert into dbo.[MKTMARKETINGPLANITEM] (
      [ID],
      [MARKETINGPLANID],
      [PARENTMARKETINGPLANITEMID],
      [LEVEL],
      [NAME],
      [PLANITEMCATEGORYCODEID],
      [STARTDATE],
      [ENDDATE],
      [GOALS],
      [BASECURRENCYID],
      [APPEALID],
      [ADDEDBYID],
      [CHANGEDBYID],
      [DATEADDED],
      [DATECHANGED]
    ) values (
      @ID,
      @MARKETINGPLANID,
      @PARENTMARKETINGPLANITEMID,
      @LEVEL,
      @NAME,
      @PLANITEMCATEGORYCODEID,
      @STARTDATE,
      @ENDDATE,
      @GOALS,
      @BASECURRENCYID,
      @APPEALID,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
    )
  end try

  begin catch
    exec dbo.[USP_RAISE_ERROR];
    return 1;
  end catch

  return 0;