USP_BATCHPLEDGEWRITEOFF_DELETE

CREATE procedure dbo.USP_BATCHPLEDGEWRITEOFF_DELETE
(
  @ID uniqueidentifier,
  @CHANGEAGENTID uniqueidentifier
)
as
begin
  --check deletion rules, if any


  declare @SOURCEREVENUEID uniqueidentifier;
  declare @CURRENTDATE datetime = getdate();

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

  if not @CHANGEAGENTID is null
    set CONTEXT_INFO @CHANGEAGENTID;

  exec USP_BATCHPLEDGEWRITEOFF_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;

  if not @contextCache is null
    set CONTEXT_INFO @contextCache;

  return 0;
end