USP_SIMPLEACKNOWLEDGEMENT_HISTORYDELETE

Deletes acknowledgement process history and optionally removes letter history from associated revenue records.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DELETELETTERHISTORY	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN

Definition

Copy



create procedure dbo.USP_SIMPLEACKNOWLEDGEMENT_HISTORYDELETE
(
    @ID uniqueidentifier,
  @DELETELETTERHISTORY bit,
    @CHANGEAGENTID uniqueidentifier
)
as begin

  declare @contextCache varbinary(128);

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

    /* cache current context information */
    set @contextCache = CONTEXT_INFO();

    /* set CONTEXT_INFO to @CHANGEAGENTID */    
    set CONTEXT_INFO @CHANGEAGENTID

  if @DELETELETTERHISTORY = 1 
    begin
      delete from dbo.REVENUELETTER where MKTSEGMENTATIONACTIVATEPROCESSSTATUSID = @ID
    end
  else
    begin
      update 
        dbo.REVENUELETTER
      set
        MKTSEGMENTATIONACTIVATEPROCESSSTATUSID = null,
        CHANGEDBYID = @CHANGEAGENTID,
        DATECHANGED = getdate()
      where
        MKTSEGMENTATIONACTIVATEPROCESSSTATUSID = @ID
    end    

  /* reset CONTEXT_INFO to previous value */
    if not @contextCache is null
        set CONTEXT_INFO @contextCache

    -- use the system generated delete routine to allow proper recording of the deleting agent

    exec dbo.USP_BUSINESSPROCESSSTATUS_DELETE @ID, @CHANGEAGENTID

    return 0;    
end