Search Results xla_tb_defn_je_sources_pvt

Overview

XLA_TB_DEFN_JE_SOURCES_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It forms part of the Subledger Accounting (XLA) infrastructure, specifically the transaction-based definition layer that governs how journal entry sources are configured for subledger accounting. The "PVT" suffix indicates that this is a private package, meaning its procedures are intended for internal use by other XLA packages rather than as a public API for external callers. In EBS, the XLA_TB_DEFN_JE_SOURCES object represents the association between a subledger journal entry source and its accounting definition, and this private package encapsulates the low-level DML operations required to maintain those associations.

The package supports the configuration and maintenance of journal entry source definitions within the Subledger Accounting model. These definitions determine which transaction sources contribute lines to generated journal entries. Because the package is classified as PVT, it is not exposed through the standard public API surface and is instead invoked by the surrounding XLA definition management code base.

Key Procedures and Functions

The ETRM metadata documents two procedures in this package:

• INSERT_ROW — Inserts a new journal entry source definition row. This procedure is responsible for creating the association record that links a subledger journal entry source to its accounting definition context within the XLA transaction-based definition framework.
• DELETE_ROW — Removes an existing journal entry source definition row. This procedure supports the removal of source-to-definition associations, typically when a definition is being reconfigured or retired.

Both procedures are private in scope and are designed to be called by higher-level XLA packages that manage the lifecycle of subledger accounting definitions. No public parameter signatures are exposed in the ETRM documentation, so callers should not invoke these procedures directly.

Tables Accessed

The package references a single underlying table via an APPS synonym:

• XLA_TB_DEFN_JE_SOURCES — This table stores the journal entry source definitions used by the transaction-based definition engine. The INSERT_ROW procedure writes new rows into this table, and DELETE_ROW removes rows from it. No other tables are documented as being accessed directly by this package.

The narrow table footprint confirms the package's role as a focused DML helper rather than a broad processing engine.

Usage Notes

XLA_TB_DEFN_JE_SOURCES_PVT is not referenced by any other documented packages, and it is not intended for direct invocation from forms, concurrent programs, or custom code. Its procedures are called internally by the XLA definition management layer when journal entry source definitions are created or deleted. Because the package is marked private and its procedures manipulate a core Subledger Accounting configuration table, direct calls from custom extensions are strongly discouraged. Any customizations that require modification of journal entry source definitions should use the supported public XLA APIs or the standard Subledger Accounting setup user interface instead. Customers upgrading between 12.1.1 and 12.2.2 should treat this object as internal infrastructure; it requires no direct maintenance and is preserved by the standard patching and upgrade process.