DBA Data[Home] [Help]

APPS.FUN_NET_ARAP_PKG dependencies on GL_CURRENCY_API

Line 444: gl_currency_api.convert_amount_sql(rct.invoice_currency_code,

440:
441: l_trx_select_clause :=
442: 'SELECT rct.customer_trx_id,
443: fun_net_arap_pkg.Calculate_ar_trx_amt(rct.customer_trx_id) transaction_amount,
444: gl_currency_api.convert_amount_sql(rct.invoice_currency_code,
445: :batch_currency,
446: trunc(:SETTLEMENT_DATE),
447: :exchange_rate_type,
448: sum(arps.amount_due_remaining)) AS open_amount,

Line 661: gl_currency_api.convert_amount_sql(api.invoice_currency_code,

657: api.invoice_amount as transaction_amount,
658: nvl(api.exchange_rate,1),
659: fc.precision,
660: SUM(aps.amount_remaining),
661: gl_currency_api.convert_amount_sql(api.invoice_currency_code,
662: :batch_currency,
663: trunc(:SETTLEMENT_DATE),
664: :exchange_rate_type,
665: SUM(aps.amount_remaining)) AS open_amount,

Line 2498: IF gl_currency_api.rate_exists(

2494:
2495: END IF;
2496:
2497: IF l_exchange_rate_type IS NOT NULL THEN
2498: IF gl_currency_api.rate_exists(
2499: x_from_currency,
2500: x_to_currency,
2501: g_batch_details.settlement_date,
2502: g_batch_details.exchange_rate_type) = 'Y' THEN

Line 2503: x_exchange_rate := gl_currency_api.get_rate(

2499: x_from_currency,
2500: x_to_currency,
2501: g_batch_details.settlement_date,
2502: g_batch_details.exchange_rate_type) = 'Y' THEN
2503: x_exchange_rate := gl_currency_api.get_rate(
2504: x_from_currency,
2505: x_to_currency,
2506: g_batch_details.settlement_date,
2507: g_batch_details.exchange_rate_type);