USP_APPEALMAILINGACTIVATEPROCESSOFFERCOUNT_DELETE

Deletes the entry for an appeal mailing's offer count.

Parameters

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

Definition

Copy



create procedure dbo.[USP_APPEALMAILINGACTIVATEPROCESSOFFERCOUNT_DELETE]
(
  @MKTSEGMENTATIONACTIVATEPROCESSSTATUSID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier
)
as
  --Cache CONTEXT INFO

  declare @contextCache varbinary(128);
  set @contextCache = CONTEXT_INFO();

  if not @CHANGEAGENTID is null
    set CONTEXT_INFO @CHANGEAGENTID;

  delete from dbo.[APPEALMAILINGACTIVATEPROCESSOFFERCOUNT]
  where [MKTSEGMENTATIONACTIVATEPROCESSSTATUSID] = @MKTSEGMENTATIONACTIVATEPROCESSSTATUSID;

  --Restore CONTEXT INFO 

  if not @contextCache is null
    set CONTEXT_INFO @contextCache;