APPS.OKL_ACCOUNT_DIST_MISC_PUB SQL Statements

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

Line: 5

PROCEDURE insert_updt_dstrs(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_tabv_tbl            IN  tabv_tbl_type,
                            x_tabv_tbl            OUT NOCOPY tabv_tbl_type)

IS
  l_api_version       CONSTANT NUMBER        := 1.0;

Line: 15

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

Line: 24

  SAVEPOINT insert_updt_dstrs;

Line: 36

   OKL_ACCOUNT_DIST_MISC_PVT.insert_updt_dstrs(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_tabv_tbl            => l_tabv_tbl,
                                               x_tabv_tbl            => x_tabv_tbl);

Line: 62

      ROLLBACK TO insert_updt_dstrs;

Line: 70

      ROLLBACK TO insert_updt_dstrs;

Line: 78

      FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCOUNT_DIST_MISC_PUB','INSERT_UPDT_DSTRS');

Line: 88

END insert_updt_dstrs;