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_FXH_PVT SQL Statements

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

Line: 66


    CURSOR c_pk_csr IS SELECT OKL_EXT_FA_HEADER_SOURCES_S.NEXTVAL FROM DUAL;

Line: 105


    DELETE FROM OKL_EXT_FA_HEADER_SOURCES_TL T
     WHERE NOT EXISTS (
        SELECT NULL
          FROM OKL_EXT_FA_HEADER_SOURCES_B B
         WHERE B.HEADER_EXTENSION_ID =T.HEADER_EXTENSION_ID
        );

Line: 112


    UPDATE OKL_EXT_FA_HEADER_SOURCES_TL T SET(
        CONTRACT_STATUS,
        TRANSACTION_TYPE_NAME) = (SELECT
                                  B.CONTRACT_STATUS,
                                  B.TRANSACTION_TYPE_NAME
                                FROM OKL_EXT_FA_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_FA_HEADER_SOURCES_TL SUBB, OKL_EXT_FA_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.TRANSACTION_TYPE_NAME <> SUBT.TRANSACTION_TYPE_NAME
                      OR (SUBB.CONTRACT_STATUS IS NULL AND SUBT.CONTRACT_STATUS IS NOT NULL)
                      OR (SUBB.TRANSACTION_TYPE_NAME IS NULL AND SUBT.TRANSACTION_TYPE_NAME IS NOT NULL)
              ));

Line: 134


    INSERT INTO OKL_EXT_FA_HEADER_SOURCES_TL (
        HEADER_EXTENSION_ID,
        LANGUAGE,
        SOURCE_LANG,
        SFWT_FLAG,
        CONTRACT_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.TRANSACTION_TYPE_NAME,
            B.CREATED_BY,
            B.CREATION_DATE,
            B.LAST_UPDATED_BY,
            B.LAST_UPDATE_DATE,
            B.LAST_UPDATE_LOGIN
        FROM OKL_EXT_FA_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_FA_HEADER_SOURCES_TL T
                     WHERE T.HEADER_EXTENSION_ID = B.HEADER_EXTENSION_ID
                       AND T.LANGUAGE = L.LANGUAGE_CODE
                    );

Line: 177


    SELECT
            HEADER_EXTENSION_ID,
            SOURCE_ID,
            SOURCE_TABLE,
            OBJECT_VERSION_NUMBER,
            TRANS_NUMBER,
            KHR_ID,
            TRY_ID,
            CONTRACT_NUMBER,
            CUSTOMER_NAME,
            CUSTOMER_ACCOUNT_NUMBER,
            BOOK_CLASSIFICATION_CODE,
            PRODUCT_NAME,
            TAX_OWNER_CODE,
            REPRESENTATION_CODE,
            REPRESENTATION_NAME,
            RENT_IA_CONTRACT_NUMBER,
            RES_IA_CONTRACT_NUMBER,
            CONVERTED_NUMBER,
            CONTRACT_EFFECTIVE_FROM,
            CONTRACT_CURRENCY_CODE,
            SALES_REP_NAME,
            RENT_IA_PRODUCT_NAME,
            RES_IA_PRODUCT_NAME,
            PO_ORDER_NUMBER,
            VENDOR_PROGRAM_NUMBER,
            RENT_IA_ACCOUNTING_CODE,
            RES_IA_ACCOUNTING_CODE,
            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,
            REV_REC_METHOD_CODE,
            INT_CALC_METHOD_CODE,
            LANGUAGE,
            CONTRACT_STATUS,
            TRANSACTION_TYPE_NAME,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            CONTRACT_STATUS_CODE,
            TRX_TYPE_CLASS_CODE,
            TERM_QUOTE_ACCEPT_DATE,
            TERM_QUOTE_NUM,
            TERM_QUOTE_TYPE_CODE,
            REPOSSESS_FLAG,
      -- 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_Fa_Header_Sources_V
     WHERE okl_ext_fa_header_sources_v.header_extension_id = p_header_extension_id;

Line: 338


              l_fxhv_rec.last_updated_by,
              l_fxhv_rec.last_update_date,
              l_fxhv_rec.last_update_login,
              l_fxhv_rec.contract_status_code,
              l_fxhv_rec.trx_type_class_code,
              l_fxhv_rec.term_quote_accept_date,
              l_fxhv_rec.term_quote_num,
              l_fxhv_rec.term_quote_type_code,
              l_fxhv_rec.repossess_flag,
	      -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
              l_fxhv_rec.party_id,
              l_fxhv_rec.cust_account_id;

Line: 393


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

Line: 424


              l_fxhl_rec.last_updated_by,
              l_fxhl_rec.last_update_date,
              l_fxhl_rec.last_update_login;

Line: 469


    SELECT
            HEADER_EXTENSION_ID,
            SOURCE_ID,
            SOURCE_TABLE,
            OBJECT_VERSION_NUMBER,
            TRANS_NUMBER,
            KHR_ID,
            TRY_ID,
            CONTRACT_NUMBER,
            CUSTOMER_NAME,
            CUSTOMER_ACCOUNT_NUMBER,
            BOOK_CLASSIFICATION_CODE,
            PRODUCT_NAME,
            TAX_OWNER_CODE,
            REPRESENTATION_CODE,
            REPRESENTATION_NAME,
            RENT_IA_CONTRACT_NUMBER,
            RES_IA_CONTRACT_NUMBER,
            CONVERTED_NUMBER,
            CONTRACT_EFFECTIVE_FROM,
            CONTRACT_CURRENCY_CODE,
            SALES_REP_NAME,
            RENT_IA_PRODUCT_NAME,
            RES_IA_PRODUCT_NAME,
            PO_ORDER_NUMBER,
            VENDOR_PROGRAM_NUMBER,
            RENT_IA_ACCOUNTING_CODE,
            RES_IA_ACCOUNTING_CODE,
            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,
            REV_REC_METHOD_CODE,
            INT_CALC_METHOD_CODE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN,
            CONTRACT_STATUS_CODE,
            TRX_TYPE_CLASS_CODE,
            TERM_QUOTE_ACCEPT_DATE,
            TERM_QUOTE_NUM,
            TERM_QUOTE_TYPE_CODE,
            REPOSSESS_FLAG,
            -- 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_Fa_Header_Sources_B
     WHERE okl_ext_fa_header_sources_b.header_extension_id = p_header_extension_id;

Line: 624


              l_fxh_rec.last_updated_by,
              l_fxh_rec.last_update_date,
              l_fxh_rec.last_update_login,
              l_fxh_rec.contract_status_code,
              l_fxh_rec.trx_type_class_code,
              l_fxh_rec.term_quote_accept_date,
              l_fxh_rec.term_quote_num,
              l_fxh_rec.term_quote_type_code,
              l_fxh_rec.repossess_flag,
	      -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
	      l_fxh_rec.party_id,
	      l_fxh_rec.cust_account_id;

Line: 885


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

Line: 888


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

Line: 891


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

Line: 1080


  SELECT '1'
  FROM hz_parties
  WHERE  party_id =  p_party_id   ;

Line: 1125


  SELECT '1'
  FROM hz_cust_accounts
  WHERE  cust_account_id=  p_cust_account_id   ;

Line: 1299


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1300


    p_to.last_update_date := p_from.last_update_date;

Line: 1301


    p_to.last_update_login := p_from.last_update_login;

Line: 1314


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1315


    p_to.last_update_date := p_from.last_update_date;

Line: 1316


    p_to.last_update_login := p_from.last_update_login;

Line: 1389


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1390


    p_to.last_update_date := p_from.last_update_date;

Line: 1391


    p_to.last_update_login := p_from.last_update_login;

Line: 1472


    p_to.last_updated_by := p_from.last_updated_by;

Line: 1473


    p_to.last_update_date := p_from.last_update_date;

Line: 1474


    p_to.last_update_login := p_from.last_update_login;

Line: 1728


  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_fxh_rec                      IN fxh_rec_type,
    x_fxh_rec                      OUT NOCOPY fxh_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1737


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

Line: 1773


    INSERT INTO OKL_EXT_FA_HEADER_SOURCES_B(
      header_extension_id,
      source_id,
      source_table,
      object_version_number,
      trans_number,
      khr_id,
      try_id,
      contract_number,
      customer_name,
      customer_account_number,
      book_classification_code,
      product_name,
      tax_owner_code,
      representation_code,
      representation_name,
      rent_ia_contract_number,
      res_ia_contract_number,
      converted_number,
      contract_effective_from,
      contract_currency_code,
      sales_rep_name,
      rent_ia_product_name,
      res_ia_product_name,
      po_order_number,
      vendor_program_number,
      rent_ia_accounting_code,
      res_ia_accounting_code,
      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,
      rev_rec_method_code,
      int_calc_method_code,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login,
      contract_status_code,
      trx_type_class_code,
      term_quote_accept_date,
      term_quote_num,
      term_quote_type_code,
      repossess_flag,
      -- 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_fxh_rec.header_extension_id,
      l_def_fxh_rec.source_id,
      l_def_fxh_rec.source_table,
      l_def_fxh_rec.object_version_number,
      l_def_fxh_rec.trans_number,
      l_def_fxh_rec.khr_id,
      l_def_fxh_rec.try_id,
      l_def_fxh_rec.contract_number,
      l_def_fxh_rec.customer_name,
      l_def_fxh_rec.customer_account_number,
      l_def_fxh_rec.book_classification_code,
      l_def_fxh_rec.product_name,
      l_def_fxh_rec.tax_owner_code,
      l_def_fxh_rec.representation_code,
      l_def_fxh_rec.representation_name,
      l_def_fxh_rec.rent_ia_contract_number,
      l_def_fxh_rec.res_ia_contract_number,
      l_def_fxh_rec.converted_number,
      l_def_fxh_rec.contract_effective_from,
      l_def_fxh_rec.contract_currency_code,
      l_def_fxh_rec.sales_rep_name,
      l_def_fxh_rec.rent_ia_product_name,
      l_def_fxh_rec.res_ia_product_name,
      l_def_fxh_rec.po_order_number,
      l_def_fxh_rec.vendor_program_number,
      l_def_fxh_rec.rent_ia_accounting_code,
      l_def_fxh_rec.res_ia_accounting_code,
      l_def_fxh_rec.assignable_flag,
      l_def_fxh_rec.converted_account_flag,
      l_def_fxh_rec.accrual_override_flag,
      l_def_fxh_rec.khr_attribute_category,
      l_def_fxh_rec.khr_attribute1,
      l_def_fxh_rec.khr_attribute2,
      l_def_fxh_rec.khr_attribute3,
      l_def_fxh_rec.khr_attribute4,
      l_def_fxh_rec.khr_attribute5,
      l_def_fxh_rec.khr_attribute6,
      l_def_fxh_rec.khr_attribute7,
      l_def_fxh_rec.khr_attribute8,
      l_def_fxh_rec.khr_attribute9,
      l_def_fxh_rec.khr_attribute10,
      l_def_fxh_rec.khr_attribute11,
      l_def_fxh_rec.khr_attribute12,
      l_def_fxh_rec.khr_attribute13,
      l_def_fxh_rec.khr_attribute14,
      l_def_fxh_rec.khr_attribute15,
      l_def_fxh_rec.cust_attribute_category,
      l_def_fxh_rec.cust_attribute1,
      l_def_fxh_rec.cust_attribute2,
      l_def_fxh_rec.cust_attribute3,
      l_def_fxh_rec.cust_attribute4,
      l_def_fxh_rec.cust_attribute5,
      l_def_fxh_rec.cust_attribute6,
      l_def_fxh_rec.cust_attribute7,
      l_def_fxh_rec.cust_attribute8,
      l_def_fxh_rec.cust_attribute9,
      l_def_fxh_rec.cust_attribute10,
      l_def_fxh_rec.cust_attribute11,
      l_def_fxh_rec.cust_attribute12,
      l_def_fxh_rec.cust_attribute13,
      l_def_fxh_rec.cust_attribute14,
      l_def_fxh_rec.cust_attribute15,
      l_def_fxh_rec.rev_rec_method_code,
      l_def_fxh_rec.int_calc_method_code,
      l_def_fxh_rec.created_by,
      l_def_fxh_rec.creation_date,
      l_def_fxh_rec.last_updated_by,
      l_def_fxh_rec.last_update_date,
      l_def_fxh_rec.last_update_login,
      l_def_fxh_rec.contract_status_code,
      l_def_fxh_rec.trx_type_class_code,
      l_def_fxh_rec.term_quote_accept_date,
      l_def_fxh_rec.term_quote_num,
      l_def_fxh_rec.term_quote_type_code,
      l_def_fxh_rec.repossess_flag,
      -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables start
      l_def_fxh_rec.party_id,
      l_def_fxh_rec.cust_account_id
      -- added by zrehman Bug#6707320 for Party Merge impact on Accounting sources tables end
      );

Line: 1970


  END insert_row;

Line: 1974


  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_fxhl_rec                     IN fxhl_rec_type,
    x_fxhl_rec                     OUT NOCOPY fxhl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 1983


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

Line: 1988


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

Line: 2027


    INSERT INTO OKL_EXT_FA_HEADER_SOURCES_TL(
      header_extension_id,
      language,
      source_lang,
      sfwt_flag,
      contract_status,
      transaction_type_name,
      created_by,
      creation_date,
      last_updated_by,
      last_update_date,
      last_update_login)
    VALUES (
      l_fxhl_rec.header_extension_id,
      l_fxhl_rec.language,
      l_fxhl_rec.source_lang,
      l_fxhl_rec.sfwt_flag,
      l_fxhl_rec.contract_status,
      l_fxhl_rec.transaction_type_name,
      l_fxhl_rec.created_by,
      l_fxhl_rec.creation_date,
      l_fxhl_rec.last_updated_by,
      l_fxhl_rec.last_update_date,
      l_fxhl_rec.last_update_login);

Line: 2086


  END insert_row;

Line: 2090


  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_fxhv_rec                     IN fxhv_rec_type,
    x_fxhv_rec                     OUT NOCOPY fxhv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2100


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

Line: 2118


      l_fxhv_rec.LAST_UPDATE_DATE := l_fxhv_rec.CREATION_DATE;

Line: 2119


      l_fxhv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 2120


      l_fxhv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 2185


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_fxh_rec,
      lx_fxh_rec
    );

Line: 2199


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_fxhl_rec,
      lx_fxhl_rec
    );

Line: 2248


  END insert_row;

Line: 2252


  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_fxhv_tbl                     IN fxhv_tbl_type,
    x_fxhv_tbl                     OUT NOCOPY fxhv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2263


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

Line: 2277


          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_fxhv_rec                     => p_fxhv_tbl(i),
            x_fxhv_rec                     => x_fxhv_tbl(i));

Line: 2345


  END insert_row;

Line: 2350


  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_fxhv_tbl                     IN fxhv_tbl_type,
    x_fxhv_tbl                     OUT NOCOPY fxhv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2360


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

Line: 2367


      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_fxhv_tbl                     => p_fxhv_tbl,
        x_fxhv_tbl                     => x_fxhv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 2409


  END insert_row;

Line: 2427


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_EXT_FA_HEADER_SOURCES_B
     WHERE HEADER_EXTENSION_ID = p_fxh_rec.header_extension_id
       AND OBJECT_VERSION_NUMBER = p_fxh_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line: 2434


    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_EXT_FA_HEADER_SOURCES_B
     WHERE HEADER_EXTENSION_ID = p_fxh_rec.header_extension_id;

Line: 2475


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2484


      OKL_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

Line: 2534


    SELECT *
      FROM OKL_EXT_FA_HEADER_SOURCES_TL
     WHERE HEADER_EXTENSION_ID = p_fxhl_rec.header_extension_id
    FOR UPDATE NOWAIT;

Line: 2570


      OKL_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

Line: 2864


  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_fxh_rec                      IN fxh_rec_type,
    x_fxh_rec                      OUT NOCOPY fxh_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 2873


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

Line: 3091


        IF x_fxh_rec.last_updated_by IS NULL THEN
          x_fxh_rec.last_updated_by := l_fxh_rec.last_updated_by;

Line: 3094


        IF x_fxh_rec.last_update_date IS NULL THEN
          x_fxh_rec.last_update_date := l_fxh_rec.last_update_date;

Line: 3097


        IF x_fxh_rec.last_update_login IS NULL THEN
          x_fxh_rec.last_update_login := l_fxh_rec.last_update_login;

Line: 3168


    UPDATE OKL_EXT_FA_HEADER_SOURCES_B
    SET SOURCE_ID = l_def_fxh_rec.source_id,
        SOURCE_TABLE = l_def_fxh_rec.source_table,
        OBJECT_VERSION_NUMBER = l_def_fxh_rec.object_version_number,
        TRANS_NUMBER = l_def_fxh_rec.trans_number,
        KHR_ID = l_def_fxh_rec.khr_id,
        TRY_ID = l_def_fxh_rec.try_id,
        CONTRACT_NUMBER = l_def_fxh_rec.contract_number,
        CUSTOMER_NAME = l_def_fxh_rec.customer_name,
        CUSTOMER_ACCOUNT_NUMBER = l_def_fxh_rec.customer_account_number,
        BOOK_CLASSIFICATION_CODE = l_def_fxh_rec.book_classification_code,
        PRODUCT_NAME = l_def_fxh_rec.product_name,
        TAX_OWNER_CODE = l_def_fxh_rec.tax_owner_code,
        REPRESENTATION_CODE = l_def_fxh_rec.representation_code,
        REPRESENTATION_NAME = l_def_fxh_rec.representation_name,
        RENT_IA_CONTRACT_NUMBER = l_def_fxh_rec.rent_ia_contract_number,
        RES_IA_CONTRACT_NUMBER = l_def_fxh_rec.res_ia_contract_number,
        CONVERTED_NUMBER = l_def_fxh_rec.converted_number,
        CONTRACT_EFFECTIVE_FROM = l_def_fxh_rec.contract_effective_from,
        CONTRACT_CURRENCY_CODE = l_def_fxh_rec.contract_currency_code,
        SALES_REP_NAME = l_def_fxh_rec.sales_rep_name,
        RENT_IA_PRODUCT_NAME = l_def_fxh_rec.rent_ia_product_name,
        RES_IA_PRODUCT_NAME = l_def_fxh_rec.res_ia_product_name,
        PO_ORDER_NUMBER = l_def_fxh_rec.po_order_number,
        VENDOR_PROGRAM_NUMBER = l_def_fxh_rec.vendor_program_number,
        RENT_IA_ACCOUNTING_CODE = l_def_fxh_rec.rent_ia_accounting_code,
        RES_IA_ACCOUNTING_CODE = l_def_fxh_rec.res_ia_accounting_code,
        ASSIGNABLE_FLAG = l_def_fxh_rec.assignable_flag,
        CONVERTED_ACCOUNT_FLAG = l_def_fxh_rec.converted_account_flag,
        ACCRUAL_OVERRIDE_FLAG = l_def_fxh_rec.accrual_override_flag,
        KHR_ATTRIBUTE_CATEGORY = l_def_fxh_rec.khr_attribute_category,
        KHR_ATTRIBUTE1 = l_def_fxh_rec.khr_attribute1,
        KHR_ATTRIBUTE2 = l_def_fxh_rec.khr_attribute2,
        KHR_ATTRIBUTE3 = l_def_fxh_rec.khr_attribute3,
        KHR_ATTRIBUTE4 = l_def_fxh_rec.khr_attribute4,
        KHR_ATTRIBUTE5 = l_def_fxh_rec.khr_attribute5,
        KHR_ATTRIBUTE6 = l_def_fxh_rec.khr_attribute6,
        KHR_ATTRIBUTE7 = l_def_fxh_rec.khr_attribute7,
        KHR_ATTRIBUTE8 = l_def_fxh_rec.khr_attribute8,
        KHR_ATTRIBUTE9 = l_def_fxh_rec.khr_attribute9,
        KHR_ATTRIBUTE10 = l_def_fxh_rec.khr_attribute10,
        KHR_ATTRIBUTE11 = l_def_fxh_rec.khr_attribute11,
        KHR_ATTRIBUTE12 = l_def_fxh_rec.khr_attribute12,
        KHR_ATTRIBUTE13 = l_def_fxh_rec.khr_attribute13,
        KHR_ATTRIBUTE14 = l_def_fxh_rec.khr_attribute14,
        KHR_ATTRIBUTE15 = l_def_fxh_rec.khr_attribute15,
        CUST_ATTRIBUTE_CATEGORY = l_def_fxh_rec.cust_attribute_category,
        CUST_ATTRIBUTE1 = l_def_fxh_rec.cust_attribute1,
        CUST_ATTRIBUTE2 = l_def_fxh_rec.cust_attribute2,
        CUST_ATTRIBUTE3 = l_def_fxh_rec.cust_attribute3,
        CUST_ATTRIBUTE4 = l_def_fxh_rec.cust_attribute4,
        CUST_ATTRIBUTE5 = l_def_fxh_rec.cust_attribute5,
        CUST_ATTRIBUTE6 = l_def_fxh_rec.cust_attribute6,
        CUST_ATTRIBUTE7 = l_def_fxh_rec.cust_attribute7,
        CUST_ATTRIBUTE8 = l_def_fxh_rec.cust_attribute8,
        CUST_ATTRIBUTE9 = l_def_fxh_rec.cust_attribute9,
        CUST_ATTRIBUTE10 = l_def_fxh_rec.cust_attribute10,
        CUST_ATTRIBUTE11 = l_def_fxh_rec.cust_attribute11,
        CUST_ATTRIBUTE12 = l_def_fxh_rec.cust_attribute12,
        CUST_ATTRIBUTE13 = l_def_fxh_rec.cust_attribute13,
        CUST_ATTRIBUTE14 = l_def_fxh_rec.cust_attribute14,
        CUST_ATTRIBUTE15 = l_def_fxh_rec.cust_attribute15,
        REV_REC_METHOD_CODE = l_def_fxh_rec.rev_rec_method_code,
        INT_CALC_METHOD_CODE = l_def_fxh_rec.int_calc_method_code,
        CREATED_BY = l_def_fxh_rec.created_by,
        CREATION_DATE = l_def_fxh_rec.creation_date,
        LAST_UPDATED_BY = l_def_fxh_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_fxh_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_fxh_rec.last_update_login,
        CONTRACT_STATUS_CODE = l_def_fxh_rec.contract_status_code,
        TRX_TYPE_CLASS_CODE = l_def_fxh_rec.trx_type_class_code,
        TERM_QUOTE_ACCEPT_DATE = l_def_fxh_rec.term_quote_accept_date,
        TERM_QUOTE_NUM = l_def_fxh_rec.term_quote_num,
        TERM_QUOTE_TYPE_CODE = l_def_fxh_rec.term_quote_type_code,
        REPOSSESS_FLAG    = l_def_fxh_rec.repossess_flag,
	PARTY_ID    = l_def_fxh_rec.party_id,
	CUST_ACCOUNT_ID    = l_def_fxh_rec.cust_account_id
    WHERE HEADER_EXTENSION_ID = l_def_fxh_rec.header_extension_id;

Line: 3281


  END update_row;

Line: 3285


  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_fxhl_rec                     IN fxhl_rec_type,
    x_fxhl_rec                     OUT NOCOPY fxhl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3294


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

Line: 3338


        IF x_fxhl_rec.last_updated_by IS NULL THEN
          x_fxhl_rec.last_updated_by := l_fxhl_rec.last_updated_by;

Line: 3341


        IF x_fxhl_rec.last_update_date IS NULL THEN
          x_fxhl_rec.last_update_date := l_fxhl_rec.last_update_date;

Line: 3344


        IF x_fxhl_rec.last_update_login IS NULL THEN
          x_fxhl_rec.last_update_login := l_fxhl_rec.last_update_login;

Line: 3390


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

Line: 3401


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

Line: 3440


  END update_row;

Line: 3444


  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_fxhv_rec                     IN fxhv_rec_type,
    x_fxhv_rec                     OUT NOCOPY fxhv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3454


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

Line: 3471


      l_fxhv_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 3472


      l_fxhv_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 3473


      l_fxhv_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 3696


        IF x_fxhv_rec.last_updated_by IS NULL THEN
          x_fxhv_rec.last_updated_by := l_db_fxhv_rec.last_updated_by;

Line: 3699


        IF x_fxhv_rec.last_update_date IS NULL THEN
          x_fxhv_rec.last_update_date := l_db_fxhv_rec.last_update_date;

Line: 3702


        IF x_fxhv_rec.last_update_login IS NULL THEN
          x_fxhv_rec.last_update_login := l_db_fxhv_rec.last_update_login;

Line: 3812


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_fxh_rec,
      lx_fxh_rec
    );

Line: 3826


    update_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_fxhl_rec,
      lx_fxhl_rec
    );

Line: 3874


  END update_row;

Line: 3878


  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_fxhv_tbl                     IN fxhv_tbl_type,
    x_fxhv_tbl                     OUT NOCOPY fxhv_tbl_type,
    px_error_tbl                   IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3889


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

Line: 3903


          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_fxhv_rec                     => p_fxhv_tbl(i),
            x_fxhv_rec                     => x_fxhv_tbl(i));

Line: 3971


  END update_row;

Line: 3976


  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_fxhv_tbl                     IN fxhv_tbl_type,
    x_fxhv_tbl                     OUT NOCOPY fxhv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 3986


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

Line: 3993


      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_fxhv_tbl                     => p_fxhv_tbl,
        x_fxhv_tbl                     => x_fxhv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 4035


  END update_row;

Line: 4043


  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_fxh_rec                      IN fxh_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4051


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

Line: 4066


    DELETE FROM OKL_EXT_FA_HEADER_SOURCES_B
     WHERE HEADER_EXTENSION_ID = p_fxh_rec.header_extension_id;

Line: 4102


  END delete_row;

Line: 4106


  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_fxhl_rec                     IN fxhl_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4114


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

Line: 4129


    DELETE FROM OKL_EXT_FA_HEADER_SOURCES_TL
     WHERE HEADER_EXTENSION_ID = p_fxhl_rec.header_extension_id;

Line: 4165


  END delete_row;

Line: 4169


  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_fxhv_rec                     IN fxhv_rec_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4178


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

Line: 4204


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

Line: 4216


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

Line: 4261


  END delete_row;

Line: 4265


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

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4275


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

Line: 4289


          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_fxhv_rec                     => p_fxhv_tbl(i));

Line: 4356


  END delete_row;

Line: 4361


  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_fxhv_tbl                     IN fxhv_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4370


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

Line: 4377


      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_fxhv_tbl                     => p_fxhv_tbl,
        px_error_tbl                   => l_error_tbl);

Line: 4418


  END delete_row;

Line: 4421


  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_fxh_rec                      IN fxh_rec_type,
    p_fxhl_tbl                     IN fxhl_tbl_type,
    x_fxh_rec                      OUT NOCOPY fxh_rec_type,
    x_fxhl_tbl                     OUT NOCOPY fxhl_tbl_type) IS

    l_api_version                  CONSTANT NUMBER := 1;

Line: 4433


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

Line: 4454


      l_fxh_rec.LAST_UPDATE_DATE := l_fxh_rec.CREATION_DATE;

Line: 4455


      l_fxh_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 4456


      l_fxh_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 4502


    insert_row(
      p_init_msg_list,
      l_return_status,
      x_msg_count,
      x_msg_data,
      l_fxh_rec,
      lx_fxh_rec
    );

Line: 4521


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

Line: 4522


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

Line: 4523


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

Line: 4525


      insert_row(
        p_init_msg_list,
        l_return_status,
        x_msg_count,
        x_msg_data,
        l_fxhl_tbl(idx),
        lx_fxhl_tbl(idx)
      );

Line: 4575


  END insert_row;