USP_CLEAR_BBPAYLOG

CREATE procedure dbo.USP_CLEAR_BBPAYLOG
(
@ID uniqueidentifier,
@ISCONFIRMED bit,
@ClearSalesOrderItem bit = 1
)
as
begin
  if(@ClearSalesOrderItem = 1)
  begin
      delete from dbo.SALESORDERBBPAYTRANSACTION where ID=@ID
      and TRANSACTIONCONFIRMED=@ISCONFIRMED;
      IF Exists (SELECT 1 from dbo.SALESORDERITEM where salesOrderId = @ID)
      BEGIN
      delete from dbo.SALESORDERITEM where salesorderid = @ID
      END
  end
  else -- for WI 1291889

  begin
      delete from dbo.SALESORDERBBPAYTRANSACTION where TRANSACTIONID = @ID
  end
end;