create procedure [dbo].[MssWebUpdateQuoteLineItem]
(
    @inOrderId int,
    @inGroupId int,
    @inQuoteHeaderFID int,
    @inRateTypeFID int,
    @inItemCodeFID int,
    @inDescription varchar(128),
    @inRate money,
    @inQuantity decimal(10, 4),
    @inQuantity2 decimal(10, 4),
    @inCharge money,
    @inQuoteServiceProviderTypeFID int,
    @inVendorID varchar(15),
    @inVendorQuotedCharge money,
    @inVendorActualCharge money,
    @inSortOrder int,
    @inPONumber varchar(20),
    @inInvoiceNumber varchar(20),
    @inServiceDate datetime,
    @inNoteText varchar(1024),
    @inLaborRatingType varchar(50) = null,
    @inQuoteServiceProviderBillToFID int,
    @inRateSource varchar(50),
    @inRateSourceRecord int,
    @inExternalVendorID varchar(15),
    @inExternalVendorName varchar(40),
    @inAccountingVendorFid int
)
as
set nocount on

begin
    update QuoteGroup
    set
        QuoteHeaderFID = @inQuoteHeaderFID,
        RateTypeFID = @inRateTypeFID,
        ItemCodeFID = @inItemCodeFID,
        [Description] = @inDescription,
        Rate = @inRate,
        Quantity = @inQuantity,
        Quantity2 = @inQuantity2,
        Charge = @inCharge,
        QuoteServiceProviderTypeFID = @inQuoteServiceProviderTypeFID,
        VendorID = @inVendorID,
        VendorQuotedCharge = @inVendorQuotedCharge,
        VendorActualCharge = @inVendorActualCharge,
        PONumber = @inPONumber,
        InvoiceNumber = @inInvoiceNumber,
        ServiceDate = @inServiceDate,
        NoteText = @inNoteText,
        SortOrder = @inSortOrder,
        LaborRatingTypeFID = (
            select top 1 LaborRatingTypeID
            from LaborRatingType
            where TypeName = @inLaborRatingType
        ),
        QuoteServiceProviderBillToFID = @inQuoteServiceProviderBillToFID,
        RateSource = @inRateSource,
        RateSourceRecord = @inRateSourceRecord,
        ExternalVendorID = @inExternalVendorID,
        ExternalVendorName = @inExternalVendorName,
        AccountingVendorFid = @inAccountingVendorFid
    from QuoteGroup
    inner join QuoteHeader
        on QuoteHeader.QuoteHeaderID = QuoteGroup.QuoteHeaderFID
        and QuoteHeader.OrdersFID = @inOrderId
    where QuoteGroup.QuoteGroupID = @inGroupId

    exec MssWebResetJobCostingOnAcceptedQuote @inOrderId,@inQuoteHeaderFID

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