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

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

Line: 43


    SELECT ID,
           LPO_ID,
            STY_ID,
            OBJECT_VERSION_NUMBER,
            LATE_POLICY_EXEMPT_YN,
            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
      FROM Okl_Strm_Type_Exempt_V
     WHERE okl_strm_type_exempt_v.id = p_id;

Line: 101


              l_slxv_rec.last_updated_by,
              l_slxv_rec.last_update_date,
              l_slxv_rec.last_update_login;

Line: 145


    SELECT
            ID,
            LPO_ID,
            STY_ID,
            OBJECT_VERSION_NUMBER,
            LATE_POLICY_EXEMPT_YN,
            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
      FROM Okl_Strm_Type_Exempt
     WHERE okl_strm_type_exempt.id = p_id;

Line: 204


              l_slx_rec.last_updated_by,
              l_slx_rec.last_update_date,
              l_slx_rec.last_update_login;

Line: 317


    IF (l_slxv_rec.last_updated_by = Okc_Api.G_MISS_NUM ) THEN
      l_slxv_rec.last_updated_by := NULL;

Line: 320


    IF (l_slxv_rec.last_update_date = Okc_Api.G_MISS_DATE ) THEN
      l_slxv_rec.last_update_date := NULL;

Line: 323


    IF (l_slxv_rec.last_update_login = Okc_Api.G_MISS_NUM ) THEN
      l_slxv_rec.last_update_login := NULL;

Line: 448


    p_to.last_updated_by := p_from.last_updated_by;

Line: 449


    p_to.last_update_date := p_from.last_update_date;

Line: 450


    p_to.last_update_login := p_from.last_update_login;

Line: 481


    p_to.last_updated_by := p_from.last_updated_by;

Line: 482


    p_to.last_update_date := p_from.last_update_date;

Line: 483


    p_to.last_update_login := p_from.last_update_login;

Line: 634


  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_slx_rec                      IN slx_rec_type,
    x_slx_rec                      OUT NOCOPY slx_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 643


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

Line: 679


    INSERT INTO OKL_STRM_TYPE_EXEMPT(
      id,
      lpo_id,
      sty_id,
      object_version_number,
      late_policy_exempt_yn,
      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 (
      l_slx_rec.id,
      l_slx_rec.lpo_id,
      l_slx_rec.sty_id,
      l_slx_rec.object_version_number,
      l_slx_rec.late_policy_exempt_yn,
      l_slx_rec.attribute_category,
      l_slx_rec.attribute1,
      l_slx_rec.attribute2,
      l_slx_rec.attribute3,
      l_slx_rec.attribute4,
      l_slx_rec.attribute5,
      l_slx_rec.attribute6,
      l_slx_rec.attribute7,
      l_slx_rec.attribute8,
      l_slx_rec.attribute9,
      l_slx_rec.attribute10,
      l_slx_rec.attribute11,
      l_slx_rec.attribute12,
      l_slx_rec.attribute13,
      l_slx_rec.attribute14,
      l_slx_rec.attribute15,
      l_slx_rec.created_by,
      l_slx_rec.creation_date,
      l_slx_rec.last_updated_by,
      l_slx_rec.last_update_date,
      l_slx_rec.last_update_login);

Line: 768


  END insert_row;

Line: 772


  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_slxv_rec                     IN slxv_rec_type,
    x_slxv_rec                     OUT NOCOPY slxv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 782


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

Line: 798


      l_slxv_rec.LAST_UPDATE_DATE := l_slxv_rec.CREATION_DATE;

Line: 799


      l_slxv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 800


      l_slxv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 864


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_slx_rec,
      lx_slx_rec
    );

Line: 913


  END insert_row;

Line: 917


  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_slxv_tbl                     IN slxv_tbl_type,
    x_slxv_tbl                     OUT NOCOPY slxv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 927


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

Line: 935


        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_slxv_rec                     => p_slxv_tbl(i),
           x_slxv_rec                     => x_slxv_tbl(i));

Line: 979


  END insert_row;

Line: 997


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_STRM_TYPE_EXEMPT
     WHERE ID = p_slx_rec.id
       AND OBJECT_VERSION_NUMBER = p_slx_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1004


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_STRM_TYPE_EXEMPT
     WHERE ID = p_slx_rec.id;

Line: 1045


      Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1054


      Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1242


  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_slx_rec                      IN slx_rec_type,
    x_slx_rec                      OUT NOCOPY slx_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1251


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

Line: 1363


        IF (x_slx_rec.last_updated_by = Okc_Api.G_MISS_NUM)
        THEN
          x_slx_rec.last_updated_by := l_slx_rec.last_updated_by;

Line: 1367


        IF (x_slx_rec.last_update_date = Okc_Api.G_MISS_DATE)
        THEN
          x_slx_rec.last_update_date := l_slx_rec.last_update_date;

Line: 1371


        IF (x_slx_rec.last_update_login = Okc_Api.G_MISS_NUM)
        THEN
          x_slx_rec.last_update_login := l_slx_rec.last_update_login;

Line: 1417


    UPDATE OKL_STRM_TYPE_EXEMPT
    SET LPO_ID = l_def_slx_rec.lpo_id,
        STY_ID = l_def_slx_rec.sty_id,
        OBJECT_VERSION_NUMBER = l_def_slx_rec.object_version_number,
        LATE_POLICY_EXEMPT_YN = l_def_slx_rec.late_policy_exempt_yn,
        ATTRIBUTE_CATEGORY = l_def_slx_rec.attribute_category,
        ATTRIBUTE1 = l_def_slx_rec.attribute1,
        ATTRIBUTE2 = l_def_slx_rec.attribute2,
        ATTRIBUTE3 = l_def_slx_rec.attribute3,
        ATTRIBUTE4 = l_def_slx_rec.attribute4,
        ATTRIBUTE5 = l_def_slx_rec.attribute5,
        ATTRIBUTE6 = l_def_slx_rec.attribute6,
        ATTRIBUTE7 = l_def_slx_rec.attribute7,
        ATTRIBUTE8 = l_def_slx_rec.attribute8,
        ATTRIBUTE9 = l_def_slx_rec.attribute9,
        ATTRIBUTE10 = l_def_slx_rec.attribute10,
        ATTRIBUTE11 = l_def_slx_rec.attribute11,
        ATTRIBUTE12 = l_def_slx_rec.attribute12,
        ATTRIBUTE13 = l_def_slx_rec.attribute13,
        ATTRIBUTE14 = l_def_slx_rec.attribute14,
        ATTRIBUTE15 = l_def_slx_rec.attribute15,
        CREATED_BY = l_def_slx_rec.created_by,
        CREATION_DATE = l_def_slx_rec.creation_date,
        LAST_UPDATED_BY = l_def_slx_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_slx_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_slx_rec.last_update_login
    WHERE ID = l_def_slx_rec.id;

Line: 1479


  END update_row;

Line: 1483


  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_slxv_rec                     IN slxv_rec_type,
    x_slxv_rec                     OUT NOCOPY slxv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1493


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

Line: 1508


      l_slxv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1509


      l_slxv_rec.LAST_UPDATED_BY := Fnd_Global.USER_ID;

Line: 1510


      l_slxv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;

Line: 1621


        IF (x_slxv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
        THEN
          x_slxv_rec.last_updated_by := l_db_slxv_rec.last_updated_by;

Line: 1625


        IF (x_slxv_rec.last_update_date = Okc_Api.G_MISS_DATE)
        THEN
          x_slxv_rec.last_update_date := l_db_slxv_rec.last_update_date;

Line: 1629


        IF (x_slxv_rec.last_update_login = Okc_Api.G_MISS_NUM)
        THEN
          x_slxv_rec.last_update_login := l_db_slxv_rec.last_update_login;

Line: 1699


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_slx_rec,
      lx_slx_rec
    );

Line: 1747


  END update_row;

Line: 1751


  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_slxv_tbl                     IN slxv_tbl_type,
    x_slxv_tbl                     OUT NOCOPY slxv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1761


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

Line: 1769


         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_slxv_rec                     => p_slxv_tbl(i),
           x_slxv_rec                     => x_slxv_tbl(i));

Line: 1813


  END update_row;

Line: 1820


  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_slx_rec                      IN slx_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1828


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

Line: 1843


    DELETE FROM OKL_STRM_TYPE_EXEMPT
     WHERE ID = p_slx_rec.id;

Line: 1879


  END delete_row;

Line: 1883


  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_slxv_rec                     IN slxv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1892


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

Line: 1916


    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_slx_rec
    );

Line: 1961


  END delete_row;

Line: 1965


  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_slxv_tbl                     IN slxv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1974


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

Line: 1982


         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_slxv_rec                     => p_slxv_tbl(i));

Line: 2026


  END delete_row;