Results for “xla_entity_types”

4 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XLA_ENTITY_TYPES_F_PKG is a Forms PL/SQL wrapper package in the Oracle E-Business Suite Subledger Accounting (XLA) module. As stated in its header, the package is a "Forms PL/SQL Wrapper for xla_entity_types" and was generated from XLAUTB. It exposes the standard Forms-level DML interface for the XLA_ENTITY_TYPES entity, which defines the accounting entity types that Subledger Accounting recognizes across the applications. Entity types are the source-specific business objects (for example, an invoice, a payment, or a journal entry) that XLA uses to identify where accounting events originate and to which transaction objects accounting rules are mapped.

The package therefore serves the maintenance of entity type definitions—the registration, enablement, translation, and lifecycle of the rows that describe each subledger entity. It does not perform accounting itself; it provides the controlled insert, lock, update, and delete operations that the Oracle Forms-based setup UI relies upon, together with FNDLOAD-based deployment procedures added for configuration migration.

Key Procedures and Functions

The package exposes seven documented procedures:

  • INSERT_ROW — Creates a new entity type row, accepting the owning application, entity code, enablement flags, descriptive name and description, and the standard WHO audit columns.
  • LOCK_ROW — Issues the locking select against an existing entity type so that the Forms session holds the row before modification, supporting optimistic concurrency control.
  • UPDATE_ROW — Modifies the mutable attributes of an existing entity type (enablement flags, name, description) and refreshes the audit columns.
  • DELETE_ROW — Removes an entity type identified by its application and entity code.
  • ADD_LANGUAGE — Inserts the translated (TL) rows required for a newly defined entity type, propagating the base definition into supported languages.
  • LOAD_ROW — Supports FNDLOAD-based upload of entity type definitions, keyed by application short name and entity code, as added in the 09/23/04 revision for configuration deployment.
  • TRANSLATE_ROW — Companion to LOAD_ROW, loading translated name and description values for a given language during FNDLOAD import.

Tables Accessed

The package operates against the following tables through APPS synonyms:

  • XLA_ENTITY_TYPES_B — the base table holding application ID, entity code, enablement flags, and ownership; the primary target of INSERT_ROW, LOCK_ROW, UPDATE_ROW, and DELETE_ROW.
  • XLA_ENTITY_TYPES_TL — the translation table holding language-specific name and description; written by INSERT_ROW, UPDATE_ROW, ADD_LANGUAGE, and TRANSLATE_ROW.
  • FND_APPLICATION — used to resolve the owning application, particularly for the FNDLOAD procedures that accept an application short name rather than an ID.
  • FND_LANGUAGES — used by ADD_LANGUAGE and TRANSLATE_ROW to determine the installed languages into which entity type definitions must be propagated.

Usage Notes

The package is invoked primarily from the Oracle Forms maintenance screen for entity types, where it enforces row-level locking and audit stamping on behalf of the form. It is also called by concurrent or command-line FNDLOAD sessions that migrate entity type configurations between environments, using LOAD_ROW and TRANSLATE_ROW. One other documented package references XLA_ENTITY_TYPES_F_PKG, indicating a degree of reuse within the XLA schema.

Because the procedures are a Forms wrapper rather than a public business API, custom code should treat them as internal and prefer the supported Subledger Accounting setup APIs or FNDLOAD-based configuration where possible. The package contents are identical across 12.1.1 and 12.2.2; the later release differences affecting XLA are held in other objects.