CREATE PROCEDURE [dbo].[MssWebDeleteOrderAddress]
    @inSysUserId int,
    @inOrderId int,
    @inAddressType varchar(50)
AS
begin
    set nocount on
        declare @theOrderAuditInfoId bigint
        declare @theUpdateSource varchar(6) = 'MS Web'

        declare @theAddressTypeId int = (select AddressType.AddressTypeID from AddressType where TypeName = @inAddressType )

        exec PrepOrderForAuditLog
            @inSysUserID = @inSysUserId,
            @inUpdateSource = @theUpdateSource,
            @outOrderAuditInfoFID = @theOrderAuditInfoId output
        
        update OrderAddress set
        OrderAuditInfoFID = @theOrderAuditInfoId,
        OrderAuditInfoManualCleanup = 1
        from OrderAddress
        where OrderFID = @inOrderId and
        AddressTypeFID = @theAddressTypeId

        delete from OrderAddress
        where OrderFID = @inOrderId and
        AddressTypeFID = @theAddressTypeId

        delete from OrderAuditInfo where OrderAuditInfoID = @theOrderAuditInfoId


end
GO
GRANT EXECUTE ON  [dbo].[MssWebDeleteOrderAddress] TO [MssExec]
GO