USP_DATAFORMTEMPLATE_EDIT_MKTMARKETINGPLANITEMDETAILS

The save procedure used by the edit dataform template "Marketing Plan Item Details Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@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_EDIT_MKTMARKETINGPLANITEMDETAILS]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @NAME nvarchar(100),
  @APPEALID nvarchar(20),
  @GOALS nvarchar(max),
  @PLANITEMCATEGORYCODEID uniqueidentifier,
  @STARTDATE dbo.[UDT_FUZZYDATE],
  @ENDDATE dbo.[UDT_FUZZYDATE]
)
as
  set nocount on;

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

  begin try
    update dbo.[MKTMARKETINGPLANITEM] set
      [NAME] = @NAME,
      [APPEALID] = @APPEALID,
      [GOALS] = @GOALS,
      [PLANITEMCATEGORYCODEID] = @PLANITEMCATEGORYCODEID,
      [STARTDATE] = @STARTDATE,
      [ENDDATE] = @ENDDATE,
      [CHANGEDBYID] = @CHANGEAGENTID,
      [DATECHANGED] = getdate()
    where [ID] = @ID;
  end try

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

  return 0;