USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATIONEXPORT_6

The save procedure used by the edit dataform template "Marketing Effort Export Edit Form 4".

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.
@DESCRIPTION	nvarchar(255)	IN	Description
@MAILEXPORTDEFINITIONID	uniqueidentifier	IN	Mail export definition
@EMAILEXPORTDEFINITIONID	uniqueidentifier	IN	Email export definition
@PHONEEXPORTDEFINITIONID	uniqueidentifier	IN	Phone export definition
@EXPORTACTIVESEGMENTS	bit	IN	Export active segments
@EXPORTINLINEEXCLUSIONS	bit	IN	Export exclusion segments
@INLINEEXCLUSIONEXPORTDEFINITIONID	uniqueidentifier	IN	Export definition

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATIONEXPORT_6]
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier = null,
  @DESCRIPTION nvarchar(255),
  @MAILEXPORTDEFINITIONID uniqueidentifier,
  @EMAILEXPORTDEFINITIONID uniqueidentifier,
  @PHONEEXPORTDEFINITIONID uniqueidentifier,
  @EXPORTACTIVESEGMENTS bit,
  @EXPORTINLINEEXCLUSIONS bit,
  @INLINEEXCLUSIONEXPORTDEFINITIONID uniqueidentifier
)
as
  set nocount on;

  begin try
    exec dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATIONEXPORTPROCESS_6]
      @ID,
      @CHANGEAGENTID,
      @DESCRIPTION,
      @MAILEXPORTDEFINITIONID,
      @EMAILEXPORTDEFINITIONID,
      @PHONEEXPORTDEFINITIONID,
      @EXPORTACTIVESEGMENTS,
      @EXPORTINLINEEXCLUSIONS,
      @INLINEEXCLUSIONEXPORTDEFINITIONID;

  end try

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

  return 0;