USP_BBISTRANSACTIONEXCEPTION_DELETE

CREATE procedure dbo.USP_BBISTRANSACTIONEXCEPTION_DELETE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
)
as begin
    declare @BBNCTRANID int, @TRANIDFORTYPE int, @TRANSACTIONTYPE nvarchar(200)

  select @BBNCTRANID = BBNCTRANID from BBNCTRANSACTIONDOWNLOADEXCEPTION where ID = @ID

  select @TRANSACTIONTYPE = TRANSACTIONTYPE, @TRANIDFORTYPE = TRANSACTIONID from TRANSACTIONS where ID = @BBNCTRANID

  exec spTransactions_MarkTransactionAsProcessed @BBNCTRANID

  if @TRANSACTIONTYPE = '{5F84002B-ABB1-4f50-A244-D4B14FBB1579}' 
  begin
    exec spTransactions_DeleteSignup @TRANIDFORTYPE
  end
  else if @TRANSACTIONTYPE = '{DCEAFCC7-0290-488e-A194-953DE66D6AAB}' 
  begin
    exec spTransactions_DeleteProfileUpdate @TRANIDFORTYPE
  end
  else if @TRANSACTIONTYPE = '{5705B543-4033-4a3a-BBCD-A731403EE1E6}' 
  begin
    exec spTransactions_DeleteDonation @TRANIDFORTYPE
  end
  else if @TRANSACTIONTYPE = '{172A5D9A-5241-493C-A2C2-EAC164C095B0}' 
  begin
    exec spTransactions_DeleteEventReg @TRANIDFORTYPE
  end
  else if @TRANSACTIONTYPE = '{D7D6143F-823D-4c74-AC2F-947CC96B7008}' 
  begin
    exec spTransactions_DeleteMembership @TRANIDFORTYPE
  end


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

    exec USP_BBNCTRANSACTIONDOWNLOADEXCEPTION_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
    return 0;

end