DBA Data[Home] [Help]

APPS.OKL_ASSET_SUBSIDY_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 3089: (TRUNC(SYSDATE) BETWEEN cv_sub_pool.effective_from_date AND NVL(cv_sub_pool.effective_to_date,okl_accounting_util.g_final_date)))THEN

3085: lv_return_status := 'N';
3086: OPEN c_sub_pool_csr; FETCH c_sub_pool_csr INTO cv_sub_pool; CLOSE c_sub_pool_csr;
3087: x_pool_status := cv_sub_pool.decision_status_code;
3088: IF((cv_sub_pool.decision_status_code = 'ACTIVE') AND
3089: (TRUNC(SYSDATE) BETWEEN cv_sub_pool.effective_from_date AND NVL(cv_sub_pool.effective_to_date,okl_accounting_util.g_final_date)))THEN
3090: lv_return_status := 'Y';
3091: END IF;
3092: return lv_return_status;
3093: END is_sub_pool_active;

Line 3112: AND NVL(cv_sub_pool.effective_to_date,OKL_ACCOUNTING_UTIL.g_final_date))THEN

3108: BEGIN
3109: lv_return_status := 'N';
3110: OPEN c_sub_pool_csr; FETCH c_sub_pool_csr INTO cv_sub_pool; CLOSE c_sub_pool_csr;
3111: IF(TRUNC(p_asset_date) BETWEEN TRUNC(cv_sub_pool.effective_from_date)
3112: AND NVL(cv_sub_pool.effective_to_date,OKL_ACCOUNTING_UTIL.g_final_date))THEN
3113: lv_return_status := 'Y';
3114: END IF;
3115: return lv_return_status;
3116: END is_sub_pool_active_by_date;

Line 3138: okl_accounting_util.get_curr_con_rate(p_api_version => l_api_version

3134: BEGIN
3135: lv_return_status := 'N';
3136: OPEN c_sub_pool_csr; FETCH c_sub_pool_csr INTO cv_sub_pool; CLOSE c_sub_pool_csr;
3137: lv_conversion_rate := 0;
3138: okl_accounting_util.get_curr_con_rate(p_api_version => l_api_version
3139: ,p_init_msg_list => OKL_API.G_TRUE
3140: ,x_return_status => x_return_status
3141: ,x_msg_count => x_msg_count
3142: ,x_msg_data => x_msg_data

Line 3283: lx_conversion_round_amt := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr

3279:
3280: lx_conversion_round_amt := 0;
3281: l_amount_in_pool_curr := lx_conversion_rate * p_subsidy_amount;
3282: -- this converted amount should be rounded
3283: lx_conversion_round_amt := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr
3284: ,p_currency_code => lx_sub_pool_curr_code);
3285: IF(lx_conversion_round_amt <= 0)THEN
3286: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3287: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |

Line 3317: lx_conversion_round_amt_tot := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr_tot

3313: -- Check accumulated subsidy amount up to now for a specific pool
3314: lx_conversion_round_amt_tot := 0;
3315: l_amount_in_pool_curr_tot := lx_conversion_rate * l_subsidy_amount_tot;
3316: -- this converted amount should be rounded
3317: lx_conversion_round_amt_tot := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr_tot
3318: ,p_currency_code => lx_sub_pool_curr_code);
3319: IF(lx_conversion_round_amt_tot <= 0)THEN
3320: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3321: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |

Line 3482: lx_conversion_round_amt := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr

3478:
3479: lx_conversion_round_amt := 0;
3480: l_amount_in_pool_curr := lx_conversion_rate * p_subsidy_amount;
3481: -- this converted amount should be rounded
3482: lx_conversion_round_amt := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr
3483: ,p_currency_code => lx_sub_pool_curr_code);
3484: IF(lx_conversion_round_amt <= 0)THEN
3485: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3486: ,'SUBSIDY', l_subsidy_name

Line 3509: lx_conversion_round_amt_tot := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr_tot

3505: -- Check accumulated subsidy amount up to now for a specific pool
3506: lx_conversion_round_amt_tot := 0;
3507: l_amount_in_pool_curr_tot := lx_conversion_rate * p_tot_subsidy_amount;
3508: -- this converted amount should be rounded
3509: lx_conversion_round_amt_tot := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr_tot
3510: ,p_currency_code => lx_sub_pool_curr_code);
3511: IF(lx_conversion_round_amt_tot <= 0)THEN
3512: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3513: ,'SUBSIDY', l_subsidy_name