USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATIONEXPORT_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.
@SEGMENTATIONID	uniqueidentifier	IN	Marketing effort
@DESCRIPTION	nvarchar(255)	IN	Export description
@MAILEXPORTDEFINITIONID	uniqueidentifier	IN	Mail export definition
@EMAILEXPORTDEFINITIONID	uniqueidentifier	IN	Email export definition
@PHONEEXPORTDEFINITIONID	uniqueidentifier	IN	Phone export definition

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATIONEXPORT_4]
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @SEGMENTATIONID uniqueidentifier,
    @DESCRIPTION nvarchar(255),
    @MAILEXPORTDEFINITIONID uniqueidentifier,
    @EMAILEXPORTDEFINITIONID uniqueidentifier,
    @PHONEEXPORTDEFINITIONID uniqueidentifier
)

as
  set nocount on;

    declare @EXPORTACTIVESEGMENTS bit;
    declare @EXPORTINLINEEXCLUSIONS bit;
    declare @INLINEEXCLUSIONEXPORTDEFINITIONID uniqueidentifier;

  exec dbo.[USP_DATAFORMTEMPLATE_EDITLOAD_MKTSEGMENTATIONEXPORT_4]
        @ID = @ID,
        @EXPORTACTIVESEGMENTS = @EXPORTACTIVESEGMENTS output,
        @EXPORTINLINEEXCLUSIONS = @EXPORTINLINEEXCLUSIONS output,
        @INLINEEXCLUSIONEXPORTDEFINITIONID = @INLINEEXCLUSIONEXPORTDEFINITIONID output

  exec dbo.[USP_DATAFORMTEMPLATE_EDIT_MKTSEGMENTATIONEXPORT_6]
        @ID,
        @CHANGEAGENTID,
        @DESCRIPTION,
        @MAILEXPORTDEFINITIONID,
        @EMAILEXPORTDEFINITIONID,
        @PHONEEXPORTDEFINITIONID,
        @EXPORTACTIVESEGMENTS,
        @EXPORTINLINEEXCLUSIONS,
        @INLINEEXCLUSIONEXPORTDEFINITIONID

  return 0;