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_ECH_PVT SQL Statements

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

Line: 48


      SELECT        object_version_number
      FROM          okl_fe_criteria_set
      WHERE         criteria_set_id = p_ech_rec.criteria_set_id
                AND object_version_number = p_ech_rec.object_version_number
      FOR UPDATE OF object_version_number NOWAIT;

Line: 55


      SELECT object_version_number
      FROM   okl_fe_criteria_set
      WHERE  criteria_set_id = p_ech_rec.criteria_set_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: 415


      SELECT criteria_set_id
            ,object_version_number
            ,source_id
            ,source_object_code
            ,match_criteria_code
            ,validation_code
            ,created_by
            ,creation_date
            ,last_updated_by
            ,last_update_date
            ,last_update_login
      FROM   okl_fe_criteria_set
      WHERE  okl_fe_criteria_set.criteria_set_id = p_id;

Line: 445


                         ,l_ech_rec.last_updated_by
                         ,l_ech_rec.last_update_date
                         ,l_ech_rec.last_update_login ;

Line: 497


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

Line: 501


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

Line: 505


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

Line: 646


  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_ech_rec        IN             okl_ech_rec
                      ,x_ech_rec           OUT NOCOPY  okl_ech_rec) IS
    l_api_version   CONSTANT number := 1;

Line: 654


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

Line: 665


      l_ech_rec.last_update_date := sysdate;

Line: 666


      l_ech_rec.last_updated_by := fnd_global.user_id;

Line: 667


      l_ech_rec.last_update_login := fnd_global.login_id;

Line: 746


    END IF;  --insert into table

Line: 748


    INSERT INTO okl_fe_criteria_set
               (criteria_set_id
               ,object_version_number
               ,source_id
               ,source_object_code
               ,match_criteria_code
               ,validation_code
               ,created_by
               ,creation_date
               ,last_updated_by
               ,last_update_date
               ,last_update_login)
    VALUES     (l_def_ech_rec.criteria_set_id
               ,l_def_ech_rec.object_version_number
               ,l_def_ech_rec.source_id
               ,l_def_ech_rec.source_object_code
               ,l_def_ech_rec.match_criteria_code
               ,l_def_ech_rec.validation_code
               ,l_def_ech_rec.created_by
               ,l_def_ech_rec.creation_date
               ,l_def_ech_rec.last_updated_by
               ,l_def_ech_rec.last_update_date
               ,l_def_ech_rec.last_update_login);

Line: 804


  END insert_row;

Line: 810


  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_ech_tbl        IN             okl_ech_tbl
                      ,x_ech_tbl           OUT NOCOPY  okl_ech_tbl) IS
    l_api_version    CONSTANT number := 1;

Line: 818


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

Line: 832


        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_ech_rec       =>  p_ech_tbl(i)
                  ,x_ech_rec       =>  x_ech_tbl(i));

Line: 877


  END insert_row;

Line: 883


  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_ech_rec        IN             okl_ech_rec
                      ,x_ech_rec           OUT NOCOPY  okl_ech_rec) IS
    l_api_version   CONSTANT number := 1;

Line: 891


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

Line: 901


      l_ech_rec.last_update_date := sysdate;

Line: 902


      l_ech_rec.last_updated_by := fnd_global.user_id;

Line: 903


      l_ech_rec.last_update_login := fnd_global.login_id;

Line: 1047


    UPDATE okl_fe_criteria_set
    SET    criteria_set_id = l_def_ech_rec.criteria_set_id
          ,object_version_number = l_def_ech_rec.object_version_number + 1
          ,source_id = l_def_ech_rec.source_id
          ,source_object_code = l_def_ech_rec.source_object_code
          ,match_criteria_code = l_def_ech_rec.match_criteria_code
          ,validation_code = l_def_ech_rec.validation_code
          ,created_by = l_def_ech_rec.created_by
          ,creation_date = l_def_ech_rec.creation_date
          ,last_updated_by = l_def_ech_rec.last_updated_by
          ,last_update_date = l_def_ech_rec.last_update_date
          ,last_update_login = l_def_ech_rec.last_update_login
    WHERE  criteria_set_id = l_def_ech_rec.criteria_set_id;

Line: 1094


  END update_row;

Line: 1100


  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_ech_tbl        IN             okl_ech_tbl
                      ,x_ech_tbl           OUT NOCOPY  okl_ech_tbl) IS
    l_api_version    CONSTANT number := 1;

Line: 1108


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

Line: 1122


        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_ech_rec       =>  p_ech_tbl(i)
                  ,x_ech_rec       =>  x_ech_tbl(i));

Line: 1167


  END update_row;

Line: 1173


  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_ech_rec        IN             okl_ech_rec) IS
    l_api_version   CONSTANT number := 1;

Line: 1180


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

Line: 1200


    DELETE FROM okl_fe_criteria_set
    WHERE       criteria_set_id = l_ech_rec.criteria_set_id;

Line: 1231


  END delete_row;

Line: 1237


  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_ech_tbl        IN             okl_ech_tbl) IS
    l_api_version    CONSTANT number := 1;

Line: 1244


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

Line: 1258


        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_ech_rec       =>  p_ech_tbl(i));

Line: 1302


  END delete_row;