eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_ECL_PVT SQL Statements

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

Line: 48


      SELECT        object_version_number
      FROM          okl_fe_criteria
      WHERE         criteria_id = p_ecl_rec.criteria_id
                AND object_version_number = p_ecl_rec.object_version_number
      FOR UPDATE OF object_version_number NOWAIT;

Line: 55


      SELECT object_version_number
      FROM   okl_fe_criteria
      WHERE  criteria_id = p_ecl_rec.criteria_id;

Line: 101


      okl_api.set_message(g_fnd_app, g_form_record_deleted);

Line: 110


      okl_api.set_message(g_app_name, g_record_logically_deleted);

Line: 320


      SELECT 'x'
      FROM   okl_fe_crit_cat_def_v
      WHERE  crit_cat_def_id = p_crit_cat_def_id;

Line: 404


      SELECT 'x'
      FROM   okl_fe_criteria_set
      WHERE  criteria_set_id = p_criteria_set_id;

Line: 565


      SELECT criteria_id
            ,object_version_number
            ,criteria_set_id
            ,crit_cat_def_id
            ,effective_from_date
            ,effective_to_date
            ,match_criteria_code
            ,created_by
            ,creation_date
            ,last_updated_by
            ,last_update_date
            ,last_update_login
      FROM   okl_fe_criteria
      WHERE  okl_fe_criteria.criteria_id = p_id;

Line: 597


                         ,l_ecl_rec.last_updated_by
                         ,l_ecl_rec.last_update_date
                         ,l_ecl_rec.last_update_login ;

Line: 653


    IF (l_ecl_rec.last_updated_by = okl_api.g_miss_num) THEN
      l_ecl_rec.last_updated_by := NULL;

Line: 657


    IF (l_ecl_rec.last_update_date = okl_api.g_miss_date) THEN
      l_ecl_rec.last_update_date := NULL;

Line: 661


    IF (l_ecl_rec.last_update_login = okl_api.g_miss_num) THEN
      l_ecl_rec.last_update_login := NULL;

Line: 783


  PROCEDURE insert_row(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_ecl_rec        IN             okl_ecl_rec
                      ,x_ecl_rec           OUT NOCOPY  okl_ecl_rec) IS
    l_api_version   CONSTANT number := 1;

Line: 791


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

Line: 802


      l_ecl_rec.last_update_date := sysdate;

Line: 803


      l_ecl_rec.last_updated_by := fnd_global.user_id;

Line: 804


      l_ecl_rec.last_update_login := fnd_global.login_id;

Line: 877


    END IF;  --insert into table

Line: 879


    INSERT INTO okl_fe_criteria
               (criteria_id
               ,object_version_number
               ,criteria_set_id
               ,crit_cat_def_id
               ,effective_from_date
               ,effective_to_date
               ,match_criteria_code
               ,created_by
               ,creation_date
               ,last_updated_by
               ,last_update_date
               ,last_update_login)
    VALUES     (l_def_ecl_rec.criteria_id
               ,l_def_ecl_rec.object_version_number
               ,l_def_ecl_rec.criteria_set_id
               ,l_def_ecl_rec.crit_cat_def_id
               ,l_def_ecl_rec.effective_from_date
               ,l_def_ecl_rec.effective_to_date
               ,l_def_ecl_rec.match_criteria_code
               ,l_def_ecl_rec.created_by
               ,l_def_ecl_rec.creation_date
               ,l_def_ecl_rec.last_updated_by
               ,l_def_ecl_rec.last_update_date
               ,l_def_ecl_rec.last_update_login);

Line: 937


  END insert_row;

Line: 943


  PROCEDURE insert_row(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_ecl_tbl        IN             okl_ecl_tbl
                      ,x_ecl_tbl           OUT NOCOPY  okl_ecl_tbl) IS
    l_api_version    CONSTANT number := 1;

Line: 951


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

Line: 965


        insert_row(p_api_version   =>  p_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_ecl_rec       =>  p_ecl_tbl(i)
                  ,x_ecl_rec       =>  x_ecl_tbl(i));

Line: 1010


  END insert_row;

Line: 1016


  PROCEDURE update_row(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_ecl_rec        IN             okl_ecl_rec
                      ,x_ecl_rec           OUT NOCOPY  okl_ecl_rec) IS
    l_api_version   CONSTANT number := 1;

Line: 1024


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

Line: 1034


      l_ecl_rec.last_update_date := sysdate;

Line: 1035


      l_ecl_rec.last_updated_by := fnd_global.user_id;

Line: 1036


      l_ecl_rec.last_update_login := fnd_global.login_id;

Line: 1183


    UPDATE okl_fe_criteria
    SET    criteria_id = l_def_ecl_rec.criteria_id
          ,object_version_number = l_def_ecl_rec.object_version_number + 1
          ,criteria_set_id = l_def_ecl_rec.criteria_set_id
          ,crit_cat_def_id = l_def_ecl_rec.crit_cat_def_id
          ,effective_from_date = l_def_ecl_rec.effective_from_date
          ,effective_to_date = l_def_ecl_rec.effective_to_date
          ,match_criteria_code = l_def_ecl_rec.match_criteria_code
          ,created_by = l_def_ecl_rec.created_by
          ,creation_date = l_def_ecl_rec.creation_date
          ,last_updated_by = l_def_ecl_rec.last_updated_by
          ,last_update_date = l_def_ecl_rec.last_update_date
          ,last_update_login = l_def_ecl_rec.last_update_login
    WHERE  criteria_id = l_def_ecl_rec.criteria_id;

Line: 1230


  END update_row;

Line: 1236


  PROCEDURE update_row(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_ecl_tbl        IN             okl_ecl_tbl
                      ,x_ecl_tbl           OUT NOCOPY  okl_ecl_tbl) IS
    l_api_version    CONSTANT number := 1;

Line: 1244


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

Line: 1258


        update_row(p_api_version   =>  p_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_ecl_rec       =>  p_ecl_tbl(i)
                  ,x_ecl_rec       =>  x_ecl_tbl(i));

Line: 1303


  END update_row;

Line: 1309


  PROCEDURE delete_row(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_ecl_rec        IN             okl_ecl_rec) IS
    l_api_version   CONSTANT number := 1;

Line: 1316


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

Line: 1336


    DELETE FROM okl_fe_criteria
    WHERE       criteria_id = l_ecl_rec.criteria_id;

Line: 1367


  END delete_row;

Line: 1373


  PROCEDURE delete_row(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_ecl_tbl        IN             okl_ecl_tbl) IS
    l_api_version    CONSTANT number := 1;

Line: 1380


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

Line: 1394


        delete_row(p_api_version   =>  p_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_ecl_rec       =>  p_ecl_tbl(i));

Line: 1438


  END delete_row;