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

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

Line: 48


      SELECT        object_version_number
      FROM          okl_fe_crit_cat_objects
      WHERE         object_class_id = p_eco_rec.object_class_id
                AND object_version_number = p_eco_rec.object_version_number
      FOR UPDATE OF object_version_number NOWAIT;

Line: 55


      SELECT object_version_number
      FROM   okl_fe_crit_cat_objects
      WHERE  object_class_id = p_eco_rec.object_class_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: 373


      SELECT 'x'
      FROM   okl_fe_crit_cat_def_v
      WHERE  crit_cat_def_id = p_crit_cat_def_id;

Line: 553


      SELECT object_class_id
            ,object_version_number
            ,crit_cat_def_id
            ,object_class_code
            ,created_by
            ,creation_date
            ,last_updated_by
            ,last_update_date
            ,last_update_login
      FROM   okl_fe_crit_cat_objects
      WHERE  okl_fe_crit_cat_objects.object_class_id = p_id;

Line: 579


                         ,l_eco_rec.last_updated_by
                         ,l_eco_rec.last_update_date
                         ,l_eco_rec.last_update_login ;

Line: 623


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

Line: 627


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

Line: 631


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

Line: 647


  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_eco_rec        IN             okl_eco_rec
                      ,x_eco_rec           OUT NOCOPY  okl_eco_rec) IS
    l_api_version   CONSTANT number := 1;

Line: 655


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

Line: 666


      l_eco_rec.last_update_date := sysdate;

Line: 667


      l_eco_rec.last_updated_by := fnd_global.user_id;

Line: 668


      l_eco_rec.last_update_login := fnd_global.login_id;

Line: 741


    INSERT INTO okl_fe_crit_cat_objects
               (object_class_id
               ,object_version_number
               ,crit_cat_def_id
               ,object_class_code
               ,created_by
               ,creation_date
               ,last_updated_by
               ,last_update_date
               ,last_update_login)
    VALUES     (l_def_eco_rec.object_class_id
               ,l_def_eco_rec.object_version_number
               ,l_def_eco_rec.crit_cat_def_id
               ,l_def_eco_rec.object_class_code
               ,l_def_eco_rec.created_by
               ,l_def_eco_rec.creation_date
               ,l_def_eco_rec.last_updated_by
               ,l_def_eco_rec.last_update_date
               ,l_def_eco_rec.last_update_login);

Line: 793


  END insert_row;

Line: 799


  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_eco_tbl        IN             okl_eco_tbl
                      ,x_eco_tbl           OUT NOCOPY  okl_eco_tbl) IS
    l_api_version    CONSTANT number := 1;

Line: 807


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

Line: 821


        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_eco_rec       =>            p_eco_tbl(i)
                  ,x_eco_rec       =>            x_eco_tbl(i));

Line: 866


  END insert_row;

Line: 872


  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_eco_rec        IN             okl_eco_rec
                      ,x_eco_rec           OUT NOCOPY  okl_eco_rec) IS
    l_api_version   CONSTANT number := 1;

Line: 880


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

Line: 890


      l_eco_rec.last_update_date := sysdate;

Line: 891


      l_eco_rec.last_updated_by := fnd_global.user_id;

Line: 892


      l_eco_rec.last_update_login := fnd_global.login_id;

Line: 1028


    UPDATE okl_fe_crit_cat_objects
    SET    object_class_id = l_def_eco_rec.object_class_id
          ,object_version_number = l_def_eco_rec.object_version_number + 1
          ,crit_cat_def_id = l_def_eco_rec.crit_cat_def_id
          ,object_class_code = l_def_eco_rec.object_class_code
          ,created_by = l_def_eco_rec.created_by
          ,creation_date = l_def_eco_rec.creation_date
          ,last_updated_by = l_def_eco_rec.last_updated_by
          ,last_update_date = l_def_eco_rec.last_update_date
          ,last_update_login = l_def_eco_rec.last_update_login
    WHERE  object_class_id = l_def_eco_rec.object_class_id;

Line: 1075


  END update_row;

Line: 1081


  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_eco_tbl        IN             okl_eco_tbl
                      ,x_eco_tbl           OUT NOCOPY  okl_eco_tbl) IS
    l_api_version    CONSTANT number := 1;

Line: 1089


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

Line: 1103


        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_eco_rec       =>            p_eco_tbl(i)
                  ,x_eco_rec       =>            x_eco_tbl(i));

Line: 1148


  END update_row;

Line: 1154


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

Line: 1161


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

Line: 1181


    DELETE FROM okl_fe_crit_cat_objects
    WHERE       object_class_id = l_eco_rec.object_class_id;

Line: 1211


  END delete_row;

Line: 1217


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

Line: 1224


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

Line: 1238


        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_eco_rec       =>            p_eco_tbl(i));

Line: 1282


  END delete_row;

Line: 1291


                          p_last_update_date       IN VARCHAR2) IS

    id        NUMBER;

Line: 1295


    f_ludate  DATE;    -- entity update date in file

Line: 1297


    db_ludate DATE;    -- entity update date in db

Line: 1309


    f_ludate := nvl(to_date(p_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 1313


       SELECT ID , LAST_UPDATED_BY, LAST_UPDATE_DATE
       into id, db_luby, db_ludate
       from OKL_FE_CRIT_CAT_OBJECTS
       where OBJECT_CLASS_ID  = p_object_class_id;

Line: 1320


         UPDATE OKL_FE_CRIT_CAT_OBJECTS
         SET
          OBJECT_VERSION_NUMBER = p_object_version_number,
          CRIT_CAT_DEF_ID       = to_number(p_crit_cat_def_id),
          OBJECT_CLASS_CODE     = p_object_class_code,
          LAST_UPDATE_DATE      = f_ludate,
          LAST_UPDATED_BY       = f_luby,
          LAST_UPDATE_LOGIN     = 0
         WHERE OBJECT_CLASS_ID = to_number(p_object_class_id);

Line: 1332


          INSERT INTO OKL_FE_CRIT_CAT_OBJECTS
          (OBJECT_CLASS_ID,
           OBJECT_VERSION_NUMBER,
           CRIT_CAT_DEF_ID,
           OBJECT_CLASS_CODE,
           CREATED_BY,
           CREATION_DATE,
           LAST_UPDATED_BY,
           LAST_UPDATE_DATE,
           LAST_UPDATE_LOGIN
           )
          VALUES(
           TO_NUMBER(p_object_class_id),
           p_OBJECT_VERSION_NUMBER,
           TO_NUMBER(p_crit_cat_def_id),
           p_object_class_code,
           f_luby,
           f_ludate,
           f_luby,
           f_ludate,
           0);