Search Results fnd_application_pkg




Overview
Explore in AI Chat

Overview

FND_APPLICATION_PKG is a core Oracle E-Business Suite foundation package owned by the APPS schema. It provides the low-level Data Manipulation Language (DML) and translation infrastructure for application registration records stored in the FND_APPLICATION family of tables. In EBS 12.1.1 and 12.2.2, these tables define the applications, their short names, base paths, and translated display names that the concurrent manager, Forms runtime, and security layer rely upon when resolving an application context.

The package serves as the persistence back end for the Application Object Library (AOL) application definition screens. Rather than being an end-user facing API, it is the repository routine layer that the AOL forms and the seed-data loader invoke to insert, lock, update, delete, and translate application rows. The ETRM metadata lists the object as status VALID, classification OTHER, and records it as being referenced by zero other database objects, confirming its role as a leaf-level utility invoked directly rather than through a published integration API.

Key Procedures and Functions

The documented package exposes ten PL/SQL entry points covering standard AOL row maintenance and multi-language support:

  • INSERT_ROW — Creates a new application definition row, populating the base FND_APPLICATION record and its associated sequence and translation rows.
  • LOCK_ROW — Acquires a row-level lock using the standard AOL WHO-column concurrency convention so that concurrent edits cannot overwrite one another.
  • UPDATE_ROW — Applies modified application attributes to an existing, previously locked row, refreshing the audit columns.
  • LOAD_ROW — Inserts or updates a seeded application definition on behalf of the AOL data loader, preserving the shipped definition state.
  • TRANSLATE_ROW — Creates or maintains the translated name and description in FND_APPLICATION_TL for the installed languages.
  • DELETE_ROW — Removes an application definition and its dependent translation and sequence records.
  • ADD_LANGUAGE — Registers and seeds translations for a newly installed language across the application definition set.

Each routine cooperates with the package private globals and the standard FND_MESSAGE and APP_EXCEPTION utilities to raise consistent, message-based errors.

Tables Accessed

  • FND_APPLICATION — The primary definition table holding short name, base path, product code, and audit columns; the target of all insert, update, and delete operations.
  • FND_APPLICATION_S — The sequence table supplying the surrogate primary key for new application rows; this is the object matched by the user's search term.
  • FND_APPLICATION_TL — Stores language-specific name and description text, written by TRANSLATE_ROW, LOAD_ROW, and ADD_LANGUAGE.
  • FND_LANGUAGES — Read to determine which installed languages require translation rows.
  • DUAL — Used for singleton select and sequence advancement operations.

Usage Notes

FND_APPLICATION_PKG is normally invoked indirectly. The AOL application definition form calls INSERT_ROW, LOCK_ROW, UPDATE_ROW, and DELETE_ROW during interactive maintenance. The concurrent program that loads AOL seed data calls LOAD_ROW, and language installation routines call ADD_LANGUAGE and TRANSLATE_ROW to propagate new translations.

Custom code should not call this package directly; the sanctioned integration point for application metadata is the AOL application API layer. Direct DML against the underlying tables bypasses the WHO-column audit and validation logic enforced here. Because the package is referenced by no other database object, compatibility impact of internal changes is contained, but the underlying table structures remain central to runtime application resolution in both 12.1.1 and 12.2.2.