The following lines contain the word 'select', 'insert', 'update' or 'delete':
OKE_TERM_PVT.Insert_Row(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_term_rec => l_term_rec,
x_term_rec => x_term_rec);
OKE_TERM_PVT.Insert_Row(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_term_tbl => p_term_tbl,
x_term_tbl => x_term_tbl);
PROCEDURE update_term(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_term_rec IN oke_term_pvt.term_rec_type,
x_term_rec OUT NOCOPY oke_term_pvt.term_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TERM';
OKE_TERM_PVT.Update_Row(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_term_rec => p_term_rec,
x_term_rec => x_term_rec);
END update_term;
PROCEDURE update_term(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_term_tbl IN oke_term_pvt.term_tbl_type,
x_term_tbl OUT NOCOPY oke_term_pvt.term_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_TERM';
OKE_TERM_PVT.Update_Row(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_term_tbl => p_term_tbl,
x_term_tbl => x_term_tbl);
END update_term;
PROCEDURE delete_term(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_term_rec IN oke_term_pvt.term_rec_type) IS
l_term_rec oke_term_pvt.term_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TERM';
OKE_TERM_PVT.delete_row(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_term_rec => p_term_rec);
END delete_term;
PROCEDURE delete_term(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_term_tbl IN oke_term_pvt.term_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TERM';
OKE_TERM_PVT.Delete_Row(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_term_tbl => p_term_tbl);
END delete_term;
PROCEDURE delete_term(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKE_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_chr_id IN NUMBER,
p_cle_id IN NUMBER,
p_trm_cd IN OKE_K_TERMS.TERM_CODE%TYPE,
p_trm_val_pk1 IN OKE_K_TERMS.TERM_VALUE_PK1%TYPE,
p_trm_val_pk2 IN OKE_K_TERMS.TERM_VALUE_PK2%TYPE) IS
l_term_rec oke_term_pvt.term_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TERM';
OKE_TERM_PVT.delete_row(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_cle_id => p_cle_id,
p_trm_cd => p_trm_cd,
p_trm_val_pk1 => p_trm_val_pk1,
p_trm_val_pk2 => p_trm_val_pk2);
OKE_TERM_PVT.delete_row(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_chr_id => p_chr_id,
p_trm_cd => p_trm_cd,
p_trm_val_pk1 => p_trm_val_pk1,
p_trm_val_pk2 => p_trm_val_pk2);
END delete_term;
SELECT
b.K_HEADER_ID ,
b.K_LINE_ID ,
b.TERM_CODE ,
b.TERM_VALUE_PK1 ,
b.TERM_VALUE_PK2 ,
b.CREATION_DATE ,
b.CREATED_BY ,
b.LAST_UPDATE_DATE ,
b.LAST_UPDATED_BY ,
b.LAST_UPDATE_LOGIN ,
b.ATTRIBUTE_CATEGORY ,
b.ATTRIBUTE1 ,
b.ATTRIBUTE2 ,
b.ATTRIBUTE3 ,
b.ATTRIBUTE4 ,
b.ATTRIBUTE5 ,
b.ATTRIBUTE6 ,
b.ATTRIBUTE7 ,
b.ATTRIBUTE8 ,
b.ATTRIBUTE9 ,
b.ATTRIBUTE10 ,
b.ATTRIBUTE11 ,
b.ATTRIBUTE12 ,
b.ATTRIBUTE13 ,
b.ATTRIBUTE14 ,
b.ATTRIBUTE15
FROM OKE_K_TERMS b
WHERE b.K_LINE_ID = p_id;
SELECT
b.K_HEADER_ID ,
b.K_LINE_ID ,
b.TERM_CODE ,
b.TERM_VALUE_PK1 ,
b.TERM_VALUE_PK2 ,
b.CREATION_DATE ,
b.CREATED_BY ,
b.LAST_UPDATE_DATE ,
b.LAST_UPDATED_BY ,
b.LAST_UPDATE_LOGIN ,
b.ATTRIBUTE_CATEGORY ,
b.ATTRIBUTE1 ,
b.ATTRIBUTE2 ,
b.ATTRIBUTE3 ,
b.ATTRIBUTE4 ,
b.ATTRIBUTE5 ,
b.ATTRIBUTE6 ,
b.ATTRIBUTE7 ,
b.ATTRIBUTE8 ,
b.ATTRIBUTE9 ,
b.ATTRIBUTE10 ,
b.ATTRIBUTE11 ,
b.ATTRIBUTE12 ,
b.ATTRIBUTE13 ,
b.ATTRIBUTE14 ,
b.ATTRIBUTE15
FROM OKE_K_TERMS b
WHERE (b.K_HEADER_ID = p_id) AND (b.K_LINE_ID IS NULL);
l_term_rec.LAST_UPDATE_DATE ,
l_term_rec.LAST_UPDATED_BY ,
l_term_rec.LAST_UPDATE_LOGIN ,
l_term_rec.ATTRIBUTE_CATEGORY ,
l_term_rec.ATTRIBUTE1 ,
l_term_rec.ATTRIBUTE2 ,
l_term_rec.ATTRIBUTE3 ,
l_term_rec.ATTRIBUTE4 ,
l_term_rec.ATTRIBUTE5 ,
l_term_rec.ATTRIBUTE6 ,
l_term_rec.ATTRIBUTE7 ,
l_term_rec.ATTRIBUTE8 ,
l_term_rec.ATTRIBUTE9 ,
l_term_rec.ATTRIBUTE10 ,
l_term_rec.ATTRIBUTE11 ,
l_term_rec.ATTRIBUTE12 ,
l_term_rec.ATTRIBUTE13 ,
l_term_rec.ATTRIBUTE14 ,
l_term_rec.ATTRIBUTE15 ;
OKE_TERM_PVT.Insert_Row(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_term_tbl => l_term_tbl,
x_term_tbl => x_term_tbl);
l_term_rec.LAST_UPDATE_DATE ,
l_term_rec.LAST_UPDATED_BY ,
l_term_rec.LAST_UPDATE_LOGIN ,
l_term_rec.ATTRIBUTE_CATEGORY ,
l_term_rec.ATTRIBUTE1 ,
l_term_rec.ATTRIBUTE2 ,
l_term_rec.ATTRIBUTE3 ,
l_term_rec.ATTRIBUTE4 ,
l_term_rec.ATTRIBUTE5 ,
l_term_rec.ATTRIBUTE6 ,
l_term_rec.ATTRIBUTE7 ,
l_term_rec.ATTRIBUTE8 ,
l_term_rec.ATTRIBUTE9 ,
l_term_rec.ATTRIBUTE10 ,
l_term_rec.ATTRIBUTE11 ,
l_term_rec.ATTRIBUTE12 ,
l_term_rec.ATTRIBUTE13 ,
l_term_rec.ATTRIBUTE14 ,
l_term_rec.ATTRIBUTE15 ;
OKE_TERM_PVT.Insert_Row(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_term_tbl => l_term_tbl,
x_term_tbl => x_term_tbl);