The following lines contain the word 'select', 'insert', 'update' or 'delete':
OKE_FORM_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_form_rec => l_form_rec,
x_form_rec => x_form_rec);
OKE_FORM_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_form_tbl => p_form_tbl,
x_form_tbl => x_form_tbl);
PROCEDURE update_print_form(
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_form_rec IN oke_form_pvt.form_rec_type,
x_form_rec OUT NOCOPY oke_form_pvt.form_rec_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PRINT_FORM';
OKE_FORM_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_form_rec => p_form_rec,
x_form_rec => x_form_rec);
END update_print_form;
PROCEDURE update_print_form(
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_form_tbl IN oke_form_pvt.form_tbl_type,
x_form_tbl OUT NOCOPY oke_form_pvt.form_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PRINT_FORM';
OKE_FORM_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_form_tbl => p_form_tbl,
x_form_tbl => x_form_tbl);
END update_print_form;
PROCEDURE delete_print_form(
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_form_rec IN oke_form_pvt.form_rec_type) IS
l_form_rec oke_form_pvt.form_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PRINT_FORM';
OKE_FORM_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_form_rec => p_form_rec);
END delete_print_form;
PROCEDURE delete_print_form(
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_form_tbl IN oke_form_pvt.form_tbl_type) IS
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PRINT_FORM';
OKE_FORM_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_form_tbl => p_form_tbl);
END delete_print_form;
PROCEDURE delete_print_form(
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_pfm_cd IN OKE_K_PRINT_FORMS.PRINT_FORM_CODE%TYPE ) IS
l_form_rec oke_form_pvt.form_rec_type;
l_api_name CONSTANT VARCHAR2(30) := 'DELETE_PRINT_FORM';
OKE_FORM_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_pfm_cd => p_pfm_cd);
OKE_FORM_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_pfm_cd => p_pfm_cd);
END delete_print_form;
SELECT
b.K_HEADER_ID ,
b.K_LINE_ID ,
b.PRINT_FORM_CODE ,
b.CREATION_DATE ,
b.CREATED_BY ,
b.LAST_UPDATE_DATE ,
b.LAST_UPDATED_BY ,
b.LAST_UPDATE_LOGIN ,
b.REQUIRED_FLAG ,
b.CUSTOMER_FURNISHED_FLAG ,
b.COMPLETED_FLAG ,
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_PRINT_FORMS b
WHERE b.K_LINE_ID = p_id;
SELECT
b.K_HEADER_ID ,
b.K_LINE_ID ,
b.PRINT_FORM_CODE ,
b.CREATION_DATE ,
b.CREATED_BY ,
b.LAST_UPDATE_DATE ,
b.LAST_UPDATED_BY ,
b.LAST_UPDATE_LOGIN ,
b.REQUIRED_FLAG ,
b.CUSTOMER_FURNISHED_FLAG ,
b.COMPLETED_FLAG ,
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_PRINT_FORMS b
WHERE (b.K_HEADER_ID = p_id) AND (b.K_LINE_ID IS NULL);
l_form_rec.LAST_UPDATE_DATE ,
l_form_rec.LAST_UPDATED_BY ,
l_form_rec.LAST_UPDATE_LOGIN ,
l_form_rec.REQUIRED_FLAG ,
l_form_rec.CUSTOMER_FURNISHED_FLAG ,
l_form_rec.COMPLETED_FLAG ,
l_form_rec.ATTRIBUTE_CATEGORY ,
l_form_rec.ATTRIBUTE1 ,
l_form_rec.ATTRIBUTE2 ,
l_form_rec.ATTRIBUTE3 ,
l_form_rec.ATTRIBUTE4 ,
l_form_rec.ATTRIBUTE5 ,
l_form_rec.ATTRIBUTE6 ,
l_form_rec.ATTRIBUTE7 ,
l_form_rec.ATTRIBUTE8 ,
l_form_rec.ATTRIBUTE9 ,
l_form_rec.ATTRIBUTE10 ,
l_form_rec.ATTRIBUTE11 ,
l_form_rec.ATTRIBUTE12 ,
l_form_rec.ATTRIBUTE13 ,
l_form_rec.ATTRIBUTE14 ,
l_form_rec.ATTRIBUTE15 ;
--FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'print FORMS inserting std form');
OKE_FORM_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_form_tbl => l_form_tbl,
x_form_tbl => x_form_tbl);
l_form_rec.LAST_UPDATE_DATE ,
l_form_rec.LAST_UPDATED_BY ,
l_form_rec.LAST_UPDATE_LOGIN ,
l_form_rec.REQUIRED_FLAG ,
l_form_rec.CUSTOMER_FURNISHED_FLAG ,
l_form_rec.COMPLETED_FLAG ,
l_form_rec.ATTRIBUTE_CATEGORY ,
l_form_rec.ATTRIBUTE1 ,
l_form_rec.ATTRIBUTE2 ,
l_form_rec.ATTRIBUTE3 ,
l_form_rec.ATTRIBUTE4 ,
l_form_rec.ATTRIBUTE5 ,
l_form_rec.ATTRIBUTE6 ,
l_form_rec.ATTRIBUTE7 ,
l_form_rec.ATTRIBUTE8 ,
l_form_rec.ATTRIBUTE9 ,
l_form_rec.ATTRIBUTE10 ,
l_form_rec.ATTRIBUTE11 ,
l_form_rec.ATTRIBUTE12 ,
l_form_rec.ATTRIBUTE13 ,
l_form_rec.ATTRIBUTE14 ,
l_form_rec.ATTRIBUTE15 ;
--FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,g_module||l_api_name,'print form inserting std form');
OKE_FORM_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_form_tbl => l_form_tbl,
x_form_tbl => x_form_tbl);