APPS.OKL_ACCOUNTING_UTIL dependencies on FND_CURRENCIES

Line 325: FROM fnd_currencies_vl

321: l_sysdate DATE := G_SYSDATE;
322:
323: CURSOR curr_csr IS
324: SELECT '1'
325: FROM fnd_currencies_vl
326: WHERE currency_code = p_currency_code
327: AND ENABLED_FLAG = 'Y'
328: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
329: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line 704: FROM fnd_currencies_vl

700: FROM OKL_SYS_ACCT_OPTS;
701:
702: CURSOR prec_csr IS
703: SELECT PRECISION
704: FROM fnd_currencies_vl
705: WHERE currency_code = p_currency_code
706: AND enabled_flag = 'Y'
707: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
708: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line 786: FROM fnd_currencies_vl

782:
783:
784: CURSOR prec_csr IS
785: SELECT PRECISION
786: FROM fnd_currencies_vl
787: WHERE currency_code = p_currency_code
788: AND enabled_flag = 'Y'
789: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
790: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line 1649: FROM fnd_currencies fc

1645: l_profl_val VARCHAR2(80);
1646:
1647: CURSOR cur_csr IS
1648: SELECT fc.precision, fc.extended_precision, fc.minimum_accountable_unit
1649: FROM fnd_currencies fc
1650: WHERE fc.currency_code = p_currency_code;
1651:
1652: BEGIN
1653:

Line 1752: FROM fnd_currencies fc

1748: BEGIN
1749: BEGIN -- get currency info
1750: SELECT PRECISION
1751: INTO l_precision
1752: FROM fnd_currencies fc
1753: WHERE fc.currency_code = p_currency_code;
1754: EXCEPTION
1755: WHEN NO_DATA_FOUND THEN
1756: l_precision := 0;

Line 1920: FROM fnd_currencies_vl

1916: SELECT cc_rounding_rule INTO l_rounding_rule
1917: FROM OKL_SYS_ACCT_OPTS;
1918:
1919: SELECT PRECISION INTO l_precision
1920: FROM fnd_currencies_vl
1921: WHERE currency_code = p_currency_code
1922: AND enabled_flag = 'Y'
1923: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
1924: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line 1982: FROM fnd_currencies_vl

1978: FROM OKL_SYS_ACCT_OPTS;
1979:
1980: CURSOR prec_csr IS
1981: SELECT PRECISION
1982: FROM fnd_currencies_vl
1983: WHERE currency_code = p_currency_code
1984: AND enabled_flag = 'Y'
1985: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)
1986: AND TRUNC(NVL(end_date_active, l_sysdate)) >= TRUNC(l_sysdate);

Line 2082: p_to_currency IN fnd_currencies.currency_code%TYPE,

2078:
2079: PROCEDURE convert_to_functional_currency
2080: (
2081: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
2082: p_to_currency IN fnd_currencies.currency_code%TYPE,
2083: p_transaction_date IN DATE,
2084: p_amount IN NUMBER,
2085: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2086: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,

Line 2192: p_to_currency IN fnd_currencies.currency_code%TYPE,

2188:
2189: PROCEDURE convert_to_functional_currency
2190: (
2191: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
2192: p_to_currency IN fnd_currencies.currency_code%TYPE,
2193: p_transaction_date IN DATE,
2194: p_amount IN NUMBER,
2195: x_return_status OUT NOCOPY VARCHAR2,
2196: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,

Line 2347: p_from_currency IN fnd_currencies.currency_code%TYPE,

2343:
2344: PROCEDURE convert_to_contract_currency
2345: (
2346: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
2347: p_from_currency IN fnd_currencies.currency_code%TYPE,
2348: p_transaction_date IN DATE,
2349: p_amount IN NUMBER,
2350: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,
2351: x_currency_conversion_type OUT NOCOPY OKL_K_HEADERS.currency_conversion_type%TYPE,

Line 2466: p_from_currency IN fnd_currencies.currency_code%TYPE,

2462:
2463: PROCEDURE convert_to_contract_currency
2464: (
2465: p_khr_id IN OKC_K_HEADERS_B.id%TYPE,
2466: p_from_currency IN fnd_currencies.currency_code%TYPE,
2467: p_transaction_date IN DATE,
2468: p_amount IN NUMBER,
2469: x_return_status OUT NOCOPY VARCHAR2,
2470: x_contract_currency OUT NOCOPY OKC_K_HEADERS_B.currency_code%TYPE,