APPS.OKL_SUBSIDY_POOL_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 370: (nvl(l_db_effective_to,okl_accounting_util.g_final_date) <> l_effective_to_date)AND

366:
367: -- if user updates a effective to date of subsidy pool to less than the system date
368: -- then set the status of pool to "expired" otherwise update the subsidy pool.
369: IF ((l_effective_to_date is not null) AND
370: (nvl(l_db_effective_to,okl_accounting_util.g_final_date) <> l_effective_to_date)AND
371: (l_effective_to_date < l_system_date)) THEN
372: -- effective to date cannot be less than the system date if pool status is "NEW"
373: -- if pool status is "ACTIVE" and effective to date is less than system date then change
374: -- the pool status to "EXPIRED".

Line 390: (nvl(l_db_effective_to,okl_accounting_util.g_final_date) <> l_effective_to_date)) THEN

386:
387: -- If effective to date of subsidy pool is updated, and the effective dates of the subsidies
388: -- attached to the pool do not overlap then throw an error that the date cannot be updated.
389: IF ((l_effective_to_date is not null) AND
390: (nvl(l_db_effective_to,okl_accounting_util.g_final_date) <> l_effective_to_date)) THEN
391: OPEN c_get_subsidy_date(l_effective_to_date,l_sub_pool_rec.id);
392: FETCH c_get_subsidy_date INTO l_dummy;
393: IF (c_get_subsidy_date%FOUND) THEN
394: CLOSE c_get_subsidy_date;

Line 409: (nvl(l_db_effective_to,okl_accounting_util.g_final_date) <> l_effective_to_date)) THEN

405:
406: -- If the effective to date is less than the transation date for the subsidy pool
407: -- then throw error that user cannot modify the effective to date less than the transaction date.
408: IF ((l_effective_to_date is not null) AND
409: (nvl(l_db_effective_to,okl_accounting_util.g_final_date) <> l_effective_to_date)) THEN
410: OPEN c_get_trx_date(l_sub_pool_rec.id);
411: FETCH c_get_trx_date INTO l_trx_date;
412: IF (c_get_trx_date%FOUND AND l_effective_to_date < l_trx_date) THEN
413: CLOSE c_get_trx_date;