APPS.OKL_ECC_DEF_PVT SQL Statements

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

Line: 19

    SELECT instr(lp_sql, ' ID,')
    INTO   i
    FROM   dual;

Line: 27

    SELECT instr(lp_sql, ' NAME ')
    INTO   i
    FROM   dual;

Line: 47

      SELECT 'x'
      FROM   okl_fe_crit_cat_def_v
      WHERE  crit_cat_name = p_eccv_rec.crit_cat_name
         AND ecc_ac_flag = p_eccv_rec.ecc_ac_flag;

Line: 96

          RAISE okl_api.g_exception_error;  --sql statement should contain ID and NAME as alias in Select clause

Line: 189

    okl_ecc_pvt.insert_row(p_api_version
                          ,okl_api.g_false
                          ,l_return_status
                          ,x_msg_count
                          ,x_msg_data
                          ,lp_eccv_rec
                          ,lx_eccv_rec);  -- write to log

Line: 200

                             ,'okl_ecc_pvt.insert_row returned with status ' ||
                              l_return_status ||
                              ' x_msg_data ' ||
                              x_msg_data);

Line: 218

      okl_eco_pvt.insert_row(p_api_version
                            ,okl_api.g_false
                            ,l_return_status
                            ,x_msg_count
                            ,x_msg_data
                            ,lp_eco_tbl
                            ,lx_eco_tbl);  -- write to log

Line: 228

                               ,'okl_eco_pvt.insert_row returned with status ' ||
                                l_return_status ||
                                ' x_msg_data ' ||
                                x_msg_data);

Line: 275

  PROCEDURE update_ecc(p_api_version    IN             number
                      ,p_init_msg_list  IN             varchar2     DEFAULT okl_api.g_false
                      ,x_return_status     OUT NOCOPY  varchar2
                      ,x_msg_count         OUT NOCOPY  number
                      ,x_msg_data          OUT NOCOPY  varchar2
                      ,p_eccv_rec       IN             okl_eccv_rec
                      ,x_eccv_rec          OUT NOCOPY  okl_eccv_rec
                      ,p_eco_tbl        IN             okl_eco_tbl
                      ,x_eco_tbl           OUT NOCOPY  okl_eco_tbl) IS
    lp_eccv_rec                    okl_eccv_rec;

Line: 294

    l_module              CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_ECC_DEF_PVT.UPDATE_ECC';

Line: 298

    l_api_name            CONSTANT varchar2(30) := 'update_ecc';

Line: 310

                             ,'begin debug OKLRECCB.pls call update_ecc');

Line: 333

    okl_ecc_pvt.update_row(p_api_version
                          ,okl_api.g_false
                          ,l_return_status
                          ,x_msg_count
                          ,x_msg_data
                          ,lp_eccv_rec
                          ,lx_eccv_rec);  -- write to log

Line: 344

                             ,'okl_ecc_pvt.update_row returned with status ' ||
                              l_return_status ||
                              ' x_msg_data ' ||
                              x_msg_data);

Line: 377

        okl_eco_pvt.insert_row(p_api_version
                              ,okl_api.g_false
                              ,l_return_status
                              ,x_msg_count
                              ,x_msg_data
                              ,lp_eco_crt_tbl
                              ,lx_eco_crt_tbl);  -- write to log

Line: 387

                                 ,'okl_eco_pvt.insert_row returned with status ' ||
                                  l_return_status ||
                                  ' x_msg_data ' ||
                                  x_msg_data);

Line: 399

        okl_eco_pvt.delete_row(p_api_version
                              ,okl_api.g_false
                              ,l_return_status
                              ,x_msg_count
                              ,x_msg_data
                              ,lp_eco_rmv_tbl);  -- write to log

Line: 408

                                 ,'okl_eco_pvt.delete_row returned with status ' ||
                                  l_return_status ||
                                  ' x_msg_data ' ||
                                  x_msg_data);

Line: 429

                             ,'end debug OKLRECCB.pls call update_ecc');

Line: 454

  END update_ecc;