DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_AUTH_TRX_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 87: NVL(cv_get_pool_dates_csr.effective_to_date,OKL_ACCOUNTING_UTIL.g_final_date))THEN

83: OPEN c_get_pool_dates_csr(lv_six_tbl(idx).subsidy_pool_id); FETCH c_get_pool_dates_csr INTO cv_get_pool_dates_csr;
84: CLOSE c_get_pool_dates_csr;
85: -- validate if the source transaction date is between the passed subsidy pool dates
86: IF NOT(TRUNC(p_source_trx_date) BETWEEN cv_get_pool_dates_csr.effective_from_date AND
87: NVL(cv_get_pool_dates_csr.effective_to_date,OKL_ACCOUNTING_UTIL.g_final_date))THEN
88: OKL_API.set_message(G_APP_NAME, G_SOURCE_TRX_DATE_POOL_VAL
89: ,'TRX_DATE', p_source_trx_date
90: ,'POOL_NAME', cv_get_pool_dates_csr.subsidy_pool_name
91: ,'ASSET_NUMBER',lv_six_tbl(idx).dnz_asset_number);