The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_system_parameters(
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_sypv_rec IN sypv_rec_type,
x_sypv_rec OUT NOCOPY sypv_rec_type) IS
l_return_status VARCHAR2(3) := G_RET_STS_SUCCESS;
SAVEPOINT insert_row_trx;
OKL_SYP_PVT.insert_row(
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_sypv_rec => p_sypv_rec,
x_sypv_rec => x_sypv_rec);
ROLLBACK TO insert_row_trx;
ROLLBACK TO insert_row_trx;
ROLLBACK TO insert_row_trx;
FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');
END insert_system_parameters;
PROCEDURE insert_system_parameters(
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_sypv_tbl IN sypv_tbl_type,
x_sypv_tbl OUT NOCOPY sypv_tbl_type) IS
l_return_status VARCHAR2(3) := G_RET_STS_SUCCESS;
SAVEPOINT insert_row_trx;
OKL_SYP_PVT.insert_row(
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_sypv_tbl => p_sypv_tbl,
x_sypv_tbl => x_sypv_tbl);
ROLLBACK TO insert_row_trx;
ROLLBACK TO insert_row_trx;
ROLLBACK TO insert_row_trx;
FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');
END insert_system_parameters;
PROCEDURE update_system_parameters(
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_sypv_rec IN sypv_rec_type,
x_sypv_rec OUT NOCOPY sypv_rec_type) IS
l_return_status VARCHAR2(3) := G_RET_STS_SUCCESS;
SAVEPOINT update_row_trx;
OKL_SYP_PVT.update_row(
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_sypv_rec => p_sypv_rec,
x_sypv_rec => x_sypv_rec);
ROLLBACK TO update_row_trx;
ROLLBACK TO update_row_trx;
ROLLBACK TO update_row_trx;
FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');
END update_system_parameters;
PROCEDURE update_system_parameters(
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_sypv_tbl IN sypv_tbl_type,
x_sypv_tbl OUT NOCOPY sypv_tbl_type) IS
l_return_status VARCHAR2(3) := G_RET_STS_SUCCESS;
SAVEPOINT update_row_trx;
OKL_SYP_PVT.update_row(
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_sypv_tbl => p_sypv_tbl,
x_sypv_tbl => x_sypv_tbl);
ROLLBACK TO update_row_trx;
ROLLBACK TO update_row_trx;
ROLLBACK TO update_row_trx;
FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');
END update_system_parameters;
PROCEDURE delete_system_parameters(
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_sypv_rec IN sypv_rec_type) IS
l_return_status VARCHAR2(3) := G_RET_STS_SUCCESS;
SAVEPOINT delete_row_trx;
OKL_SYP_PVT.delete_row(
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_sypv_rec => p_sypv_rec);
ROLLBACK TO delete_row_trx;
ROLLBACK TO delete_row_trx;
ROLLBACK TO delete_row_trx;
FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');
END delete_system_parameters;
PROCEDURE delete_system_parameters(
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_sypv_tbl IN sypv_tbl_type) IS
l_return_status VARCHAR2(3) := G_RET_STS_SUCCESS;
SAVEPOINT delete_row_trx;
OKL_SYP_PVT.delete_row(
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_sypv_tbl => p_sypv_tbl);
ROLLBACK TO delete_row_trx;
ROLLBACK TO delete_row_trx;
ROLLBACK TO delete_row_trx;
FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');
END delete_system_parameters;
CURSOR C IS SELECT item_inv_org_id ,
rpt_prod_book_type_code ,
asst_add_book_type_code ,
ccard_remittance_id
FROM okl_system_params_all
WHERE org_id = l_org_id ;