USP_MKTSEGMENTATIONEXCLUSION_DELETE

Deletes a removes members process and restores its effects.

Parameters

Parameter	Parameter Type	Mode	Description
@STATUSID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_MKTSEGMENTATIONEXCLUSION_DELETE
(
  @STATUSID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier
)
as
  set nocount on;

  exec dbo.USP_BUSINESSPROCESSSTATUS_VALIDATESTATUS;

  if exists (select [ID] from dbo.[BUSINESSPROCESSSTATUS]    where [ID] = @STATUSID and STATUSCODE = 1)
    raiserror('Business process is still running',13,1);

  declare @SEGMENTATIONEXCLUSIONID uniqueidentifier;
  select @SEGMENTATIONEXCLUSIONID = [ID] from dbo.[MKTSEGMENTATIONEXCLUSION] where [STATUSID] = @STATUSID;

  if @SEGMENTATIONEXCLUSIONID is not null
    exec dbo.USP_MKTSEGMENTATIONEXCLUSION_ROLLBACK @SEGMENTATIONEXCLUSIONID, @CHANGEAGENTID;

  exec dbo.USP_BUSINESSPROCESSSTATUS_DELETEBYID_WITHCHANGEAGENTID @STATUSID, @CHANGEAGENTID;

  return 0;