DBA Data[Home] [Help]

APPS.OKL_PXL_PVT SQL Statements

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

Line: 66

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

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

    UPDATE OKL_EXT_AP_LINE_SOURCES_TL T SET(
        INVENTORY_ORG_NAME,
        STREAM_TYPE_NAME,
        TRANS_LINE_DESCRIPTION,
        INVENTORY_ITEM_NAME) = (SELECT
                                  B.INVENTORY_ORG_NAME,
                                  B.STREAM_TYPE_NAME,
                                  B.TRANS_LINE_DESCRIPTION,
                                  B.INVENTORY_ITEM_NAME
                                FROM OKL_EXT_AP_LINE_SOURCES_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_EXT_AP_LINE_SOURCES_TL SUBB, OKL_EXT_AP_LINE_SOURCES_TL SUBT
               WHERE SUBB.LINE_EXTENSION_ID = SUBT.LINE_EXTENSION_ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.INVENTORY_ORG_NAME <> SUBT.INVENTORY_ORG_NAME
                      OR SUBB.STREAM_TYPE_NAME <> SUBT.STREAM_TYPE_NAME
                      OR SUBB.TRANS_LINE_DESCRIPTION <> SUBT.TRANS_LINE_DESCRIPTION
                      OR SUBB.INVENTORY_ITEM_NAME <> SUBT.INVENTORY_ITEM_NAME
                      OR (SUBB.INVENTORY_ORG_NAME IS NULL AND SUBT.INVENTORY_ORG_NAME IS NOT NULL)
                      OR (SUBB.STREAM_TYPE_NAME IS NULL AND SUBT.STREAM_TYPE_NAME IS NOT NULL)
                      OR (SUBB.TRANS_LINE_DESCRIPTION IS NULL AND SUBT.TRANS_LINE_DESCRIPTION IS NOT NULL)
                      OR (SUBB.INVENTORY_ITEM_NAME IS NULL AND SUBT.INVENTORY_ITEM_NAME IS NOT NULL)
              ));
Line: 141

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

    SELECT
            LINE_EXTENSION_ID,
            HEADER_EXTENSION_ID,
            SOURCE_ID,
            SOURCE_TABLE,
            OBJECT_VERSION_NUMBER,
            KLE_ID,
            STY_ID,
            ASSET_NUMBER,
            CONTRACT_LINE_NUMBER,
            ASSET_VENDOR_NAME,
            INSTALLED_SITE_ID,
            FIXED_ASSET_LOCATION_NAME,
            ACCOUNTING_TEMPLATE_NAME,
            FEE_TYPE_CODE,
            MEMO_FLAG,
            CONTRACT_LINE_TYPE,
            LINE_ATTRIBUTE_CATEGORY,
            LINE_ATTRIBUTE1,
            LINE_ATTRIBUTE2,
            LINE_ATTRIBUTE3,
            LINE_ATTRIBUTE4,
            LINE_ATTRIBUTE5,
            LINE_ATTRIBUTE6,
            LINE_ATTRIBUTE7,
            LINE_ATTRIBUTE8,
            LINE_ATTRIBUTE9,
            LINE_ATTRIBUTE10,
            LINE_ATTRIBUTE11,
            LINE_ATTRIBUTE12,
            LINE_ATTRIBUTE13,
            LINE_ATTRIBUTE14,
            LINE_ATTRIBUTE15,
            STREAM_TYPE_CODE,
            STREAM_TYPE_PURPOSE_CODE,
            INVENTORY_ORG_CODE,
            LANGUAGE,
            INVENTORY_ORG_NAME,
            STREAM_TYPE_NAME,
            TRANS_LINE_DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ASSET_CATEGORY_NAME,
            INVENTORY_ITEM_NAME_CODE,
            INVENTORY_ITEM_NAME,
	    ASSET_VENDOR_ID
      FROM Okl_Ext_Ap_Line_Sources_V
     WHERE okl_ext_ap_line_sources_v.line_extension_id = p_line_extension_id;
Line: 287

              l_pxlv_rec.last_updated_by,
              l_pxlv_rec.last_update_date,
              l_pxlv_rec.last_update_login,
              l_pxlv_rec.asset_category_name,
              l_pxlv_rec.inventory_item_name_code,
              l_pxlv_rec.inventory_item_name,
	       l_pxlv_rec.asset_vendor_id;
Line: 335

    SELECT
            LINE_EXTENSION_ID,
            HEADER_EXTENSION_ID,
            SOURCE_ID,
            SOURCE_TABLE,
            OBJECT_VERSION_NUMBER,
            KLE_ID,
            STY_ID,
            ASSET_NUMBER,
            CONTRACT_LINE_NUMBER,
            ASSET_VENDOR_NAME,
            INSTALLED_SITE_ID,
            FIXED_ASSET_LOCATION_NAME,
            ACCOUNTING_TEMPLATE_NAME,
            FEE_TYPE_CODE,
            MEMO_FLAG,
            CONTRACT_LINE_TYPE,
            LINE_ATTRIBUTE_CATEGORY,
            LINE_ATTRIBUTE1,
            LINE_ATTRIBUTE2,
            LINE_ATTRIBUTE3,
            LINE_ATTRIBUTE4,
            LINE_ATTRIBUTE5,
            LINE_ATTRIBUTE6,
            LINE_ATTRIBUTE7,
            LINE_ATTRIBUTE8,
            LINE_ATTRIBUTE9,
            LINE_ATTRIBUTE10,
            LINE_ATTRIBUTE11,
            LINE_ATTRIBUTE12,
            LINE_ATTRIBUTE13,
            LINE_ATTRIBUTE14,
            LINE_ATTRIBUTE15,
            STREAM_TYPE_CODE,
            STREAM_TYPE_PURPOSE_CODE,
            INVENTORY_ORG_CODE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            ASSET_CATEGORY_NAME,
            INVENTORY_ITEM_NAME_CODE,
	    ASSET_VENDOR_ID
      FROM Okl_Ext_Ap_Line_Sources_B
     WHERE okl_ext_ap_line_sources_b.line_extension_id = p_line_extension_id;
Line: 425

              l_pxl_rec.last_updated_by,
              l_pxl_rec.last_update_date,
              l_pxl_rec.last_update_login,
              l_pxl_rec.asset_category_name,
              l_pxl_rec.inventory_item_name_code,
	      l_pxl_rec.asset_vendor_id;
Line: 473

    SELECT
            LINE_EXTENSION_ID,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            INVENTORY_ORG_NAME,
            STREAM_TYPE_NAME,
            TRANS_LINE_DESCRIPTION,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            INVENTORY_ITEM_NAME
      FROM Okl_Ext_Ap_Line_Sources_Tl
     WHERE okl_ext_ap_line_sources_tl.line_extension_id = p_line_extension_id
       AND okl_ext_ap_line_sources_tl.language = p_language;
Line: 507

              l_pxll_rec.last_updated_by,
              l_pxll_rec.last_update_date,
              l_pxll_rec.last_update_login,
              l_pxll_rec.inventory_item_name;
Line: 676

    IF (l_pxlv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_pxlv_rec.last_updated_by := NULL;
Line: 679

    IF (l_pxlv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_pxlv_rec.last_update_date := NULL;
Line: 682

    IF (l_pxlv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_pxlv_rec.last_update_login := NULL;
Line: 888

  SELECT '1'
  FROM ap_suppliers
  WHERE  vendor_id =  p_asset_vendor_id   ;
Line: 1090

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

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

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

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

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

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

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

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

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

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

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

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

  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_pxl_rec                      IN pxl_rec_type,
    x_pxl_rec                      OUT NOCOPY pxl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1433

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

    INSERT INTO OKL_EXT_AP_LINE_SOURCES_B(
      line_extension_id,
      header_extension_id,
      source_id,
      source_table,
      object_version_number,
      kle_id,
      sty_id,
      asset_number,
      contract_line_number,
      asset_vendor_name,
      installed_site_id,
      fixed_asset_location_name,
      accounting_template_name,
      fee_type_code,
      memo_flag,
      contract_line_type,
      line_attribute_category,
      line_attribute1,
      line_attribute2,
      line_attribute3,
      line_attribute4,
      line_attribute5,
      line_attribute6,
      line_attribute7,
      line_attribute8,
      line_attribute9,
      line_attribute10,
      line_attribute11,
      line_attribute12,
      line_attribute13,
      line_attribute14,
      line_attribute15,
      stream_type_code,
      stream_type_purpose_code,
      inventory_org_code,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      asset_category_name,
      inventory_item_name_code,
      asset_vendor_id)
    VALUES (
      l_def_pxl_rec.line_extension_id,
      l_def_pxl_rec.header_extension_id,
      l_def_pxl_rec.source_id,
      l_def_pxl_rec.source_table,
      l_def_pxl_rec.object_version_number,
      l_def_pxl_rec.kle_id,
      l_def_pxl_rec.sty_id,
      l_def_pxl_rec.asset_number,
      l_def_pxl_rec.contract_line_number,
      l_def_pxl_rec.asset_vendor_name,
      l_def_pxl_rec.installed_site_id,
      l_def_pxl_rec.fixed_asset_location_name,
      l_def_pxl_rec.accounting_template_name,
      l_def_pxl_rec.fee_type_code,
      l_def_pxl_rec.memo_flag,
      l_def_pxl_rec.contract_line_type,
      l_def_pxl_rec.line_attribute_category,
      l_def_pxl_rec.line_attribute1,
      l_def_pxl_rec.line_attribute2,
      l_def_pxl_rec.line_attribute3,
      l_def_pxl_rec.line_attribute4,
      l_def_pxl_rec.line_attribute5,
      l_def_pxl_rec.line_attribute6,
      l_def_pxl_rec.line_attribute7,
      l_def_pxl_rec.line_attribute8,
      l_def_pxl_rec.line_attribute9,
      l_def_pxl_rec.line_attribute10,
      l_def_pxl_rec.line_attribute11,
      l_def_pxl_rec.line_attribute12,
      l_def_pxl_rec.line_attribute13,
      l_def_pxl_rec.line_attribute14,
      l_def_pxl_rec.line_attribute15,
      l_def_pxl_rec.stream_type_code,
      l_def_pxl_rec.stream_type_purpose_code,
      l_def_pxl_rec.inventory_org_code,
      l_def_pxl_rec.created_by,
      l_def_pxl_rec.creation_date,
      l_def_pxl_rec.last_updated_by,
      l_def_pxl_rec.last_update_date,
      l_def_pxl_rec.last_update_login,
      l_def_pxl_rec.asset_category_name,
      l_def_pxl_rec.inventory_item_name_code,
      l_def_pxl_rec.asset_vendor_id);
Line: 1592

  END insert_row;
Line: 1596

  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_pxll_rec                     IN pxll_rec_type,
    x_pxll_rec                     OUT NOCOPY pxll_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1605

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

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

      INSERT INTO OKL_EXT_AP_LINE_SOURCES_TL(
        line_extension_id,
        language,
        source_lang,
        sfwt_flag,
        inventory_org_name,
        stream_type_name,
        trans_line_description,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login,
        inventory_item_name)
      VALUES (
        l_pxll_rec.line_extension_id,
        l_pxll_rec.language,
        l_pxll_rec.source_lang,
        l_pxll_rec.sfwt_flag,
        l_pxll_rec.inventory_org_name,
        l_pxll_rec.stream_type_name,
        l_pxll_rec.trans_line_description,
        l_pxll_rec.created_by,
        l_pxll_rec.creation_date,
        l_pxll_rec.last_updated_by,
        l_pxll_rec.last_update_date,
        l_pxll_rec.last_update_login,
        l_pxll_rec.inventory_item_name);
Line: 1710

  END insert_row;
Line: 1714

  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_pxlv_rec                     IN pxlv_rec_type,
    x_pxlv_rec                     OUT NOCOPY pxlv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1724

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

      l_pxlv_rec.LAST_UPDATE_DATE := l_pxlv_rec.CREATION_DATE;
Line: 1743

      l_pxlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 1744

      l_pxlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 1809

    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pxl_rec,
      lx_pxl_rec
    );
Line: 1823

    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pxll_rec,
      lx_pxll_rec
    );
Line: 1872

  END insert_row;
Line: 1876

  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_pxlv_tbl                     IN pxlv_tbl_type,
    x_pxlv_tbl                     OUT NOCOPY pxlv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1887

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

          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_pxlv_rec                     => p_pxlv_tbl(i),
            x_pxlv_rec                     => x_pxlv_tbl(i));
Line: 1969

  END insert_row;
Line: 1974

  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_pxlv_tbl                     IN pxlv_tbl_type,
    x_pxlv_tbl                     OUT NOCOPY pxlv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 1984

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

      insert_row (
        p_api_version                  => p_api_version,
        p_init_msg_list                => OKL_API.G_FALSE,
        x_return_status                => x_return_status,
        x_msg_count                    => x_msg_count,
        x_msg_data                     => x_msg_data,
        p_pxlv_tbl                     => p_pxlv_tbl,
        x_pxlv_tbl                     => x_pxlv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 2033

  END insert_row;
Line: 2051

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_EXT_AP_LINE_SOURCES_B
     WHERE LINE_EXTENSION_ID = p_pxl_rec.line_extension_id
       AND OBJECT_VERSION_NUMBER = p_pxl_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 2058

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_EXT_AP_LINE_SOURCES_B
     WHERE LINE_EXTENSION_ID = p_pxl_rec.line_extension_id;
Line: 2099

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

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

    SELECT *
      FROM OKL_EXT_AP_LINE_SOURCES_TL
     WHERE LINE_EXTENSION_ID = p_pxll_rec.line_extension_id
    FOR UPDATE NOWAIT;
Line: 2194

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

  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_pxl_rec                      IN pxl_rec_type,
    x_pxl_rec                      OUT NOCOPY pxl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2497

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

        IF x_pxl_rec.last_updated_by IS NULL THEN
          x_pxl_rec.last_updated_by := l_pxl_rec.last_updated_by;
Line: 2631

        IF x_pxl_rec.last_update_date IS NULL THEN
          x_pxl_rec.last_update_date := l_pxl_rec.last_update_date;
Line: 2634

        IF x_pxl_rec.last_update_login IS NULL THEN
          x_pxl_rec.last_update_login := l_pxl_rec.last_update_login;
Line: 2688

    UPDATE OKL_EXT_AP_LINE_SOURCES_B
    SET HEADER_EXTENSION_ID = l_def_pxl_rec.header_extension_id,
        SOURCE_ID = l_def_pxl_rec.source_id,
        SOURCE_TABLE = l_def_pxl_rec.source_table,
        OBJECT_VERSION_NUMBER = l_def_pxl_rec.object_version_number,
        KLE_ID = l_def_pxl_rec.kle_id,
        STY_ID = l_def_pxl_rec.sty_id,
        ASSET_NUMBER = l_def_pxl_rec.asset_number,
        CONTRACT_LINE_NUMBER = l_def_pxl_rec.contract_line_number,
        ASSET_VENDOR_NAME = l_def_pxl_rec.asset_vendor_name,
        INSTALLED_SITE_ID = l_def_pxl_rec.installed_site_id,
        FIXED_ASSET_LOCATION_NAME = l_def_pxl_rec.fixed_asset_location_name,
        ACCOUNTING_TEMPLATE_NAME = l_def_pxl_rec.accounting_template_name,
        FEE_TYPE_CODE = l_def_pxl_rec.fee_type_code,
        MEMO_FLAG = l_def_pxl_rec.memo_flag,
        CONTRACT_LINE_TYPE = l_def_pxl_rec.contract_line_type,
        LINE_ATTRIBUTE_CATEGORY = l_def_pxl_rec.line_attribute_category,
        LINE_ATTRIBUTE1 = l_def_pxl_rec.line_attribute1,
        LINE_ATTRIBUTE2 = l_def_pxl_rec.line_attribute2,
        LINE_ATTRIBUTE3 = l_def_pxl_rec.line_attribute3,
        LINE_ATTRIBUTE4 = l_def_pxl_rec.line_attribute4,
        LINE_ATTRIBUTE5 = l_def_pxl_rec.line_attribute5,
        LINE_ATTRIBUTE6 = l_def_pxl_rec.line_attribute6,
        LINE_ATTRIBUTE7 = l_def_pxl_rec.line_attribute7,
        LINE_ATTRIBUTE8 = l_def_pxl_rec.line_attribute8,
        LINE_ATTRIBUTE9 = l_def_pxl_rec.line_attribute9,
        LINE_ATTRIBUTE10 = l_def_pxl_rec.line_attribute10,
        LINE_ATTRIBUTE11 = l_def_pxl_rec.line_attribute11,
        LINE_ATTRIBUTE12 = l_def_pxl_rec.line_attribute12,
        LINE_ATTRIBUTE13 = l_def_pxl_rec.line_attribute13,
        LINE_ATTRIBUTE14 = l_def_pxl_rec.line_attribute14,
        LINE_ATTRIBUTE15 = l_def_pxl_rec.line_attribute15,
        STREAM_TYPE_CODE = l_def_pxl_rec.stream_type_code,
        STREAM_TYPE_PURPOSE_CODE = l_def_pxl_rec.stream_type_purpose_code,
        INVENTORY_ORG_CODE = l_def_pxl_rec.inventory_org_code,
        CREATED_BY = l_def_pxl_rec.created_by,
        CREATION_DATE = l_def_pxl_rec.creation_date,
        LAST_UPDATED_BY = l_def_pxl_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_pxl_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_pxl_rec.last_update_login,
        ASSET_CATEGORY_NAME = l_def_pxl_rec.asset_category_name,
        INVENTORY_ITEM_NAME_CODE = l_def_pxl_rec.inventory_item_name_code,
	ASSET_VENDOR_ID = l_def_pxl_rec.asset_vendor_id
    WHERE LINE_EXTENSION_ID = l_def_pxl_rec.line_extension_id;
Line: 2767

  END update_row;
Line: 2771

  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_pxll_rec                     IN pxll_rec_type,
    x_pxll_rec                     OUT NOCOPY pxll_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2780

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

        IF x_pxll_rec.last_updated_by IS NULL THEN
          x_pxll_rec.last_updated_by := l_pxll_rec.last_updated_by;
Line: 2830

        IF x_pxll_rec.last_update_date IS NULL THEN
          x_pxll_rec.last_update_date := l_pxll_rec.last_update_date;
Line: 2833

        IF x_pxll_rec.last_update_login IS NULL THEN
          x_pxll_rec.last_update_login := l_pxll_rec.last_update_login;
Line: 2882

    UPDATE OKL_EXT_AP_LINE_SOURCES_TL
    SET INVENTORY_ORG_NAME = l_def_pxll_rec.inventory_org_name,
        STREAM_TYPE_NAME = l_def_pxll_rec.stream_type_name,
        TRANS_LINE_DESCRIPTION = l_def_pxll_rec.trans_line_description,
        CREATED_BY = l_def_pxll_rec.created_by,
        CREATION_DATE = l_def_pxll_rec.creation_date,
        LAST_UPDATED_BY = l_def_pxll_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_pxll_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_pxll_rec.last_update_login,
        INVENTORY_ITEM_NAME = l_def_pxll_rec.inventory_item_name
    WHERE LINE_EXTENSION_ID = l_def_pxll_rec.line_extension_id
      AND SOURCE_LANG = USERENV('LANG');
Line: 2895

    UPDATE OKL_EXT_AP_LINE_SOURCES_TL
    SET SFWT_FLAG = 'Y'
    WHERE LINE_EXTENSION_ID = l_def_pxll_rec.line_extension_id
      AND SOURCE_LANG <> USERENV('LANG');
Line: 2934

  END update_row;
Line: 2938

  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_pxlv_rec                     IN pxlv_rec_type,
    x_pxlv_rec                     OUT NOCOPY pxlv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 2948

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

      l_pxlv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 2966

      l_pxlv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 2967

      l_pxlv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 3106

        IF x_pxlv_rec.last_updated_by IS NULL THEN
          x_pxlv_rec.last_updated_by := l_db_pxlv_rec.last_updated_by;
Line: 3109

        IF x_pxlv_rec.last_update_date IS NULL THEN
          x_pxlv_rec.last_update_date := l_db_pxlv_rec.last_update_date;
Line: 3112

        IF x_pxlv_rec.last_update_login IS NULL THEN
          x_pxlv_rec.last_update_login := l_db_pxlv_rec.last_update_login;
Line: 3210

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pxl_rec,
      lx_pxl_rec
    );
Line: 3224

    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pxll_rec,
      lx_pxll_rec
    );
Line: 3272

  END update_row;
Line: 3276

  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_pxlv_tbl                     IN pxlv_tbl_type,
    x_pxlv_tbl                     OUT NOCOPY pxlv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3287

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

          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_pxlv_rec                     => p_pxlv_tbl(i),
            x_pxlv_rec                     => x_pxlv_tbl(i));
Line: 3369

  END update_row;
Line: 3374

  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_pxlv_tbl                     IN pxlv_tbl_type,
    x_pxlv_tbl                     OUT NOCOPY pxlv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3384

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

      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_pxlv_tbl                     => p_pxlv_tbl,
        x_pxlv_tbl                     => x_pxlv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 3433

  END update_row;
Line: 3441

  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_pxl_rec                      IN pxl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3449

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

    DELETE FROM OKL_EXT_AP_LINE_SOURCES_B
     WHERE LINE_EXTENSION_ID = p_pxl_rec.line_extension_id;
Line: 3500

  END delete_row;
Line: 3504

  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_pxll_rec                     IN pxll_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3512

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

    DELETE FROM OKL_EXT_AP_LINE_SOURCES_TL
     WHERE LINE_EXTENSION_ID = p_pxll_rec.line_extension_id;
Line: 3563

  END delete_row;
Line: 3567

  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_pxlv_rec                     IN pxlv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3576

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

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pxll_rec
    );
Line: 3614

    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pxl_rec
    );
Line: 3659

  END delete_row;
Line: 3663

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

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3673

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

          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_pxlv_rec                     => p_pxlv_tbl(i));
Line: 3754

  END delete_row;
Line: 3759

  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_pxlv_tbl                     IN pxlv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3768

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

      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_pxlv_tbl                     => p_pxlv_tbl,
        px_error_tbl                   => l_error_tbl);
Line: 3816

  END delete_row;
Line: 3826

  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_pxl_rec                      IN pxl_rec_type,
    p_pxll_tbl                     IN pxll_tbl_type,
    x_pxl_rec                      OUT NOCOPY pxl_rec_type,
    x_pxll_tbl                     OUT NOCOPY pxll_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;
Line: 3838

    l_api_name                     CONSTANT VARCHAR2(30) := 'B_TL_insert_row';
Line: 3858

      l_pxl_rec.LAST_UPDATE_DATE := l_pxl_rec.CREATION_DATE;
Line: 3859

      l_pxl_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 3860

      l_pxl_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 3906

    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pxl_rec,
      lx_pxl_rec
    );
Line: 3927

     l_pxll_tbl(idx).LAST_UPDATE_DATE := l_pxll_tbl(idx).CREATION_DATE;
Line: 3928

     l_pxll_tbl(idx).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
Line: 3929

     l_pxll_tbl(idx).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
Line: 3930

     insert_row(
       p_init_msg_list,
       l_return_status,
       x_msg_count,
       x_msg_data,
       l_pxll_tbl(idx),
       lx_pxll_tbl(idx)
     );
Line: 3980

  END insert_row;