DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_APPROVAL_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 118: IF(TRUNC(SYSDATE) > NVL(cv_pool_details_csr.effective_to_date,okl_accounting_util.g_final_date))THEN

114: END IF;
115:
116: -- check for pool expiration here. pool could be logically expired by the time user submits for approval.
117: -- in such a case, expire the pool and throw the error
118: IF(TRUNC(SYSDATE) > NVL(cv_pool_details_csr.effective_to_date,okl_accounting_util.g_final_date))THEN
119: okl_subsidy_pool_pvt.expire_sub_pool(p_api_version => p_api_version
120: ,p_init_msg_list => p_init_msg_list
121: ,x_return_status => x_return_status
122: ,x_msg_count => x_msg_count

Line 445: IF(TRUNC(SYSDATE) > NVL(cv_get_pool_info.pool_end_date,okl_accounting_util.g_final_date))THEN

441: END IF;
442:
443: -- check for pool expiration here. pool could be logically expired by the time user submits line for approval.
444: -- in such a case, expire the pool and throw the error
445: IF(TRUNC(SYSDATE) > NVL(cv_get_pool_info.pool_end_date,okl_accounting_util.g_final_date))THEN
446: okl_subsidy_pool_pvt.expire_sub_pool(p_api_version => p_api_version
447: ,p_init_msg_list => p_init_msg_list
448: ,x_return_status => x_return_status
449: ,x_msg_count => x_msg_count