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 FND_CURRENCIES

Line 103: l_inv_currency fnd_currencies.currency_code%TYPE;

99: IS
100: l_exg_rate fun_net_batches_all.exchange_rate%TYPE;
101: l_exg_rate_1 fun_net_batches_all.exchange_rate%TYPE;
102: l_exchange_rate_type fun_net_batches_all.exchange_rate_type%TYPE;
103: l_inv_currency fnd_currencies.currency_code%TYPE;
104: l_precision fnd_currencies.precision%TYPE;
105: l_batch_currency fun_net_batches_all.BATCH_CURRENCY%TYPE;
106: l_settlement_date fun_net_batches_all.SETTLEMENT_DATE%TYPE;
107: l_exchange_rate fun_net_batches_all.EXCHANGE_RATE%TYPE;

Line 104: l_precision fnd_currencies.precision%TYPE;

100: l_exg_rate fun_net_batches_all.exchange_rate%TYPE;
101: l_exg_rate_1 fun_net_batches_all.exchange_rate%TYPE;
102: l_exchange_rate_type fun_net_batches_all.exchange_rate_type%TYPE;
103: l_inv_currency fnd_currencies.currency_code%TYPE;
104: l_precision fnd_currencies.precision%TYPE;
105: l_batch_currency fun_net_batches_all.BATCH_CURRENCY%TYPE;
106: l_settlement_date fun_net_batches_all.SETTLEMENT_DATE%TYPE;
107: l_exchange_rate fun_net_batches_all.EXCHANGE_RATE%TYPE;
108: l_org_id fun_net_batches_all.ORG_ID%TYPE;

Line 115: FROM ap_invoices_all api, fnd_currencies fc

111: l_path := g_path || 'Derive Converted Amount';
112: IF ap_ar='AP' THEN
113: SELECT fc.currency_code,fc.precision
114: INTO l_inv_currency,l_precision
115: FROM ap_invoices_all api, fnd_currencies fc
116: WHERE api.invoice_id = p_trx_id
117: AND api.invoice_currency_code = fc.currency_code;
118: ELSE
119: SELECT fc.currency_code,fc.precision

Line 121: FROM ra_customer_trx_all rct, fnd_currencies fc

117: AND api.invoice_currency_code = fc.currency_code;
118: ELSE
119: SELECT fc.currency_code,fc.precision
120: INTO l_inv_currency,l_precision
121: FROM ra_customer_trx_all rct, fnd_currencies fc
122: WHERE rct.customer_trx_id = p_trx_id
123: AND rct.invoice_currency_code = fc.currency_code;
124: END IF;
125: SELECT BATCH_CURRENCY,SETTLEMENT_DATE,EXCHANGE_RATE_TYPE,EXCHANGE_RATE,ORG_ID

Line 923: l_inv_from_clause := l_inv_from_clause || ', fnd_currencies fc ';

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 ';
924: l_inv_where_clause := l_inv_where_clause || ' AND api.invoice_currency_code = fc.currency_code ';
925: l_inv_group_by_clause := ' GROUP BY api.invoice_id,
926: api.invoice_amount,
927: nvl(api.exchange_rate,1),

Line 1041: TYPE precision_tab IS TABLE OF fnd_currencies.precision%TYPE INDEX BY BINARY_INTEGER;

1037: TYPE trx_type IS TABLE OF fun_net_ar_txns_all.customer_trx_id%TYPE INDEX BY BINARY_INTEGER;
1038: TYPE payment_num IS TABLE OF ap_payment_schedules_all.payment_num%TYPE INDEX BY BINARY_INTEGER;
1039: TYPE inv_rank IS TABLE OF fun_net_ap_invs_all.ap_txn_rank%TYPE INDEX BY BINARY_INTEGER;
1040: TYPE exchange_rate IS TABLE OF ap_invoices_all.exchange_rate%TYPE INDEX BY BINARY_INTEGER;
1041: TYPE precision_tab IS TABLE OF fnd_currencies.precision%TYPE INDEX BY BINARY_INTEGER;
1042: --l_invoice_id fun_net_ap_invs_all.invoice_id%TYPE;
1043: --l_invoice_amt fun_net_ap_invs_all.invoice_amt%TYPE;
1044: --l_open_amt fun_net_ap_invs_all.open_amt%TYPE;
1045: --l_inv_curr_open_amt fun_net_ap_invs_all.inv_curr_open_amt%TYPE;

Line 1657: l_inv_currency fnd_currencies.currency_code%TYPE;

1653: l_trx_id trx_type;
1654: l_inv_curr_open_amt amt_type;
1655: l_inv_curr_net_amt amt_type;
1656: l_amt_to_net fun_net_batches_all.total_netted_amt%TYPE;
1657: l_inv_currency fnd_currencies.currency_code%TYPE;
1658: l_precision fnd_currencies.precision%TYPE;
1659: l_sql_stmt Varchar2(150);
1660: l_net_amt_cur NUMBER;
1661: TYPE tnxCurTyp IS REF CURSOR;

Line 1658: l_precision fnd_currencies.precision%TYPE;

1654: l_inv_curr_open_amt amt_type;
1655: l_inv_curr_net_amt amt_type;
1656: l_amt_to_net fun_net_batches_all.total_netted_amt%TYPE;
1657: l_inv_currency fnd_currencies.currency_code%TYPE;
1658: l_precision fnd_currencies.precision%TYPE;
1659: l_sql_stmt Varchar2(150);
1660: l_net_amt_cur NUMBER;
1661: TYPE tnxCurTyp IS REF CURSOR;
1662: tnx_rec tnxCurTyp;

Line 1680: -- FROM ap_invoices_all api, fnd_currencies fc

1676: fun_net_util.Log_String(g_state_level,l_path,'Inside IF condition');
1677: --IF g_net_currency_rule = 'ACCOUNTING_CURRENCY' THEN
1678: -- SELECT fc.currency_code,fc.precision
1679: -- INTO l_inv_currency,l_precision
1680: -- FROM ap_invoices_all api, fnd_currencies fc
1681: -- WHERE api.invoice_id = l_trx_id(i)
1682: -- AND api.invoice_currency_code = fc.currency_code;
1683: --l_net_amt_cur := l_open_amt_afterdisc(i) * Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);
1684: --l_net_amt_cur := ROUND(l_net_amt_cur,l_precision);

Line 1707: FROM ap_invoices_all api, fnd_currencies fc

1703: IF g_net_currency_rule = 'ACCOUNTING_CURRENCY' THEN
1704: IF p_appln = 'AP' THEN
1705: SELECT fc.currency_code,fc.precision
1706: INTO l_inv_currency,l_precision
1707: FROM ap_invoices_all api, fnd_currencies fc
1708: WHERE api.invoice_id = l_trx_id(i)
1709: AND api.invoice_currency_code = fc.currency_code;
1710: ELSE
1711: SELECT fc.currency_code,fc.precision

Line 1713: FROM ra_customer_trx_all rct, fnd_currencies fc

1709: AND api.invoice_currency_code = fc.currency_code;
1710: ELSE
1711: SELECT fc.currency_code,fc.precision
1712: INTO l_inv_currency,l_precision
1713: FROM ra_customer_trx_all rct, fnd_currencies fc
1714: WHERE rct.customer_trx_id = l_trx_id(i)
1715: AND rct.invoice_currency_code = fc.currency_code;
1716: END IF;
1717: l_amt_to_net := round(l_amt_to_net * Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency),l_precision);

Line 1776: FROM ap_invoices_all api, fnd_currencies fc

1772: IF g_net_currency_rule = 'ACCOUNTING_CURRENCY' THEN
1773: IF p_appln = 'AP' THEN
1774: SELECT fc.currency_code,fc.precision
1775: INTO l_inv_currency,l_precision
1776: FROM ap_invoices_all api, fnd_currencies fc
1777: WHERE api.invoice_id = l_trx_id(i)
1778: AND api.invoice_currency_code = fc.currency_code;
1779: ELSE
1780: SELECT fc.currency_code,fc.precision

Line 1782: FROM ra_customer_trx_all rct, fnd_currencies fc

1778: AND api.invoice_currency_code = fc.currency_code;
1779: ELSE
1780: SELECT fc.currency_code,fc.precision
1781: INTO l_inv_currency,l_precision
1782: FROM ra_customer_trx_all rct, fnd_currencies fc
1783: WHERE rct.customer_trx_id = l_trx_id(i)
1784: AND rct.invoice_currency_code = fc.currency_code;
1785: END IF;
1786: l_applieddisc(i):=round(l_applieddisc(i) * Derive_Net_Exchg_Rate(l_inv_currency,g_func_currency),l_precision); -- from ACC CUR t BATCH CUR

Line 1793: FROM ap_invoices_all api, fnd_currencies fc

1789: /*IF g_net_currency_rule = 'ACCOUNTING_CURRENCY' THEN
1790: IF p_appln = 'AP' THEN
1791: SELECT fc.currency_code,fc.precision
1792: INTO l_inv_currency,l_precision
1793: FROM ap_invoices_all api, fnd_currencies fc
1794: WHERE api.invoice_id = l_trx_id(i)
1795: AND api.invoice_currency_code = fc.currency_code;
1796: l_exc_rate := Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);
1797: fun_net_util.Log_String(g_state_level,l_path,'l_exc_rate:'||l_exc_rate);

Line 1804: FROM ra_customer_trx_all rct, fnd_currencies fc

1800: l_inv_curr_net_amt(i) := ROUND(l_inv_curr_net_amt(i),l_precision);
1801: ELSIF p_appln = 'AR' THEN
1802: SELECT fc.currency_code,fc.precision
1803: INTO l_inv_currency,l_precision
1804: FROM ra_customer_trx_all rct, fnd_currencies fc
1805: WHERE rct.customer_trx_id = l_trx_id(i)
1806: AND rct.invoice_currency_code = fc.currency_code;
1807: l_inv_curr_net_amt(i) := l_net_amt(i) * Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);
1808: l_inv_curr_net_amt(i) := ROUND(l_inv_curr_net_amt(i),l_precision);

Line 2234: l_inv_currency fnd_currencies.currency_code%TYPE;

2230: l_trx_id trx_type;
2231: l_inv_curr_open_amt amt_type;
2232: l_inv_curr_net_amt amt_type;
2233: l_amt_to_net fun_net_batches_all.total_netted_amt%TYPE;
2234: l_inv_currency fnd_currencies.currency_code%TYPE;
2235: l_precision fnd_currencies.precision%TYPE;
2236: TYPE tnxCurTyp IS REF CURSOR;
2237: tnx_rec tnxCurTyp;
2238: l_path varchar2(100);

Line 2235: l_precision fnd_currencies.precision%TYPE;

2231: l_inv_curr_open_amt amt_type;
2232: l_inv_curr_net_amt amt_type;
2233: l_amt_to_net fun_net_batches_all.total_netted_amt%TYPE;
2234: l_inv_currency fnd_currencies.currency_code%TYPE;
2235: l_precision fnd_currencies.precision%TYPE;
2236: TYPE tnxCurTyp IS REF CURSOR;
2237: tnx_rec tnxCurTyp;
2238: l_path varchar2(100);
2239: BEGIN

Line 2264: FROM ap_invoices_all api, fnd_currencies fc

2260: IF g_net_currency_rule = 'ACCOUNTING_CURRENCY' THEN
2261: IF p_appln = 'AP' THEN
2262: SELECT fc.currency_code,fc.precision
2263: INTO l_inv_currency,l_precision
2264: FROM ap_invoices_all api, fnd_currencies fc
2265: WHERE api.invoice_id = l_trx_id(i)
2266: AND api.invoice_currency_code = fc.currency_code;
2267: l_exc_rate := Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);
2268: fun_net_util.Log_String(g_state_level,l_path,'l_exc_rate:'||l_exc_rate);

Line 2275: FROM ra_customer_trx_all rct, fnd_currencies fc

2271: l_inv_curr_net_amt(i) := ROUND(l_inv_curr_net_amt(i),l_precision);
2272: ELSIF p_appln = 'AR' THEN
2273: SELECT fc.currency_code,fc.precision
2274: INTO l_inv_currency,l_precision
2275: FROM ra_customer_trx_all rct, fnd_currencies fc
2276: WHERE rct.customer_trx_id = l_trx_id(i)
2277: AND rct.invoice_currency_code = fc.currency_code;
2278: l_inv_curr_net_amt(i) := l_amt_to_net * Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);
2279: l_inv_curr_net_amt(i) := ROUND(l_inv_curr_net_amt(i),l_precision);

Line 3273: TYPE currency_type IS TABLE OF fnd_currencies.currency_code%TYPE INDEX BY BINARY_INTEGER;

3269: l_path VARCHAR2(100);
3270: l_gl_date date; -- Bug: 7639863
3271: TYPE vendor_type IS TABLE OF po_vendors.vendor_id%TYPE INDEX BY BINARY_INTEGER;
3272: TYPE vendor_site_type IS TABLE OF po_vendor_sites_all.vendor_site_id%TYPE INDEX BY BINARY_INTEGER;
3273: TYPE currency_type IS TABLE OF fnd_currencies.currency_code%TYPE INDEX BY BINARY_INTEGER;
3274: TYPE ap_check_amt_type IS TABLE OF ap_checks.amount%TYPE INDEX BY BINARY_INTEGER;
3275: TYPE ap_invoice_type IS TABLE OF ap_invoices.invoice_id%TYPE INDEX BY BINARY_INTEGER;
3276: TYPE party_type IS TABLE OF ap_invoices_all.party_id%TYPE INDEX BY BINARY_INTEGER;
3277: TYPE party_site_type IS TABLE OF ap_invoices_all.party_site_id%TYPE INDEX BY BINARY_INTEGER;

Line 4088: FROM fnd_currencies fc

4084: fun_net_util.Log_String(g_state_level,l_path,'l_func_to_trans_rate:'||l_func_to_trans_rate);
4085: -- get the prcesion of the trx currency
4086: SELECT fc.precision
4087: INTO l_precision
4088: FROM fnd_currencies fc
4089: WHERE fc.currency_code = txnTable(i).invoice_currency_code;
4090: fun_net_util.Log_String(g_event_level,l_path
4091: ,'l_precision:' ||l_precision);
4092: -- End of Exchange related logic for bug 5463394