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.HR_CURRENCY_PKG dependencies on FND_CURRENCIES

Line 9: TYPE tl_efc_currency_code IS TABLE OF fnd_currencies.currency_code%TYPE

5: -- the add_to_efc_currency_list procedure, efc_convert_number_amount,
6: -- efc_convert_varchar2_amount and efc_is_ncu_currency functions. This
7: -- provides a cache of values required by the EFC conversion process.
8: --
9: TYPE tl_efc_currency_code IS TABLE OF fnd_currencies.currency_code%TYPE
10: INDEX BY BINARY_INTEGER;
11: g_efc_currency_code tl_efc_currency_code;
12: g_rate_currency_code_tab tl_efc_currency_code;
13: g_rate_empty_currency_tab tl_efc_currency_code;

Line 15: TYPE tl_efc_derive_factor IS TABLE OF fnd_currencies.derive_factor%TYPE

11: g_efc_currency_code tl_efc_currency_code;
12: g_rate_currency_code_tab tl_efc_currency_code;
13: g_rate_empty_currency_tab tl_efc_currency_code;
14: --
15: TYPE tl_efc_derive_factor IS TABLE OF fnd_currencies.derive_factor%TYPE
16: INDEX BY BINARY_INTEGER;
17: g_efc_derive_factor tl_efc_derive_factor;
18: --
19: TYPE tl_efc_is_ncu_sysdate IS TABLE OF boolean INDEX BY BINARY_INTEGER;

Line 35: g_derive_effective fnd_currencies.derive_effective%TYPE; -- Value from table

31: -- performance reasons.
32: --
33: g_hash_number binary_integer; -- Value used to hash on the currency cache
34: g_rounding number; -- Factor to use in rounding the EUR amount
35: g_derive_effective fnd_currencies.derive_effective%TYPE; -- Value from table
36: g_derive_type fnd_currencies.derive_type%TYPE; -- Value from table
37: g_derive_factor fnd_currencies.derive_factor%TYPE; -- Value from table
38: --
39: -- The following global variables are used for chaching in function

Line 36: g_derive_type fnd_currencies.derive_type%TYPE; -- Value from table

32: --
33: g_hash_number binary_integer; -- Value used to hash on the currency cache
34: g_rounding number; -- Factor to use in rounding the EUR amount
35: g_derive_effective fnd_currencies.derive_effective%TYPE; -- Value from table
36: g_derive_type fnd_currencies.derive_type%TYPE; -- Value from table
37: g_derive_factor fnd_currencies.derive_factor%TYPE; -- Value from table
38: --
39: -- The following global variables are used for chaching in function
40: -- get_other_rate

Line 37: g_derive_factor fnd_currencies.derive_factor%TYPE; -- Value from table

33: g_hash_number binary_integer; -- Value used to hash on the currency cache
34: g_rounding number; -- Factor to use in rounding the EUR amount
35: g_derive_effective fnd_currencies.derive_effective%TYPE; -- Value from table
36: g_derive_type fnd_currencies.derive_type%TYPE; -- Value from table
37: g_derive_factor fnd_currencies.derive_factor%TYPE; -- Value from table
38: --
39: -- The following global variables are used for chaching in function
40: -- get_other_rate
41: --

Line 83: -- Get currency information from FND_CURRENCIES table

79: p_mau IN OUT NOCOPY NUMBER,
80: p_currency_type IN OUT NOCOPY VARCHAR2) IS
81: --
82: BEGIN
83: -- Get currency information from FND_CURRENCIES table
84: SELECT DECODE(
85: fc.derive_type,
86: 'EURO', 'EURO',
87: 'EMU', DECODE(

Line 102: FROM fnd_currencies fc

98: POWER(10, (-1 * fc.precision)))
99: INTO p_currency_type,
100: p_conversion_rate,
101: p_mau
102: FROM fnd_currencies fc
103: WHERE fc.currency_code = p_currency;
104: EXCEPTION
105: WHEN NO_DATA_FOUND THEN
106: RAISE invalid_currency;

Line 150: -- select this currency code from fnd_currencies table because

146: -- get_euro_code
147: --
148: -- Purpose
149: -- Returns the currency code for the EURO currency. We need to
150: -- select this currency code from fnd_currencies table because
151: -- the currency code for EURO has not been fixed at this time.
152: --
153: -- History
154: -- 24-JUL-97 W Wong Created

Line 166: FROM FND_CURRENCIES

162: BEGIN
163: -- Get currency code of the EURO currency
164: SELECT currency_code
165: INTO euro_code
166: FROM FND_CURRENCIES
167: WHERE derive_type = 'EURO';
168:
169: return( euro_code );
170:

Line 773: from fnd_currencies fcu

769: cursor csr_fnd_cur is
770: select fcu.derive_type
771: , fcu.derive_effective
772: , fcu.derive_factor
773: from fnd_currencies fcu
774: where fcu.currency_code = p_from_currency;
775: --
776: cursor csr_fnd_eur is
777: select NVL(fcu.minimum_accountable_unit, POWER(10, (-1 * fcu.precision)))

Line 778: from fnd_currencies fcu

774: where fcu.currency_code = p_from_currency;
775: --
776: cursor csr_fnd_eur is
777: select NVL(fcu.minimum_accountable_unit, POWER(10, (-1 * fcu.precision)))
778: from fnd_currencies fcu
779: where fcu.currency_code = 'EUR';
780: --
781: -- This function uses the g_derive_effective, g_derive_type
782: -- and g_derive_factor variables as if they were local variables.

Line 887: -- factor from the FND_CURRENCIES table. Also round the converted

883: end if;
884: --
885: -- Otherwise the p_from_currency is an NCU as of sysdate and the
886: -- p_amount value should be converted to EUR using the derived
887: -- factor from the FND_CURRENCIES table. Also round the converted
888: -- amount to the number of decimal places passed into this function
889: -- or the standard number of decimal places for the EUR currency
890: -- and minumum accountable units.
891: --