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.OKS_AVL_PVT SQL Statements

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

Line: 43


    SELECT
            ID,
            OBJECT1_ID1,
            OBJECT1_ID2,
            JTOT_OBJECT1_CODE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            GENERAL_YN,
            EXCEPT_OBJECT_TYPE,
            START_DATE_ACTIVE,
            END_DATE_ACTIVE,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15
      FROM Oks_Serv_Avails
     WHERE oks_serv_avails.id   = p_id;

Line: 90


              l_sav_rec.LAST_UPDATED_BY,
              l_sav_rec.LAST_UPDATE_DATE,
              l_sav_rec.GENERAL_YN,
              l_sav_rec.EXCEPT_OBJECT_TYPE,
              l_sav_rec.START_DATE_ACTIVE,
              l_sav_rec.END_DATE_ACTIVE,
              l_sav_rec.LAST_UPDATE_LOGIN,
              l_sav_rec.ATTRIBUTE_CATEGORY,
              l_sav_rec.ATTRIBUTE1,
              l_sav_rec.ATTRIBUTE2,
              l_sav_rec.ATTRIBUTE3,
              l_sav_rec.ATTRIBUTE4,
              l_sav_rec.ATTRIBUTE5,
              l_sav_rec.ATTRIBUTE6,
              l_sav_rec.ATTRIBUTE7,
              l_sav_rec.ATTRIBUTE8,
              l_sav_rec.ATTRIBUTE9,
              l_sav_rec.ATTRIBUTE10,
              l_sav_rec.ATTRIBUTE11,
              l_sav_rec.ATTRIBUTE12,
              l_sav_rec.ATTRIBUTE13,
              l_sav_rec.ATTRIBUTE14,
              l_sav_rec.ATTRIBUTE15;

Line: 133


    SELECT
            ID,
            OBJECT1_ID1,
            OBJECT1_ID2,
            JTOT_OBJECT1_CODE,
            OBJECT_VERSION_NUMBER,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            GENERAL_YN,
            EXCEPT_OBJECT_TYPE,
            START_DATE_ACTIVE,
            END_DATE_ACTIVE,
            LAST_UPDATE_LOGIN,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15
      FROM Oks_Serv_Avails_V
     WHERE oks_serv_avails_v.id = p_id;

Line: 180


              l_savv_rec.LAST_UPDATED_BY,
              l_savv_rec.LAST_UPDATE_DATE,
              l_savv_rec.GENERAL_YN,
              l_savv_rec.EXCEPT_OBJECT_TYPE,
              l_savv_rec.START_DATE_ACTIVE,
              l_savv_rec.END_DATE_ACTIVE,
              l_savv_rec.LAST_UPDATE_LOGIN,
              l_savv_rec.ATTRIBUTE_CATEGORY,
              l_savv_rec.ATTRIBUTE1,
              l_savv_rec.ATTRIBUTE2,
              l_savv_rec.ATTRIBUTE3,
              l_savv_rec.ATTRIBUTE4,
              l_savv_rec.ATTRIBUTE5,
              l_savv_rec.ATTRIBUTE6,
              l_savv_rec.ATTRIBUTE7,
              l_savv_rec.ATTRIBUTE8,
              l_savv_rec.ATTRIBUTE9,
              l_savv_rec.ATTRIBUTE10,
              l_savv_rec.ATTRIBUTE11,
              l_savv_rec.ATTRIBUTE12,
              l_savv_rec.ATTRIBUTE13,
              l_savv_rec.ATTRIBUTE14,
              l_savv_rec.ATTRIBUTE15;

Line: 242


    IF (l_savv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_savv_rec.last_updated_by := NULL;

Line: 245


    IF (l_savv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_savv_rec.last_update_date := NULL;

Line: 260


    IF (l_savv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_savv_rec.last_update_login := NULL;

Line: 1950


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1951


    p_to.last_update_date := p_from.last_update_date;

Line: 1956


    p_to.last_update_login := p_from.last_update_login;

Line: 1986


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1987


    p_to.last_update_date := p_from.last_update_date;

Line: 1992


    p_to.last_update_login := p_from.last_update_login;

Line: 2167


  PROCEDURE insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sav_rec                      IN sav_rec_type,
    x_sav_rec                      OUT NOCOPY sav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2176


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

Line: 2216


    INSERT INTO OKS_SERV_AVAILS(
        id,
        object1_id1,
        object1_id2,
        JTOT_OBJECT1_CODE,
        object_version_number,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        general_yn,
        except_object_type,
        start_date_active,
        end_date_active,
        last_update_login,
        attribute_category,
        attribute1,
        attribute2,
        attribute3,
        attribute4,
        attribute5,
        attribute6,
        attribute7,
        attribute8,
        attribute9,
        attribute10,
        attribute11,
        attribute12,
        attribute13,
        attribute14,
        attribute15)
      VALUES (
        l_sav_rec.id,
        l_sav_rec.object1_id1,
        l_sav_rec.object1_id2,
        l_sav_rec.JTOT_OBJECT1_CODE,
        l_sav_rec.object_version_number,
        l_sav_rec.created_by,
        l_sav_rec.creation_date,
        l_sav_rec.last_updated_by,
        l_sav_rec.last_update_date,
        l_sav_rec.general_yn,
        l_sav_rec.except_object_type,
        l_sav_rec.start_date_active,
        l_sav_rec.end_date_active,
        l_sav_rec.last_update_login,
        l_sav_rec.attribute_category,
        l_sav_rec.attribute1,
        l_sav_rec.attribute2,
        l_sav_rec.attribute3,
        l_sav_rec.attribute4,
        l_sav_rec.attribute5,
        l_sav_rec.attribute6,
        l_sav_rec.attribute7,
        l_sav_rec.attribute8,
        l_sav_rec.attribute9,
        l_sav_rec.attribute10,
        l_sav_rec.attribute11,
        l_sav_rec.attribute12,
        l_sav_rec.attribute13,
        l_sav_rec.attribute14,
        l_sav_rec.attribute15);

Line: 2314


  END insert_row;

Line: 2318


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_savv_rec                     IN savv_rec_type,
    x_savv_rec                     OUT NOCOPY savv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2328


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

Line: 2344


      l_savv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 2345


      l_savv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2346


      l_savv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2418


    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sav_rec,
      lx_sav_rec
    );

Line: 2468


  END insert_row;

Line: 2472


  PROCEDURE insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_savv_tbl                     IN savv_tbl_type,
    x_savv_tbl                     OUT NOCOPY savv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2482


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

Line: 2491


        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_savv_rec                     => p_savv_tbl(i),
          x_savv_rec                     => x_savv_tbl(i));

Line: 2535


  END insert_row;

Line: 2553


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_SERV_AVAILS
     WHERE ID = p_sav_rec.id
       AND OBJECT_VERSION_NUMBER = p_sav_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2560


    SELECT OBJECT_VERSION_NUMBER
      FROM OKS_SERV_AVAILS
    WHERE ID = p_sav_rec.id;

Line: 2601


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2610


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2797


  PROCEDURE update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sav_rec                      IN sav_rec_type,
    x_sav_rec                      OUT NOCOPY sav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 2806


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

Line: 2856


      IF (x_sav_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_sav_rec.last_updated_by := l_sav_rec.last_updated_by;

Line: 2860


      IF (x_sav_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_sav_rec.last_update_date := l_sav_rec.last_update_date;

Line: 2880


      IF (x_sav_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_sav_rec.last_update_login := l_sav_rec.last_update_login;

Line: 2988


    UPDATE  OKS_SERV_AVAILS
    SET OBJECT1_ID1 = l_def_sav_rec.object1_id1,
        OBJECT1_ID2 = l_def_sav_rec.object1_id2,
        JTOT_OBJECT1_CODE = l_def_sav_rec.JTOT_OBJECT1_CODE,
        OBJECT_VERSION_NUMBER = l_def_sav_rec.object_version_number,
        CREATED_BY = l_def_sav_rec.created_by,
        CREATION_DATE = l_def_sav_rec.creation_date,
        LAST_UPDATED_BY = l_def_sav_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_sav_rec.last_update_date,
        GENERAL_YN = l_def_sav_rec.general_yn,
        EXCEPT_OBJECT_TYPE = l_def_sav_rec.except_object_type,
        START_DATE_ACTIVE = l_def_sav_rec.start_date_active,
        END_DATE_ACTIVE = l_def_sav_rec.end_date_active,
        LAST_UPDATE_LOGIN = l_def_sav_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_def_sav_rec.attribute_category,
        ATTRIBUTE1 = l_def_sav_rec.attribute1,
        ATTRIBUTE2 = l_def_sav_rec.attribute2,
        ATTRIBUTE3 = l_def_sav_rec.attribute3,
        ATTRIBUTE4 = l_def_sav_rec.attribute4,
        ATTRIBUTE5 = l_def_sav_rec.attribute5,
        ATTRIBUTE6 = l_def_sav_rec.attribute6,
        ATTRIBUTE7 = l_def_sav_rec.attribute7,
        ATTRIBUTE8 = l_def_sav_rec.attribute8,
        ATTRIBUTE9 = l_def_sav_rec.attribute9,
        ATTRIBUTE10 = l_def_sav_rec.attribute10,
        ATTRIBUTE11 = l_def_sav_rec.attribute11,
        ATTRIBUTE12 = l_def_sav_rec.attribute12,
        ATTRIBUTE13 = l_def_sav_rec.attribute13,
        ATTRIBUTE14 = l_def_sav_rec.attribute14,

        ATTRIBUTE15 = l_def_sav_rec.attribute15
    WHERE ID = l_def_sav_rec.id;

Line: 3054


  END update_row;

Line: 3058


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_savv_rec                     IN savv_rec_type,
    x_savv_rec                     OUT NOCOPY savv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3068


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

Line: 3082


      l_savv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3083


      l_savv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3084


      l_savv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3132


      IF (x_savv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_savv_rec.last_updated_by := l_savv_rec.last_updated_by;

Line: 3136


      IF (x_savv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_savv_rec.last_update_date := l_savv_rec.last_update_date;

Line: 3156


      IF (x_savv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_savv_rec.last_update_login := l_savv_rec.last_update_login;

Line: 3292


    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sav_rec,
      lx_sav_rec
    );

Line: 3339


  END update_row;

Line: 3343


  PROCEDURE update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_savv_tbl                     IN savv_tbl_type,
    x_savv_tbl                     OUT NOCOPY savv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3353


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

Line: 3362


        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_savv_rec                     => p_savv_tbl(i),
          x_savv_rec                     => x_savv_tbl(i));

Line: 3405


  END update_row;

Line: 3413


  PROCEDURE delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_sav_rec                      IN sav_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3421


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

Line: 3435


    DELETE FROM OKS_SERV_AVAILS
     WHERE ID = l_sav_rec.id;

Line: 3470


  END delete_row;

Line: 3474


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_savv_rec                     IN savv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3483


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

Line: 3507


    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_sav_rec
    );

Line: 3551


  END delete_row;

Line: 3555


  PROCEDURE delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_savv_tbl                     IN savv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;

Line: 3564


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

Line: 3573


        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKC_API.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_savv_rec                     => p_savv_tbl(i));

Line: 3615


  END delete_row;

Line: 3617


PROCEDURE INSERT_ROW_UPG(p_savv_tbl savv_tbl_type ) IS
  l_tabsize NUMBER := p_savv_tbl.COUNT;

Line: 3650


  in_last_updated_by               OKC_DATATYPES.NumberTabTyp;

Line: 3651


  in_last_update_date              OKC_DATATYPES.DateTabTyp;

Line: 3652


  in_last_update_login             OKC_DATATYPES.NumberTabTyp;

Line: 3689


    in_last_updated_by               (j) := p_savv_tbl(i).last_updated_by;

Line: 3690


    in_last_update_date              (j) := p_savv_tbl(i).last_update_date;

Line: 3691


    in_last_update_login             (j) := p_savv_tbl(i).last_update_login;

Line: 3698


  Insert into
              OKS_SERV_AVAILS
              (
                id
               , object1_id1
               , object1_id2
               , jtot_object1_code
               , general_yn
               , except_object_type
               , start_date_active
               , end_date_active
               , object_version_number
               , attribute_category
               , attribute1
               , attribute2
               , attribute3
               , attribute4
               , attribute5
               , attribute6
               , attribute7
               , attribute8
               , attribute9
               , attribute10
               , attribute11
               , attribute12
               , attribute13
               , attribute14
               , attribute15
               , created_by
               , creation_date
               , last_updated_by
               , last_update_date
               , last_update_login
              )
              Values
              (
                 in_id(i),
                 in_object1_id1(i),
                 in_object1_id2(i),
                 in_jtot_object1_code(i),
                 in_general_yn(i),
                 in_except_object_type(i),
                 in_start_date_active(i),
                 in_end_date_active(i),
                 in_object_version_number(i),
                 in_attribute_category(i),
                 in_attribute1(i),
                 in_attribute2(i),
                 in_attribute3(i),
                 in_attribute4(i),
                 in_attribute5(i),
                 in_attribute6(i),
                 in_attribute7(i),
                 in_attribute8(i),
                 in_attribute9(i),
                 in_attribute10(i),
                 in_attribute11(i),
                 in_attribute12(i),
                 in_attribute13(i),
                 in_attribute14(i),
                 in_attribute15(i),
                 in_created_by(i),
                 in_creation_date(i),
                 in_last_updated_by(i),
                 in_last_update_date(i),
                 in_last_update_login(i)
              );

Line: 3768


END INSERT_ROW_UPG;