The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_accrual_rules(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_agnv_rec IN agnv_rec_type,
x_agnv_rec OUT NOCOPY agnv_rec_type)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'update_accrual_rules';
SAVEPOINT update_accrual_rules;
OKL_SETUP_ACCRUALS_PVT.update_accrual_rules(p_api_version => l_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_agnv_rec => p_agnv_rec,
x_agnv_rec => x_agnv_rec);
ROLLBACK TO update_accrual_rules;
ROLLBACK TO update_accrual_rules;
ROLLBACK TO update_accrual_rules;
FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','update_accrual_rules');
END update_accrual_rules;
PROCEDURE update_accrual_rules(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_agnv_tbl IN agnv_tbl_type,
x_agnv_tbl OUT NOCOPY agnv_tbl_type)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'update_accrual_rules';
SAVEPOINT update_accrual_rules;
OKL_SETUP_ACCRUALS_PVT.update_accrual_rules(p_api_version => l_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_agnv_rec => l_agnv_tbl(i),
x_agnv_rec => x_agnv_tbl(i));
ROLLBACK TO update_accrual_rules;
ROLLBACK TO update_accrual_rules;
ROLLBACK TO update_accrual_rules;
FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','update_accrual_rules');
END update_accrual_rules;
PROCEDURE delete_accrual_rules(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_agnv_rec IN agnv_rec_type)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'delete_accrual_rules';
SAVEPOINT delete_accrual_rules;
OKL_SETUP_ACCRUALS_PVT.delete_accrual_rules(p_api_version => l_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_agnv_rec => p_agnv_rec);
ROLLBACK TO delete_accrual_rules;
ROLLBACK TO delete_accrual_rules;
ROLLBACK TO delete_accrual_rules;
FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','delete_accrual_rules');
END delete_accrual_rules;
PROCEDURE delete_accrual_rules(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_agnv_tbl IN agnv_tbl_type)
IS
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'delete_accrual_rules';
SAVEPOINT delete_accrual_rules;
OKL_SETUP_ACCRUALS_PVT.delete_accrual_rules(p_api_version => l_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_agnv_rec => l_agnv_tbl(i));
ROLLBACK TO delete_accrual_rules;
ROLLBACK TO delete_accrual_rules;
ROLLBACK TO delete_accrual_rules;
FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUP_ACCRUALS_PUB','delete_accrual_rules');
END delete_accrual_rules;