DBA Data[Home] [Help]

APPS.OKL_TEL_PVT SQL Statements

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

Line: 66

    CURSOR c_pk_csr IS SELECT okl_txl_extension_b_s.NEXTVAL FROM DUAL;
Line: 104

    DELETE FROM OKL_TXL_EXTENSION_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_TXL_EXTENSION_B B
         WHERE B.LINE_EXTENSION_ID =T.LINE_EXTENSION_ID
        );
Line: 111

    UPDATE OKL_TXL_EXTENSION_TL T SET(
        INVENTORY_ITEM_NAME,
        INVENTORY_ORG_NAME) = (SELECT
                                  B.INVENTORY_ITEM_NAME,
                                  B.INVENTORY_ORG_NAME
                                FROM OKL_TXL_EXTENSION_TL B
                               WHERE B.LINE_EXTENSION_ID = T.LINE_EXTENSION_ID
                                 AND B.LANGUAGE = T.SOURCE_LANG)
      WHERE ( T.LINE_EXTENSION_ID,
              T.LANGUAGE)
          IN (SELECT
                  SUBT.LINE_EXTENSION_ID,
                  SUBT.LANGUAGE
                FROM OKL_TXL_EXTENSION_TL SUBB, OKL_TXL_EXTENSION_TL SUBT
               WHERE SUBB.LINE_EXTENSION_ID = SUBT.LINE_EXTENSION_ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.INVENTORY_ITEM_NAME <> SUBT.INVENTORY_ITEM_NAME
                      OR SUBB.INVENTORY_ORG_NAME <> SUBT.INVENTORY_ORG_NAME
                      OR (SUBB.INVENTORY_ITEM_NAME IS NULL AND SUBT.INVENTORY_ITEM_NAME IS NOT NULL)
                      OR (SUBB.INVENTORY_ORG_NAME IS NULL AND SUBT.INVENTORY_ORG_NAME IS NOT NULL)
              ));
Line: 133

    INSERT INTO OKL_TXL_EXTENSION_TL (
        LINE_EXTENSION_ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        INVENTORY_ITEM_NAME,
        INVENTORY_ORG_NAME,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN)
      SELECT
            B.LINE_EXTENSION_ID,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.INVENTORY_ITEM_NAME,
            B.INVENTORY_ORG_NAME,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN
        FROM OKL_TXL_EXTENSION_TL B, FND_LANGUAGES L
       WHERE L.INSTALLED_FLAG IN ('I', 'B')
         AND B.LANGUAGE = USERENV('LANG')
         AND NOT EXISTS (
                    SELECT NULL
                      FROM OKL_TXL_EXTENSION_TL T
                     WHERE T.LINE_EXTENSION_ID = B.LINE_EXTENSION_ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );
Line: 176

    SELECT
            LINE_EXTENSION_ID,
            TEH_ID,
            SOURCE_ID,
            SOURCE_TABLE,
            OBJECT_VERSION_NUMBER,
            LANGUAGE,
            CONTRACT_LINE_NUMBER,
            FEE_TYPE_CODE,
            ASSET_NUMBER,
            ASSET_CATEGORY_NAME,
            ASSET_VENDOR_NAME,
            ASSET_MANUFACTURER_NAME,
            ASSET_YEAR_MANUFACTURED,
            ASSET_MODEL_NUMBER,
            ASSET_DELIVERED_DATE,
            INSTALLED_SITE_ID,
            FIXED_ASSET_LOCATION_NAME,
            CONTINGENCY_CODE,
            SUBSIDY_NAME,
            SUBSIDY_PARTY_NAME,
            MEMO_FLAG,
            RECIEVABLES_TRX_TYPE_NAME,
            CONTRACT_LINE_TYPE,
            PAY_SUPPLIER_SITE_NAME,
            AGING_BUCKET_NAME,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            INVENTORY_ITEM_NAME,
            INVENTORY_ORG_NAME,
            INVENTORY_ITEM_NAME_CODE,
            INVENTORY_ORG_CODE,
	    VENDOR_SITE_ID,
            SUBSIDY_VENDOR_ID,
            -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
	    ASSET_VENDOR_ID
            -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables end
      FROM Okl_Txl_Extension_V
     WHERE okl_txl_extension_v.line_extension_id = p_line_extension_id;
Line: 252

              l_telv_rec.last_updated_by,
              l_telv_rec.last_update_date,
              l_telv_rec.last_update_login,
              l_telv_rec.inventory_item_name,
              l_telv_rec.inventory_org_name,
              l_telv_rec.inventory_item_name_code,
              l_telv_rec.inventory_org_code,
	      l_telv_rec.vendor_site_id ,
	      l_telv_rec.subsidy_vendor_id,
	      -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
	      l_telv_rec.asset_vendor_id;
Line: 306

    SELECT
            LINE_EXTENSION_ID,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            INVENTORY_ITEM_NAME,
            INVENTORY_ORG_NAME,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Txl_Extension_Tl
     WHERE okl_txl_extension_tl.line_extension_id = p_line_extension_id
       AND okl_txl_extension_tl.language = p_language;
Line: 337

              l_tell_rec.last_updated_by,
              l_tell_rec.last_update_date,
              l_tell_rec.last_update_login;
Line: 382

    SELECT
            LINE_EXTENSION_ID,
            SOURCE_ID,
            SOURCE_TABLE,
            OBJECT_VERSION_NUMBER,
            CONTRACT_LINE_NUMBER,
            FEE_TYPE_CODE,
            ASSET_NUMBER,
            ASSET_CATEGORY_NAME,
            ASSET_VENDOR_NAME,
            ASSET_MANUFACTURER_NAME,
            ASSET_YEAR_MANUFACTURED,
            ASSET_MODEL_NUMBER,
            ASSET_DELIVERED_DATE,
            INSTALLED_SITE_ID,
            FIXED_ASSET_LOCATION_NAME,
            CONTINGENCY_CODE,
            SUBSIDY_NAME,
            SUBSIDY_PARTY_NAME,
            MEMO_FLAG,
            RECIEVABLES_TRX_TYPE_NAME,
            AGING_BUCKET_NAME,
            CONTRACT_LINE_TYPE,
            PAY_SUPPLIER_SITE_NAME,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            TEH_ID,
            INVENTORY_ITEM_NAME_CODE,
            INVENTORY_ORG_CODE,
	    VENDOR_SITE_ID,
            SUBSIDY_VENDOR_ID,
	    -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
	    ASSET_VENDOR_ID
            -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables end
      FROM Okl_Txl_Extension_B
     WHERE okl_txl_extension_b.line_extension_id = p_line_extension_id;
Line: 453

              l_tel_rec.last_updated_by,
              l_tel_rec.last_update_date,
              l_tel_rec.last_update_login,
              l_tel_rec.teh_id,
              l_tel_rec.inventory_item_name_code,
              l_tel_rec.inventory_org_code,
	      l_tel_rec.vendor_site_id ,
	      l_tel_rec.subsidy_vendor_id ,
	      -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
              l_tel_rec.asset_vendor_id;
Line: 586

    IF (l_telv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_telv_rec.last_updated_by := NULL;
Line: 589

    IF (l_telv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_telv_rec.last_update_date := NULL;
Line: 592

    IF (l_telv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_telv_rec.last_update_login := NULL;
Line: 650

    SELECT 1
    FROM okl_trx_extension_b
    WHERE header_extension_id = p_t_id;
Line: 767

  SELECT '1'
  FROM ap_suppliers
  WHERE  vendor_id =  p_subsidy_vendor_id   ;
Line: 812

  SELECT '1'
  FROM ap_supplier_sites
  WHERE  vendor_site_id =  p_vendor_site_id   ;
Line: 978

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

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

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

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

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

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

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

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

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

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

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

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

  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_tel_rec                      IN tel_rec_type,
    x_tel_rec                      OUT NOCOPY tel_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1330

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

    INSERT INTO OKL_TXL_EXTENSION_B(
      line_extension_id,
      source_id,
      source_table,
      object_version_number,
      contract_line_number,
      fee_type_code,
      asset_number,
      asset_category_name,
      asset_vendor_name,
      asset_manufacturer_name,
      asset_year_manufactured,
      asset_model_number,
      asset_delivered_date,
      installed_site_id,
      fixed_asset_location_name,
      contingency_code,
      subsidy_name,
      subsidy_party_name,
      memo_flag,
      recievables_trx_type_name,
      aging_bucket_name,
      contract_line_type,
      pay_supplier_site_name,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      teh_id,
      inventory_item_name_code,
      inventory_org_code,
      vendor_site_id ,
      subsidy_vendor_id ,
      asset_vendor_id)
    VALUES (
      l_def_tel_rec.line_extension_id,
      l_def_tel_rec.source_id,
      l_def_tel_rec.source_table,
      l_def_tel_rec.object_version_number,
      l_def_tel_rec.contract_line_number,
      l_def_tel_rec.fee_type_code,
      l_def_tel_rec.asset_number,
      l_def_tel_rec.asset_category_name,
      l_def_tel_rec.asset_vendor_name,
      l_def_tel_rec.asset_manufacturer_name,
      l_def_tel_rec.asset_year_manufactured,
      l_def_tel_rec.asset_model_number,
      l_def_tel_rec.asset_delivered_date,
      l_def_tel_rec.installed_site_id,
      l_def_tel_rec.fixed_asset_location_name,
      l_def_tel_rec.contingency_code,
      l_def_tel_rec.subsidy_name,
      l_def_tel_rec.subsidy_party_name,
      l_def_tel_rec.memo_flag,
      l_def_tel_rec.recievables_trx_type_name,
      l_def_tel_rec.aging_bucket_name,
      l_def_tel_rec.contract_line_type,
      l_def_tel_rec.pay_supplier_site_name,
      l_def_tel_rec.created_by,
      l_def_tel_rec.creation_date,
      l_def_tel_rec.last_updated_by,
      l_def_tel_rec.last_update_date,
      l_def_tel_rec.last_update_login,
      l_def_tel_rec.teh_id,
      l_def_tel_rec.inventory_item_name_code,
      l_def_tel_rec.inventory_org_code,
      l_def_tel_rec.vendor_site_id,
      l_def_tel_rec.subsidy_vendor_id,
      l_def_tel_rec.asset_vendor_id);
Line: 1471

  END insert_row;
Line: 1475

  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_tell_rec                     IN tell_rec_type,
    x_tell_rec                     OUT NOCOPY tell_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1484

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

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

      INSERT INTO OKL_TXL_EXTENSION_TL(
        line_extension_id,
        language,
        source_lang,
        sfwt_flag,
        inventory_item_name,
        inventory_org_name,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_tell_rec.line_extension_id,
        l_tell_rec.language,
        l_tell_rec.source_lang,
        l_tell_rec.sfwt_flag,
        l_tell_rec.inventory_item_name,
        l_tell_rec.inventory_org_name,
        l_tell_rec.created_by,
        l_tell_rec.creation_date,
        l_tell_rec.last_updated_by,
        l_tell_rec.last_update_date,
        l_tell_rec.last_update_login);
Line: 1589

  END insert_row;
Line: 1593

  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_telv_rec                     IN telv_rec_type,
    x_telv_rec                     OUT NOCOPY telv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1603

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

      l_telv_rec.LAST_UPDATE_DATE := l_telv_rec.CREATION_DATE;
Line: 1622

      l_telv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1623

      l_telv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1688

    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_tel_rec,
      lx_tel_rec
    );
Line: 1702

    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_tell_rec,
      lx_tell_rec
    );
Line: 1751

  END insert_row;
Line: 1755

  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_telv_tbl                     IN telv_tbl_type,
    x_telv_tbl                     OUT NOCOPY telv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1766

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

          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_telv_rec                     => p_telv_tbl(i),
            x_telv_rec                     => x_telv_tbl(i));
Line: 1848

  END insert_row;
Line: 1853

  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_telv_tbl                     IN telv_tbl_type,
    x_telv_tbl                     OUT NOCOPY telv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1863

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

    l_last_updated_by               NUMBER;
Line: 1872

    l_last_update_date              DATE;
Line: 1873

    l_last_update_login             NUMBER;
Line: 1884

    l_last_updated_by   := FND_GLOBAL.USER_ID;
Line: 1886

    l_last_update_date  := SYSDATE;
Line: 1887

    l_last_update_login := FND_GLOBAL.LOGIN_ID;
Line: 1899

        l_telv_tbl_in(i).last_updated_by          := l_last_updated_by;
Line: 1900

        l_telv_tbl_in(i).last_update_date         := l_last_update_date;
Line: 1901

        l_telv_tbl_in(i).last_update_login        := l_last_update_login;
Line: 1928

        l_tel_tbl_in(j).last_updated_by           := l_telv_tbl_in(i).last_updated_by ;
Line: 1929

        l_tel_tbl_in(j).last_update_date          := l_telv_tbl_in(i).last_update_date ;
Line: 1930

        l_tel_tbl_in(j).last_update_login         := l_telv_tbl_in(i).last_update_login ;
Line: 1946

        l_tell_tbl_in(j).last_updated_by          := l_telv_tbl_in(i).last_updated_by;
Line: 1947

        l_tell_tbl_in(j).last_update_date         := l_telv_tbl_in(i).last_update_date;
Line: 1948

        l_tell_tbl_in(j).last_update_login        := l_telv_tbl_in(i).last_update_login;
Line: 1956

      INSERT INTO OKL_TXL_EXTENSION_B
        VALUES l_tel_tbl_in(j);
Line: 1960

      INSERT INTO OKL_TXL_EXTENSION_TL
        VALUES l_tell_tbl_in(j);
Line: 2000

  END insert_row;
Line: 2018

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TXL_EXTENSION_B
     WHERE LINE_EXTENSION_ID = p_tel_rec.line_extension_id
       AND OBJECT_VERSION_NUMBER = p_tel_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 2025

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_TXL_EXTENSION_B
     WHERE LINE_EXTENSION_ID = p_tel_rec.line_extension_id;
Line: 2066

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

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

    SELECT *
      FROM OKL_TXL_EXTENSION_TL
     WHERE LINE_EXTENSION_ID = p_tell_rec.line_extension_id
    FOR UPDATE NOWAIT;
Line: 2161

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

  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_tel_rec                      IN tel_rec_type,
    x_tel_rec                      OUT NOCOPY tel_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2464

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

        IF x_tel_rec.last_updated_by IS NULL THEN
          x_tel_rec.last_updated_by := l_tel_rec.last_updated_by;
Line: 2562

        IF x_tel_rec.last_update_date IS NULL THEN
          x_tel_rec.last_update_date := l_tel_rec.last_update_date;
Line: 2565

        IF x_tel_rec.last_update_login IS NULL THEN
          x_tel_rec.last_update_login := l_tel_rec.last_update_login;
Line: 2628

    UPDATE OKL_TXL_EXTENSION_B
    SET SOURCE_ID = l_def_tel_rec.source_id,
        SOURCE_TABLE = l_def_tel_rec.source_table,
        OBJECT_VERSION_NUMBER = l_def_tel_rec.object_version_number,
        CONTRACT_LINE_NUMBER = l_def_tel_rec.contract_line_number,
        FEE_TYPE_CODE = l_def_tel_rec.fee_type_code,
        ASSET_NUMBER = l_def_tel_rec.asset_number,
        ASSET_CATEGORY_NAME = l_def_tel_rec.asset_category_name,
        ASSET_VENDOR_NAME = l_def_tel_rec.asset_vendor_name,
        ASSET_MANUFACTURER_NAME = l_def_tel_rec.asset_manufacturer_name,
        ASSET_YEAR_MANUFACTURED = l_def_tel_rec.asset_year_manufactured,
        ASSET_MODEL_NUMBER = l_def_tel_rec.asset_model_number,
        ASSET_DELIVERED_DATE = l_def_tel_rec.asset_delivered_date,
        INSTALLED_SITE_ID = l_def_tel_rec.installed_site_id,
        FIXED_ASSET_LOCATION_NAME = l_def_tel_rec.fixed_asset_location_name,
        CONTINGENCY_CODE = l_def_tel_rec.contingency_code,
        SUBSIDY_NAME = l_def_tel_rec.subsidy_name,
        SUBSIDY_PARTY_NAME = l_def_tel_rec.subsidy_party_name,
        MEMO_FLAG = l_def_tel_rec.memo_flag,
        RECIEVABLES_TRX_TYPE_NAME = l_def_tel_rec.recievables_trx_type_name,
        AGING_BUCKET_NAME = l_def_tel_rec.aging_bucket_name,
        CONTRACT_LINE_TYPE = l_def_tel_rec.contract_line_type,
        PAY_SUPPLIER_SITE_NAME = l_def_tel_rec.pay_supplier_site_name,
        CREATED_BY = l_def_tel_rec.created_by,
        CREATION_DATE = l_def_tel_rec.creation_date,
        LAST_UPDATED_BY = l_def_tel_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_tel_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_tel_rec.last_update_login,
        TEH_ID = l_def_tel_rec.teh_id,
        INVENTORY_ITEM_NAME_CODE = l_def_tel_rec.inventory_item_name_code,
        INVENTORY_ORG_CODE = l_def_tel_rec.inventory_org_code,
	VENDOR_SITE_ID = l_def_tel_rec.vendor_site_id,
	SUBSIDY_VENDOR_ID = l_def_tel_rec.subsidy_vendor_id,
	ASSET_VENDOR_ID = l_def_tel_rec.asset_vendor_id
    WHERE LINE_EXTENSION_ID = l_def_tel_rec.line_extension_id;
Line: 2698

  END update_row;
Line: 2702

  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_tell_rec                     IN tell_rec_type,
    x_tell_rec                     OUT NOCOPY tell_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2711

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

        IF x_tell_rec.last_updated_by IS NULL THEN
          x_tell_rec.last_updated_by := l_tell_rec.last_updated_by;
Line: 2758

        IF x_tell_rec.last_update_date IS NULL THEN
          x_tell_rec.last_update_date := l_tell_rec.last_update_date;
Line: 2761

        IF x_tell_rec.last_update_login IS NULL THEN
          x_tell_rec.last_update_login := l_tell_rec.last_update_login;
Line: 2807

    UPDATE OKL_TXL_EXTENSION_TL
    SET INVENTORY_ITEM_NAME = l_def_tell_rec.inventory_item_name,
        INVENTORY_ORG_NAME = l_def_tell_rec.inventory_org_name,
        CREATED_BY = l_def_tell_rec.created_by,
        CREATION_DATE = l_def_tell_rec.creation_date,
        LAST_UPDATED_BY = l_def_tell_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_tell_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_tell_rec.last_update_login
    WHERE LINE_EXTENSION_ID = l_def_tell_rec.line_extension_id
      AND SOURCE_LANG = USERENV('LANG');
Line: 2818

    UPDATE OKL_TXL_EXTENSION_TL
    SET SFWT_FLAG = 'Y'
    WHERE LINE_EXTENSION_ID = l_def_tell_rec.line_extension_id
      AND SOURCE_LANG <> USERENV('LANG');
Line: 2857

  END update_row;
Line: 2861

  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_telv_rec                     IN telv_rec_type,
    x_telv_rec                     OUT NOCOPY telv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2871

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

      l_telv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2889

      l_telv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2890

      l_telv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 2987

        IF x_telv_rec.last_updated_by IS NULL THEN
          x_telv_rec.last_updated_by := l_db_telv_rec.last_updated_by;
Line: 2990

        IF x_telv_rec.last_update_date IS NULL THEN
          x_telv_rec.last_update_date := l_db_telv_rec.last_update_date;
Line: 2993

        IF x_telv_rec.last_update_login IS NULL THEN
          x_telv_rec.last_update_login := l_db_telv_rec.last_update_login;
Line: 3100

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_tel_rec,
      lx_tel_rec
    );
Line: 3114

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_tell_rec,
      lx_tell_rec
    );
Line: 3162

  END update_row;
Line: 3166

  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_telv_tbl                     IN telv_tbl_type,
    x_telv_tbl                     OUT NOCOPY telv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3177

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

          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_telv_rec                     => p_telv_tbl(i),
            x_telv_rec                     => x_telv_tbl(i));
Line: 3259

  END update_row;
Line: 3264

  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_telv_tbl                     IN telv_tbl_type,
    x_telv_tbl                     OUT NOCOPY telv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3274

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

      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_telv_tbl                     => p_telv_tbl,
        x_telv_tbl                     => x_telv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 3323

  END update_row;
Line: 3331

  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_tel_rec                      IN tel_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3339

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

    DELETE FROM OKL_TXL_EXTENSION_B
     WHERE LINE_EXTENSION_ID = p_tel_rec.line_extension_id;
Line: 3390

  END delete_row;
Line: 3394

  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_tell_rec                     IN tell_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3402

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

    DELETE FROM OKL_TXL_EXTENSION_TL
     WHERE LINE_EXTENSION_ID = p_tell_rec.line_extension_id;
Line: 3453

  END delete_row;
Line: 3457

  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_telv_rec                     IN telv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3466

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

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_tell_rec
    );
Line: 3504

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_tel_rec
    );
Line: 3549

  END delete_row;
Line: 3553

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

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3563

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

          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_telv_rec                     => p_telv_tbl(i));
Line: 3644

  END delete_row;
Line: 3649

  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_telv_tbl                     IN telv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3658

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

      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_telv_tbl                     => p_telv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 3706

  END delete_row;
Line: 3716

  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_tel_rec                      IN tel_rec_type,
    p_tell_tbl                     IN tell_tbl_type,
    x_tel_rec                      OUT NOCOPY tel_rec_type,
    x_tell_tbl                     OUT NOCOPY tell_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3728

    l_api_name                     CONSTANT VARCHAR2(30) := 'insert_row';
Line: 3758

    l_tel_rec.LAST_UPDATE_DATE := l_tel_rec.CREATION_DATE;
Line: 3759

    l_tel_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 3760

    l_tel_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 3762

    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_tel_rec,
      lx_tel_rec
    );
Line: 3780

     l_tell_tbl(idx).LAST_UPDATE_DATE := l_tell_tbl(idx).CREATION_DATE;
Line: 3781

     l_tell_tbl(idx).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 3782

     l_tell_tbl(idx).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 3783

     insert_row(
       p_init_msg_list,
       l_return_status,
       x_msg_count,
       x_msg_data,
       l_tell_tbl(idx),
       lx_tell_tbl(idx)
     );
Line: 3833

  END insert_row;