[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT id
,object_version_number
,lrt_id
,term_in_months
,residual_value_percent
,interest_rate
,lease_rate_factor
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,rate_set_version_id
INTO l_lrfv_rec.id
,l_lrfv_rec.object_version_number
,l_lrfv_rec.lrt_id
,l_lrfv_rec.term_in_months
,l_lrfv_rec.residual_value_percent
,l_lrfv_rec.interest_rate
,l_lrfv_rec.lease_rate_factor
,l_lrfv_rec.created_by
,l_lrfv_rec.creation_date
,l_lrfv_rec.last_updated_by
,l_lrfv_rec.last_update_date
,l_lrfv_rec.last_update_login
,l_lrfv_rec.attribute_category
,l_lrfv_rec.attribute1
,l_lrfv_rec.attribute2
,l_lrfv_rec.attribute3
,l_lrfv_rec.attribute4
,l_lrfv_rec.attribute5
,l_lrfv_rec.attribute6
,l_lrfv_rec.attribute7
,l_lrfv_rec.attribute8
,l_lrfv_rec.attribute9
,l_lrfv_rec.attribute10
,l_lrfv_rec.attribute11
,l_lrfv_rec.attribute12
,l_lrfv_rec.attribute13
,l_lrfv_rec.attribute14
,l_lrfv_rec.attribute15
,l_lrfv_rec.rate_set_version_id
FROM okl_ls_rt_fctr_ents_v lrfv
WHERE lrfv.id = p_id;
IF (l_lrfv_rec.last_updated_by = g_miss_num) THEN
l_lrfv_rec.last_updated_by := NULL;
IF (l_lrfv_rec.last_update_date = g_miss_date) THEN
l_lrfv_rec.last_update_date := NULL;
IF (l_lrfv_rec.last_update_login = g_miss_num) THEN
l_lrfv_rec.last_update_login := NULL;
SELECT 'x'
FROM okl_ls_rt_fctr_sets_b
WHERE id = p_lrt_id;
SELECT 'x'
FROM okl_fe_rate_set_versions
WHERE rate_set_version_id = p_rate_set_version_id;
SELECT 'x'
FROM okl_ls_rt_fctr_ents
WHERE rate_set_version_id = p_lrfv_rec.rate_set_version_id --lrt_id = p_lrfv_rec.lrt_id
AND term_in_months = p_lrfv_rec.term_in_months
AND residual_value_percent = p_lrfv_rec.residual_value_percent
AND interest_rate = p_lrfv_rec.interest_rate
AND id <> p_lrfv_rec.id;
PROCEDURE insert_row(p_api_version IN number
,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
,p_lrfv_rec IN lrfv_rec_type
,x_lrfv_rec OUT NOCOPY lrfv_rec_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'insert_row (REC)';
l_lrfv_rec.last_update_date := sysdate;
l_lrfv_rec.last_updated_by := fnd_global.user_id;
l_lrfv_rec.last_update_login := fnd_global.login_id;
INSERT INTO okl_ls_rt_fctr_ents
(id
,object_version_number
,lrt_id
,term_in_months
,residual_value_percent
,interest_rate
,lease_rate_factor
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,rate_set_version_id)
VALUES (l_lrfv_rec.id
,l_lrfv_rec.object_version_number
,l_lrfv_rec.lrt_id
,l_lrfv_rec.term_in_months
,l_lrfv_rec.residual_value_percent
,l_lrfv_rec.interest_rate
,l_lrfv_rec.lease_rate_factor
,l_lrfv_rec.created_by
,l_lrfv_rec.creation_date
,l_lrfv_rec.last_updated_by
,l_lrfv_rec.last_update_date
,l_lrfv_rec.last_update_login
,l_lrfv_rec.attribute_category
,l_lrfv_rec.attribute1
,l_lrfv_rec.attribute2
,l_lrfv_rec.attribute3
,l_lrfv_rec.attribute4
,l_lrfv_rec.attribute5
,l_lrfv_rec.attribute6
,l_lrfv_rec.attribute7
,l_lrfv_rec.attribute8
,l_lrfv_rec.attribute9
,l_lrfv_rec.attribute10
,l_lrfv_rec.attribute11
,l_lrfv_rec.attribute12
,l_lrfv_rec.attribute13
,l_lrfv_rec.attribute14
,l_lrfv_rec.attribute15
,l_lrfv_rec.rate_set_version_id);
END insert_row;
PROCEDURE insert_row(p_api_version IN number
,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
,p_lrfv_tbl IN lrfv_tbl_type
,x_lrfv_tbl OUT NOCOPY lrfv_tbl_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'insert_row (TBL)';
insert_row(p_api_version => g_api_version
,p_init_msg_list => g_false
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_lrfv_rec => p_lrfv_tbl(i)
,x_lrfv_rec => x_lrfv_tbl(i));
END insert_row;
SELECT object_version_number
FROM okl_ls_rt_fctr_ents
WHERE id = p_lrfv_rec.id
AND object_version_number = p_lrfv_rec.object_version_number
FOR UPDATE OF object_version_number NOWAIT;
SELECT object_version_number
FROM okl_ls_rt_fctr_ents
WHERE id = p_lrfv_rec.id;
okc_api.set_message(g_fnd_app, g_form_record_deleted);
okc_api.set_message(g_app_name, g_record_logically_deleted);
PROCEDURE update_row(p_api_version IN number
,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
,p_lrfv_rec IN lrfv_rec_type
,x_lrfv_rec OUT NOCOPY lrfv_rec_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'update_row (_V)';
l_lrfv_rec.last_update_date := sysdate;
l_lrfv_rec.last_updated_by := fnd_global.user_id;
l_lrfv_rec.last_update_login := fnd_global.login_id;
UPDATE okl_ls_rt_fctr_ents
SET object_version_number = l_lrfv_rec.object_version_number + 1
,lrt_id = l_lrfv_rec.lrt_id
,term_in_months = l_lrfv_rec.term_in_months
,residual_value_percent = l_lrfv_rec.residual_value_percent
,interest_rate = l_lrfv_rec.interest_rate
,lease_rate_factor = l_lrfv_rec.lease_rate_factor
,created_by = l_lrfv_rec.created_by
,creation_date = l_lrfv_rec.creation_date
,last_updated_by = l_lrfv_rec.last_updated_by
,last_update_date = l_lrfv_rec.last_update_date
,last_update_login = l_lrfv_rec.last_update_login
,attribute_category = l_lrfv_rec.attribute_category
,attribute1 = l_lrfv_rec.attribute1
,attribute2 = l_lrfv_rec.attribute2
,attribute3 = l_lrfv_rec.attribute3
,attribute4 = l_lrfv_rec.attribute4
,attribute5 = l_lrfv_rec.attribute5
,attribute6 = l_lrfv_rec.attribute6
,attribute7 = l_lrfv_rec.attribute7
,attribute8 = l_lrfv_rec.attribute8
,attribute9 = l_lrfv_rec.attribute9
,attribute10 = l_lrfv_rec.attribute10
,attribute11 = l_lrfv_rec.attribute11
,attribute12 = l_lrfv_rec.attribute12
,attribute13 = l_lrfv_rec.attribute13
,attribute14 = l_lrfv_rec.attribute14
,attribute15 = l_lrfv_rec.attribute15
,rate_set_version_id = l_lrfv_rec.rate_set_version_id
WHERE id = l_lrfv_rec.id;
END update_row;
PROCEDURE update_row(p_api_version IN number
,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
,p_lrfv_tbl IN lrfv_tbl_type
,x_lrfv_tbl OUT NOCOPY lrfv_tbl_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'update_row (TBL)';
update_row(p_api_version => g_api_version
,p_init_msg_list => g_false
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_lrfv_rec => p_lrfv_tbl(i)
,x_lrfv_rec => x_lrfv_tbl(i));
END update_row;
PROCEDURE delete_row(p_api_version IN number
,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
,p_lrfv_rec IN lrfv_rec_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'delete_row (REC)';
DELETE FROM okl_ls_rt_fctr_ents
WHERE id = p_lrfv_rec.id;
END delete_row;
PROCEDURE delete_row(p_api_version IN number
,p_init_msg_list IN varchar2 DEFAULT okc_api.g_false
,x_return_status OUT NOCOPY varchar2
,x_msg_count OUT NOCOPY number
,x_msg_data OUT NOCOPY varchar2
,p_lrfv_tbl IN lrfv_tbl_type) IS
l_api_name CONSTANT varchar2(61) := g_pkg_name || '.' || 'delete_row (TBL)';
delete_row(p_api_version => g_api_version
,p_init_msg_list => g_false
,x_return_status => l_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_lrfv_rec => p_lrfv_tbl(i));
END delete_row;