DBA Data[Home] [Help]

APPS.OKL_ASSET_SUBSIDY_PVT dependencies on OKL_ACCOUNTING_UTIL

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

3064: lv_return_status := 'N';
3065: OPEN c_sub_pool_csr; FETCH c_sub_pool_csr INTO cv_sub_pool; CLOSE c_sub_pool_csr;
3066: x_pool_status := cv_sub_pool.decision_status_code;
3067: IF((cv_sub_pool.decision_status_code = 'ACTIVE') AND
3068: (TRUNC(SYSDATE) BETWEEN cv_sub_pool.effective_from_date AND NVL(cv_sub_pool.effective_to_date,okl_accounting_util.g_final_date)))THEN
3069: lv_return_status := 'Y';
3070: END IF;
3071: return lv_return_status;
3072: END is_sub_pool_active;

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

3087: BEGIN
3088: lv_return_status := 'N';
3089: OPEN c_sub_pool_csr; FETCH c_sub_pool_csr INTO cv_sub_pool; CLOSE c_sub_pool_csr;
3090: IF(TRUNC(p_asset_date) BETWEEN TRUNC(cv_sub_pool.effective_from_date)
3091: AND NVL(cv_sub_pool.effective_to_date,OKL_ACCOUNTING_UTIL.g_final_date))THEN
3092: lv_return_status := 'Y';
3093: END IF;
3094: return lv_return_status;
3095: END is_sub_pool_active_by_date;

Line 3117: okl_accounting_util.get_curr_con_rate(p_api_version => l_api_version

3113: BEGIN
3114: lv_return_status := 'N';
3115: OPEN c_sub_pool_csr; FETCH c_sub_pool_csr INTO cv_sub_pool; CLOSE c_sub_pool_csr;
3116: lv_conversion_rate := 0;
3117: okl_accounting_util.get_curr_con_rate(p_api_version => l_api_version
3118: ,p_init_msg_list => OKL_API.G_TRUE
3119: ,x_return_status => x_return_status
3120: ,x_msg_count => x_msg_count
3121: ,x_msg_data => x_msg_data

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

3258:
3259: lx_conversion_round_amt := 0;
3260: l_amount_in_pool_curr := lx_conversion_rate * p_subsidy_amount;
3261: -- this converted amount should be rounded
3262: lx_conversion_round_amt := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr
3263: ,p_currency_code => lx_sub_pool_curr_code);
3264: IF(lx_conversion_round_amt <= 0)THEN
3265: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3266: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |

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

3292: -- Check accumulated subsidy amount up to now for a specific pool
3293: lx_conversion_round_amt_tot := 0;
3294: l_amount_in_pool_curr_tot := lx_conversion_rate * l_subsidy_amount_tot;
3295: -- this converted amount should be rounded
3296: lx_conversion_round_amt_tot := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr_tot
3297: ,p_currency_code => lx_sub_pool_curr_code);
3298: IF(lx_conversion_round_amt_tot <= 0)THEN
3299: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3300: --START: 24-Oct-2005 cklee - Fixed bug#4687505 |

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

3457:
3458: lx_conversion_round_amt := 0;
3459: l_amount_in_pool_curr := lx_conversion_rate * p_subsidy_amount;
3460: -- this converted amount should be rounded
3461: lx_conversion_round_amt := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr
3462: ,p_currency_code => lx_sub_pool_curr_code);
3463: IF(lx_conversion_round_amt <= 0)THEN
3464: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3465: ,'SUBSIDY', l_subsidy_name

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

3484: -- Check accumulated subsidy amount up to now for a specific pool
3485: lx_conversion_round_amt_tot := 0;
3486: l_amount_in_pool_curr_tot := lx_conversion_rate * p_tot_subsidy_amount;
3487: -- this converted amount should be rounded
3488: lx_conversion_round_amt_tot := okl_accounting_util.cross_currency_round_amount(p_amount => l_amount_in_pool_curr_tot
3489: ,p_currency_code => lx_sub_pool_curr_code);
3490: IF(lx_conversion_round_amt_tot <= 0)THEN
3491: OKC_API.set_message(G_APP_NAME, G_NO_CONVERSION_BASIS
3492: ,'SUBSIDY', l_subsidy_name