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.OKL_ACCOUNTING_UTIL dependencies on OKL_ACCOUNTING_UTIL

Line 1: PACKAGE BODY okl_accounting_util AS

1: PACKAGE BODY okl_accounting_util AS
2: /* $Header: OKLRAUTB.pls 120.19 2011/05/20 04:27:36 rpillay ship $ */
3:
4: /**************************************************************************/
5:

Line 49: l_seg_array OKL_ACCOUNTING_UTIL.seg_array_type;

45: ORDER BY segment_num;
46:
47: i INTEGER := 1;
48: l_delimiter VARCHAR2(1);
49: l_seg_array OKL_ACCOUNTING_UTIL.seg_array_type;
50: l_seg_desc VARCHAR2(2000);
51: --Bug# 12336692
52: l_concate_desc VARCHAR2(2000);
53: l_parent_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;

Line 109: OKL_ACCOUNTING_UTIL.get_segment_array

105: x_application_id => 101,
106: x_id_flex_code => 'GL#',
107: x_id_flex_num => p_chart_of_account_id);
108:
109: OKL_ACCOUNTING_UTIL.get_segment_array
110: (p_concate_segments => p_concate_segments,
111: p_delimiter => l_delimiter,
112: p_seg_array_type => l_seg_array);
113:

Line 1670: l_curr_neg_format := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('CURRENCY:NEGATIVE_FORMAT', fnd_profile.value('CURRENCY:NEGATIVE_FORMAT'), 0, 0);

1666: l_curr_separator := TRUE;
1667: ELSE
1668: l_curr_separator := FALSE;
1669: END IF;
1670: l_curr_neg_format := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('CURRENCY:NEGATIVE_FORMAT', fnd_profile.value('CURRENCY:NEGATIVE_FORMAT'), 0, 0);
1671: l_curr_pos_format := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('CURRENCY:POSITIVE_FORMAT', fnd_profile.value('CURRENCY:POSITIVE_FORMAT'), 0, 0);
1672:
1673: IF (L_PRECISION > 0) THEN
1674: l_decimal_width := 1 + l_PRECISION;

Line 1671: l_curr_pos_format := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('CURRENCY:POSITIVE_FORMAT', fnd_profile.value('CURRENCY:POSITIVE_FORMAT'), 0, 0);

1667: ELSE
1668: l_curr_separator := FALSE;
1669: END IF;
1670: l_curr_neg_format := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('CURRENCY:NEGATIVE_FORMAT', fnd_profile.value('CURRENCY:NEGATIVE_FORMAT'), 0, 0);
1671: l_curr_pos_format := OKL_ACCOUNTING_UTIL.GET_LOOKUP_MEANING('CURRENCY:POSITIVE_FORMAT', fnd_profile.value('CURRENCY:POSITIVE_FORMAT'), 0, 0);
1672:
1673: IF (L_PRECISION > 0) THEN
1674: l_decimal_width := 1 + l_PRECISION;
1675: ELSE

Line 2125: l_func_currency := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;

2121: -- currency code is null
2122:
2123: l_func_currency := p_to_currency;
2124: IF l_func_currency IS NULL THEN
2125: l_func_currency := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;
2126: END IF;
2127:
2128: -- Currency conversion rate is 1 if both the contract and functional
2129: -- currencies are same

Line 2139: l_currency_conversion_rate := OKL_ACCOUNTING_UTIL.get_curr_con_rate

2135: -- conversion type is not 'USER'
2136:
2137: IF UPPER(l_currency_conversion_type) <> 'USER' THEN
2138: l_currency_conversion_date := p_transaction_date;
2139: l_currency_conversion_rate := OKL_ACCOUNTING_UTIL.get_curr_con_rate
2140: (p_from_curr_code => l_contract_currency,
2141: p_to_curr_code => l_func_currency,
2142: p_con_date => l_currency_conversion_date,
2143: p_con_type => l_currency_conversion_type);

Line 2152: -- l_converted_amount := OKL_ACCOUNTING_UTIL.CROSS_CURRENCY_ROUND_AMOUNT(l_converted_amount, l_contract_currency);

2148: -- Calculate the converted amount
2149: l_converted_amount := p_amount * l_currency_conversion_rate;
2150:
2151: -- Round the converted amount
2152: -- l_converted_amount := OKL_ACCOUNTING_UTIL.CROSS_CURRENCY_ROUND_AMOUNT(l_converted_amount, l_contract_currency);
2153:
2154: -- Populate the OUT parameters.
2155: x_converted_amount := l_converted_amount;
2156: x_contract_currency := l_contract_currency;

Line 2253: l_func_currency := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;

2249: -- currency code is null
2250:
2251: l_func_currency := p_to_currency;
2252: IF l_func_currency IS NULL THEN
2253: l_func_currency := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;
2254: END IF;
2255:
2256: -- Currency conversion rate is 1 if both the contract and functional
2257: -- currencies are same

Line 2298: -- l_converted_amount := OKL_ACCOUNTING_UTIL.CROSS_CURRENCY_ROUND_AMOUNT(l_converted_amount, l_contract_currency);

2294: -- Calculate the converted amount
2295: l_converted_amount := p_amount * l_currency_conversion_rate;
2296:
2297: -- Round the converted amount
2298: -- l_converted_amount := OKL_ACCOUNTING_UTIL.CROSS_CURRENCY_ROUND_AMOUNT(l_converted_amount, l_contract_currency);
2299:
2300: -- Populate the OUT parameters.
2301: x_converted_amount := l_converted_amount;
2302: x_contract_currency := l_contract_currency;

Line 2390: l_func_currency := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;

2386: -- Get the functional currency code using Accounting Util API if the passed
2387: -- currency code is null
2388: l_func_currency := p_from_currency;
2389: IF l_func_currency IS NULL THEN
2390: l_func_currency := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;
2391: END IF;
2392:
2393: -- Currency conversion rate is 1 if both the contract and functional
2394: -- currencies are same

Line 2410: l_currency_conversion_rate := OKL_ACCOUNTING_UTIL.get_curr_con_rate

2406: -- Get the currency conversion rate using get_curr_con_rate API if the
2407: -- conversion type is not 'USER'
2408:
2409: l_currency_conversion_date := p_transaction_date;
2410: l_currency_conversion_rate := OKL_ACCOUNTING_UTIL.get_curr_con_rate
2411: (p_from_curr_code => l_func_currency,
2412: p_to_curr_code => l_contract_currency,
2413: p_con_date => l_currency_conversion_date,
2414: p_con_type => l_currency_conversion_type);

Line 2424: -- l_converted_amount := OKL_ACCOUNTING_UTIL.CROSS_CURRENCY_ROUND_AMOUNT(l_converted_amount, l_contract_currency);

2420: -- Calculate the converted amount
2421: l_converted_amount := p_amount * l_currency_conversion_rate;
2422:
2423: -- Round the converted amount
2424: -- l_converted_amount := OKL_ACCOUNTING_UTIL.CROSS_CURRENCY_ROUND_AMOUNT(l_converted_amount, l_contract_currency);
2425:
2426: -- Populate the OUT parameters.
2427: x_converted_amount := l_converted_amount;
2428: x_contract_currency := l_contract_currency;

Line 2526: l_func_currency := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;

2522: -- Get the functional currency code using Accounting Util API if the passed
2523: -- currency code is null
2524: l_func_currency := p_from_currency;
2525: IF l_func_currency IS NULL THEN
2526: l_func_currency := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;
2527: END IF;
2528:
2529: -- Currency conversion rate is 1 if both the contract and functional
2530: -- currencies are same

Line 2572: -- l_converted_amount := OKL_ACCOUNTING_UTIL.CROSS_CURRENCY_ROUND_AMOUNT(l_converted_amount, l_contract_currency);

2568: -- Calculate the converted amount
2569: l_converted_amount := p_amount * l_currency_conversion_rate;
2570:
2571: -- Round the converted amount
2572: -- l_converted_amount := OKL_ACCOUNTING_UTIL.CROSS_CURRENCY_ROUND_AMOUNT(l_converted_amount, l_contract_currency);
2573:
2574: -- Populate the OUT parameters.
2575: x_converted_amount := l_converted_amount;
2576: x_contract_currency := l_contract_currency;

Line 3015: l_fa_trx_date := Okl_Accounting_Util.get_fa_trx_date(p_book_type_code);

3011:
3012: BEGIN
3013: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
3014:
3015: l_fa_trx_date := Okl_Accounting_Util.get_fa_trx_date(p_book_type_code);
3016:
3017: IF l_fa_trx_date IS NULL THEN
3018: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
3019: p_msg_name => 'OKL_NO_FA_TRX_DATE');

Line 3066: RETURN Okl_Accounting_Util.g_final_date;

3062:
3063: BEGIN
3064:
3065: IF p_sts_code IN ('NEW', 'INCOMPLETE', 'PASSED', 'COMPLETE', 'APPROVED','PENDING_APPROVAL') THEN
3066: RETURN Okl_Accounting_Util.g_final_date;
3067: ELSE
3068:
3069: OPEN fa_trx_st_dt_csr;
3070: FETCH fa_trx_st_dt_csr INTO l_fa_date;

Line 3343: END okl_accounting_util;

3339: p_token2_value => sqlerrm);
3340: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
3341: END get_reporting_product;
3342:
3343: END okl_accounting_util;