DBA Data[Home] [Help]

APPS.OKL_VFA_PVT SQL Statements

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

Line: 30

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT id
                  FROM okc_k_headers_b
                  WHERE id = p_dnz_chr_id);
Line: 110

    SELECT lse.lty_code
    FROM okc_k_lines_b cle,
         okc_line_styles_b lse
    WHERE cle.id = p_cle_id
    AND cle.lse_id = lse.id;
Line: 118

    SELECT 1
    FROM DUAL
    WHERE EXISTS (SELECT t1.id
                  FROM okc_line_styles_b t1
                       ,okc_line_styles_b t2
                       ,okc_subclass_top_line t3
                       ,okc_k_lines_b cle
                  WHERE t1.lty_code = p_code
                  AND cle.id = p_cle_id
                  AND cle.lse_id = t1.id
                  AND t2.lty_code = G_FIN_LINE_LTY_CODE
                  AND t1.lse_parent_id = t2.id
                  AND t3.lse_id = t2.id
                  AND t3.scs_code = 'LEASE');
Line: 309

    SELECT ID,
           MAJOR_VERSION,
           OBJECT_VERSION_NUMBER,
           DNZ_CHR_ID,
           FA_CLE_ID,
           NAME,
           DESCRIPTION,
           ASSET_ID,
           ASSET_NUMBER,
           CORPORATE_BOOK,
           LIFE_IN_MONTHS,
           ORIGINAL_COST,
           COST,
           ADJUSTED_COST,
           CURRENT_UNITS,
           NEW_USED,
           IN_SERVICE_DATE,
           MODEL_NUMBER,
           ASSET_TYPE,
           SALVAGE_VALUE,
           PERCENT_SALVAGE_VALUE,
           DEPRECIATION_CATEGORY,
           DEPRN_START_DATE,
           DEPRN_METHOD_CODE,
           RATE_ADJUSTMENT_FACTOR,
           BASIC_RATE,
           ADJUSTED_RATE,
           START_DATE_ACTIVE,
           END_DATE_ACTIVE,
           STATUS,
           PRIMARY_UOM_CODE,
           RECOVERABLE_COST,
--Bug# 2981308 :
           ASSET_KEY_ID,
           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,
	   --Added by dpsingh for LE uptake
           LEGAL_ENTITY_ID
      FROM Okl_Contract_Asset_Hv
      WHERE Okl_Contract_Asset_Hv.ID = p_id;
Line: 427

              l_vfav_rec.last_updated_by,
              l_vfav_rec.last_update_date,
              l_vfav_rec.last_update_login,
	      --Added by dpsingh for LE uptake
               l_vfav_rec.legal_entity_id;
Line: 472

    SELECT ID,
           MAJOR_VERSION,
           OBJECT_VERSION_NUMBER,
           DNZ_CHR_ID,
           FA_CLE_ID,
           NAME,
           DESCRIPTION,
           ASSET_ID,
           ASSET_NUMBER,
           CORPORATE_BOOK,
           LIFE_IN_MONTHS,
           ORIGINAL_COST,
           COST,
           ADJUSTED_COST,
           CURRENT_UNITS,
           NEW_USED,
           IN_SERVICE_DATE,
           MODEL_NUMBER,
           ASSET_TYPE,
           SALVAGE_VALUE,
           PERCENT_SALVAGE_VALUE,
           DEPRECIATION_CATEGORY,
           DEPRN_START_DATE,
           DEPRN_METHOD_CODE,
           RATE_ADJUSTMENT_FACTOR,
           BASIC_RATE,
           ADJUSTED_RATE,
           START_DATE_ACTIVE,
           END_DATE_ACTIVE,
           STATUS,
           PRIMARY_UOM_CODE,
           RECOVERABLE_COST,
--Bug# 2981308 :
           ASSET_KEY_ID,
           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,
           --Added by dpsingh for LE uptake
           LEGAL_ENTITY_ID
      FROM Okl_Contract_Asset_H
      WHERE Okl_Contract_Asset_H.ID = p_id;
Line: 590

              l_vfa_rec.last_updated_by,
              l_vfa_rec.last_update_date,
              l_vfa_rec.last_update_login,
	      --Added by dpsingh for LE uptake
               l_vfa_rec.legal_entity_id;
Line: 789

    IF (l_vfav_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_vfav_rec.last_updated_by := NULL;
Line: 792

    IF (l_vfav_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_vfav_rec.last_update_date := NULL;
Line: 795

    IF (l_vfav_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_vfav_rec.last_update_login := NULL;
Line: 958

    p_to.last_updated_by := p_from.last_updated_by;
Line: 959

    p_to.last_update_date := p_from.last_update_date;
Line: 960

    p_to.last_update_login := p_from.last_update_login;
Line: 1021

    p_to.last_updated_by := p_from.last_updated_by;
Line: 1022

    p_to.last_update_date := p_from.last_update_date;
Line: 1023

    p_to.last_update_login := p_from.last_update_login;
Line: 1176

  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_vfa_rec                     IN vfa_rec_type,
    x_vfa_rec                     OUT NOCOPY vfa_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1185

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

    INSERT INTO OKL_CONTRACT_ASSET_H(
      id,
      major_version,
      object_version_number,
      dnz_chr_id,
      fa_cle_id,
      name,
      description,
      asset_id,
      asset_number,
      corporate_book,
      life_in_months,
      original_cost,
      cost,
      adjusted_cost,
      current_units,
      new_used,
      in_service_date,
      model_number,
      asset_type,
      salvage_value,
      percent_salvage_value,
      depreciation_category,
      deprn_start_date,
      deprn_method_code,
      rate_adjustment_factor,
      basic_rate,
      adjusted_rate,
      start_date_active,
      end_date_active,
      status,
      primary_uom_code,
      recoverable_cost,
--Bug# 2981308
      asset_key_id,
      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,
      --Added by dpsingh for LE uptake
      legal_entity_id)
    VALUES (
      l_vfa_rec.id,
      l_vfa_rec.major_version,
      l_vfa_rec.object_version_number,
      l_vfa_rec.dnz_chr_id,
      l_vfa_rec.fa_cle_id,
      l_vfa_rec.name,
      l_vfa_rec.description,
      l_vfa_rec.asset_id,
      l_vfa_rec.asset_number,
      l_vfa_rec.corporate_book,
      l_vfa_rec.life_in_months,
      l_vfa_rec.original_cost,
      l_vfa_rec.cost,
      l_vfa_rec.adjusted_cost,
      l_vfa_rec.current_units,
      l_vfa_rec.new_used,
      l_vfa_rec.in_service_date,
      l_vfa_rec.model_number,
      l_vfa_rec.asset_type,
      l_vfa_rec.salvage_value,
      l_vfa_rec.percent_salvage_value,
      l_vfa_rec.depreciation_category,
      l_vfa_rec.deprn_start_date,
      l_vfa_rec.deprn_method_code,
      l_vfa_rec.rate_adjustment_factor,
      l_vfa_rec.basic_rate,
      l_vfa_rec.adjusted_rate,
      l_vfa_rec.start_date_active,
      l_vfa_rec.end_date_active,
      l_vfa_rec.status,
      l_vfa_rec.primary_uom_code,
      l_vfa_rec.recoverable_cost,
--bug# 2981308
      l_vfa_rec.asset_key_id,
      l_vfa_rec.attribute_category,
      l_vfa_rec.attribute1,
      l_vfa_rec.attribute2,
      l_vfa_rec.attribute3,
      l_vfa_rec.attribute4,
      l_vfa_rec.attribute5,
      l_vfa_rec.attribute6,
      l_vfa_rec.attribute7,
      l_vfa_rec.attribute8,
      l_vfa_rec.attribute9,
      l_vfa_rec.attribute10,
      l_vfa_rec.attribute11,
      l_vfa_rec.attribute12,
      l_vfa_rec.attribute13,
      l_vfa_rec.attribute14,
      l_vfa_rec.attribute15,
      l_vfa_rec.created_by,
      l_vfa_rec.creation_date,
      l_vfa_rec.last_updated_by,
      l_vfa_rec.last_update_date,
      l_vfa_rec.last_update_login,
     --Added by dpsingh for LE uptake
      l_vfa_rec.legal_entity_id);
Line: 1372

  END insert_row;
Line: 1376

  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_vfav_rec                     IN vfav_rec_type,
    x_vfav_rec                     OUT NOCOPY vfav_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1386

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

      l_vfav_rec.LAST_UPDATE_DATE := l_vfav_rec.CREATION_DATE;
Line: 1403

      l_vfav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1404

      l_vfav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1468

    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vfa_rec,
      lx_vfa_rec
    );
Line: 1517

  END insert_row;
Line: 1521

  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_vfav_tbl                     IN vfav_tbl_type,
    x_vfav_tbl                     OUT NOCOPY vfav_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1531

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

        insert_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => p_init_msg_list,
            x_return_status                => x_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_vfav_rec                     => p_vfav_tbl(i),
            x_vfav_rec                     => x_vfav_tbl(i));
Line: 1583

  END insert_row;
Line: 1600

    SELECT OBJECT_VERSION_NUMBER
    FROM OKL_CONTRACT_ASSET_H
    WHERE OBJECT_VERSION_NUMBER = p_vfa_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1606

    SELECT OBJECT_VERSION_NUMBER
    FROM OKL_CONTRACT_ASSET_H
    WHERE ID = p_vfa_rec.id;
Line: 1647

      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1656

      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 1845

  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_vfa_rec                      IN vfa_rec_type,
    x_vfa_rec                      OUT NOCOPY vfa_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1854

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

        IF (x_vfa_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_vfa_rec.last_updated_by := l_vfa_rec.last_updated_by;
Line: 2083

        IF (x_vfa_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vfa_rec.last_update_date := l_vfa_rec.last_update_date;
Line: 2087

        IF (x_vfa_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_vfa_rec.last_update_login := l_vfa_rec.last_update_login;
Line: 2138

    UPDATE OKL_CONTRACT_ASSET_H
    SET ID = l_def_vfa_rec.id,
        MAJOR_VERSION = l_def_vfa_rec.major_version,
        OBJECT_VERSION_NUMBER = l_def_vfa_rec.object_version_number,
        DNZ_CHR_ID = l_def_vfa_rec.dnz_chr_id,
        FA_CLE_ID = l_def_vfa_rec.fa_cle_id,
        NAME = l_def_vfa_rec.name,
        DESCRIPTION = l_def_vfa_rec.description,
        ASSET_ID = l_def_vfa_rec.asset_id,
        ASSET_NUMBER = l_def_vfa_rec.asset_number,
        CORPORATE_BOOK = l_def_vfa_rec.corporate_book,
        LIFE_IN_MONTHS = l_def_vfa_rec.life_in_months,
        ORIGINAL_COST = l_def_vfa_rec.original_cost,
        COST = l_def_vfa_rec.cost,
        ADJUSTED_COST = l_def_vfa_rec.adjusted_cost,
        CURRENT_UNITS = l_def_vfa_rec.current_units,
        NEW_USED = l_def_vfa_rec.new_used,
        IN_SERVICE_DATE = l_def_vfa_rec.in_service_date,
        MODEL_NUMBER = l_def_vfa_rec.model_number,
        ASSET_TYPE = l_def_vfa_rec.asset_type,
        SALVAGE_VALUE = l_def_vfa_rec.salvage_value,
        PERCENT_SALVAGE_VALUE = l_def_vfa_rec.percent_salvage_value,
        DEPRECIATION_CATEGORY = l_def_vfa_rec.depreciation_category,
        DEPRN_START_DATE = l_def_vfa_rec.deprn_start_date,
        DEPRN_METHOD_CODE = l_def_vfa_rec.deprn_method_code,
        RATE_ADJUSTMENT_FACTOR = l_def_vfa_rec.rate_adjustment_factor,
        BASIC_RATE = l_def_vfa_rec.basic_rate,
        ADJUSTED_RATE = l_def_vfa_rec.adjusted_rate,
        START_DATE_ACTIVE = l_def_vfa_rec.start_date_active,
        END_DATE_ACTIVE = l_def_vfa_rec.end_date_active,
        STATUS = l_def_vfa_rec.status,
        PRIMARY_UOM_CODE = l_def_vfa_rec.primary_uom_code,
        RECOVERABLE_COST = l_def_vfa_rec.recoverable_cost,
--Bug# 2981308:
        ASSET_KEY_ID = l_def_vfa_rec.asset_key_id,
        ATTRIBUTE_CATEGORY = l_def_vfa_rec.attribute_category,
        ATTRIBUTE1 = l_def_vfa_rec.attribute1,
        ATTRIBUTE2 = l_def_vfa_rec.attribute2,
        ATTRIBUTE3 = l_def_vfa_rec.attribute3,
        ATTRIBUTE4 = l_def_vfa_rec.attribute4,
        ATTRIBUTE5 = l_def_vfa_rec.attribute5,
        ATTRIBUTE6 = l_def_vfa_rec.attribute6,
        ATTRIBUTE7 = l_def_vfa_rec.attribute7,
        ATTRIBUTE8 = l_def_vfa_rec.attribute8,
        ATTRIBUTE9 = l_def_vfa_rec.attribute9,
        ATTRIBUTE10 = l_def_vfa_rec.attribute10,
        ATTRIBUTE11 = l_def_vfa_rec.attribute11,
        ATTRIBUTE12 = l_def_vfa_rec.attribute12,
        ATTRIBUTE13 = l_def_vfa_rec.attribute13,
        ATTRIBUTE14 = l_def_vfa_rec.attribute14,
        ATTRIBUTE15 = l_def_vfa_rec.attribute15,
        CREATED_BY = l_def_vfa_rec.created_by,
        CREATION_DATE = l_def_vfa_rec.creation_date,
        LAST_UPDATED_BY = l_def_vfa_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_vfa_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_vfa_rec.last_update_login,
	--Added by dpsingh for LE uptake
        LEGAL_ENTITY_ID = l_def_vfa_rec.legal_entity_id
    WHERE ID = l_def_vfa_rec.id;
Line: 2231

  END update_row;
Line: 2235

  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_vfav_rec                     IN vfav_rec_type,
    x_vfav_rec                     OUT NOCOPY vfav_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2245

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

      l_vfav_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2261

      l_vfav_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2262

      l_vfav_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2483

        IF (x_vfav_rec.last_updated_by = OKL_API.G_MISS_NUM)
        THEN
          x_vfav_rec.last_updated_by := l_db_vfav_rec.last_updated_by;
Line: 2487

        IF (x_vfav_rec.last_update_date = OKL_API.G_MISS_DATE)
        THEN
          x_vfav_rec.last_update_date := l_db_vfav_rec.last_update_date;
Line: 2491

        IF (x_vfav_rec.last_update_login = OKL_API.G_MISS_NUM)
        THEN
          x_vfav_rec.last_update_login := l_db_vfav_rec.last_update_login;
Line: 2567

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vfa_rec,
      lx_vfa_rec
    );
Line: 2615

  END update_row;
Line: 2619

  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_vfav_tbl                     IN vfav_tbl_type,
    x_vfav_tbl                     OUT NOCOPY vfav_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2629

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

          update_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => p_init_msg_list,
            x_return_status                => x_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_vfav_rec                     => p_vfav_tbl(i),
            x_vfav_rec                     => x_vfav_tbl(i));
Line: 2681

  END update_row;
Line: 2688

  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_vfa_rec                     IN vfa_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2696

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

    DELETE FROM OKL_CONTRACT_ASSET_H
    WHERE ID = p_vfa_rec.id;
Line: 2746

  END delete_row;
Line: 2750

  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_vfav_rec                     IN vfav_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2759

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

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_vfa_rec
    );
Line: 2828

  END delete_row;
Line: 2832

  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_vfav_tbl                     IN vfav_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2841

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

          delete_row (
            p_api_version                  => p_api_version,
            p_init_msg_list                => p_init_msg_list,
            x_return_status                => x_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_vfav_rec                     => p_vfav_tbl(i));
Line: 2892

  END delete_row;