APPS.OKL_CS_LEASE_RENEWAL_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 159

PROCEDURE update_lrnw_request(
     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_trqv_rec              IN  okl_trx_requests_pub.trqv_rec_type
    ,x_trqv_rec              OUT  NOCOPY okl_trx_requests_pub.trqv_rec_type)
  AS

    l_return_status          VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 184

    okl_cs_lease_renewal_pvt.update_lrnw_request (p_api_version   => p_api_version,
                                                    p_init_msg_list => p_init_msg_list,
                                                   x_return_status => l_return_status,
                                                   x_msg_count     => l_msg_count,
                                                   x_msg_data      => l_msg_data,
                                                   p_trqv_rec      => p_trqv_rec,
                                                   x_trqv_rec      => x_trqv_rec);

Line: 222

      FND_MSG_PUB.ADD_EXC_MSG('okl_cs_lease_renewal_pub','update_lrnw_request');

Line: 226

  END update_lrnw_request;