DBA Data[Home] [Help]

APPS.OKL_SUB_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 2195: IF((nvl(lv_pool_effective_to,OKL_ACCOUNTING_UTIL.g_final_date) < trunc(p_subv_rec.effective_from_date))OR

2191: -- end: cklee 07/22/05
2192: CLOSE c_get_pool_dates_csr;
2193: -- if either the pool effective from date is not between subsidy dates or subsidy effective from date is not between pool effective dates
2194: -- raise error
2195: IF((nvl(lv_pool_effective_to,OKL_ACCOUNTING_UTIL.g_final_date) < trunc(p_subv_rec.effective_from_date))OR
2196: (nvl(p_subv_rec.EFFECTIVE_TO_DATE,OKL_ACCOUNTING_UTIL.g_final_date) < lv_pool_effective_From)
2197: )THEN
2198: --cklee 09/12/2005 OKL_API.set_message(G_APP_NAME,G_SUBSIDY_POOL_EFFECTIVE_DATES);
2199: OKL_API.set_message(G_APP_NAME,G_SUBSIDY_POOL_EFFECTIVE_DATES,'SUBSIDY',p_subv_rec.name);

Line 2196: (nvl(p_subv_rec.EFFECTIVE_TO_DATE,OKL_ACCOUNTING_UTIL.g_final_date) < lv_pool_effective_From)

2192: CLOSE c_get_pool_dates_csr;
2193: -- if either the pool effective from date is not between subsidy dates or subsidy effective from date is not between pool effective dates
2194: -- raise error
2195: IF((nvl(lv_pool_effective_to,OKL_ACCOUNTING_UTIL.g_final_date) < trunc(p_subv_rec.effective_from_date))OR
2196: (nvl(p_subv_rec.EFFECTIVE_TO_DATE,OKL_ACCOUNTING_UTIL.g_final_date) < lv_pool_effective_From)
2197: )THEN
2198: --cklee 09/12/2005 OKL_API.set_message(G_APP_NAME,G_SUBSIDY_POOL_EFFECTIVE_DATES);
2199: OKL_API.set_message(G_APP_NAME,G_SUBSIDY_POOL_EFFECTIVE_DATES,'SUBSIDY',p_subv_rec.name);
2200: