DBA Data[Home] [Help]

APPS.OKL_ART_PVT SQL Statements

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

Line: 424

	select 'x' from OKL_K_LINES_V
	where ID = p_artv_rec.kle_id;
Line: 817

select 'x' from OKL_TRX_AP_INVOICES_V
where ID = p_artv_rec.security_dep_trx_ap_id;
Line: 882

select 'x' from OKX_SELL_ORDERS_V
where ID = p_artv_rec.iso_id; */
Line: 950

select 'x' from OKX_VENDORS_V
where ID1 = p_artv_rec.rna_id;
Line: 1017

select 'x' from OKL_AM_REMARKET_TEAMS_UV
where ORIG_SYSTEM_ID = p_artv_rec.rmr_id;
Line: 1087

select 'x' from OKX_SYSTEM_ITEMS_V
where ID1 = p_artv_rec.imr_id;
Line: 1451

    SELECT id, ars_code
    FROM   OKL_ASSET_RETURNS_V
    WHERE  id = p_id;
Line: 1457

    SELECT ars_code
    FROM   OKL_ASSET_RETURNS_V
    WHERE  kle_id = p_kle_id;
Line: 1463

    SELECT ars_code
    FROM   OKL_ASSET_RETURNS_V
    WHERE  kle_id = p_kle_id
    AND    id <> p_id;
Line: 1470

    SELECT meaning
    FROM   FND_LOOKUPS
    WHERE  lookup_code = p_code
      AND  lookup_type = 'OKL_ASSET_RETURN_STATUS';
Line: 1477

    SELECT  name
    FROM    OKC_K_LINES_V
    WHERE   id = p_kle_id;
Line: 1637

    DELETE FROM OKL_ASSET_RETURNS_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_ASSET_RETURNS_ALL_B  B
         WHERE B.ID = T.ID
        );
Line: 1644

    UPDATE OKL_ASSET_RETURNS_TL T SET (
        COMMENTS) = (SELECT
                                  B.COMMENTS
                                FROM OKL_ASSET_RETURNS_TL B
                               WHERE B.ID = T.ID
                                 AND B.LANGUAGE = T.SOURCE_LANG)
      WHERE (
              T.ID,
              T.LANGUAGE)
          IN (SELECT
                  SUBT.ID,
                  SUBT.LANGUAGE
                FROM OKL_ASSET_RETURNS_TL SUBB, OKL_ASSET_RETURNS_TL SUBT
               WHERE SUBB.ID = SUBT.ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.COMMENTS <> SUBT.COMMENTS
                      OR (SUBB.COMMENTS IS NULL AND SUBT.COMMENTS IS NOT NULL)
                      OR (SUBB.COMMENTS IS NOT NULL AND SUBT.COMMENTS IS NULL)
              ));
Line: 1664

    INSERT INTO OKL_ASSET_RETURNS_TL (
        ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        COMMENTS,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN,
        NEW_ITEM_DESCRIPTION)
      SELECT
            B.ID,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.COMMENTS,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN,
            B.NEW_ITEM_DESCRIPTION
        FROM OKL_ASSET_RETURNS_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS(
                    SELECT NULL
                      FROM OKL_ASSET_RETURNS_TL T
                     WHERE T.ID = B.ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );
Line: 1718

    SELECT
            ID,
            KLE_ID,
            SECURITY_DEP_TRX_AP_ID,
            ISO_ID,
            RNA_ID,
            RMR_ID,
            ARS_CODE,
            IMR_ID,
            ART1_CODE,
            DATE_RETURN_DUE,
            DATE_RETURN_NOTIFIED,
            RELOCATE_ASSET_YN,
            OBJECT_VERSION_NUMBER,
            VOLUNTARY_YN,
            COMMMERCIALLY_REAS_SALE_YN,
            DATE_REPOSSESSION_REQUIRED,
            DATE_REPOSSESSION_ACTUAL,
            DATE_HOLD_UNTIL,
            DATE_RETURNED,
            DATE_TITLE_RETURNED,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            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,
            FLOOR_PRICE,
            NEW_ITEM_PRICE,
			-- SECHAWLA 30-SEP-04 3924244 : added  a new column new_item_number
			NEW_ITEM_NUMBER,
            ASSET_RELOCATED_YN,
            REPURCHASE_AGMT_YN,
            LIKE_KIND_YN,
  -- RABHUPAT - 2667636 - Start
            CURRENCY_CODE,
            CURRENCY_CONVERSION_CODE,
            CURRENCY_CONVERSION_TYPE,
            CURRENCY_CONVERSION_RATE,
            CURRENCY_CONVERSION_DATE,
  -- RABHUPAT - 2667636 - End
  -- RRAVIKIR Legal Entity Changes
            LEGAL_ENTITY_ID,
  -- Legal Entity Changes End
  -- DJANASWA Loan Repossession proj start
            ASSET_FMV_AMOUNT
  --   Loan Repossession proj end
      FROM Okl_Asset_Returns_B
     WHERE okl_asset_returns_b.id = p_id;
Line: 1818

              l_art_rec.PROGRAM_UPDATE_DATE,
              l_art_rec.ATTRIBUTE_CATEGORY,
              l_art_rec.ATTRIBUTE1,
              l_art_rec.ATTRIBUTE2,
              l_art_rec.ATTRIBUTE3,
              l_art_rec.ATTRIBUTE4,
              l_art_rec.ATTRIBUTE5,
              l_art_rec.ATTRIBUTE6,
              l_art_rec.ATTRIBUTE7,
              l_art_rec.ATTRIBUTE8,
              l_art_rec.ATTRIBUTE9,
              l_art_rec.ATTRIBUTE10,
              l_art_rec.ATTRIBUTE11,
              l_art_rec.ATTRIBUTE12,
              l_art_rec.ATTRIBUTE13,
              l_art_rec.ATTRIBUTE14,
              l_art_rec.ATTRIBUTE15,
              l_art_rec.CREATED_BY,
              l_art_rec.CREATION_DATE,
              l_art_rec.LAST_UPDATED_BY,
              l_art_rec.LAST_UPDATE_DATE,
              l_art_rec.LAST_UPDATE_LOGIN,
              l_art_rec.FLOOR_PRICE,
              l_art_rec.NEW_ITEM_PRICE,
			  -- SECHAWLA 30-SEP-04 3924244 : added  a new column new_item_number
			  l_art_rec.NEW_ITEM_NUMBER,
              l_art_rec.ASSET_RELOCATED_YN,
              l_art_rec.REPURCHASE_AGMT_YN,
              l_art_rec.LIKE_KIND_YN,
  -- RABHUPAT - 2667636 - Start
              l_art_rec.CURRENCY_CODE,
              l_art_rec.CURRENCY_CONVERSION_CODE,
              l_art_rec.CURRENCY_CONVERSION_TYPE,
              l_art_rec.CURRENCY_CONVERSION_RATE,
              l_art_rec.CURRENCY_CONVERSION_DATE,
  -- RABHUPAT - 2667636 - End
  -- RRAVIKIR Legal Entity Changes
              l_art_rec.LEGAL_ENTITY_ID,
  -- Legal Entity Changes End
 -- DJANASWA Loan Repossession proj start
              l_art_rec.ASSET_FMV_AMOUNT;
Line: 1881

    SELECT
            ID,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            COMMENTS,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            NEW_ITEM_DESCRIPTION
      FROM Okl_Asset_Returns_Tl
     WHERE okl_asset_returns_tl.id = p_id
       AND okl_asset_returns_tl.language = p_language;
Line: 1911

              l_okl_asset_returns_tl_rec.LAST_UPDATED_BY,
              l_okl_asset_returns_tl_rec.LAST_UPDATE_DATE,
              l_okl_asset_returns_tl_rec.LAST_UPDATE_LOGIN,
              l_okl_asset_returns_tl_rec.NEW_ITEM_DESCRIPTION;
Line: 1945

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            SFWT_FLAG,
            RMR_ID,
            IMR_ID,
            RNA_ID,
            KLE_ID,
            ISO_ID,
            SECURITY_DEP_TRX_AP_ID,
            ARS_CODE,
            ART1_CODE,
            DATE_RETURNED,
            DATE_TITLE_RETURNED,
            DATE_RETURN_DUE,
            DATE_RETURN_NOTIFIED,
            RELOCATE_ASSET_YN,
            VOLUNTARY_YN,
            DATE_REPOSSESSION_REQUIRED,
            DATE_REPOSSESSION_ACTUAL,
            DATE_HOLD_UNTIL,
            COMMMERCIALLY_REAS_SALE_YN,
            COMMENTS,
            ATTRIBUTE_CATEGORY,
            ATTRIBUTE1,
            ATTRIBUTE2,
            ATTRIBUTE3,
            ATTRIBUTE4,
            ATTRIBUTE5,
            ATTRIBUTE6,
            ATTRIBUTE7,
            ATTRIBUTE8,
            ATTRIBUTE9,
            ATTRIBUTE10,
            ATTRIBUTE11,
            ATTRIBUTE12,
            ATTRIBUTE13,
            ATTRIBUTE14,
            ATTRIBUTE15,
            ORG_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_ID,
            PROGRAM_UPDATE_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            FLOOR_PRICE,
            NEW_ITEM_PRICE,
			-- SECHAWLA 30-SEP-04 3924244 : added  a new column new_item_number
			NEW_ITEM_NUMBER,
            ASSET_RELOCATED_YN,
            NEW_ITEM_DESCRIPTION,
            REPURCHASE_AGMT_YN,
            LIKE_KIND_YN,
  -- RABHUPAT - 2667636 - Start
            CURRENCY_CODE,
            CURRENCY_CONVERSION_CODE,
            CURRENCY_CONVERSION_TYPE,
            CURRENCY_CONVERSION_RATE,
            CURRENCY_CONVERSION_DATE,
  -- RABHUPAT - 2667636 - End
  -- RRAVIKIR Legal Entity Changes
            LEGAL_ENTITY_ID,
  -- Legal Entity Changes End
 -- DJANASWA Loan Repossession proj start
            ASSET_FMV_AMOUNT
  --   Loan Repossession proj end
      FROM Okl_Asset_Returns_V
     WHERE okl_asset_returns_v.id = p_id;
Line: 2066

              l_artv_rec.PROGRAM_UPDATE_DATE,
              l_artv_rec.CREATED_BY,
              l_artv_rec.CREATION_DATE,
              l_artv_rec.LAST_UPDATED_BY,
              l_artv_rec.LAST_UPDATE_DATE,
              l_artv_rec.LAST_UPDATE_LOGIN,
              l_artv_rec.FLOOR_PRICE,
              l_artv_rec.NEW_ITEM_PRICE,
			  -- SECHAWLA 30-SEP-04 3924244 : added  a new column new_item_number
			  l_artv_rec.NEW_ITEM_NUMBER,
              l_artv_rec.ASSET_RELOCATED_YN,
              l_artv_rec.NEW_ITEM_DESCRIPTION,
              l_artv_rec.REPURCHASE_AGMT_YN,
              l_artv_rec.LIKE_KIND_YN,
  -- RABHUPAT - 2667636 - Start
              l_artv_rec.CURRENCY_CODE,
              l_artv_rec.CURRENCY_CONVERSION_CODE,
              l_artv_rec.CURRENCY_CONVERSION_TYPE,
              l_artv_rec.CURRENCY_CONVERSION_RATE,
              l_artv_rec.CURRENCY_CONVERSION_DATE,
  -- RABHUPAT - 2667636 - End
  -- RRAVIKIR Legal Entity Changes
              l_artv_rec.LEGAL_ENTITY_ID,
  -- Legal Entity Changes End
 -- DJANASWA Loan Repossession proj start
             l_artv_rec.ASSET_FMV_AMOUNT;
Line: 2244

    IF (l_artv_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
      l_artv_rec.last_updated_by := NULL;
Line: 2247

    IF (l_artv_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
      l_artv_rec.last_update_date := NULL;
Line: 2250

    IF (l_artv_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
      l_artv_rec.last_update_login := NULL;
Line: 2660

    p_to.program_update_date := p_from.program_update_date;
Line: 2679

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

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

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

    p_to.program_update_date := p_from.program_update_date;
Line: 2766

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

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

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

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

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

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

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

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

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

  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_art_rec                      IN art_rec_type,
    x_art_rec                      OUT NOCOPY art_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3014

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

    INSERT INTO OKL_ASSET_RETURNS_B(
        id,
        kle_id,
        security_dep_trx_ap_id,
        iso_id,
        rna_id,
        rmr_id,
        ars_code,
        imr_id,
        art1_code,
        date_return_due,
        date_return_notified,
        relocate_asset_yn,
        object_version_number,
        voluntary_yn,
        commmercially_reas_sale_yn,
        date_repossession_required,
        date_repossession_actual,
        date_hold_until,
        date_returned,
        date_title_returned,
        org_id,
        request_id,
        program_application_id,
        program_id,
        program_update_date,
        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,
        floor_price,
        new_item_price,

		-- SECHAWLA 30-SEP-04 3924244 : added  a new column new_item_number
    	new_item_number,

        asset_relocated_yn,
        repurchase_agmt_yn,
        like_kind_yn,
  -- RABHUPAT - 2667636 - Start
        currency_code,
        currency_conversion_code,
        currency_conversion_type,
        currency_conversion_rate,
        currency_conversion_date,
  -- RABHUPAT - 2667636 - End
  -- RRAVIKIR Legal Entity Changes
        legal_entity_id,
  -- Legal Entity Changes End
  -- DJANASWA Loan Repossession proj start
         ASSET_FMV_AMOUNT)
  --   Loan Repossession proj end
      VALUES (
        l_art_rec.id,
        l_art_rec.kle_id,
        l_art_rec.security_dep_trx_ap_id,
        l_art_rec.iso_id,
        l_art_rec.rna_id,
        l_art_rec.rmr_id,
        l_art_rec.ars_code,
        l_art_rec.imr_id,
        l_art_rec.art1_code,
        l_art_rec.date_return_due,
        l_art_rec.date_return_notified,
        l_art_rec.relocate_asset_yn,
        l_art_rec.object_version_number,
        l_art_rec.voluntary_yn,
        l_art_rec.commmercially_reas_sale_yn,
        l_art_rec.date_repossession_required,
        l_art_rec.date_repossession_actual,
        l_art_rec.date_hold_until,
        l_art_rec.date_returned,
        l_art_rec.date_title_returned,
        l_art_rec.org_id,
        DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,FND_GLOBAL.CONC_REQUEST_ID),
        DECODE(FND_GLOBAL.PROG_APPL_ID,-1,NULL,FND_GLOBAL.PROG_APPL_ID),
        DECODE(FND_GLOBAL.CONC_PROGRAM_ID,-1,NULL,FND_GLOBAL.CONC_PROGRAM_ID),
        DECODE(FND_GLOBAL.CONC_REQUEST_ID,-1,NULL,SYSDATE),
        l_art_rec.attribute_category,
        l_art_rec.attribute1,
        l_art_rec.attribute2,
        l_art_rec.attribute3,
        l_art_rec.attribute4,
        l_art_rec.attribute5,
        l_art_rec.attribute6,
        l_art_rec.attribute7,
        l_art_rec.attribute8,
        l_art_rec.attribute9,
        l_art_rec.attribute10,
        l_art_rec.attribute11,
        l_art_rec.attribute12,
        l_art_rec.attribute13,
        l_art_rec.attribute14,
        l_art_rec.attribute15,
        l_art_rec.created_by,
        l_art_rec.creation_date,
        l_art_rec.last_updated_by,
        l_art_rec.last_update_date,
        l_art_rec.last_update_login,
        l_art_rec.floor_price,
        l_art_rec.new_item_price,

		-- SECHAWLA 30-SEP-04 3924244 : added  a new column new_item_number
		l_art_rec.new_item_number,

        l_art_rec.asset_relocated_yn,
        l_art_rec.repurchase_agmt_yn,
        l_art_rec.like_kind_yn,
  -- RABHUPAT - 2667636 - Start
        l_art_rec.currency_code,
        l_art_rec.currency_conversion_code,
        l_art_rec.currency_conversion_type,
        l_art_rec.currency_conversion_rate,
        l_art_rec.currency_conversion_date,
  -- RABHUPAT - 2667636 - End
  -- RRAVIKIR Legal Entity Changes
        l_art_rec.legal_entity_id,
  -- Legal Entity Changes End
 -- DJANASWA Loan Repossession proj start
        l_art_rec.ASSET_FMV_AMOUNT);
Line: 3222

  END insert_row;
Line: 3226

  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_okl_asset_returns_tl_rec     IN okl_asset_returns_tl_rec_type,
    x_okl_asset_returns_tl_rec     OUT NOCOPY okl_asset_returns_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3235

    l_api_name                     CONSTANT VARCHAR2(30) := 'TL_insert_row';
Line: 3240

      SELECT *
        FROM FND_LANGUAGES
       WHERE INSTALLED_FLAG IN ('I', 'B');
Line: 3279

      INSERT INTO OKL_ASSET_RETURNS_TL(
          id,
          language,
          source_lang,
          sfwt_flag,
          comments,
          created_by,
          creation_date,
          last_updated_by,
          last_update_date,
          last_update_login,
          new_item_description)
        VALUES (
          l_okl_asset_returns_tl_rec.id,
          l_okl_asset_returns_tl_rec.language,
          l_okl_asset_returns_tl_rec.source_lang,
          l_okl_asset_returns_tl_rec.sfwt_flag,
          l_okl_asset_returns_tl_rec.comments,
          l_okl_asset_returns_tl_rec.created_by,
          l_okl_asset_returns_tl_rec.creation_date,
          l_okl_asset_returns_tl_rec.last_updated_by,
          l_okl_asset_returns_tl_rec.last_update_date,
          l_okl_asset_returns_tl_rec.last_update_login,
          l_okl_asset_returns_tl_rec.new_item_description);
Line: 3338

  END insert_row;
Line: 3352

  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_artv_rec                     IN artv_rec_type,
    x_artv_rec                     OUT NOCOPY artv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3362

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

      l_artv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 3381

      l_artv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 3382

      l_artv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 3491

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_art_rec,
      lx_art_rec
    );
Line: 3505

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_asset_returns_tl_rec,
      lx_okl_asset_returns_tl_rec
    );
Line: 3553

  END insert_row;
Line: 3557

  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_artv_tbl                     IN artv_tbl_type,
    x_artv_tbl                     OUT NOCOPY artv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 3567

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

        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_artv_rec                     => p_artv_tbl(i),
          x_artv_rec                     => x_artv_tbl(i));
Line: 3635

  END insert_row;
Line: 3653

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ASSET_RETURNS_B
     WHERE ID = p_art_rec.id
       AND OBJECT_VERSION_NUMBER = p_art_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 3660

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_ASSET_RETURNS_B
    WHERE ID = p_art_rec.id;
Line: 3701

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 3710

      OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 3759

    SELECT *
      FROM OKL_ASSET_RETURNS_TL
     WHERE ID = p_okl_asset_returns_tl_rec.id
    FOR UPDATE NOWAIT;
Line: 3795

      OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 4022

  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_art_rec                      IN art_rec_type,
    x_art_rec                      OUT NOCOPY art_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 4031

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

      IF (x_art_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_art_rec.program_update_date := l_art_rec.program_update_date;
Line: 4225

      IF (x_art_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_art_rec.last_updated_by := l_art_rec.last_updated_by;
Line: 4229

      IF (x_art_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_art_rec.last_update_date := l_art_rec.last_update_date;
Line: 4233

      IF (x_art_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_art_rec.last_update_login := l_art_rec.last_update_login;
Line: 4342

    UPDATE  OKL_ASSET_RETURNS_B
    SET KLE_ID = l_def_art_rec.kle_id,
        SECURITY_DEP_TRX_AP_ID = l_def_art_rec.security_dep_trx_ap_id,
        ISO_ID = l_def_art_rec.iso_id,
        RNA_ID = l_def_art_rec.rna_id,
        RMR_ID = l_def_art_rec.rmr_id,
        ARS_CODE = l_def_art_rec.ars_code,
        IMR_ID = l_def_art_rec.imr_id,
        ART1_CODE = l_def_art_rec.art1_code,
        DATE_RETURN_DUE = l_def_art_rec.date_return_due,
        DATE_RETURN_NOTIFIED = l_def_art_rec.date_return_notified,
        RELOCATE_ASSET_YN = l_def_art_rec.relocate_asset_yn,
        OBJECT_VERSION_NUMBER = l_def_art_rec.object_version_number,
        VOLUNTARY_YN = l_def_art_rec.voluntary_yn,
        COMMMERCIALLY_REAS_SALE_YN = l_def_art_rec.commmercially_reas_sale_yn,
        DATE_REPOSSESSION_REQUIRED = l_def_art_rec.date_repossession_required,
        DATE_REPOSSESSION_ACTUAL = l_def_art_rec.date_repossession_actual,
        DATE_HOLD_UNTIL = l_def_art_rec.date_hold_until,
        DATE_RETURNED = l_def_art_rec.date_returned,
        DATE_TITLE_RETURNED = l_def_art_rec.date_title_returned,
        ORG_ID = l_def_art_rec.org_id,
        REQUEST_ID = l_def_art_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_art_rec.program_application_id,
        PROGRAM_ID = l_def_art_rec.program_id,
        PROGRAM_UPDATE_DATE = l_def_art_rec.program_update_date,
        ATTRIBUTE_CATEGORY = l_def_art_rec.attribute_category,
        ATTRIBUTE1 = l_def_art_rec.attribute1,
        ATTRIBUTE2 = l_def_art_rec.attribute2,
        ATTRIBUTE3 = l_def_art_rec.attribute3,
        ATTRIBUTE4 = l_def_art_rec.attribute4,
        ATTRIBUTE5 = l_def_art_rec.attribute5,
        ATTRIBUTE6 = l_def_art_rec.attribute6,
        ATTRIBUTE7 = l_def_art_rec.attribute7,
        ATTRIBUTE8 = l_def_art_rec.attribute8,
        ATTRIBUTE9 = l_def_art_rec.attribute9,
        ATTRIBUTE10 = l_def_art_rec.attribute10,
        ATTRIBUTE11 = l_def_art_rec.attribute11,
        ATTRIBUTE12 = l_def_art_rec.attribute12,
        ATTRIBUTE13 = l_def_art_rec.attribute13,
        ATTRIBUTE14 = l_def_art_rec.attribute14,
        ATTRIBUTE15 = l_def_art_rec.attribute15,
        CREATED_BY = l_def_art_rec.created_by,
        CREATION_DATE = l_def_art_rec.creation_date,
        LAST_UPDATED_BY = l_def_art_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_art_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_art_rec.last_update_login,
        FLOOR_PRICE = l_def_art_rec.floor_price,
        NEW_ITEM_PRICE = l_def_art_rec.new_item_price,

        -- SECHAWLA 30-SEP-04 3924244 : added  a new column new_item_number
        NEW_ITEM_NUMBER = l_def_art_rec.new_item_number,

        ASSET_RELOCATED_YN = l_def_art_rec.asset_relocated_yn,
        REPURCHASE_AGMT_YN = l_def_art_rec.repurchase_agmt_yn,
        LIKE_KIND_YN = l_def_art_rec.like_kind_yn,
  -- RABHUPAT - 2667636 - Start
        CURRENCY_CODE = l_def_art_rec.currency_code,
        CURRENCY_CONVERSION_CODE = l_def_art_rec.currency_conversion_code,
        CURRENCY_CONVERSION_TYPE = l_def_art_rec.currency_conversion_type,
        CURRENCY_CONVERSION_RATE = l_def_art_rec.currency_conversion_rate,
        CURRENCY_CONVERSION_DATE = l_def_art_rec.currency_conversion_date,
  -- RABHUPAT - 2667636 - End
  -- RRAVIKIR Legal Entity Changes
        LEGAL_ENTITY_ID = l_def_art_rec.legal_entity_id,
  -- Legal Entity Changes End
 -- DJANASWA Loan Repossession proj start
        ASSET_FMV_AMOUNT = l_def_art_rec.ASSET_FMV_AMOUNT
  --   Loan Repossession proj end
    WHERE ID = l_def_art_rec.id;
Line: 4445

  END update_row;
Line: 4449

  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_okl_asset_returns_tl_rec     IN okl_asset_returns_tl_rec_type,
    x_okl_asset_returns_tl_rec     OUT NOCOPY okl_asset_returns_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 4458

    l_api_name                     CONSTANT VARCHAR2(30) := 'TL_update_row';
Line: 4508

      IF (x_okl_asset_returns_tl_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_okl_asset_returns_tl_rec.last_updated_by := l_okl_asset_returns_tl_rec.last_updated_by;
Line: 4512

      IF (x_okl_asset_returns_tl_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_okl_asset_returns_tl_rec.last_update_date := l_okl_asset_returns_tl_rec.last_update_date;
Line: 4516

      IF (x_okl_asset_returns_tl_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_okl_asset_returns_tl_rec.last_update_login := l_okl_asset_returns_tl_rec.last_update_login;
Line: 4567

    UPDATE  OKL_ASSET_RETURNS_TL
    SET COMMENTS = ldefoklassetreturnstlrec.comments,
        SOURCE_LANG = ldefoklassetreturnstlrec.source_lang, --Fix for bug 3637102
        CREATED_BY = ldefoklassetreturnstlrec.created_by,
        CREATION_DATE = ldefoklassetreturnstlrec.creation_date,
        LAST_UPDATED_BY = ldefoklassetreturnstlrec.last_updated_by,
        LAST_UPDATE_DATE = ldefoklassetreturnstlrec.last_update_date,
        LAST_UPDATE_LOGIN = ldefoklassetreturnstlrec.last_update_login,
        NEW_ITEM_DESCRIPTION = ldefoklassetreturnstlrec.new_item_description
    WHERE ID = ldefoklassetreturnstlrec.id
      AND USERENV('LANG') in (SOURCE_LANG,LANGUAGE);-- Fix for bug 3637102
Line: 4580

    UPDATE  OKL_ASSET_RETURNS_TL
    SET SFWT_FLAG = 'Y'
    WHERE ID = ldefoklassetreturnstlrec.id
      AND SOURCE_LANG <> USERENV('LANG');
Line: 4618

  END update_row;
Line: 4632

  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_artv_rec                     IN artv_rec_type,
    x_artv_rec                     OUT NOCOPY artv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 4642

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

      l_artv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 4659

      l_artv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 4660

      l_artv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 4848

      IF (x_artv_rec.program_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_artv_rec.program_update_date := l_artv_rec.program_update_date;
Line: 4860

      IF (x_artv_rec.last_updated_by = OKC_API.G_MISS_NUM)
      THEN
        x_artv_rec.last_updated_by := l_artv_rec.last_updated_by;
Line: 4864

      IF (x_artv_rec.last_update_date = OKC_API.G_MISS_DATE)
      THEN
        x_artv_rec.last_update_date := l_artv_rec.last_update_date;
Line: 4868

      IF (x_artv_rec.last_update_login = OKC_API.G_MISS_NUM)
      THEN
        x_artv_rec.last_update_login := l_artv_rec.last_update_login;
Line: 5007

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_asset_returns_tl_rec,
      lx_okl_asset_returns_tl_rec
    );
Line: 5021

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_art_rec,
      lx_art_rec
    );
Line: 5068

  END update_row;
Line: 5072

  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_artv_tbl                     IN artv_tbl_type,
    x_artv_tbl                     OUT NOCOPY artv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 5082

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

        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_artv_rec                     => p_artv_tbl(i),
          x_artv_rec                     => x_artv_tbl(i));
Line: 5150

  END update_row;
Line: 5158

  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_art_rec                      IN art_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 5166

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

    DELETE FROM OKL_ASSET_RETURNS_B
     WHERE ID = l_art_rec.id;
Line: 5215

  END delete_row;
Line: 5219

  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_okl_asset_returns_tl_rec     IN okl_asset_returns_tl_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 5227

    l_api_name                     CONSTANT VARCHAR2(30) := 'TL_delete_row';
Line: 5264

    DELETE FROM OKL_ASSET_RETURNS_TL
     WHERE ID = l_okl_asset_returns_tl_rec.id;
Line: 5299

  END delete_row;
Line: 5303

  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_artv_rec                     IN artv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 5312

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

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_okl_asset_returns_tl_rec
    );
Line: 5350

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_art_rec
    );
Line: 5394

  END delete_row;
Line: 5398

  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_artv_tbl                     IN artv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 5407

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

        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_artv_rec                     => p_artv_tbl(i));
Line: 5474

  END delete_row;