Search Results fa_lookup_types_pkg




Overview
Explore in AI Chat

Overview

FA_LOOKUP_TYPES_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides the programmatic interface for maintaining Oracle Assets lookup type definitions. In Oracle Assets (FA), lookup types represent the extensible, user-definable code categories that drive validation and display across the application — for example asset categories, depreciation methods, prorate conventions, asset key structures, and other seeded or customer-defined value sets stored in the FA_LOOKUP_TYPES family of tables.

The package encapsulates the standard row-level operations required to create, modify, delete, translate, and seed these lookup definitions without direct table manipulation. It is classified as a business-entity maintenance API rather than an open public interface, and it is exposed via APPS synonyms to the base dictionary tables FA_LOOKUP_TYPES, FA_LOOKUP_TYPES_B, and FA_LOOKUP_TYPES_TL. The "_B" suffix denotes the base (language-independent) table, while the "_TL" suffix denotes the translatable (language-dependent) table, reflecting Oracle's standard multi-language object architecture. The package is dependent on FA_API_TYPES and STANDARD, and the ETRM metadata records no reverse dependencies, meaning no other packaged API invokes it directly.

Key Procedures and Functions

The documented interface consists of ten procedures and functions spanning DML, translation, and seeding operations:

  • INSERT_ROW — Inserts a new lookup type definition row into the base table.
  • UPDATE_ROW — Modifies attributes of an existing lookup type row.
  • DELETE_ROW — Removes a lookup type row from the entity.
  • LOCK_ROW — Acquires a row-level lock to support optimistic concurrency control during maintenance operations.
  • ADD_LANGUAGE — Inserts the translatable row required when a lookup definition must exist in an additional installed language.
  • TRANSLATE_ROW — Updates the language-dependent (TL) description or display text for an existing lookup type in a specified language.
  • LOAD_ROW — Loads a single lookup type record, typically during data migration or seed data installation.
  • LOAD_SEED_ROW — Loads seeded (Oracle-delivered) lookup type records, applying the standard seed-data conventions used by Oracle's installation and upgrade utilities.

The procedure names follow Oracle's consistent naming convention for entity-maintenance APIs, and the presence of both LOAD_ROW and LOAD_SEED_ROW indicates explicit support for distinguishing customer data from Oracle seed data during patching and upgrade cycles.

Tables Accessed

The package reads and writes the following tables through APPS synonyms:

  • FA_LOOKUP_TYPES — The primary view or table aliasing the base and translated lookup definitions used by the application for validation.
  • FA_LOOKUP_TYPES_B — The base, language-independent table storing the core lookup type rows and their non-translatable attributes.
  • FA_LOOKUP_TYPES_TL — The translation table holding language-specific display text, maintained by ADD_LANGUAGE and TRANSLATE_ROW.
  • FND_LANGUAGES — The Oracle Application Object Library language repository, consulted to validate installed and active languages during translation operations.

Usage Notes

FA_LOOKUP_TYPES_PKG is an internal maintenance API and is not intended as a general-purpose integration interface. It is typically invoked by Oracle Assets setup forms, by Oracle seed-data loader and upgrade utilities, and by controlled data-migration scripts where lookup type definitions must be moved between environments. Because the ETRM metadata records zero packages referencing it, custom code should treat it as a low-level utility invoked only when no higher-level public API exists. Direct DML against the underlying tables should be avoided in favor of these procedures, which preserve the base/translation relationship and the integrity of seeded versus customer-defined data. Oracle proprietary and confidential — refer to Oracle's legal notices before redistribution.