245: update lns_terms
246: set next_rate_change_date = l_next_rate_change
247: ,open_projected_rate = p_annualized_interest_rate
248: ,last_update_date = sysdate
249: ,last_updated_by = lns_utility_pub.user_id
250: where loan_id = p_loan_id;
251: elsif p_phase = 'TERM' then
252: update lns_terms
253: set next_rate_change_date = l_next_rate_change
252: update lns_terms
253: set next_rate_change_date = l_next_rate_change
254: ,term_projected_rate = p_annualized_interest_rate
255: ,last_update_date = sysdate
256: ,last_updated_by = lns_utility_pub.user_id
257: where loan_id = p_loan_id;
258: end if;
259:
260: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - updating the rate schedule ' || p_rate_id);
673: --
674: -- Api body
675: -- ----------------------------------------------------------------
676: -- validate loan_id
677: lns_utility_pub.validate_any_id(p_api_version => 1.0
678: ,p_init_msg_list => p_init_msg_list
679: ,x_msg_count => l_msg_count
680: ,x_msg_data => l_msg_data
681: ,x_return_status => l_return_status
1372: ,p_loan_id
1373: ,l_actual_balance
1374: ,p_installment_number
1375: ,null
1376: ,lns_utility_pub.created_by
1377: ,lns_utility_pub.creation_date
1378: ,lns_utility_pub.last_updated_by
1379: ,lns_utility_pub.last_update_date
1380: ,1);
1373: ,l_actual_balance
1374: ,p_installment_number
1375: ,null
1376: ,lns_utility_pub.created_by
1377: ,lns_utility_pub.creation_date
1378: ,lns_utility_pub.last_updated_by
1379: ,lns_utility_pub.last_update_date
1380: ,1);
1381: -- bug #3718480
1374: ,p_installment_number
1375: ,null
1376: ,lns_utility_pub.created_by
1377: ,lns_utility_pub.creation_date
1378: ,lns_utility_pub.last_updated_by
1379: ,lns_utility_pub.last_update_date
1380: ,1);
1381: -- bug #3718480
1382: -- we will need to credit out all unpaid principal documents
1375: ,null
1376: ,lns_utility_pub.created_by
1377: ,lns_utility_pub.creation_date
1378: ,lns_utility_pub.last_updated_by
1379: ,lns_utility_pub.last_update_date
1380: ,1);
1381: -- bug #3718480
1382: -- we will need to credit out all unpaid principal documents
1383: /*
1399: ,p_loan_id
1400: ,l_actual_balance
1401: ,p_installment_number
1402: ,null
1403: ,lns_utility_pub.created_by
1404: ,lns_utility_pub.creation_date
1405: ,lns_utility_pub.last_updated_by
1406: ,lns_utility_pub.last_update_date
1407: ,1);
1400: ,l_actual_balance
1401: ,p_installment_number
1402: ,null
1403: ,lns_utility_pub.created_by
1404: ,lns_utility_pub.creation_date
1405: ,lns_utility_pub.last_updated_by
1406: ,lns_utility_pub.last_update_date
1407: ,1);
1408: */
1401: ,p_installment_number
1402: ,null
1403: ,lns_utility_pub.created_by
1404: ,lns_utility_pub.creation_date
1405: ,lns_utility_pub.last_updated_by
1406: ,lns_utility_pub.last_update_date
1407: ,1);
1408: */
1409: else
1402: ,null
1403: ,lns_utility_pub.created_by
1404: ,lns_utility_pub.creation_date
1405: ,lns_utility_pub.last_updated_by
1406: ,lns_utility_pub.last_update_date
1407: ,1);
1408: */
1409: else
1410: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' WILL NOT REAMORTIZE!');
6098: --
6099: -- Api body
6100: -- ----------------------------------------------------------------
6101: -- validate loan_id
6102: lns_utility_pub.validate_any_id(p_api_version => 1.0
6103: ,p_init_msg_list => p_init_msg_list
6104: ,x_msg_count => l_msg_count
6105: ,x_msg_data => l_msg_data
6106: ,x_return_status => l_return_status
7659:
7660: --
7661: -- Api body
7662: -- ----------------------------------------------------------------
7663: lns_utility_pub.validate_any_id(p_api_version => 1.0
7664: ,p_init_msg_list => 'T'
7665: ,x_msg_count => l_msg_count
7666: ,x_msg_data => l_msg_data
7667: ,x_return_status => l_return_status