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 390: FROM fnd_currencies

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

Line 401: FROM fnd_currencies c,

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

Line 1114: p_base_currency IN fnd_currencies.currency_code%TYPE,

1110: | Introduced for 11.5 Tax accounting - used by ARALLOCB.pls and ARTWRAPB.pls
1111: *===================================================================================*/
1112: PROCEDURE Set_Buckets(
1113: p_header_acctd_amt IN NUMBER ,
1114: p_base_currency IN fnd_currencies.currency_code%TYPE,
1115: p_exchange_rate IN NUMBER ,
1116: p_base_precision IN NUMBER ,
1117: p_base_min_acc_unit IN NUMBER ,
1118: p_tax_amt IN NUMBER ,

Line 1537: FROM fnd_currencies_vl

1533: ELSIF (p_entity = 'CURRENCY_NAME')
1534: THEN
1535: SELECT currency_code
1536: INTO l_selected_id
1537: FROM fnd_currencies_vl
1538: WHERE name = p_value;
1539: ELSIF (p_entity = 'EXCHANGE_RATE_TYPE_NAME')
1540: THEN
1541: SELECT conversion_type