CREATE PROCEDURE [dbo].[XLedgerMarkTransactionsPostAsSuccess]
    @batchId int,
    @journalHeaders XLedgerTransactionHeaderInsertItem readonly,
    @journalHeaderMappings XLedgerTransactionHeaderMappingInsertItem readonly
AS
begin
    set nocount on
    insert into XLedgerTransactionHeader
    (
        XLedgerDbId,
        XLedgerJournalEntryBatchFid
    )
    select
        XLedgerDbId,
        @batchId
    from @journalHeaders JournalHeaders

    update XLedgerJournalEntryBatchItem set
        XLedgerTransactionHeaderFid = XLedgerTransactionHeader.XLedgerTransactionHeaderId
    from @journalHeaderMappings JournalHeaderMappings
    inner join XLedgerJournalEntryBatchItem on
        JournalHeaderMappings.XLedgerJournalEntryBatchItemId = XLedgerJournalEntryBatchItem.XLedgerJournalEntryBatchItemId
    inner join XLedgerTransactionHeader on JournalHeaderMappings.JournalHeaderXLedgerDbId = XLedgerTransactionHeader.XLedgerDbId
end
GO
GRANT EXECUTE ON  [dbo].[XLedgerMarkTransactionsPostAsSuccess] TO [MssExec]
GO