USP_DATAFORMTEMPLATE_EDIT_MKTMARKETINGPLANPROPERTIES

The save procedure used by the edit dataform template "Marketing Plan Properties 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.
@ITEMLIST	xml	IN	Items

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTMARKETINGPLANPROPERTIES]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @ITEMLIST xml
)
as
  set nocount on;

  begin try
    if @CHANGEAGENTID is null  
      exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

    -- needed for multi user --

    update
      dbo.[MKTMARKETINGPLAN]
    set
      [DATECHANGED]=GETDATE(),
      [CHANGEDBYID]=@CHANGEAGENTID
    where
      [ID]=@ID;

    -- save the template items

    if @ITEMLIST is not null
      exec dbo.USP_MKTMARKETINGPLAN_GETTEMPLATEITEMLIST_UPDATEFROMXML @ID, @ITEMLIST, @CHANGEAGENTID
  end try
  begin catch
    exec dbo.USP_RAISE_ERROR;
    return 1;
  end catch

  return 0;