The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE delete_refund_hdr
( p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
,p_refund_header_id IN NUMBER
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
l_api_version NUMBER := 1;
l_api_name CONSTANT VARCHAR2(50) := 'DELETE_REFUND_HDR';
SAVEPOINT DELETE_REFUND_HDR;
'okl_pay_cure_refunds_pvt.DELETE_REFUND_HDR');
okl_pay_cure_refunds_pvt.DELETE_REFUND_HDR(
p_api_version => l_api_version
,p_init_msg_list => p_init_msg_list
,p_commit => p_commit
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_refund_header_id => p_refund_header_id);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'success - delete refund batch');
ROLLBACK TO DELETE_REFUND_HDR;
ROLLBACK TO DELETE_REFUND_HDR;
ROLLBACK TO DELETE_REFUND_HDR;
Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PUB','DELETE_REFUND_HDR');
END delete_refund_hdr;
PROCEDURE update_refund_hdr
( p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
l_api_version NUMBER := 1;
l_api_name CONSTANT VARCHAR2(50) := 'UPDATE_REFUND_HDR';
SAVEPOINT UPDATE_REFUND_HDR;
'okl_pay_cure_refunds_pvt.UPDATE_REFUND_HDR');
okl_pay_cure_refunds_pvt.UPDATE_REFUND_HDR(
p_api_version => l_api_version
,p_init_msg_list => p_init_msg_list
,p_commit => p_commit
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_pay_cure_refunds_rec => l_pay_cure_refunds_rec);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'okl_pay_cure_refunds_pvt.UPDATE_REFUND_HDR'
||l_return_status );
ROLLBACK TO UPDATE_REFUND_HDR;
ROLLBACK TO UPDATE_REFUND_HDR;
ROLLBACK TO UPDATE_REFUND_HDR;
Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PUB','UPDATE_REFUND_HDR');
END update_refund_hdr;
PROCEDURE UPDATE_REFUND_HEADERS
( p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
,p_pay_cure_refunds_rec IN pay_cure_refunds_rec_type
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
l_api_version NUMBER := 1;
l_api_name CONSTANT VARCHAR2(50) := 'UPDATE_REFUND_HEADERS';
SAVEPOINT UPDATE_REFUND_HEADERS;
'okl_pay_cure_refunds_pvt.UPDATE_REFUND_HEADERS');
okl_pay_cure_refunds_pvt.UPDATE_REFUND_HEADERS(
p_api_version => l_api_version
,p_init_msg_list => p_init_msg_list
,p_commit => p_commit
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_pay_cure_refunds_rec => l_pay_cure_refunds_rec);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'okl_pay_cure_refunds_pvt.UPDATE_REFUND_HEADERS'
||l_return_status );
ROLLBACK TO UPDATE_REFUND_HEADERS;
ROLLBACK TO UPDATE_REFUND_HEADERS;
ROLLBACK TO UPDATE_REFUND_HEADERS;
Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PUB','UPDATE_REFUND_HEADERS');
END UPDATE_REFUND_HEADERS;
PROCEDURE UPDATE_REFUND_DETAILS
( p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
l_api_version NUMBER := 1;
l_api_name CONSTANT VARCHAR2(50) := 'UPDATE_REFUND_DETAILS';
SAVEPOINT UPDATE_REFUND_DETAILS;
'okl_pay_cure_refunds_pvt.UPDATE_REFUND_DETAILS');
okl_pay_cure_refunds_pvt.UPDATE_REFUND_DETAILS(
p_api_version => l_api_version
,p_init_msg_list => p_init_msg_list
,p_commit => p_commit
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_pay_cure_refunds_tbl => l_pay_cure_refunds_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'okl_pay_cure_refunds_pvt.UPDATE_REFUND_DETAILS'
||l_return_status );
ROLLBACK TO UPDATE_REFUND_DETAILS;
ROLLBACK TO UPDATE_REFUND_DETAILS;
ROLLBACK TO UPDATE_REFUND_DETAILS;
Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PUB','UPDATE_REFUND_DETAILS');
END UPDATE_REFUND_DETAILS;
PROCEDURE DELETE_REFUND_DETAILS
( p_api_version IN NUMBER
,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_TRUE
,p_commit IN VARCHAR2 DEFAULT OKC_API.G_FALSE
,p_pay_cure_refunds_tbl IN pay_cure_refunds_tbl_type
,x_return_status OUT NOCOPY VARCHAR2
,x_msg_count OUT NOCOPY NUMBER
,x_msg_data OUT NOCOPY VARCHAR2
) IS
l_api_version NUMBER := 1;
l_api_name CONSTANT VARCHAR2(50) := 'DELETE_REFUND_DETAILS';
SAVEPOINT DELETE_REFUND_DETAILS;
'okl_pay_cure_refunds_pvt.DELETE_REFUND_DETAILS');
okl_pay_cure_refunds_pvt.DELETE_REFUND_DETAILS(
p_api_version => l_api_version
,p_init_msg_list => p_init_msg_list
,p_commit => p_commit
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_pay_cure_refunds_tbl => l_pay_cure_refunds_tbl);
OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'okl_pay_cure_refunds_pvt.DELETE_REFUND_DETAILS'
||l_return_status );
ROLLBACK TO DELETE_REFUND_DETAILS;
ROLLBACK TO DELETE_REFUND_DETAILS;
ROLLBACK TO DELETE_REFUND_DETAILS;
Fnd_Msg_Pub.ADD_EXC_MSG('OKL_PAY_CURE_REFUNDS_PUB','DELETE_REFUND_DETAILS');
END DELETE_REFUND_DETAILS;