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

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

Line: 17


    SELECT
      ID,
      OBJECT_VERSION_NUMBER,
      CAT_ID1,
      CAT_ID2,
      TERM_IN_MONTHS,
      RESIDUAL_VALUE_PERCENT,
      ITEM_RESIDUAL_ID,
      STS_CODE,
      VERSION_NUMBER,
      START_DATE,
      END_DATE,
      CREATED_BY,
      CREATION_DATE,
      LAST_UPDATED_BY,
      LAST_UPDATE_DATE,
      LAST_UPDATE_LOGIN,
      ATTRIBUTE_CATEGORY,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10,
      ATTRIBUTE11,
      ATTRIBUTE12,
      ATTRIBUTE13,
      ATTRIBUTE14,
      ATTRIBUTE15
    INTO
      l_icpv_rec.id,
      l_icpv_rec.object_version_number,
      l_icpv_rec.cat_id1,
      l_icpv_rec.cat_id2,
      l_icpv_rec.term_in_months,
      l_icpv_rec.residual_value_percent,
      l_icpv_rec.item_residual_id,
      l_icpv_rec.sts_code,
      l_icpv_rec.version_number,
      l_icpv_rec.start_date,
      l_icpv_rec.end_date,
      l_icpv_rec.created_by,
      l_icpv_rec.creation_date,
      l_icpv_rec.last_updated_by,
      l_icpv_rec.last_update_date,
      l_icpv_rec.last_update_login,
      l_icpv_rec.attribute_category,
      l_icpv_rec.attribute1,
      l_icpv_rec.attribute2,
      l_icpv_rec.attribute3,
      l_icpv_rec.attribute4,
      l_icpv_rec.attribute5,
      l_icpv_rec.attribute6,
      l_icpv_rec.attribute7,
      l_icpv_rec.attribute8,
      l_icpv_rec.attribute9,
      l_icpv_rec.attribute10,
      l_icpv_rec.attribute11,
      l_icpv_rec.attribute12,
      l_icpv_rec.attribute13,
      l_icpv_rec.attribute14,
      l_icpv_rec.attribute15
    FROM okl_itm_cat_rv_prcs_v icpv
    WHERE icpv.id = p_id;

Line: 164


    IF (l_icpv_rec.last_updated_by = G_MISS_NUM ) THEN
      l_icpv_rec.last_updated_by := NULL;

Line: 167


    IF (l_icpv_rec.last_update_date = G_MISS_DATE ) THEN
      l_icpv_rec.last_update_date := NULL;

Line: 170


    IF (l_icpv_rec.last_update_login = G_MISS_NUM ) THEN
      l_icpv_rec.last_update_login := NULL;

Line: 862


      SELECT start_date,
             end_date
      FROM   okl_itm_cat_rv_prcs
      WHERE  cat_id1 = p_icpv_rec.cat_id1
      AND    cat_id2 = p_icpv_rec.cat_id2
      AND    term_in_months = p_icpv_rec.term_in_months
      AND    id <> p_icpv_rec.id
      AND    start_date IS NOT NULL
      ORDER BY start_date;

Line: 905


      SELECT description
      INTO   l_item_desc
      FROM   mtl_system_items_tl
      WHERE  inventory_item_id = p_icpv_rec.cat_id1
      AND    organization_id = p_icpv_rec.cat_id2
      AND    language = USERENV('LANG');

Line: 1135


  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_icpv_rec                     IN icpv_rec_type,
    x_icpv_rec                     OUT NOCOPY icpv_rec_type) IS

    l_api_name                     CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'insert_row (REC)';

Line: 1157


    l_icpv_rec.LAST_UPDATE_DATE      := SYSDATE;

Line: 1158


    l_icpv_rec.LAST_UPDATED_BY       := FND_GLOBAL.USER_ID;

Line: 1159


    l_icpv_rec.LAST_UPDATE_LOGIN     := FND_GLOBAL.LOGIN_ID;

Line: 1175


    INSERT INTO OKL_ITM_CAT_RV_PRCS(
      id,
      object_version_number,
      cat_id1,
      cat_id2,
      term_in_months,
      residual_value_percent,
      item_residual_id,
      sts_code,
      version_number,
      start_date,
      end_date,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      attribute_category,
      attribute1,
      attribute2,
      attribute3,
      attribute4,
      attribute5,
      attribute6,
      attribute7,
      attribute8,
      attribute9,
      attribute10,
      attribute11,
      attribute12,
      attribute13,
      attribute14,
      attribute15)
    VALUES (
      l_icpv_rec.id,
      l_icpv_rec.object_version_number,
      l_icpv_rec.cat_id1,
      l_icpv_rec.cat_id2,
      l_icpv_rec.term_in_months,
      l_icpv_rec.residual_value_percent,
      l_icpv_rec.item_residual_id,
      l_icpv_rec.sts_code,
      l_icpv_rec.version_number,
      l_icpv_rec.start_date,
      l_icpv_rec.end_date,
      l_icpv_rec.created_by,
      l_icpv_rec.creation_date,
      l_icpv_rec.last_updated_by,
      l_icpv_rec.last_update_date,
      l_icpv_rec.last_update_login,
      l_icpv_rec.attribute_category,
      l_icpv_rec.attribute1,
      l_icpv_rec.attribute2,
      l_icpv_rec.attribute3,
      l_icpv_rec.attribute4,
      l_icpv_rec.attribute5,
      l_icpv_rec.attribute6,
      l_icpv_rec.attribute7,
      l_icpv_rec.attribute8,
      l_icpv_rec.attribute9,
      l_icpv_rec.attribute10,
      l_icpv_rec.attribute11,
      l_icpv_rec.attribute12,
      l_icpv_rec.attribute13,
      l_icpv_rec.attribute14,
      l_icpv_rec.attribute15);

Line: 1267


  END insert_row;

Line: 1273


  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_icpv_tbl                     IN icpv_tbl_type,
    x_icpv_tbl                     OUT NOCOPY icpv_tbl_type) IS

    l_api_name                     CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'insert_row (TBL)';

Line: 1293


          insert_row (p_api_version                  => G_API_VERSION,
                      p_init_msg_list                => G_FALSE,
                      x_return_status                => l_return_status,
                      x_msg_count                    => x_msg_count,
                      x_msg_data                     => x_msg_data,
                      p_icpv_rec                     => p_icpv_tbl(i),
                      x_icpv_rec                     => x_icpv_tbl(i));

Line: 1341


  END insert_row;

Line: 1362


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ITM_CAT_RV_PRCS
     WHERE ID = p_icpv_rec.id
       AND OBJECT_VERSION_NUMBER = p_icpv_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 1369


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ITM_CAT_RV_PRCS
     WHERE ID = p_icpv_rec.id;

Line: 1402


      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 1411


      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 1521


  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_icpv_rec                     IN icpv_rec_type,
    x_icpv_rec                     OUT NOCOPY icpv_rec_type) IS

    l_api_name                     CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'update_row (_V)';

Line: 1685


    l_icpv_rec.LAST_UPDATE_DATE  := SYSDATE;

Line: 1686


    l_icpv_rec.LAST_UPDATED_BY   := FND_GLOBAL.USER_ID;

Line: 1687


    l_icpv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 1718


    UPDATE OKL_ITM_CAT_RV_PRCS
    SET OBJECT_VERSION_NUMBER = l_icpv_rec.object_version_number+1,
        CAT_ID1 = l_icpv_rec.cat_id1,
        CAT_ID2 = l_icpv_rec.cat_id2,
        TERM_IN_MONTHS = l_icpv_rec.term_in_months,
        RESIDUAL_VALUE_PERCENT = l_icpv_rec.residual_value_percent,
        ITEM_RESIDUAL_ID = l_icpv_rec.item_residual_id,
        STS_CODE = l_icpv_rec.sts_code,
        VERSION_NUMBER = l_icpv_rec.version_number,
        START_DATE = l_icpv_rec.start_date,
        END_DATE = l_icpv_rec.end_date,
        CREATED_BY = l_icpv_rec.created_by,
        CREATION_DATE = l_icpv_rec.creation_date,
        LAST_UPDATED_BY = l_icpv_rec.last_updated_by,
        LAST_UPDATE_DATE = l_icpv_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_icpv_rec.last_update_login,
        ATTRIBUTE_CATEGORY = l_icpv_rec.attribute_category,
        ATTRIBUTE1 = l_icpv_rec.attribute1,
        ATTRIBUTE2 = l_icpv_rec.attribute2,
        ATTRIBUTE3 = l_icpv_rec.attribute3,
        ATTRIBUTE4 = l_icpv_rec.attribute4,
        ATTRIBUTE5 = l_icpv_rec.attribute5,
        ATTRIBUTE6 = l_icpv_rec.attribute6,
        ATTRIBUTE7 = l_icpv_rec.attribute7,
        ATTRIBUTE8 = l_icpv_rec.attribute8,
        ATTRIBUTE9 = l_icpv_rec.attribute9,
        ATTRIBUTE10 = l_icpv_rec.attribute10,
        ATTRIBUTE11 = l_icpv_rec.attribute11,
        ATTRIBUTE12 = l_icpv_rec.attribute12,
        ATTRIBUTE13 = l_icpv_rec.attribute13,
        ATTRIBUTE14 = l_icpv_rec.attribute14,
        ATTRIBUTE15 = l_icpv_rec.attribute15
    WHERE ID = l_icpv_rec.id;

Line: 1778


  END update_row;

Line: 1784


  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_icpv_tbl                     IN icpv_tbl_type,
    x_icpv_tbl                     OUT NOCOPY icpv_tbl_type) IS

    l_api_name                     CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'update_row (TBL)';

Line: 1806


          update_row (p_api_version                  => G_API_VERSION,
                      p_init_msg_list                => G_FALSE,
                      x_return_status                => l_return_status,
                      x_msg_count                    => x_msg_count,
                      x_msg_data                     => x_msg_data,
                      p_icpv_rec                     => p_icpv_tbl(i),
                      x_icpv_rec                     => x_icpv_tbl(i));

Line: 1854


  END update_row;

Line: 1860


  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_icpv_rec                     IN icpv_rec_type) IS

    l_api_name                     CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'delete_row (REC)';

Line: 1872


    DELETE FROM OKL_ITM_CAT_RV_PRCS WHERE id = p_icpv_rec.id;

Line: 1899


  END delete_row;

Line: 1904


  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_icpv_tbl                     IN icpv_tbl_type) IS

    l_api_name                     CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||'delete_row (TBL)';

Line: 1926


          delete_row (p_api_version                  => G_API_VERSION,
                      p_init_msg_list                => G_FALSE,
                      x_return_status                => l_return_status,
                      x_msg_count                    => x_msg_count,
                      x_msg_data                     => x_msg_data,
                      p_icpv_rec                     => p_icpv_tbl(i));

Line: 1973


  END delete_row;