APPS.OKL_PERD_STATUS_PUB SQL Statements

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

Line: 113

PROCEDURE UPDATE_PERIOD_STATUS(p_api_version        IN       NUMBER,
                               p_init_msg_list      IN       VARCHAR2,
                               x_return_status      OUT      NOCOPY VARCHAR2,
                               x_msg_count          OUT      NOCOPY NUMBER,
                               x_msg_data           OUT      NOCOPY VARCHAR2,
                               p_period_tbl         IN       PERIOD_TBL_TYPE)
IS


l_api_version NUMBER := 1.0;

Line: 123

l_api_name    VARCHAR2(30) := 'UPDATE_PERIOD_STATUS';

Line: 132

  SAVEPOINT UPDATE_PERIOD_STATUS;

Line: 150

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPPSMB.pls call OKL_PERD_STATUS_PVT.UPDATE_PERIOD_STATUS ');

Line: 153

  OKL_PERD_STATUS_PVT.UPDATE_PERIOD_STATUS(p_api_version        => l_api_version,
                                           p_init_msg_list      => p_init_msg_list,
                                           x_return_status      => x_return_status,
                                           x_msg_count          => x_msg_count,
                                           x_msg_data           => x_msg_data,
                                           p_period_tbl         => p_period_tbl);

Line: 161

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPPSMB.pls call OKL_PERD_STATUS_PVT.UPDATE_PERIOD_STATUS ');

Line: 180

      ROLLBACK TO UPDATE_PERIOD_STATUS;

Line: 188

      ROLLBACK TO UPDATE_PERIOD_STATUS;

Line: 196

      FND_MSG_PUB.ADD_EXC_MSG('OKL_PERD_STATUS_PUB','UPDATE_PERIOD_STATUS');

Line: 205

END UPDATE_PERIOD_STATUS;