CREATE PROCEDURE [dbo].[MssWebDeleteQuoteLineItem]
    @inOrderId int,
    @inQuoteId int,
    @inQuoteGroupId int
as
begin
    set nocount on;

    delete QuoteGroup
    from QuoteGroup
    inner join QuoteHeader on
        QuoteHeader.QuoteHeaderID = QuoteGroup.QuoteHeaderFID
        and QuoteHeader.OrdersFID = @inOrderId
        and QuoteHeader.QuoteHeaderID = @inQuoteId
    where QuoteGroup.QuoteGroupID = @inQuoteGroupId;

    exec MssWebResequenceQuoteGroupSortOrder @inQuoteId

    exec MssWebResetJobCostingOnAcceptedQuote @inOrderId,@inQuoteId
end;
GO
GRANT EXECUTE ON  [dbo].[MssWebDeleteQuoteLineItem] TO [MssExec]
GO