The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_qclv_rec.last_updated_by := p_qclv_rec1.last_updated_by;
l_qclv_rec.last_update_date := p_qclv_rec1.last_update_date;
l_qclv_rec.last_update_login := p_qclv_rec1.last_update_login;
PROCEDURE update_qa_check_list(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qclv_rec IN qclv_rec_type,
x_qclv_rec OUT NOCOPY qclv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'update_qa_check_list';
OKC_QA_CHECK_LIST_PVT.update_qa_check_list(
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_qclv_rec => l_qclv_rec,
x_qclv_rec => x_qclv_rec);
END update_qa_check_list;
PROCEDURE update_qa_check_list(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qclv_tbl IN qclv_tbl_type,
x_qclv_tbl OUT NOCOPY qclv_tbl_type) IS
i NUMBER := 0;
update_qa_check_list(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_qclv_rec => p_qclv_tbl(i),
x_qclv_rec => x_qclv_tbl(i));
END update_qa_check_list;
PROCEDURE delete_qa_check_list(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qclv_rec IN qclv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'delete_qa_check_list';
OKC_QA_CHECK_LIST_PVT.delete_qa_check_list(
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_qclv_rec => p_qclv_rec);
END delete_qa_check_list;
PROCEDURE delete_qa_check_list(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qclv_tbl IN qclv_tbl_type) IS
i NUMBER := 0;
delete_qa_check_list(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_qclv_rec => p_qclv_tbl(i));
END delete_qa_check_list;
l_qlpv_rec.last_updated_by := p_qlpv_rec1.last_updated_by;
l_qlpv_rec.last_update_date := p_qlpv_rec1.last_update_date;
l_qlpv_rec.last_update_login := p_qlpv_rec1.last_update_login;
PROCEDURE update_qa_process(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qlpv_rec IN qlpv_rec_type,
x_qlpv_rec OUT NOCOPY qlpv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'update_qa_process';
OKC_QA_CHECK_LIST_PVT.update_qa_process(
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_qlpv_rec => l_qlpv_rec,
x_qlpv_rec => x_qlpv_rec);
END update_qa_process;
PROCEDURE update_qa_process(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qlpv_tbl IN qlpv_tbl_type,
x_qlpv_tbl OUT NOCOPY qlpv_tbl_type) IS
i NUMBER := 0;
update_qa_process(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_qlpv_rec => p_qlpv_tbl(i),
x_qlpv_rec => x_qlpv_tbl(i));
END update_qa_process;
PROCEDURE delete_qa_process(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qlpv_rec IN qlpv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'delete_qa_process';
OKC_QA_CHECK_LIST_PVT.delete_qa_process(
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_qlpv_rec => p_qlpv_rec);
END delete_qa_process;
PROCEDURE delete_qa_process(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qlpv_tbl IN qlpv_tbl_type) IS
i NUMBER := 0;
delete_qa_process(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_qlpv_rec => p_qlpv_tbl(i));
END delete_qa_process;
l_qppv_rec.last_updated_by := p_qppv_rec1.last_updated_by;
l_qppv_rec.last_update_date := p_qppv_rec1.last_update_date;
l_qppv_rec.last_update_login := p_qppv_rec1.last_update_login;
PROCEDURE update_qa_parm(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qppv_rec IN qppv_rec_type,
x_qppv_rec OUT NOCOPY qppv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'update_qa_parm';
OKC_QA_CHECK_LIST_PVT.update_qa_parm(
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_qppv_rec => l_qppv_rec,
x_qppv_rec => x_qppv_rec);
END update_qa_parm;
PROCEDURE update_qa_parm(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qppv_tbl IN qppv_tbl_type,
x_qppv_tbl OUT NOCOPY qppv_tbl_type) IS
i NUMBER := 0;
update_qa_parm(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_qppv_rec => p_qppv_tbl(i),
x_qppv_rec => x_qppv_tbl(i));
END update_qa_parm;
PROCEDURE delete_qa_parm(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qppv_rec IN qppv_rec_type) IS
l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
l_api_name CONSTANT VARCHAR2(30) := 'delete_qa_parm';
OKC_QA_CHECK_LIST_PVT.delete_qa_parm(
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_qppv_rec => p_qppv_rec);
END delete_qa_parm;
PROCEDURE delete_qa_parm(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 ,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_qppv_tbl IN qppv_tbl_type) IS
i NUMBER := 0;
delete_qa_parm(
p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_qppv_rec => p_qppv_tbl(i));
END delete_qa_parm;