[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'x'
FROM hr_all_organization_units
WHERE organization_id = p_eto_rec.organization_id;
SELECT 'x'
FROM mtl_system_items_b
WHERE inventory_item_id = p_eto_rec.inventory_item_id;
SELECT 'x'
FROM okl_fe_resi_cat_all_b
WHERE resi_category_set_id = p_eto_rec.resi_category_set_id;
SELECT end_of_term_obj_id
,object_version_number
,inventory_item_id
,organization_id
,category_id
,category_set_id
,resi_category_set_id
,end_of_term_ver_id
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login
FROM okl_fe_eo_term_objects
WHERE okl_fe_eo_term_objects.end_of_term_obj_id = p_id;
,l_eto_rec.last_updated_by
,l_eto_rec.last_update_date
,l_eto_rec.last_update_login ;
IF (l_eto_rec.last_updated_by = okl_api.g_miss_num) THEN
l_eto_rec.last_updated_by := NULL;
IF (l_eto_rec.last_update_date = okl_api.g_miss_date) THEN
l_eto_rec.last_update_date := NULL;
IF (l_eto_rec.last_update_login = okl_api.g_miss_num) THEN
l_eto_rec.last_update_login := NULL;
SELECT object_version_number
FROM okl_fe_eo_term_objects
WHERE end_of_term_obj_id = p_def_eto_rec.end_of_term_obj_id
AND object_version_number = p_def_eto_rec.object_version_number
FOR UPDATE OF object_version_number NOWAIT;
SELECT object_version_number
FROM okl_fe_eo_term_objects
WHERE end_of_term_obj_id = p_def_eto_rec.end_of_term_obj_id;
,g_form_record_deleted);
,g_record_logically_deleted);
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_eto_rec IN okl_eto_rec
,x_eto_rec OUT NOCOPY okl_eto_rec) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
l_eto_rec.last_update_date := SYSDATE;
l_eto_rec.last_updated_by := fnd_global.user_id;
l_eto_rec.last_update_login := fnd_global.login_id;
INSERT INTO okl_fe_eo_term_objects
(end_of_term_obj_id
,object_version_number
,inventory_item_id
,organization_id
,category_id
,category_set_id
,resi_category_set_id
,end_of_term_ver_id
,attribute_category
,attribute1
,attribute2
,attribute3
,attribute4
,attribute5
,attribute6
,attribute7
,attribute8
,attribute9
,attribute10
,attribute11
,attribute12
,attribute13
,attribute14
,attribute15
,created_by
,creation_date
,last_updated_by
,last_update_date
,last_update_login)
VALUES (l_def_eto_rec.end_of_term_obj_id
,l_def_eto_rec.object_version_number
,l_def_eto_rec.inventory_item_id
,l_def_eto_rec.organization_id
,l_def_eto_rec.category_id
,l_def_eto_rec.category_set_id
,l_def_eto_rec.resi_category_set_id
,l_def_eto_rec.end_of_term_ver_id
,l_def_eto_rec.attribute_category
,l_def_eto_rec.attribute1
,l_def_eto_rec.attribute2
,l_def_eto_rec.attribute3
,l_def_eto_rec.attribute4
,l_def_eto_rec.attribute5
,l_def_eto_rec.attribute6
,l_def_eto_rec.attribute7
,l_def_eto_rec.attribute8
,l_def_eto_rec.attribute9
,l_def_eto_rec.attribute10
,l_def_eto_rec.attribute11
,l_def_eto_rec.attribute12
,l_def_eto_rec.attribute13
,l_def_eto_rec.attribute14
,l_def_eto_rec.attribute15
,l_def_eto_rec.created_by
,l_def_eto_rec.creation_date
,l_def_eto_rec.last_updated_by
,l_def_eto_rec.last_update_date
,l_def_eto_rec.last_update_login);
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_eto_tbl IN okl_eto_tbl
,x_eto_tbl OUT NOCOPY okl_eto_tbl) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'insert_row_tbl';
insert_row(p_api_version => p_api_version
,p_init_msg_list => okc_api.g_false
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_eto_rec => p_eto_tbl(i)
,x_eto_rec => x_eto_tbl(i));
END insert_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_eto_rec IN okl_eto_rec
,x_eto_rec OUT NOCOPY okl_eto_rec) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'v_insert_row';
l_eto_rec.last_update_date := SYSDATE;
l_eto_rec.last_updated_by := fnd_global.user_id;
l_eto_rec.last_update_login := fnd_global.login_id;
IF (x_eto_rec.last_updated_by IS NULL) THEN
x_eto_rec.last_updated_by := l_eto_rec.last_updated_by;
IF (x_eto_rec.last_update_date IS NULL) THEN
x_eto_rec.last_update_date := l_eto_rec.last_update_date;
IF (x_eto_rec.last_update_login IS NULL) THEN
x_eto_rec.last_update_login := l_eto_rec.last_update_login;
UPDATE okl_fe_eo_term_objects
SET end_of_term_obj_id = l_def_eto_rec.end_of_term_obj_id
,object_version_number = l_def_eto_rec.object_version_number + 1
,inventory_item_id = l_def_eto_rec.inventory_item_id
,organization_id = l_def_eto_rec.organization_id
,category_id = l_def_eto_rec.category_id
,category_set_id = l_def_eto_rec.category_set_id
,resi_category_set_id = l_def_eto_rec.resi_category_set_id
,end_of_term_ver_id = l_def_eto_rec.end_of_term_ver_id
,attribute_category = l_def_eto_rec.attribute_category
,attribute1 = l_def_eto_rec.attribute1
,attribute2 = l_def_eto_rec.attribute2
,attribute3 = l_def_eto_rec.attribute3
,attribute4 = l_def_eto_rec.attribute4
,attribute5 = l_def_eto_rec.attribute5
,attribute6 = l_def_eto_rec.attribute6
,attribute7 = l_def_eto_rec.attribute7
,attribute8 = l_def_eto_rec.attribute8
,attribute9 = l_def_eto_rec.attribute9
,attribute10 = l_def_eto_rec.attribute10
,attribute11 = l_def_eto_rec.attribute11
,attribute12 = l_def_eto_rec.attribute12
,attribute13 = l_def_eto_rec.attribute13
,attribute14 = l_def_eto_rec.attribute14
,attribute15 = l_def_eto_rec.attribute15
,created_by = l_def_eto_rec.created_by
,creation_date = l_def_eto_rec.creation_date
,last_updated_by = l_def_eto_rec.last_updated_by
,last_update_date = l_def_eto_rec.last_update_date
,last_update_login = l_def_eto_rec.last_update_login
WHERE end_of_term_obj_id = l_def_eto_rec.end_of_term_obj_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_eto_tbl IN okl_eto_tbl
,x_eto_tbl OUT NOCOPY okl_eto_tbl) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'update_row_tbl';
update_row(p_api_version => p_api_version
,p_init_msg_list => okc_api.g_false
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_eto_rec => p_eto_tbl(i)
,x_eto_rec => x_eto_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_eto_rec IN okl_eto_rec) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
DELETE FROM okl_fe_eo_term_objects
WHERE end_of_term_obj_id = l_eto_rec.end_of_term_obj_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_eto_tbl IN okl_eto_tbl) IS
l_api_version CONSTANT NUMBER := 1;
l_api_name CONSTANT VARCHAR2(30) := 'delete_row_tbl';
delete_row(p_api_version => p_api_version
,p_init_msg_list => okc_api.g_false
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,p_eto_rec => p_eto_tbl(i));
END delete_row;