APPS.OKL_ACCOUNT_DIST_PUB SQL Statements

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

Line: 332

PROCEDURE UPDATE_POST_TO_GL(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_source_id            IN               NUMBER,
			    p_source_table         IN               VARCHAR2)
IS

  l_api_version          NUMBER := 1.0;

Line: 342

  l_api_name             CONSTANT VARCHAR2(30)  := 'UPDATE_POST_TO_GL';

Line: 349

  SAVEPOINT UPDATE_POST_TO_GL1;

Line: 364

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPTDTB.pls call OKL_ACCOUNT_DIST_PVT.UPDATE_POST_TO_GL ');

Line: 367

   OKL_ACCOUNT_DIST_PVT.UPDATE_POST_TO_GL(p_api_version       => l_api_version,
                                          p_init_msg_list     => OKL_API.G_FALSE,
                                          x_return_status     => x_return_status,
                                          x_msg_count         => x_msg_count,
                                          x_msg_data          => x_msg_data,
                                          p_source_id         => l_source_id,
				          p_source_table      => l_source_table);

Line: 376

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTDTB.pls call OKL_ACCOUNT_DIST_PVT.UPDATE_POST_TO_GL ');

Line: 393

      ROLLBACK TO UPDATE_POST_TO_GL1;

Line: 401

      ROLLBACK TO UPDATE_POST_TO_GL1;

Line: 409

      ROLLBACK TO UPDATE_POST_TO_GL1;

Line: 410

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCOUNT_DIST_PUB','UPDATE_POST_TO_GL');

Line: 418

END UPDATE_POST_TO_GL;

Line: 464

PROCEDURE  DELETE_ACCT_ENTRIES(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_source_id                  IN         NUMBER,
                               p_source_table               IN         VARCHAR2)

IS

BEGIN


-- Start of wraper code generated automatically by Debug code generator for OKL_ACCOUNT_DIST_PVT.DELETE_ACCT_ENTRIES
  IF(L_DEBUG_ENABLED='Y') THEN
    L_LEVEL_PROCEDURE :=FND_LOG.LEVEL_PROCEDURE;

Line: 484

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPTDTB.pls call OKL_ACCOUNT_DIST_PVT.DELETE_ACCT_ENTRIES ');

Line: 487

    OKL_ACCOUNT_DIST_PVT.DELETE_ACCT_ENTRIES(p_api_version       => p_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_source_id         => p_source_id,
                                             p_source_table      => p_source_table);

Line: 496

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPTDTB.pls call OKL_ACCOUNT_DIST_PVT.DELETE_ACCT_ENTRIES ');

Line: 501

END DELETE_ACCT_ENTRIES;