[Home] [Help]
514: p_denominator_rate IN NUMBER,
515: p_mau IN NUMBER,
516: p_precision IN NUMBER) IS
517: /* ************************************************************************
518: This procedure will select all the rows in fa_asset_invoices for each
519: asset being converted and insert them into fa_mc_asset_invoices.
520: All amount columns will be
521: converted either with the exchange rate or a derived rate of
522: cost/primary_cur_cost based on the conversion basis of R or C.
529: BEGIN
530:
531: if (g_print_debug) then
532: fa_debug_pkg.add('convert_assets',
533: 'Converting FA_ASSET_INVOICES records',
534: 'start');
535: end if;
536:
537: SELECT book_class
538: INTO l_book_class
539: FROM fa_book_controls
540: WHERE book_type_code = p_book_type_code;
541:
542: -- Only convert fa_asset_invoices when run for corporate books. When
543: -- run for tax books can result in duplicate invoice lines in
544: -- reporting book
545: IF (l_book_class = 'CORPORATE') THEN
546: INSERT INTO fa_mc_asset_invoices(
737: ai.invoice_distribution_id,
738: ai.invoice_line_number,
739: ai.po_distribution_id
740: FROM
741: fa_asset_invoices ai,
742: fa_mc_conversion_rates cr
743: WHERE
744: ai.asset_id = cr.asset_id AND
745: cr.set_of_books_id = p_rsob_id AND
749: END IF; -- l_book_class
750:
751: if (g_print_debug) then
752: fa_debug_pkg.add('convert_assets',
753: 'Converted FA_ASSET_INVOICES records',
754: 'success');
755: end if;
756:
757: