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

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

Line: 101


    SELECT
            ID,
            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
      FROM Okl_K_Party_Roles_V
     WHERE okl_k_party_roles_v.id = p_id;

Line: 154


              l_kplv_rec.last_updated_by,
              l_kplv_rec.last_update_date,
              l_kplv_rec.last_update_login;

Line: 198


    SELECT
            ID,
            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
      FROM Okl_K_Party_Roles
     WHERE okl_k_party_roles.id = p_id;

Line: 251


              l_kpl_rec.last_updated_by,
              l_kpl_rec.last_update_date,
              l_kpl_rec.last_update_login;

Line: 355


    IF (l_kplv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_kplv_rec.last_updated_by := NULL;

Line: 358


    IF (l_kplv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_kplv_rec.last_update_date := NULL;

Line: 361


    IF (l_kplv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_kplv_rec.last_update_login := NULL;

Line: 605


    p_to.last_updated_by := p_from.last_updated_by;

Line: 606


    p_to.last_update_date := p_from.last_update_date;

Line: 607


    p_to.last_update_login := p_from.last_update_login;

Line: 634


    p_to.last_updated_by := p_from.last_updated_by;

Line: 635


    p_to.last_update_date := p_from.last_update_date;

Line: 636


    p_to.last_update_login := p_from.last_update_login;

Line: 882


  PROCEDURE insert_row(
    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_kpl_rec                      IN kpl_rec_type,
    x_kpl_rec                      OUT NOCOPY kpl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 891


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

Line: 927


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

Line: 1010


  END insert_row;

Line: 1014


  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_kplv_rec                     IN kplv_rec_type,
    x_kplv_rec                     OUT NOCOPY kplv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1024


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

Line: 1040


      l_kplv_rec.LAST_UPDATE_DATE := l_kplv_rec.CREATION_DATE;

Line: 1041


      l_kplv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1042


      l_kplv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1108


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_kpl_rec,
      lx_kpl_rec
    );

Line: 1157


  END insert_row;

Line: 1161


  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_kplv_tbl                     IN kplv_tbl_type,
    x_kplv_tbl                     OUT NOCOPY kplv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1172


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

Line: 1186


          insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_kplv_rec                     => p_kplv_tbl(i),
            x_kplv_rec                     => x_kplv_tbl(i));

Line: 1254


  END insert_row;

Line: 1259


  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_kplv_tbl                     IN kplv_tbl_type,
    x_kplv_tbl                     OUT NOCOPY kplv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1269


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

Line: 1276


      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_kplv_tbl                     => p_kplv_tbl,
        x_kplv_tbl                     => x_kplv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 1318


  END insert_row;

Line: 1336


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_K_PARTY_ROLES
     WHERE ID = p_kpl_rec.id
       AND OBJECT_VERSION_NUMBER = p_kpl_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1343


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_K_PARTY_ROLES
     WHERE ID = p_kpl_rec.id;

Line: 1384


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1393


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1673


  PROCEDURE update_row(
    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_kpl_rec                      IN kpl_rec_type,
    x_kpl_rec                      OUT NOCOPY kpl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1682


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

Line: 1782


        IF (x_kpl_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_kpl_rec.last_updated_by := l_kpl_rec.last_updated_by;

Line: 1786


        IF (x_kpl_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_kpl_rec.last_update_date := l_kpl_rec.last_update_date;

Line: 1790


        IF (x_kpl_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_kpl_rec.last_update_login := l_kpl_rec.last_update_login;

Line: 1836


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

Line: 1895


  END update_row;

Line: 1899


  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_kplv_rec                     IN kplv_rec_type,
    x_kplv_rec                     OUT NOCOPY kplv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1909


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

Line: 1924


      l_kplv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 1925


      l_kplv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 1926


      l_kplv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2025


        IF (x_kplv_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_kplv_rec.last_updated_by := l_db_kplv_rec.last_updated_by;

Line: 2029


        IF (x_kplv_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_kplv_rec.last_update_date := l_db_kplv_rec.last_update_date;

Line: 2033


        IF (x_kplv_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_kplv_rec.last_update_login := l_db_kplv_rec.last_update_login;

Line: 2120


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_kpl_rec,
      lx_kpl_rec
    );

Line: 2168


  END update_row;

Line: 2172


  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_kplv_tbl                     IN kplv_tbl_type,
    x_kplv_tbl                     OUT NOCOPY kplv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2183


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

Line: 2197


          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_kplv_rec                     => p_kplv_tbl(i),
            x_kplv_rec                     => x_kplv_tbl(i));

Line: 2265


  END update_row;

Line: 2270


  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_kplv_tbl                     IN kplv_tbl_type,
    x_kplv_tbl                     OUT NOCOPY kplv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2280


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

Line: 2287


      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_kplv_tbl                     => p_kplv_tbl,
        x_kplv_tbl                     => x_kplv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2329


  END update_row;

Line: 2337


  PROCEDURE delete_row(
    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_kpl_rec                      IN kpl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2345


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

Line: 2360


    DELETE FROM OKL_K_PARTY_ROLES
     WHERE ID = p_kpl_rec.id;

Line: 2396


  END delete_row;

Line: 2400


  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_kplv_rec                     IN kplv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2409


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

Line: 2433


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

Line: 2478


  END delete_row;

Line: 2482


  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_kplv_tbl                     IN kplv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2492


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

Line: 2506


          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_error_rec.error_type,
            x_msg_count                    => l_error_rec.msg_count,
            x_msg_data                     => l_error_rec.msg_data,
            p_kplv_rec                     => p_kplv_tbl(i));

Line: 2573


  END delete_row;

Line: 2578


  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_kplv_tbl                     IN kplv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2587


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

Line: 2594


      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_kplv_tbl                     => p_kplv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2635


  END delete_row;

Line: 2648


    INSERT INTO OKL_K_PARTY_ROLES_H
    (
      MAJOR_VERSION,
      ID,
      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
    )
    SELECT
      p_major_version,
      ID,
      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
    FROM OKL_K_PARTY_ROLES
    WHERE id in (select id
                 from okc_k_party_roles_b
                 where dnz_chr_id = p_chr_id);

Line: 2729


    INSERT INTO OKL_K_PARTY_ROLES
    (
      ID,
      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
    )
    SELECT
      ID,
      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
    FROM OKL_K_PARTY_ROLES_H
    WHERE id IN (select id
                 from okc_k_party_roles_b cpl
                 where dnz_chr_id = p_chr_id)
    AND major_version = p_major_version;