The following lines contain the word 'select', 'insert', 'update' or 'delete':
SAVEPOINT save_Insert_row;
ROLLBACK TO save_Insert_row;
ROLLBACK TO save_Insert_row;
ROLLBACK TO save_Insert_row;
Fnd_Msg_Pub.ADD_EXC_MSG('OKL_XCB_PUB','insert_row');
PROCEDURE update_ext_ar_txns(
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_xcrv_rec IN xcrv_rec_type
,p_xcav_tbl IN xcav_tbl_type
,x_xcrv_rec OUT NOCOPY xcrv_rec_type
,x_xcav_tbl OUT NOCOPY xcav_tbl_type
) IS
l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
SAVEPOINT save_update_row;
Okl_Extrn_Pvt.UPDATE_EXT_CSH_TXNS(
p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcrv_rec
,p_xcav_tbl
,x_xcrv_rec
,x_xcav_tbl
);
ROLLBACK TO save_update_row;
ROLLBACK TO save_update_row;
ROLLBACK TO save_update_row;
Fnd_Msg_Pub.ADD_EXC_MSG('OKL_XCB_PUB','update_row');
END update_ext_ar_txns;
PROCEDURE update_ext_csh_txns(
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_xcrv_rec IN xcrv_rec_type
,x_xcrv_rec OUT NOCOPY xcrv_rec_type
) IS
l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
SAVEPOINT save_update_row;
Okl_Extrn_Pvt.update_ext_csh_txns(
p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcrv_rec
,x_xcrv_rec
);
ROLLBACK TO save_update_row;
ROLLBACK TO save_update_row;
ROLLBACK TO save_update_row;
Fnd_Msg_Pub.ADD_EXC_MSG('OKL_XCB_PUB','update_row');
END update_ext_csh_txns;
PROCEDURE delete_ext_ar_txns(
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_xcrv_rec IN xcrv_rec_type
,p_xcav_tbl IN xcav_tbl_type
,x_xcrv_rec OUT NOCOPY xcrv_rec_type
,x_xcav_tbl OUT NOCOPY xcav_tbl_type
) IS
l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
SAVEPOINT save_update_row;
Okl_Extrn_Pvt.DELETE_EXT_CSH_TXNS(
p_api_version
,p_init_msg_list
,x_return_status
,x_msg_count
,x_msg_data
,p_xcrv_rec
,p_xcav_tbl
,x_xcrv_rec
,x_xcav_tbl
);
ROLLBACK TO save_update_row;
ROLLBACK TO save_update_row;
ROLLBACK TO save_update_row;
Fnd_Msg_Pub.ADD_EXC_MSG('OKL_XCR_PUB','delete_row');
END delete_ext_ar_txns;