APPS.OKL_XMLP_PARAMS_PVT SQL Statements

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

Line: 55

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');

Line: 80

   okl_xmp_pvt.insert_row( l_api_version,
                           l_init_msg_list,
                           l_return_status,
                           l_msg_count,
                           l_msg_data,
                           l_xmp_rec,
                           x_xmp_rec);

Line: 101

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');

Line: 193

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');

Line: 218

   okl_xmp_pvt.insert_row( l_api_version,
                           l_init_msg_list,
                           l_return_status,
                           l_msg_count,
                           l_msg_data,
                           l_xmp_tbl,
                           x_xmp_tbl);

Line: 239

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');

Line: 294

  PROCEDURE update_xmlp_params_rec     ( 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_xmp_rec         IN  xmp_rec_type
                                 ,x_xmp_rec         OUT NOCOPY xmp_rec_type
                                ) IS
---------------------------
-- DECLARE Local Variables
---------------------------
  L_MODULE                   CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.update_xmlp_params_rec';

Line: 315

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

Line: 328

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');

Line: 336

   SAVEPOINT update_xmlp_params_rec_PVT;

Line: 352

   okl_xmp_pvt.update_row(l_api_version,
                          l_init_msg_list,
                          l_return_status,
                          l_msg_count,
                          l_msg_data,
                          l_xmp_rec,
                          x_xmp_rec);

Line: 373

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');

Line: 411

END update_xmlp_params_rec;

Line: 427

  PROCEDURE update_xmlp_params_tbl     ( 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_xmp_tbl         IN  xmp_tbl_type
                                 ,x_xmp_tbl         OUT NOCOPY xmp_tbl_type
                                ) IS
---------------------------
-- DECLARE Local Variables
---------------------------
  L_MODULE                   CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.update_xmlp_params_tbl';

Line: 448

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

Line: 461

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');

Line: 469

   SAVEPOINT update_xmlp_params_rec_PVT;

Line: 485

   okl_xmp_pvt.update_row(l_api_version,
                          l_init_msg_list,
                          l_return_status,
                          l_msg_count,
                          l_msg_data,
                          l_xmp_tbl,
                          x_xmp_tbl);

Line: 506

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');

Line: 544

END update_xmlp_params_tbl;

Line: 560

  PROCEDURE delete_xmlp_params     ( 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_batch_id         IN  OKL_XMLP_PARAMS.Batch_Id%TYPE
                                ) IS
---------------------------
-- DECLARE Local Variables
---------------------------
  L_MODULE                   CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.delete_xmlp_params';

Line: 582

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

Line: 589

  SELECT ID,
         BATCH_ID
  FROM OKL_XMLP_PARAMS
  WHERE BATCH_ID = p_batch_id;

Line: 602

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.delete_row ');

Line: 610

  SAVEPOINT delete_xmlp_params_PVT;

Line: 629

    okl_xmp_pvt.delete_row(l_api_version,
                           l_init_msg_list,
                           l_return_status,
                           l_msg_count,
                           l_msg_data,
                           l_xmp_rec);

Line: 650

        Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.delete_row ');

Line: 687

 END delete_xmlp_params;