USP_DATAFORMTEMPLATE_ADD_MKTMARKETINGPLANMAILING

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

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.
@PARENTMARKETINGPLANITEMID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@LEVEL	int	IN	Level
@MARKETINGPLANID	uniqueidentifier	IN	Marketing plan item
@NAME	nvarchar(100)	IN	Name
@CODE	nvarchar(10)	IN	Code
@GOALS	nvarchar(max)	IN	Goals
@PLANITEMCATEGORYCODEID	uniqueidentifier	IN	Category
@STARTDATE	UDT_FUZZYDATE	IN	Start date
@ENDDATE	UDT_FUZZYDATE	IN	End date
@SOURCECODEID	uniqueidentifier	IN	Source code
@ITEMLIST	xml	IN	Items
@MAILDATE	datetime	IN	Date
@CODEVALUEID	uniqueidentifier	IN	Code value ID

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTMARKETINGPLANMAILING]
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,
  @PARENTMARKETINGPLANITEMID uniqueidentifier ,
  @LEVEL integer = null,
  @MARKETINGPLANID uniqueidentifier = null, 
  @NAME nvarchar(100) = '',
  @CODE nvarchar(10) = '',
  @GOALS nvarchar(max) = '',
  @PLANITEMCATEGORYCODEID uniqueidentifier = null, 
  @STARTDATE dbo.UDT_FUZZYDATE = null,
  @ENDDATE dbo.UDT_FUZZYDATE = null,
  @SOURCECODEID uniqueidentifier = null, 
  @ITEMLIST xml = null,
  @MAILDATE datetime = null,
  @CODEVALUEID uniqueidentifier = null
)
as

  set nocount on;

  declare @CURRENTDATE datetime;

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

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

  set @CURRENTDATE = getdate();

  begin try
    -- create the plan item

    insert into dbo.[MKTMARKETINGPLANITEM] (
      [ID],
      [PARENTMARKETINGPLANITEMID],
      [LEVEL],
      [MARKETINGPLANID],
      [NAME],
      [CODE],
      [PARTDEFINITIONVALUESID],
      [GOALS],
      [PLANITEMCATEGORYCODEID],
      [STARTDATE],
      [ENDDATE],
      [SOURCECODEID],
      [MAILDATE],
      [ADDEDBYID],
      [CHANGEDBYID],
      [DATEADDED],
      [DATECHANGED]
    ) values (
      @ID,
      @PARENTMARKETINGPLANITEMID,
      @LEVEL,
      @MARKETINGPLANID,
      @NAME,
      @CODE,
      @CODEVALUEID,
      @GOALS,
      @PLANITEMCATEGORYCODEID,
      @STARTDATE,
      @ENDDATE,
      @SOURCECODEID,
      @MAILDATE,
      @CHANGEAGENTID,
      @CHANGEAGENTID,
      @CURRENTDATE,
      @CURRENTDATE
    );

    /* save the source code information */
    exec dbo.[USP_MKTPLANSOURCECODEPART_GETITEMLIST_UPDATEFROMXML] @ID, @ITEMLIST, @CHANGEAGENTID, @CURRENTDATE;

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

  return 0;