DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_RPT_PVT dependencies on OKL_SUBSIDY_POOL_PVT

Line 2513: okl_subsidy_pool_pvt.set_decision_status_code ( l_api_version,

2509: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool
2510: -- status is other than "EXPIRED' than set the stauts to "EXPIRED'.
2511: IF(each_row.effective_to_date < TRUNC(SYSDATE) AND each_row.decision_status_code <> 'EXPIRED')THEN
2512: l_decision_status_code := 'EXPIRED';
2513: okl_subsidy_pool_pvt.set_decision_status_code ( l_api_version,
2514: l_init_msg_list,
2515: l_return_status,
2516: l_msg_count,
2517: l_msg_data,

Line 2557: okl_subsidy_pool_pvt.set_decision_status_code ( l_api_version,

2553: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool
2554: -- status is other than "EXPIRED' than set the stauts to "EXPIRED'.
2555: IF(each_row.effective_to_date < TRUNC(SYSDATE) AND each_row.decision_status_code <> 'EXPIRED')THEN
2556: l_decision_status_code := 'EXPIRED';
2557: okl_subsidy_pool_pvt.set_decision_status_code ( l_api_version,
2558: l_init_msg_list,
2559: l_return_status,
2560: l_msg_count,
2561: l_msg_data,

Line 3565: okl_subsidy_pool_pvt.set_decision_status_code ( l_api_version,

3561: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool
3562: -- status is other than "EXPIRED' than set the stauts to "EXPIRED'.
3563: IF(each_row.effective_to_date < TRUNC(SYSDATE) AND each_row.decision_status_code <> 'EXPIRED')THEN
3564: l_decision_status_code := 'EXPIRED';
3565: okl_subsidy_pool_pvt.set_decision_status_code ( l_api_version,
3566: l_init_msg_list,
3567: l_return_status,
3568: l_msg_count,
3569: l_msg_data,

Line 3619: okl_subsidy_pool_pvt.set_decision_status_code ( l_api_version,

3615: -- If subsidy pool effective to date is less than the current sysdate and the subsidy pool
3616: -- status is other than "EXPIRED' than set the stauts to "EXPIRED'.
3617: IF(each_row.effective_to_date < TRUNC(SYSDATE) AND each_row.decision_status_code <> 'EXPIRED')THEN
3618: l_decision_status_code := 'EXPIRED';
3619: okl_subsidy_pool_pvt.set_decision_status_code ( l_api_version,
3620: l_init_msg_list,
3621: l_return_status,
3622: l_msg_count,
3623: l_msg_data,