DBA Data[Home] [Help]

APPS.AP_UTILITIES_PKG dependencies on FND_CURRENCIES

Line 55: l_minimum_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;

51: (P_Amount IN number
52: ,P_Currency_Code IN varchar2)
53: return number is
54: l_rounded_amount number;
55: l_minimum_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
56: l_precision FND_CURRENCIES.precision%TYPE;
57:
58: begin
59:

Line 56: l_precision FND_CURRENCIES.precision%TYPE;

52: ,P_Currency_Code IN varchar2)
53: return number is
54: l_rounded_amount number;
55: l_minimum_acct_unit FND_CURRENCIES.minimum_accountable_unit%TYPE;
56: l_precision FND_CURRENCIES.precision%TYPE;
57:
58: begin
59:
60: /* Bug 5572876. Ccaching is done for Currency Data */

Line 73: from fnd_currencies FC

69:
70: Begin
71: select FC.minimum_accountable_unit, FC.precision
72: into l_minimum_acct_unit, l_precision
73: from fnd_currencies FC
74: where FC.currency_code = P_Currency_Code;
75:
76: g_fnd_currency_code_t(p_currency_code).minimum_accountable_unit := l_minimum_acct_unit;
77: g_fnd_currency_code_t(p_currency_code).precision := l_precision;

Line 96: from fnd_currencies FC

92:
93: Begin
94: select FC.minimum_accountable_unit, FC.precision
95: into l_minimum_acct_unit, l_precision
96: from fnd_currencies FC
97: where FC.currency_code = P_Currency_Code;
98:
99: g_fnd_currency_code_t(p_currency_code).minimum_accountable_unit := l_minimum_acct_unit;
100: g_fnd_currency_code_t(p_currency_code).precision := l_precision;

Line 204: fnd_currencies FC

200: INTO l_func_currency,
201: l_fc_precision,
202: l_fc_min_acct_unit
203: FROM ap_system_parameters SP,
204: fnd_currencies FC
205: WHERE FC.currency_code = P_Currency_Code;
206:
207:
208: -------------------------- DEBUG INFORMATION ------------------------------

Line 321: FROM fnd_currencies FC

317: SELECT FC.precision,
318: FC.minimum_accountable_unit
319: INTO l_fc_precision,
320: l_fc_min_acct_unit
321: FROM fnd_currencies FC
322: WHERE FC.currency_code = P_Currency_Code;
323:
324: l_precision := l_fc_precision;
325: l_min_acct_unit := l_fc_min_acct_unit;