DBA Data[Home] [Help]

APPS.FA_MC_UTIL_PVT dependencies on AP_MC_INVOICE_DISTS

Line 409: -- for invoice is found in ap_mc_invoice_dists

405: -- of the invoice in AP
406: -- l_mc_inv_exchange_rate is the exchange rate used to
407: -- convert from transaction currency to reporting currency
408: -- l_result_code will be set to NOT_FOUND if no match
409: -- for invoice is found in ap_mc_invoice_dists
410: -- which means that reporting book is not set up as
411: -- conversion option for AP for the primary book in GL
412:
413: BEGIN

Line 425: ap_mc_invoice_dists b

421: l_mc_inv_exchange_date,
422: l_mc_inv_exchange_rate_type,
423: l_mc_line_base_amount
424: from ap_invoices_all a,
425: ap_mc_invoice_dists b
426: where a.invoice_id = p_inv_rec.invoice_id
427: and a.invoice_id = b.invoice_id
428: and b.distribution_line_number = p_inv_rec.ap_distribution_line_number
429: and b.set_of_books_id = p_set_of_books_id;

Line 442: value1 => 'ap_mc_invoice_dists',

438: fa_srvr_msg.add_message(
439: calling_fn => l_calling_fn,
440: name => 'FA_MRC_SLT_MC_RECS',
441: token1 => 'TABLE',
442: value1 => 'ap_mc_invoice_dists',
443: token2 => 'TRIGGER',
444: value2 => 'fa_mc_mass_additions_aiud', p_log_level_rec => p_log_level_rec);
445: raise error_found;
446: END;

Line 486: -- found invoice in ap_mc_invoice_dists for this reporting book

482: raise error_found;
483: END;
484:
485: if (l_result_code = 'FOUND') then
486: -- found invoice in ap_mc_invoice_dists for this reporting book
487:
488: if (l_line_base_amount = 0) then
489: l_exchange_rate := 1;
490: else

Line 495: -- invoice not found in ap_mc_invoice_dists table for reporting book

491: l_exchange_rate := (l_mc_line_base_amount/
492: l_line_base_amount);
493: end if;
494: else
495: -- invoice not found in ap_mc_invoice_dists table for reporting book
496: if (l_inv_currency_code <> l_currency_code) then
497:
498: l_exchange_date := l_inv_exchange_date;
499: l_exchange_rate := l_inv_exchange_rate;