APPS.OKL_CURE_RECON_PUB SQL Statements

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

Line: 10

PROCEDURE UPDATE_CURE_INVOICE (
                               p_api_version   IN NUMBER,
                               p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.G_FALSE,
                               p_commit        IN VARCHAR2 DEFAULT fnd_api.G_FALSE,
                               p_report_id     IN NUMBER,
                               p_invoice_date  IN DATE,
                               p_cam_tbl       IN cure_amount_tbl,
                               p_operation     IN VARCHAR2,
                               x_return_status OUT NOCOPY VARCHAR2,
                               x_msg_count     OUT NOCOPY NUMBER,
                               x_msg_data      OUT NOCOPY VARCHAR2) IS
  l_return_status      VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line: 29

        SAVEPOINT UPDATE_CURE_INVOICE;

Line: 30

        OKL_CURE_RECON_PVT.UPDATE_CURE_INVOICE(
                              p_api_version   =>p_api_version,
                              p_init_msg_list =>p_init_msg_list,
                              p_commit        => p_commit,
                              p_report_id     =>p_report_id,
                              p_invoice_date  =>p_invoice_date,
                              p_cam_tbl       =>p_cam_tbl,
                              p_operation     =>p_operation,
                              x_return_status => l_return_status,
                              x_msg_count     => l_msg_count,
                              x_msg_data      => l_msg_data );

Line: 48

                                      OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKL_CURE_RECON_PUB.UPDATE_CURE_INVOICE status is '
                                    ||l_return_status || 'operation was ' ||p_operation);

Line: 62

      ROLLBACK TO UPDATE_CURE_INVOICE;

Line: 70

      ROLLBACK TO UPDATE_CURE_INVOICE;

Line: 78

      ROLLBACK TO UPDATE_CURE_INVOICE;

Line: 82

      Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CURE_RECON_PUB','UPDATE_CURE_INVOICE');

Line: 87

 END UPDATE_CURE_INVOICE;