APPS.ARP_UTIL dependencies on FND_CURRENCIES

Line 98: CURSOR curr_info (cc FND_CURRENCIES.CURRENCY_CODE%TYPE) IS

94: | Supplied |
95: | |
96: *----------------------------------------------------------------------------*/
97:
98: CURSOR curr_info (cc FND_CURRENCIES.CURRENCY_CODE%TYPE) IS
99: SELECT PRECISION,
100: MINIMUM_ACCOUNTABLE_UNIT,
101: CURRENCY_CODE
102: FROM FND_CURRENCIES

Line 102: FROM FND_CURRENCIES

98: CURSOR curr_info (cc FND_CURRENCIES.CURRENCY_CODE%TYPE) IS
99: SELECT PRECISION,
100: MINIMUM_ACCOUNTABLE_UNIT,
101: CURRENCY_CODE
102: FROM FND_CURRENCIES
103: WHERE CURRENCY_CODE = cc;
104:
105: /*---------------------------------------------------------------------------*
106: | PRIVATE DATATYPES |

Line 199: P_currency_code IN fnd_currencies.currency_code%TYPE )

195:
196: FUNCTION calc_dynamic_amount(
197: P_amount IN NUMBER,
198: P_exchange_rate IN NUMBER,
199: P_currency_code IN fnd_currencies.currency_code%TYPE )
200: RETURN NUMBER IS
201:
202: l_precision fnd_currencies.precision%TYPE;
203: l_ext_precision fnd_currencies.extended_precision%TYPE;

Line 202: l_precision fnd_currencies.precision%TYPE;

198: P_exchange_rate IN NUMBER,
199: P_currency_code IN fnd_currencies.currency_code%TYPE )
200: RETURN NUMBER IS
201:
202: l_precision fnd_currencies.precision%TYPE;
203: l_ext_precision fnd_currencies.extended_precision%TYPE;
204: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
205: l_format_mask VARCHAR2(45);
206:

Line 203: l_ext_precision fnd_currencies.extended_precision%TYPE;

199: P_currency_code IN fnd_currencies.currency_code%TYPE )
200: RETURN NUMBER IS
201:
202: l_precision fnd_currencies.precision%TYPE;
203: l_ext_precision fnd_currencies.extended_precision%TYPE;
204: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
205: l_format_mask VARCHAR2(45);
206:
207: BEGIN

Line 204: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;

200: RETURN NUMBER IS
201:
202: l_precision fnd_currencies.precision%TYPE;
203: l_ext_precision fnd_currencies.extended_precision%TYPE;
204: l_min_acct_unit fnd_currencies.minimum_accountable_unit%TYPE;
205: l_format_mask VARCHAR2(45);
206:
207: BEGIN
208: --

Line 393: FROM fnd_currencies

389: SELECT minimum_accountable_unit,
390: precision
391: INTO l_mau,
392: l_precision
393: FROM fnd_currencies
394: WHERE currency_code = p_currency;
395: ELSE
396: IF (NOT( (p_precision IS NULL ) AND (p_mau IS NULL))) THEN
397: l_precision := p_precision;

Line 404: FROM fnd_currencies c,

400: SELECT c.minimum_accountable_unit,
401: c.precision
402: INTO l_mau,
403: l_precision
404: FROM fnd_currencies c,
405: gl_sets_of_books sob,
406: ar_system_parameters sp
407: WHERE sob.set_of_books_id = sp.set_of_books_id
408: AND c.currency_code = sob.currency_code;

Line 1173: p_base_currency IN fnd_currencies.currency_code%TYPE,

1169: | Introduced for 11.5 Tax accounting - used by ARALLOCB.pls and ARTWRAPB.pls
1170: *===================================================================================*/
1171: PROCEDURE Set_Buckets(
1172: p_header_acctd_amt IN NUMBER ,
1173: p_base_currency IN fnd_currencies.currency_code%TYPE,
1174: p_exchange_rate IN NUMBER ,
1175: p_base_precision IN NUMBER ,
1176: p_base_min_acc_unit IN NUMBER ,
1177: p_tax_amt IN NUMBER ,

Line 1596: FROM fnd_currencies_vl

1592: ELSIF (p_entity = 'CURRENCY_NAME')
1593: THEN
1594: SELECT currency_code
1595: INTO l_selected_id
1596: FROM fnd_currencies_vl
1597: WHERE name = p_value;
1598: ELSIF (p_entity = 'EXCHANGE_RATE_TYPE_NAME')
1599: THEN
1600: SELECT conversion_type