The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE update_shipping_instr(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rasv_rec IN rasv_rec_type,
x_rasv_rec OUT NOCOPY rasv_rec_type) IS
l_api_version NUMBER ;
SAVEPOINT shipping_instr_update;
okl_am_shipping_instr_pvt.update_shipping_instr(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_rasv_rec
,lx_rasv_rec);
ROLLBACK TO shipping_instr_update;
ROLLBACK TO shipping_instr_update;
ROLLBACK TO shipping_instr_update;
FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_SHIPPING_INSTR_PUB','update_shipping_instr');
END update_shipping_instr;
PROCEDURE update_shipping_instr(
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_rasv_tbl IN rasv_tbl_type,
x_rasv_tbl OUT NOCOPY rasv_tbl_type) IS
l_api_version NUMBER;
SAVEPOINT shipping_instr_update;
okl_am_shipping_instr_pvt.update_shipping_instr(
l_api_version
,l_init_msg_list
,l_return_status
,l_msg_count
,l_msg_data
,lp_rasv_tbl
,lx_rasv_tbl);
ROLLBACK TO shipping_instr_update;
ROLLBACK TO shipping_instr_update;
ROLLBACK TO shipping_instr_update;
FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_SHIPPING_INSTR_PUB','update_shipping_instr');
END update_shipping_instr;