eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PXH_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_header_sources_s.NEXTVAL FROM DUAL;

Line: 104


    DELETE FROM OKL_EXT_AP_HEADER_SOURCES_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_EXT_AP_HEADER_SOURCES_B B
         WHERE B.HEADER_EXTENSION_ID =T.HEADER_EXTENSION_ID
        );

Line: 111


    UPDATE OKL_EXT_AP_HEADER_SOURCES_TL T SET(
        CONTRACT_STATUS,
        INV_AGRMNT_STATUS,
        TRANSACTION_TYPE_NAME) = (SELECT
                                  B.CONTRACT_STATUS,
                                  B.INV_AGRMNT_STATUS,
                                  B.TRANSACTION_TYPE_NAME
                                FROM OKL_EXT_AP_HEADER_SOURCES_TL B
                               WHERE B.HEADER_EXTENSION_ID = T.HEADER_EXTENSION_ID
                                 AND B.LANGUAGE = T.SOURCE_LANG)
      WHERE ( T.HEADER_EXTENSION_ID,
              T.LANGUAGE)
          IN (SELECT
                  SUBT.HEADER_EXTENSION_ID,
                  SUBT.LANGUAGE
                FROM OKL_EXT_AP_HEADER_SOURCES_TL SUBB, OKL_EXT_AP_HEADER_SOURCES_TL SUBT
               WHERE SUBB.HEADER_EXTENSION_ID = SUBT.HEADER_EXTENSION_ID
                 AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
                 AND (SUBB.CONTRACT_STATUS <> SUBT.CONTRACT_STATUS
                      OR SUBB.INV_AGRMNT_STATUS <> SUBT.INV_AGRMNT_STATUS
                      OR SUBB.TRANSACTION_TYPE_NAME <> SUBT.TRANSACTION_TYPE_NAME
                      OR (SUBB.CONTRACT_STATUS IS NULL AND SUBT.CONTRACT_STATUS IS NOT NULL)
                      OR (SUBB.INV_AGRMNT_STATUS IS NULL AND SUBT.INV_AGRMNT_STATUS IS NOT NULL)
                      OR (SUBB.TRANSACTION_TYPE_NAME IS NULL AND SUBT.TRANSACTION_TYPE_NAME IS NOT NULL)
              ));

Line: 137


    INSERT INTO OKL_EXT_AP_HEADER_SOURCES_TL (
        HEADER_EXTENSION_ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        CONTRACT_STATUS,
        INV_AGRMNT_STATUS,
        TRANSACTION_TYPE_NAME,
        CREATED_BY,
        CREATION_DATE,
        LAST_UPDATED_BY,
        LAST_UPDATE_DATE,
        LAST_UPDATE_LOGIN)
      SELECT
            B.HEADER_EXTENSION_ID,
            L.LANGUAGE_CODE,
            B.SOURCE_LANG,
            B.SFWT_FLAG,
            B.CONTRACT_STATUS,
            B.INV_AGRMNT_STATUS,
            B.TRANSACTION_TYPE_NAME,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN
        FROM OKL_EXT_AP_HEADER_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_HEADER_SOURCES_TL T
                     WHERE T.HEADER_EXTENSION_ID = B.HEADER_EXTENSION_ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );

Line: 182


    SELECT
            HEADER_EXTENSION_ID,
            SOURCE_ID,
            SOURCE_TABLE,
            OBJECT_VERSION_NUMBER,
            KHR_ID,
            TRY_ID,
            TRANS_NUMBER,
            CONTRACT_NUMBER,
            CUSTOMER_NAME,
            CUST_ACCOUNT_NUMBER,
            PRODUCT_NAME,
            BOOK_CLASSIFICATION_CODE,
            TAX_OWNER_CODE,
            INT_CALC_METHOD_CODE,
            REV_REC_METHOD_CODE,
            SCS_CODE,
            CONVERTED_NUMBER,
            CONTRACT_EFFECTIVE_FROM,
            CONTRACT_CURRENCY_CODE,
            SALES_REP_NAME,
            PO_ORDER_NUMBER,
            VENDOR_PROGRAM_NUMBER,
            ASSIGNABLE_FLAG,
            CONVERTED_ACCOUNT_FLAG,
            ACCRUAL_OVERRIDE_FLAG,
            KHR_ATTRIBUTE_CATEGORY,
            KHR_ATTRIBUTE1,
            KHR_ATTRIBUTE2,
            KHR_ATTRIBUTE3,
            KHR_ATTRIBUTE4,
            KHR_ATTRIBUTE5,
            KHR_ATTRIBUTE6,
            KHR_ATTRIBUTE7,
            KHR_ATTRIBUTE8,
            KHR_ATTRIBUTE9,
            KHR_ATTRIBUTE10,
            KHR_ATTRIBUTE11,
            KHR_ATTRIBUTE12,
            KHR_ATTRIBUTE13,
            KHR_ATTRIBUTE14,
            KHR_ATTRIBUTE15,
            CUST_ATTRIBUTE_CATEGORY,
            CUST_ATTRIBUTE1,
            CUST_ATTRIBUTE2,
            CUST_ATTRIBUTE3,
            CUST_ATTRIBUTE4,
            CUST_ATTRIBUTE5,
            CUST_ATTRIBUTE6,
            CUST_ATTRIBUTE7,
            CUST_ATTRIBUTE8,
            CUST_ATTRIBUTE9,
            CUST_ATTRIBUTE10,
            CUST_ATTRIBUTE11,
            CUST_ATTRIBUTE12,
            CUST_ATTRIBUTE13,
            CUST_ATTRIBUTE14,
            CUST_ATTRIBUTE15,
            RENT_IA_CONTRACT_NUMBER,
            RENT_IA_PRODUCT_NAME,
            RENT_IA_ACCOUNTING_CODE,
            RES_IA_CONTRACT_NUMBER,
            RES_IA_PRODUCT_NAME,
            RES_IA_ACCOUNTING_CODE,
            INV_AGRMNT_NUMBER,
            INV_AGRMNT_EFFECTIVE_FROM,
            INV_AGRMNT_PRODUCT_NAME,
            INV_AGRMNT_CURRENCY_CODE,
            INV_AGRMNT_SYND_CODE,
            INV_AGRMNT_POOL_NUMBER,
            CONTRACT_STATUS_CODE,
            INV_AGRMNT_STATUS_CODE,
            TRX_TYPE_CLASS_CODE,
            LANGUAGE,
            CONTRACT_STATUS,
            INV_AGRMNT_STATUS,
            TRANSACTION_TYPE_NAME,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
-- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
            PARTY_ID,
	    CUST_ACCOUNT_ID
      FROM Okl_Ext_Ap_Header_Sources_V
     WHERE okl_ext_ap_header_sources_v.header_extension_id = p_header_extension_id;

Line: 354


              l_pxhv_rec.last_updated_by,
              l_pxhv_rec.last_update_date,
              l_pxhv_rec.last_update_login,
-- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
	      l_pxhv_rec.party_id,
	      l_pxhv_rec.cust_account_id;

Line: 402


    SELECT
            HEADER_EXTENSION_ID,
            SOURCE_ID,
            SOURCE_TABLE,
            OBJECT_VERSION_NUMBER,
            KHR_ID,
            TRY_ID,
            TRANS_NUMBER,
            CONTRACT_NUMBER,
            CUSTOMER_NAME,
            CUST_ACCOUNT_NUMBER,
            PRODUCT_NAME,
            BOOK_CLASSIFICATION_CODE,
            TAX_OWNER_CODE,
            INT_CALC_METHOD_CODE,
            REV_REC_METHOD_CODE,
            SCS_CODE,
            CONVERTED_NUMBER,
            CONTRACT_EFFECTIVE_FROM,
            CONTRACT_CURRENCY_CODE,
            SALES_REP_NAME,
            PO_ORDER_NUMBER,
            VENDOR_PROGRAM_NUMBER,
            ASSIGNABLE_FLAG,
            CONVERTED_ACCOUNT_FLAG,
            ACCRUAL_OVERRIDE_FLAG,
            KHR_ATTRIBUTE_CATEGORY,
            KHR_ATTRIBUTE1,
            KHR_ATTRIBUTE2,
            KHR_ATTRIBUTE3,
            KHR_ATTRIBUTE4,
            KHR_ATTRIBUTE5,
            KHR_ATTRIBUTE6,
            KHR_ATTRIBUTE7,
            KHR_ATTRIBUTE8,
            KHR_ATTRIBUTE9,
            KHR_ATTRIBUTE10,
            KHR_ATTRIBUTE11,
            KHR_ATTRIBUTE12,
            KHR_ATTRIBUTE13,
            KHR_ATTRIBUTE14,
            KHR_ATTRIBUTE15,
            CUST_ATTRIBUTE_CATEGORY,
            CUST_ATTRIBUTE1,
            CUST_ATTRIBUTE2,
            CUST_ATTRIBUTE3,
            CUST_ATTRIBUTE4,
            CUST_ATTRIBUTE5,
            CUST_ATTRIBUTE6,
            CUST_ATTRIBUTE7,
            CUST_ATTRIBUTE8,
            CUST_ATTRIBUTE9,
            CUST_ATTRIBUTE10,
            CUST_ATTRIBUTE11,
            CUST_ATTRIBUTE12,
            CUST_ATTRIBUTE13,
            CUST_ATTRIBUTE14,
            CUST_ATTRIBUTE15,
            RENT_IA_CONTRACT_NUMBER,
            RENT_IA_PRODUCT_NAME,
            RENT_IA_ACCOUNTING_CODE,
            RES_IA_CONTRACT_NUMBER,
            RES_IA_PRODUCT_NAME,
            RES_IA_ACCOUNTING_CODE,
            INV_AGRMNT_NUMBER,
            INV_AGRMNT_EFFECTIVE_FROM,
            INV_AGRMNT_PRODUCT_NAME,
            INV_AGRMNT_CURRENCY_CODE,
            INV_AGRMNT_SYND_CODE,
            INV_AGRMNT_POOL_NUMBER,
            CONTRACT_STATUS_CODE,
            INV_AGRMNT_STATUS_CODE,
            TRX_TYPE_CLASS_CODE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
-- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
            PARTY_ID,
	    CUST_ACCOUNT_ID
-- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables end
      FROM Okl_Ext_Ap_Header_Sources_B
     WHERE okl_ext_ap_header_sources_b.header_extension_id = p_header_extension_id;

Line: 567


              l_pxh_rec.last_updated_by,
              l_pxh_rec.last_update_date,
              l_pxh_rec.last_update_login,
-- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
              l_pxh_rec.party_id,
	      l_pxh_rec.cust_account_id
-- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables end
;

Line: 617


    SELECT
            HEADER_EXTENSION_ID,
            LANGUAGE,
            SOURCE_LANG,
            SFWT_FLAG,
            CONTRACT_STATUS,
            INV_AGRMNT_STATUS,
            TRANSACTION_TYPE_NAME,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Ext_Ap_Header_Sources_Tl
     WHERE okl_ext_ap_header_sources_tl.header_extension_id = p_header_extension_id
       AND okl_ext_ap_header_sources_tl.language = p_language;

Line: 650


              l_pxhl_rec.last_updated_by,
              l_pxhl_rec.last_update_date,
              l_pxhl_rec.last_update_login;

Line: 929


    IF (l_pxhv_rec.last_updated_by = OKL_API.G_MISS_NUM ) THEN
      l_pxhv_rec.last_updated_by := NULL;

Line: 932


    IF (l_pxhv_rec.last_update_date = OKL_API.G_MISS_DATE ) THEN
      l_pxhv_rec.last_update_date := NULL;

Line: 935


    IF (l_pxhv_rec.last_update_login = OKL_API.G_MISS_NUM ) THEN
      l_pxhv_rec.last_update_login := NULL;

Line: 1134


    SELECT '1'
    FROM hz_parties
    WHERE  party_id =  p_party_id;

Line: 1177


    SELECT '1'
    FROM hz_cust_accounts
    WHERE  cust_account_id = p_cust_account_id;

Line: 1429


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1430


    p_to.last_update_date := p_from.last_update_date;

Line: 1431


    p_to.last_update_login := p_from.last_update_login;

Line: 1516


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1517


    p_to.last_update_date := p_from.last_update_date;

Line: 1518


    p_to.last_update_login := p_from.last_update_login;

Line: 1536


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1537


    p_to.last_update_date := p_from.last_update_date;

Line: 1538


    p_to.last_update_login := p_from.last_update_login;

Line: 1552


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1553


    p_to.last_update_date := p_from.last_update_date;

Line: 1554


    p_to.last_update_login := p_from.last_update_login;

Line: 1800


  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_pxh_rec                      IN pxh_rec_type,
    x_pxh_rec                      OUT NOCOPY pxh_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1809


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

Line: 1845


    INSERT INTO OKL_EXT_AP_HEADER_SOURCES_B(
      header_extension_id,
      source_id,
      source_table,
      object_version_number,
      khr_id,
      try_id,
      trans_number,
      contract_number,
      customer_name,
      cust_account_number,
      product_name,
      book_classification_code,
      tax_owner_code,
      int_calc_method_code,
      rev_rec_method_code,
      scs_code,
      converted_number,
      contract_effective_from,
      contract_currency_code,
      sales_rep_name,
      po_order_number,
      vendor_program_number,
      assignable_flag,
      converted_account_flag,
      accrual_override_flag,
      khr_attribute_category,
      khr_attribute1,
      khr_attribute2,
      khr_attribute3,
      khr_attribute4,
      khr_attribute5,
      khr_attribute6,
      khr_attribute7,
      khr_attribute8,
      khr_attribute9,
      khr_attribute10,
      khr_attribute11,
      khr_attribute12,
      khr_attribute13,
      khr_attribute14,
      khr_attribute15,
      cust_attribute_category,
      cust_attribute1,
      cust_attribute2,
      cust_attribute3,
      cust_attribute4,
      cust_attribute5,
      cust_attribute6,
      cust_attribute7,
      cust_attribute8,
      cust_attribute9,
      cust_attribute10,
      cust_attribute11,
      cust_attribute12,
      cust_attribute13,
      cust_attribute14,
      cust_attribute15,
      rent_ia_contract_number,
      rent_ia_product_name,
      rent_ia_accounting_code,
      res_ia_contract_number,
      res_ia_product_name,
      res_ia_accounting_code,
      inv_agrmnt_number,
      inv_agrmnt_effective_from,
      inv_agrmnt_product_name,
      inv_agrmnt_currency_code,
      inv_agrmnt_synd_code,
      inv_agrmnt_pool_number,
      contract_status_code,
      inv_agrmnt_status_code,
      trx_type_class_code,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
-- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
      party_id,
      cust_account_id
-- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables end
      )
    VALUES (
      l_def_pxh_rec.header_extension_id,
      l_def_pxh_rec.source_id,
      l_def_pxh_rec.source_table,
      l_def_pxh_rec.object_version_number,
      l_def_pxh_rec.khr_id,
      l_def_pxh_rec.try_id,
      l_def_pxh_rec.trans_number,
      l_def_pxh_rec.contract_number,
      l_def_pxh_rec.customer_name,
      l_def_pxh_rec.cust_account_number,
      l_def_pxh_rec.product_name,
      l_def_pxh_rec.book_classification_code,
      l_def_pxh_rec.tax_owner_code,
      l_def_pxh_rec.int_calc_method_code,
      l_def_pxh_rec.rev_rec_method_code,
      l_def_pxh_rec.scs_code,
      l_def_pxh_rec.converted_number,
      l_def_pxh_rec.contract_effective_from,
      l_def_pxh_rec.contract_currency_code,
      l_def_pxh_rec.sales_rep_name,
      l_def_pxh_rec.po_order_number,
      l_def_pxh_rec.vendor_program_number,
      l_def_pxh_rec.assignable_flag,
      l_def_pxh_rec.converted_account_flag,
      l_def_pxh_rec.accrual_override_flag,
      l_def_pxh_rec.khr_attribute_category,
      l_def_pxh_rec.khr_attribute1,
      l_def_pxh_rec.khr_attribute2,
      l_def_pxh_rec.khr_attribute3,
      l_def_pxh_rec.khr_attribute4,
      l_def_pxh_rec.khr_attribute5,
      l_def_pxh_rec.khr_attribute6,
      l_def_pxh_rec.khr_attribute7,
      l_def_pxh_rec.khr_attribute8,
      l_def_pxh_rec.khr_attribute9,
      l_def_pxh_rec.khr_attribute10,
      l_def_pxh_rec.khr_attribute11,
      l_def_pxh_rec.khr_attribute12,
      l_def_pxh_rec.khr_attribute13,
      l_def_pxh_rec.khr_attribute14,
      l_def_pxh_rec.khr_attribute15,
      l_def_pxh_rec.cust_attribute_category,
      l_def_pxh_rec.cust_attribute1,
      l_def_pxh_rec.cust_attribute2,
      l_def_pxh_rec.cust_attribute3,
      l_def_pxh_rec.cust_attribute4,
      l_def_pxh_rec.cust_attribute5,
      l_def_pxh_rec.cust_attribute6,
      l_def_pxh_rec.cust_attribute7,
      l_def_pxh_rec.cust_attribute8,
      l_def_pxh_rec.cust_attribute9,
      l_def_pxh_rec.cust_attribute10,
      l_def_pxh_rec.cust_attribute11,
      l_def_pxh_rec.cust_attribute12,
      l_def_pxh_rec.cust_attribute13,
      l_def_pxh_rec.cust_attribute14,
      l_def_pxh_rec.cust_attribute15,
      l_def_pxh_rec.rent_ia_contract_number,
      l_def_pxh_rec.rent_ia_product_name,
      l_def_pxh_rec.rent_ia_accounting_code,
      l_def_pxh_rec.res_ia_contract_number,
      l_def_pxh_rec.res_ia_product_name,
      l_def_pxh_rec.res_ia_accounting_code,
      l_def_pxh_rec.inv_agrmnt_number,
      l_def_pxh_rec.inv_agrmnt_effective_from,
      l_def_pxh_rec.inv_agrmnt_product_name,
      l_def_pxh_rec.inv_agrmnt_currency_code,
      l_def_pxh_rec.inv_agrmnt_synd_code,
      l_def_pxh_rec.inv_agrmnt_pool_number,
      l_def_pxh_rec.contract_status_code,
      l_def_pxh_rec.inv_agrmnt_status_code,
      l_def_pxh_rec.trx_type_class_code,
      l_def_pxh_rec.created_by,
      l_def_pxh_rec.creation_date,
      l_def_pxh_rec.last_updated_by,
      l_def_pxh_rec.last_update_date,
      l_def_pxh_rec.last_update_login,
      l_def_pxh_rec.party_id,
      l_def_pxh_rec.cust_account_id
      );

Line: 2044


  END insert_row;

Line: 2048


  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_pxhl_rec                     IN pxhl_rec_type,
    x_pxhl_rec                     OUT NOCOPY pxhl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2057


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

Line: 2062


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

Line: 2099


      INSERT INTO OKL_EXT_AP_HEADER_SOURCES_TL(
        header_extension_id,
        language,
        source_lang,
        sfwt_flag,
        contract_status,
        inv_agrmnt_status,
        transaction_type_name,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_pxhl_rec.header_extension_id,
        l_pxhl_rec.language,
        l_pxhl_rec.source_lang,
        l_pxhl_rec.sfwt_flag,
        l_pxhl_rec.contract_status,
        l_pxhl_rec.inv_agrmnt_status,
        l_pxhl_rec.transaction_type_name,
        l_pxhl_rec.created_by,
        l_pxhl_rec.creation_date,
        l_pxhl_rec.last_updated_by,
        l_pxhl_rec.last_update_date,
        l_pxhl_rec.last_update_login);

Line: 2160


  END insert_row;

Line: 2164


  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_pxhv_rec                     IN pxhv_rec_type,
    x_pxhv_rec                     OUT NOCOPY pxhv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2174


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

Line: 2192


      l_pxhv_rec.LAST_UPDATE_DATE := l_pxhv_rec.CREATION_DATE;

Line: 2193


      l_pxhv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2194


      l_pxhv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2259


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pxh_rec,
      lx_pxh_rec
    );

Line: 2273


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pxhl_rec,
      lx_pxhl_rec
    );

Line: 2322


  END insert_row;

Line: 2326


  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_pxhv_tbl                     IN pxhv_tbl_type,
    x_pxhv_tbl                     OUT NOCOPY pxhv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2337


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

Line: 2351


          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_pxhv_rec                     => p_pxhv_tbl(i),
            x_pxhv_rec                     => x_pxhv_tbl(i));

Line: 2419


  END insert_row;

Line: 2424


  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_pxhv_tbl                     IN pxhv_tbl_type,
    x_pxhv_tbl                     OUT NOCOPY pxhv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2434


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

Line: 2441


      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_pxhv_tbl                     => p_pxhv_tbl,
        x_pxhv_tbl                     => x_pxhv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2483


  END insert_row;

Line: 2501


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_EXT_AP_HEADER_SOURCES_B
     WHERE HEADER_EXTENSION_ID = p_pxh_rec.header_extension_id
       AND OBJECT_VERSION_NUMBER = p_pxh_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2508


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_EXT_AP_HEADER_SOURCES_B
     WHERE HEADER_EXTENSION_ID = p_pxh_rec.header_extension_id;

Line: 2549


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2558


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2608


    SELECT *
      FROM OKL_EXT_AP_HEADER_SOURCES_TL
     WHERE HEADER_EXTENSION_ID = p_pxhl_rec.header_extension_id
    FOR UPDATE NOWAIT;

Line: 2644


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2938


  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_pxh_rec                      IN pxh_rec_type,
    x_pxh_rec                      OUT NOCOPY pxh_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2947


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

Line: 3189


        IF x_pxh_rec.last_updated_by IS NULL THEN
          x_pxh_rec.last_updated_by := l_pxh_rec.last_updated_by;

Line: 3192


        IF x_pxh_rec.last_update_date IS NULL THEN
          x_pxh_rec.last_update_date := l_pxh_rec.last_update_date;

Line: 3195


        IF x_pxh_rec.last_update_login IS NULL THEN
          x_pxh_rec.last_update_login := l_pxh_rec.last_update_login;

Line: 3248


    UPDATE OKL_EXT_AP_HEADER_SOURCES_B
    SET SOURCE_ID = l_def_pxh_rec.source_id,
        SOURCE_TABLE = l_def_pxh_rec.source_table,
        OBJECT_VERSION_NUMBER = l_def_pxh_rec.object_version_number,
        KHR_ID = l_def_pxh_rec.khr_id,
        TRY_ID = l_def_pxh_rec.try_id,
        TRANS_NUMBER = l_def_pxh_rec.trans_number,
        CONTRACT_NUMBER = l_def_pxh_rec.contract_number,
        CUSTOMER_NAME = l_def_pxh_rec.customer_name,
        CUST_ACCOUNT_NUMBER = l_def_pxh_rec.cust_account_number,
        PRODUCT_NAME = l_def_pxh_rec.product_name,
        BOOK_CLASSIFICATION_CODE = l_def_pxh_rec.book_classification_code,
        TAX_OWNER_CODE = l_def_pxh_rec.tax_owner_code,
        INT_CALC_METHOD_CODE = l_def_pxh_rec.int_calc_method_code,
        REV_REC_METHOD_CODE = l_def_pxh_rec.rev_rec_method_code,
        SCS_CODE = l_def_pxh_rec.scs_code,
        CONVERTED_NUMBER = l_def_pxh_rec.converted_number,
        CONTRACT_EFFECTIVE_FROM = l_def_pxh_rec.contract_effective_from,
        CONTRACT_CURRENCY_CODE = l_def_pxh_rec.contract_currency_code,
        SALES_REP_NAME = l_def_pxh_rec.sales_rep_name,
        PO_ORDER_NUMBER = l_def_pxh_rec.po_order_number,
        VENDOR_PROGRAM_NUMBER = l_def_pxh_rec.vendor_program_number,
        ASSIGNABLE_FLAG = l_def_pxh_rec.assignable_flag,
        CONVERTED_ACCOUNT_FLAG = l_def_pxh_rec.converted_account_flag,
        ACCRUAL_OVERRIDE_FLAG = l_def_pxh_rec.accrual_override_flag,
        KHR_ATTRIBUTE_CATEGORY = l_def_pxh_rec.khr_attribute_category,
        KHR_ATTRIBUTE1 = l_def_pxh_rec.khr_attribute1,
        KHR_ATTRIBUTE2 = l_def_pxh_rec.khr_attribute2,
        KHR_ATTRIBUTE3 = l_def_pxh_rec.khr_attribute3,
        KHR_ATTRIBUTE4 = l_def_pxh_rec.khr_attribute4,
        KHR_ATTRIBUTE5 = l_def_pxh_rec.khr_attribute5,
        KHR_ATTRIBUTE6 = l_def_pxh_rec.khr_attribute6,
        KHR_ATTRIBUTE7 = l_def_pxh_rec.khr_attribute7,
        KHR_ATTRIBUTE8 = l_def_pxh_rec.khr_attribute8,
        KHR_ATTRIBUTE9 = l_def_pxh_rec.khr_attribute9,
        KHR_ATTRIBUTE10 = l_def_pxh_rec.khr_attribute10,
        KHR_ATTRIBUTE11 = l_def_pxh_rec.khr_attribute11,
        KHR_ATTRIBUTE12 = l_def_pxh_rec.khr_attribute12,
        KHR_ATTRIBUTE13 = l_def_pxh_rec.khr_attribute13,
        KHR_ATTRIBUTE14 = l_def_pxh_rec.khr_attribute14,
        KHR_ATTRIBUTE15 = l_def_pxh_rec.khr_attribute15,
        CUST_ATTRIBUTE_CATEGORY = l_def_pxh_rec.cust_attribute_category,
        CUST_ATTRIBUTE1 = l_def_pxh_rec.cust_attribute1,
        CUST_ATTRIBUTE2 = l_def_pxh_rec.cust_attribute2,
        CUST_ATTRIBUTE3 = l_def_pxh_rec.cust_attribute3,
        CUST_ATTRIBUTE4 = l_def_pxh_rec.cust_attribute4,
        CUST_ATTRIBUTE5 = l_def_pxh_rec.cust_attribute5,
        CUST_ATTRIBUTE6 = l_def_pxh_rec.cust_attribute6,
        CUST_ATTRIBUTE7 = l_def_pxh_rec.cust_attribute7,
        CUST_ATTRIBUTE8 = l_def_pxh_rec.cust_attribute8,
        CUST_ATTRIBUTE9 = l_def_pxh_rec.cust_attribute9,
        CUST_ATTRIBUTE10 = l_def_pxh_rec.cust_attribute10,
        CUST_ATTRIBUTE11 = l_def_pxh_rec.cust_attribute11,
        CUST_ATTRIBUTE12 = l_def_pxh_rec.cust_attribute12,
        CUST_ATTRIBUTE13 = l_def_pxh_rec.cust_attribute13,
        CUST_ATTRIBUTE14 = l_def_pxh_rec.cust_attribute14,
        CUST_ATTRIBUTE15 = l_def_pxh_rec.cust_attribute15,
        RENT_IA_CONTRACT_NUMBER = l_def_pxh_rec.rent_ia_contract_number,
        RENT_IA_PRODUCT_NAME = l_def_pxh_rec.rent_ia_product_name,
        RENT_IA_ACCOUNTING_CODE = l_def_pxh_rec.rent_ia_accounting_code,
        RES_IA_CONTRACT_NUMBER = l_def_pxh_rec.res_ia_contract_number,
        RES_IA_PRODUCT_NAME = l_def_pxh_rec.res_ia_product_name,
        RES_IA_ACCOUNTING_CODE = l_def_pxh_rec.res_ia_accounting_code,
        INV_AGRMNT_NUMBER = l_def_pxh_rec.inv_agrmnt_number,
        INV_AGRMNT_EFFECTIVE_FROM = l_def_pxh_rec.inv_agrmnt_effective_from,
        INV_AGRMNT_PRODUCT_NAME = l_def_pxh_rec.inv_agrmnt_product_name,
        INV_AGRMNT_CURRENCY_CODE = l_def_pxh_rec.inv_agrmnt_currency_code,
        INV_AGRMNT_SYND_CODE = l_def_pxh_rec.inv_agrmnt_synd_code,
        INV_AGRMNT_POOL_NUMBER = l_def_pxh_rec.inv_agrmnt_pool_number,
        CONTRACT_STATUS_CODE = l_def_pxh_rec.contract_status_code,
        INV_AGRMNT_STATUS_CODE = l_def_pxh_rec.inv_agrmnt_status_code,
        TRX_TYPE_CLASS_CODE = l_def_pxh_rec.trx_type_class_code,
        CREATED_BY = l_def_pxh_rec.created_by,
        CREATION_DATE = l_def_pxh_rec.creation_date,
        LAST_UPDATED_BY = l_def_pxh_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_pxh_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_pxh_rec.last_update_login,
-- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
        PARTY_ID = l_def_pxh_rec.party_id,
        CUST_ACCOUNT_ID = l_def_pxh_rec.cust_account_id
-- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables end
    WHERE HEADER_EXTENSION_ID = l_def_pxh_rec.header_extension_id;

Line: 3365


  END update_row;

Line: 3369


  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_pxhl_rec                     IN pxhl_rec_type,
    x_pxhl_rec                     OUT NOCOPY pxhl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3378


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

Line: 3425


        IF x_pxhl_rec.last_updated_by IS NULL THEN
          x_pxhl_rec.last_updated_by := l_pxhl_rec.last_updated_by;

Line: 3428


        IF x_pxhl_rec.last_update_date IS NULL THEN
          x_pxhl_rec.last_update_date := l_pxhl_rec.last_update_date;

Line: 3431


        IF x_pxhl_rec.last_update_login IS NULL THEN
          x_pxhl_rec.last_update_login := l_pxhl_rec.last_update_login;

Line: 3477


    UPDATE OKL_EXT_AP_HEADER_SOURCES_TL
    SET CONTRACT_STATUS = l_def_pxhl_rec.contract_status,
        INV_AGRMNT_STATUS = l_def_pxhl_rec.inv_agrmnt_status,
        TRANSACTION_TYPE_NAME = l_def_pxhl_rec.transaction_type_name,
        CREATED_BY = l_def_pxhl_rec.created_by,
        CREATION_DATE = l_def_pxhl_rec.creation_date,
        LAST_UPDATED_BY = l_def_pxhl_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_pxhl_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_pxhl_rec.last_update_login
    WHERE HEADER_EXTENSION_ID = l_def_pxhl_rec.header_extension_id
      AND SOURCE_LANG = USERENV('LANG');

Line: 3489


    UPDATE OKL_EXT_AP_HEADER_SOURCES_TL
    SET SFWT_FLAG = 'Y'
    WHERE HEADER_EXTENSION_ID = l_def_pxhl_rec.header_extension_id
      AND SOURCE_LANG <> USERENV('LANG');

Line: 3528


  END update_row;

Line: 3532


  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_pxhv_rec                     IN pxhv_rec_type,
    x_pxhv_rec                     OUT NOCOPY pxhv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3542


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

Line: 3559


      l_pxhv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3560


      l_pxhv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3561


      l_pxhv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3811


        IF x_pxhv_rec.last_updated_by IS NULL THEN
          x_pxhv_rec.last_updated_by := l_db_pxhv_rec.last_updated_by;

Line: 3814


        IF x_pxhv_rec.last_update_date IS NULL THEN
          x_pxhv_rec.last_update_date := l_db_pxhv_rec.last_update_date;

Line: 3817


        IF x_pxhv_rec.last_update_login IS NULL THEN
          x_pxhv_rec.last_update_login := l_db_pxhv_rec.last_update_login;

Line: 3911


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pxh_rec,
      lx_pxh_rec
    );

Line: 3925


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pxhl_rec,
      lx_pxhl_rec
    );

Line: 3973


  END update_row;

Line: 3977


  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_pxhv_tbl                     IN pxhv_tbl_type,
    x_pxhv_tbl                     OUT NOCOPY pxhv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3988


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

Line: 4002


          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_pxhv_rec                     => p_pxhv_tbl(i),
            x_pxhv_rec                     => x_pxhv_tbl(i));

Line: 4070


  END update_row;

Line: 4075


  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_pxhv_tbl                     IN pxhv_tbl_type,
    x_pxhv_tbl                     OUT NOCOPY pxhv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4085


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

Line: 4092


      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_pxhv_tbl                     => p_pxhv_tbl,
        x_pxhv_tbl                     => x_pxhv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 4134


  END update_row;

Line: 4142


  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_pxh_rec                      IN pxh_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4150


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

Line: 4165


    DELETE FROM OKL_EXT_AP_HEADER_SOURCES_B
     WHERE HEADER_EXTENSION_ID = p_pxh_rec.header_extension_id;

Line: 4201


  END delete_row;

Line: 4205


  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_pxhl_rec                     IN pxhl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4213


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

Line: 4228


    DELETE FROM OKL_EXT_AP_HEADER_SOURCES_TL
     WHERE HEADER_EXTENSION_ID = p_pxhl_rec.header_extension_id;

Line: 4264


  END delete_row;

Line: 4268


  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_pxhv_rec                     IN pxhv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4277


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

Line: 4303


    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pxhl_rec
    );

Line: 4315


    delete_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pxh_rec
    );

Line: 4360


  END delete_row;

Line: 4364


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4374


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

Line: 4388


          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_pxhv_rec                     => p_pxhv_tbl(i));

Line: 4455


  END delete_row;

Line: 4460


  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_pxhv_tbl                     IN pxhv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4469


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

Line: 4476


      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_pxhv_tbl                     => p_pxhv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 4517


  END delete_row;

Line: 4527


  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_pxh_rec                      IN pxh_rec_type,
    p_pxhl_tbl                     IN pxhl_tbl_type,
    x_pxh_rec                      OUT NOCOPY pxh_rec_type,
    x_pxhl_tbl                     OUT NOCOPY pxhl_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4539


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

Line: 4560


      l_pxh_rec.LAST_UPDATE_DATE := l_pxh_rec.CREATION_DATE;

Line: 4561


      l_pxh_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 4562


      l_pxh_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 4608


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_pxh_rec,
      lx_pxh_rec
    );

Line: 4629


      l_pxhl_tbl(idx).LAST_UPDATE_DATE := l_pxhl_tbl(idx).CREATION_DATE;

Line: 4630


      l_pxhl_tbl(idx).LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 4631


      l_pxhl_tbl(idx).LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 4632


      insert_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_pxhl_tbl(idx),
        lx_pxhl_tbl(idx)
      );

Line: 4682


  END insert_row;