CREATE PROCEDURE [dbo].[XLedgerMarkTransactionsPostAsSuccess]
    @journalHeaders XLedgerJournalHeaderInsertItem readonly,
    @journalHeaderMappings XLedgerJournalHeaderMappingInsertItem readonly
AS
begin
    set nocount on
    insert into XLedgerJournalHeader
    (
        XLedgerDbId
    )
    select XLedgerDbId
    from @journalHeaders JournalHeaders

    update XLedgerJournalEntryBatchItem set
        XLedgerJournalHeaderFid = XLedgerJournalHeader.XLedgerJournalHeaderId
    from @journalHeaderMappings JournalHeaderMappings
    inner join XLedgerJournalEntryBatchItem on
        JournalHeaderMappings.XLedgerJournalEntryBatchItemId = XLedgerJournalEntryBatchItem.XLedgerJournalEntryBatchItemId
    inner join XLedgerJournalHeader on JournalHeaderMappings.JournalHeaderXLedgerDbId = XLedgerJournalHeader.XLedgerDbId


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