Search Results fnd_profile_cat_options_pkg




Overview
Explore in AI Chat

Overview

The APPS.FND_PROFILE_CAT_OPTIONS_PKG package body provides the foundational data-maintenance API for the profile option category options entity within Oracle E-Business Suite 12.1.1 and 12.2.2. The FND_PROFILE_CAT_OPTIONS table stores the association between user profile option categories (defined in FND_PROFILE_CATS) and individual profile options (defined in FND_PROFILE_OPTIONS). This package encapsulates the insert, update, delete, locking, language-installation, translation, and seed-data loading operations required to maintain those associations safely against the EBS database.

The package is classified as OTHER in the ETRM metadata, indicating that it is an internal infrastructure package rather than a publicly documented business API. Because it handles multilingual (MLS) translation maintenance, it also supports the runtime language-installation and NLS upgrade processes that Oracle Applications use when a new language is activated.

Key Procedures and Functions

The package body exposes seven documented procedures, each targeting a specific maintenance concern:

  • INSERT_ROW — Creates a new category-option association row in the underlying tables.
  • LOCK_ROW — Acquires a pessimistic lock on an existing association row, guaranteeing exclusivity for subsequent updates.
  • UPDATE_ROW — Modifies an existing association row in place.
  • DELETE_ROW — Removes an association row from the tables.
  • ADD_LANGUAGE — Populates the translated (MLS) columns for a newly installed language.
  • TRANSLATE_ROW — Updates or inserts translated attribute values for a specific row and language.
  • LOAD_ROW — Implements the seed-data loader contract so that category-option definitions can be delivered by the Oracle Applications seed-data mechanism.

No public parameter lists are documented in the ETRM excerpt; only the procedure names and their operational intent are supported by the metadata.

Tables Accessed

The package references the following objects, all accessed through APPS synonyms:

  • FND_PROFILE_CAT_OPTIONS — The primary entity table that the package inserts into, updates, deletes from, and locks.
  • FND_PROFILE_CATS — The parent profile-option category table, used to validate category references.
  • FND_PROFILE_OPTIONS — The master profile-option definitions, validated when associating options with categories.
  • FND_PROFILE_OPTIONS_S — The MLS shadow/sequence-support view referenced during translated-row operations.
  • FND_APPLICATION — Used for application context resolution during insert and load operations.
  • DUAL — Utilized for scalar and sequence evaluations.

Supporting PL/SQL objects referenced include FND_API, FND_LOAD_UTIL, FND_MESSAGE, APP_EXCEPTION, and FND_PROFILE_OPTIONS_PKG. The package does not reference itself recursively and is not referenced by any other database object.

Usage Notes

Because the ETRM metadata records zero inbound dependencies from other database objects, FND_PROFILE_CAT_OPTIONS_PKG is not designed as a cross-application callable API. It is invoked by the Oracle Applications Framework (OAF) and Oracle Forms–based System Administrator setup flows, by the concurrent programs that install and upgrade profile option seed data, and by the runtime language-installation process when MLS translations are added.

Custom code that needs to maintain profile option categories should prefer invoking these package procedures rather than performing direct DML against FND_PROFILE_CAT_OPTIONS, since LOCK_ROW is the supported mechanism for concurrency control on this entity. The LOAD_ROW procedure is the entry point used by the seed-data loader, and ADD_LANGUAGE and TRANSLATE_ROW are invoked during the Applications language and NLS upgrade cycles. Direct invocation outside these supported flows is not recommended in production environments.