[Home] [Help]
454: p_denominator_rate IN NUMBER,
455: p_mau IN NUMBER,
456: p_precision IN NUMBER) IS
457: /* ************************************************************************
458: This procedure will select all the rows in fa_asset_invoices for each
459: asset being converted and insert them into fa_mc_asset_invoices.
460: All amount columns will be
461: converted either with the exchange rate or a derived rate of
462: cost/primary_cur_cost based on the conversion basis of R or C.
469: BEGIN
470:
471: if (g_print_debug) then
472: fa_debug_pkg.add('convert_assets',
473: 'Converting FA_ASSET_INVOICES records',
474: 'start');
475: end if;
476:
477: SELECT book_class
478: INTO l_book_class
479: FROM fa_book_controls
480: WHERE book_type_code = p_book_type_code;
481:
482: -- Only convert fa_asset_invoices when run for corporate books. When
483: -- run for tax books can result in duplicate invoice lines in
484: -- reporting book
485: IF (l_book_class = 'CORPORATE') THEN
486: INSERT INTO fa_mc_asset_invoices(
676: ai.invoice_distribution_id,
677: ai.invoice_line_number,
678: ai.po_distribution_id
679: FROM
680: fa_asset_invoices ai,
681: fa_mc_conversion_rates cr
682: WHERE
683: ai.asset_id = cr.asset_id AND
684: cr.set_of_books_id = p_rsob_id AND
688: END IF; -- l_book_class
689:
690: if (g_print_debug) then
691: fa_debug_pkg.add('convert_assets',
692: 'Converted FA_ASSET_INVOICES records',
693: 'success');
694: end if;
695:
696: