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.GL_CURRENCY_API dependencies on GL_LEDGERS

Line 776: -- Get to_currency from GL_LEDGERS, i.e. the functional currency

772: to_currency VARCHAR2(15);
773: rate NUMBER;
774:
775: BEGIN
776: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
777: SELECT currency_code
778: INTO to_currency
779: FROM GL_LEDGERS
780: WHERE ledger_id = x_set_of_books_id;

Line 779: FROM GL_LEDGERS

775: BEGIN
776: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
777: SELECT currency_code
778: INTO to_currency
779: FROM GL_LEDGERS
780: WHERE ledger_id = x_set_of_books_id;
781:
782: -- Call get_rate() with the to_currency we get from the ledger
783: rate := get_rate( x_from_currency, to_currency, x_conversion_date,

Line 1037: -- Get to_currency from GL_LEDGERS, i.e. the functional currency

1033: to_currency VARCHAR2(15);
1034: rate NUMBER;
1035:
1036: BEGIN
1037: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
1038: SELECT currency_code
1039: INTO to_currency
1040: FROM GL_LEDGERS
1041: WHERE ledger_id = x_set_of_books_id;

Line 1040: FROM GL_LEDGERS

1036: BEGIN
1037: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
1038: SELECT currency_code
1039: INTO to_currency
1040: FROM GL_LEDGERS
1041: WHERE ledger_id = x_set_of_books_id;
1042:
1043: -- Call get_closest_rate() with the to_currency we get from the Ledgers
1044: rate := get_closest_rate( x_from_currency,

Line 1310: -- Get to_currency from GL_LEDGERS, i.e. the functional currency

1306: to_currency VARCHAR2(15);
1307: converted_amount NUMBER;
1308:
1309: BEGIN
1310: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
1311: SELECT currency_code
1312: INTO to_currency
1313: FROM GL_LEDGERS
1314: WHERE ledger_id = x_set_of_books_id;

Line 1313: FROM GL_LEDGERS

1309: BEGIN
1310: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
1311: SELECT currency_code
1312: INTO to_currency
1313: FROM GL_LEDGERS
1314: WHERE ledger_id = x_set_of_books_id;
1315:
1316: -- Call convert_amount() with the to_currency we get from the Ledger
1317: converted_amount := convert_amount( x_from_currency, to_currency,

Line 1679: -- Get to_currency from GL_LEDGERS, i.e. the functional currency

1675: to_currency VARCHAR2(15);
1676: numerator NUMBER;
1677:
1678: BEGIN
1679: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
1680: SELECT currency_code
1681: INTO to_currency
1682: FROM GL_LEDGERS
1683: WHERE ledger_id = x_set_of_books_id;

Line 1682: FROM GL_LEDGERS

1678: BEGIN
1679: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
1680: SELECT currency_code
1681: INTO to_currency
1682: FROM GL_LEDGERS
1683: WHERE ledger_id = x_set_of_books_id;
1684:
1685: -- Call get_rate_numerator_sql() with the to_currency we get from the Ledger
1686: numerator := get_rate_numerator_sql( x_from_currency,

Line 1788: -- Get to_currency from GL_LEDGERS, i.e. the functional currency

1784: to_currency VARCHAR2(15);
1785: denominator NUMBER;
1786:
1787: BEGIN
1788: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
1789: SELECT currency_code
1790: INTO to_currency
1791: FROM GL_LEDGERS
1792: WHERE ledger_id = x_set_of_books_id;

Line 1791: FROM GL_LEDGERS

1787: BEGIN
1788: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
1789: SELECT currency_code
1790: INTO to_currency
1791: FROM GL_LEDGERS
1792: WHERE ledger_id = x_set_of_books_id;
1793:
1794: -- Call get_rate_denominator_sql() with the to_currency we get from Ledger
1795: denominator := get_rate_denominator_sql( x_from_currency,

Line 1899: -- Get to_currency from GL_LEDGERS, i.e. the functional currency

1895:
1896: to_currency VARCHAR2(15);
1897:
1898: BEGIN
1899: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
1900: SELECT currency_code
1901: INTO to_currency
1902: FROM GL_LEDGERS
1903: WHERE ledger_id = x_set_of_books_id;

Line 1902: FROM GL_LEDGERS

1898: BEGIN
1899: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
1900: SELECT currency_code
1901: INTO to_currency
1902: FROM GL_LEDGERS
1903: WHERE ledger_id = x_set_of_books_id;
1904:
1905: -- Get value of numerator and denominator
1906: x_numerator := get_rate_numerator_sql( x_from_currency,

Line 2087: -- Get to_currency from GL_LEDGERS, i.e. the functional currency

2083: to_currency VARCHAR2(15);
2084: numerator NUMBER;
2085:
2086: BEGIN
2087: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
2088: SELECT currency_code
2089: INTO to_currency
2090: FROM GL_LEDGERS
2091: WHERE ledger_id = x_set_of_books_id;

Line 2090: FROM GL_LEDGERS

2086: BEGIN
2087: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
2088: SELECT currency_code
2089: INTO to_currency
2090: FROM GL_LEDGERS
2091: WHERE ledger_id = x_set_of_books_id;
2092:
2093: -- Call get_closest_rate() with the to_currency we get from the Ledger
2094: numerator := get_closest_rate_numerator_sql( x_from_currency,

Line 2204: -- Get to_currency from GL_LEDGERS, i.e. the functional currency

2200: to_currency VARCHAR2(15);
2201: denominator NUMBER;
2202:
2203: BEGIN
2204: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
2205: SELECT currency_code
2206: INTO to_currency
2207: FROM GL_LEDGERS
2208: WHERE ledger_id = x_set_of_books_id;

Line 2207: FROM GL_LEDGERS

2203: BEGIN
2204: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
2205: SELECT currency_code
2206: INTO to_currency
2207: FROM GL_LEDGERS
2208: WHERE ledger_id = x_set_of_books_id;
2209:
2210: -- Call get_closest_rate_denom_sql() with the to_currency
2211: -- we get from the Ledger

Line 2314: -- Get to_currency from GL_LEDGERS, i.e. the functional currency

2310:
2311: to_currency VARCHAR2(15);
2312:
2313: BEGIN
2314: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
2315: SELECT currency_code
2316: INTO to_currency
2317: FROM GL_LEDGERS
2318: WHERE ledger_id = x_set_of_books_id;

Line 2317: FROM GL_LEDGERS

2313: BEGIN
2314: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
2315: SELECT currency_code
2316: INTO to_currency
2317: FROM GL_LEDGERS
2318: WHERE ledger_id = x_set_of_books_id;
2319:
2320: -- Get value of numerator and denominator
2321: x_numerator := get_closest_rate_numerator_sql( x_from_currency,

Line 2454: -- Get to_currency from GL_LEDGERS, i.e. the functional currency

2450: to_mau NUMBER;
2451: to_type VARCHAR2(8);
2452:
2453: BEGIN
2454: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
2455: SELECT currency_code
2456: INTO to_currency
2457: FROM GL_LEDGERS
2458: WHERE ledger_id = x_set_of_books_id;

Line 2457: FROM GL_LEDGERS

2453: BEGIN
2454: -- Get to_currency from GL_LEDGERS, i.e. the functional currency
2455: SELECT currency_code
2456: INTO to_currency
2457: FROM GL_LEDGERS
2458: WHERE ledger_id = x_set_of_books_id;
2459:
2460: -- Get currency information from the to_currency ( for use in rounding )
2461: get_info ( to_currency, x_conversion_date, to_rate, to_mau, to_type );