eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FUN_NET_ARAP_PKG dependencies on GL_CURRENCY_API

Line 138: IF gl_currency_api.rate_exists(

134: FROM ap_system_parameters_all
135: WHERE org_id = l_org_id;
136: END IF;
137: IF ((l_exchange_rate_type IS NOT NULL) AND (l_exchange_rate_type<>'User'))THEN
138: IF gl_currency_api.rate_exists(
139: l_batch_currency, -- From currency
140: l_inv_currency, -- To Currency
141: l_settlement_date,
142: l_exchange_rate_type) = 'Y' THEN

Line 143: l_exg_rate := gl_currency_api.get_rate(

139: l_batch_currency, -- From currency
140: l_inv_currency, -- To Currency
141: l_settlement_date,
142: l_exchange_rate_type) = 'Y' THEN
143: l_exg_rate := gl_currency_api.get_rate(
144: l_batch_currency, -- From currency
145: l_inv_currency, -- To Currency
146: l_settlement_date,
147: l_exchange_rate_type);

Line 149: RETURN round(gl_currency_api.convert_closest_amount_sql(l_inv_currency,l_batch_currency,trunc(l_settlement_date),l_exchange_rate_type,l_exg_rate,p_amount,0),l_precision);

145: l_inv_currency, -- To Currency
146: l_settlement_date,
147: l_exchange_rate_type);
148: ELSIF(l_exchange_rate_type='User') THEN
149: RETURN round(gl_currency_api.convert_closest_amount_sql(l_inv_currency,l_batch_currency,trunc(l_settlement_date),l_exchange_rate_type,l_exg_rate,p_amount,0),l_precision);
150: ELSE
151: RETURN null;
152: END IF;
153: END IF;

Line 216: l_applieddisc := gl_currency_api.convert_amount_sql(l_invoice_currency_code,

212: select INVOICE_CURRENCY_CODE
213: into l_invoice_currency_code
214: from AP_INVOICES_ALL
215: where INVOICE_ID = p_invoice_id;
216: l_applieddisc := gl_currency_api.convert_amount_sql(l_invoice_currency_code,
217: l_currency_code,
218: trunc(l_settlement_date),
219: l_exchange_rate_type,
220: l_applieddisc);

Line 292: l_applieddisc := gl_currency_api.convert_amount_sql(l_invoice_currency_code,

288: select INVOICE_CURRENCY_CODE
289: into l_invoice_currency_code
290: from RA_CUSTOMER_TRX_ALL
291: where CUSTOMER_TRX_ID = p_cust_txn_id;
292: l_applieddisc := gl_currency_api.convert_amount_sql(l_invoice_currency_code,
293: l_currency_code,
294: trunc(l_settlement_date),
295: l_exchange_rate_type,
296: l_applieddisc);

Line 618: gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,

614: IF l_allow_disc_flag='N' THEN -- FOR NON ESD AGREEMENTS
615: l_trx_select_clause :=
616: 'SELECT rct.customer_trx_id,
617: fun_net_arap_pkg.Calculate_ar_trx_amt(rct.customer_trx_id) transaction_amount,
618: gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,
619: :batch_currency,
620: trunc(:SETTLEMENT_DATE),
621: :exchange_rate_type,
622: :exchange_rate,

Line 630: gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,

626: ELSE -- FOR ESD ENABLED AGREEMENTS,Calculating OPEN_AMOUNT_AFTERDISC for ESD enabled Agreements
627: l_trx_select_clause :=
628: 'SELECT rct.customer_trx_id,
629: fun_net_arap_pkg.Calculate_ar_trx_amt(rct.customer_trx_id) transaction_amount,
630: gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,
631: :batch_currency,
632: trunc(:SETTLEMENT_DATE),
633: :exchange_rate_type,
634: :exchange_rate,

Line 638: ((gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,SUM(arps.amount_due_remaining),:max_roll_days))

634: :exchange_rate,
635: sum(arps.amount_due_remaining),
636: :max_roll_days) AS open_amount,
637: sum(arps.amount_due_remaining) AS txn_curr_open_amt,
638: ((gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,SUM(arps.amount_due_remaining),:max_roll_days))
639: -(gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,
640: SUM(ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(arps.PAYMENT_SCHEDULE_ID,:SETTLEMENT_DATE,NULL)),:max_roll_days))) AS OPEN_AMOUNT_AFTERDISC,
641: sum(arps.amount_due_remaining - ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(arps.PAYMENT_SCHEDULE_ID,:SETTLEMENT_DATE,NULL)) AS TXN_CURR_OPEN_AMOUNT_AFTERDISC'; -- ADDED FOR ESD ENABLED AGREEMENTS
642: END IF;

Line 639: -(gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,

635: sum(arps.amount_due_remaining),
636: :max_roll_days) AS open_amount,
637: sum(arps.amount_due_remaining) AS txn_curr_open_amt,
638: ((gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,SUM(arps.amount_due_remaining),:max_roll_days))
639: -(gl_currency_api.convert_closest_amount_sql(rct.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,
640: SUM(ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(arps.PAYMENT_SCHEDULE_ID,:SETTLEMENT_DATE,NULL)),:max_roll_days))) AS OPEN_AMOUNT_AFTERDISC,
641: sum(arps.amount_due_remaining - ARP_DISCOUNTS_API.Get_Available_Disc_On_Inv(arps.PAYMENT_SCHEDULE_ID,:SETTLEMENT_DATE,NULL)) AS TXN_CURR_OPEN_AMOUNT_AFTERDISC'; -- ADDED FOR ESD ENABLED AGREEMENTS
642: END IF;
643: l_trx_group_by_clause := l_trx_group_by_clause ||

Line 892: gl_currency_api.convert_closest_amount_sql(api.invoice_currency_code,

888: api.invoice_amount as transaction_amount,
889: nvl(api.exchange_rate,1),
890: fc.precision,
891: SUM(aps.amount_remaining),
892: gl_currency_api.convert_closest_amount_sql(api.invoice_currency_code,
893: :batch_currency,
894: trunc(:SETTLEMENT_DATE),
895: :exchange_rate_type,
896: :exchange_rate,

Line 909: gl_currency_api.convert_closest_amount_sql(api.invoice_currency_code,

905: api.invoice_amount as transaction_amount,
906: nvl(api.exchange_rate,1),
907: fc.precision,
908: SUM(aps.amount_remaining),
909: gl_currency_api.convert_closest_amount_sql(api.invoice_currency_code,
910: :batch_currency,
911: trunc(:SETTLEMENT_DATE),
912: :exchange_rate_type,
913: :exchange_rate,

Line 918: ((gl_currency_api.convert_closest_amount_sql(api.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,SUM(aps.amount_remaining),:max_roll_days))

914: SUM(aps.amount_remaining),
915: :max_roll_days) AS open_amount,
916: min(aps.payment_num),
917: max(aps.payment_num),
918: ((gl_currency_api.convert_closest_amount_sql(api.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,SUM(aps.amount_remaining),:max_roll_days))
919: -(gl_currency_api.convert_closest_amount_sql(api.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,
920: SUM(AP_PAYMENT_PUBLIC_PKG.Get_Disc_For_Pmt_Schedule(api.invoice_id,aps.payment_num,to_date(:SETTLEMENT_DATE))),:max_roll_days))) OPEN_AMOUNT_AFTERDISC,
921: sum(aps.amount_remaining - AP_PAYMENT_PUBLIC_PKG.Get_Disc_For_Pmt_Schedule(api.invoice_id,aps.payment_num,:SETTLEMENT_DATE)) AS TXN_CURR_OPEN_AMOUNT_AFTERDISC';
922: END IF;

Line 919: -(gl_currency_api.convert_closest_amount_sql(api.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,

915: :max_roll_days) AS open_amount,
916: min(aps.payment_num),
917: max(aps.payment_num),
918: ((gl_currency_api.convert_closest_amount_sql(api.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,SUM(aps.amount_remaining),:max_roll_days))
919: -(gl_currency_api.convert_closest_amount_sql(api.invoice_currency_code,:batch_currency,trunc(:SETTLEMENT_DATE),:exchange_rate_type,:exchange_rate,
920: SUM(AP_PAYMENT_PUBLIC_PKG.Get_Disc_For_Pmt_Schedule(api.invoice_id,aps.payment_num,to_date(:SETTLEMENT_DATE))),:max_roll_days))) OPEN_AMOUNT_AFTERDISC,
921: sum(aps.amount_remaining - AP_PAYMENT_PUBLIC_PKG.Get_Disc_For_Pmt_Schedule(api.invoice_id,aps.payment_num,:SETTLEMENT_DATE)) AS TXN_CURR_OPEN_AMOUNT_AFTERDISC';
922: END IF;
923: l_inv_from_clause := l_inv_from_clause || ', fnd_currencies fc ';

Line 3191: IF gl_currency_api.rate_exists(

3187: FROM ap_system_parameters_all
3188: WHERE org_id = g_batch_details.org_id;
3189: END IF;
3190: IF l_exchange_rate_type IS NOT NULL THEN
3191: IF gl_currency_api.rate_exists(
3192: x_from_currency,
3193: x_to_currency,
3194: g_batch_details.settlement_date,
3195: g_batch_details.exchange_rate_type) = 'Y' THEN

Line 3196: x_exchange_rate := gl_currency_api.get_rate(

3192: x_from_currency,
3193: x_to_currency,
3194: g_batch_details.settlement_date,
3195: g_batch_details.exchange_rate_type) = 'Y' THEN
3196: x_exchange_rate := gl_currency_api.get_rate(
3197: x_from_currency,
3198: x_to_currency,
3199: g_batch_details.settlement_date,
3200: g_batch_details.exchange_rate_type);

Line 3396: gl_currency_api.convert_amount_sql(

3392: SELECT
3393: inv.invoice_id AS invoice_id,
3394: apps.payment_num AS payment_num,
3395: finv.inv_curr_net_amt AS pymt_amt,
3396: gl_currency_api.convert_amount_sql(
3397: inv.invoice_currency_code,
3398: g_batch_details.batch_currency,
3399: g_batch_details.settlement_date,
3400: g_batch_details.exchange_rate_type,