The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_cash_flow_level(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_cflv_rec IN cflv_rec_type,
x_cflv_rec OUT NOCOPY cflv_rec_type) IS
l_api_version NUMBER ;
SAVEPOINT cash_flow_level_insert ;
okl_cfl_pvt.insert_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_cflv_rec
,lx_cflv_rec);
ROLLBACK TO cash_flow_level_insert;
ROLLBACK TO cash_flow_level_insert;
ROLLBACK TO cash_flow_level_insert;
FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','insert_cash_flow_level');
END insert_cash_flow_level;
PROCEDURE insert_cash_flow_level(
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_cflv_tbl IN cflv_tbl_type,
x_cflv_tbl OUT NOCOPY cflv_tbl_type) IS
l_api_version NUMBER;
SAVEPOINT cash_flow_level_insert;
okl_cfl_pvt.insert_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_cflv_tbl
,lx_cflv_tbl);
ROLLBACK TO cash_flow_level_insert;
ROLLBACK TO cash_flow_level_insert;
ROLLBACK TO cash_flow_level_insert;
FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','insert_cash_flow_level');
END insert_cash_flow_level;
PROCEDURE update_cash_flow_level(
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_cflv_rec IN cflv_rec_type
,x_cflv_rec OUT NOCOPY cflv_rec_type) IS
l_api_version NUMBER ;
SAVEPOINT cash_flow_level_update;
okl_cfl_pvt.update_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_cflv_rec
,lx_cflv_rec);
ROLLBACK TO cash_flow_level_update;
ROLLBACK TO cash_flow_level_update;
ROLLBACK TO cash_flow_level_update;
FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','update_cash_flow_level');
END update_cash_flow_level;
PROCEDURE update_cash_flow_level(
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_cflv_tbl IN cflv_tbl_type,
x_cflv_tbl OUT NOCOPY cflv_tbl_type) IS
l_api_version NUMBER;
SAVEPOINT cash_flow_level_update;
okl_cfl_pvt.update_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_cflv_tbl
,lx_cflv_tbl);
ROLLBACK TO cash_flow_level_update;
ROLLBACK TO cash_flow_level_update;
ROLLBACK TO cash_flow_level_update;
FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','update_cash_flow_level');
END update_cash_flow_level;
PROCEDURE delete_cash_flow_level(
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_cflv_rec IN cflv_rec_type) IS
i NUMBER :=0;
SAVEPOINT cash_flow_level_delete;
okl_cfl_pvt.delete_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_cflv_rec);
ROLLBACK TO cash_flow_level_delete;
ROLLBACK TO cash_flow_level_delete;
ROLLBACK TO cash_flow_level_delete;
FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','delete_cash_flow_level');
END delete_cash_flow_level;
PROCEDURE delete_cash_flow_level(
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_cflv_tbl IN cflv_tbl_type) IS
i NUMBER := 0;
SAVEPOINT cash_flow_level_delete;
okl_cfl_pvt.delete_row(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_cflv_tbl);
ROLLBACK TO cash_flow_level_delete;
ROLLBACK TO cash_flow_level_delete;
ROLLBACK TO cash_flow_level_delete;
FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','delete_cash_flow_level');
END delete_cash_flow_level;