Search Results p_je_source_name

Overview

The APPS.XLA_TB_DEFN_JE_SOURCES_PVT package body is a private (PVT) PL/SQL API within the Oracle E-Business Suite Subledger Accounting (XLA) architecture. Its stated purpose, per the source header, is to contain all logic required to maintain trial balance report definitions as they relate to journal entry sources. In practical terms, the package manages the association between a trial balance definition (identified by a definition code) and one or more journal entry sources. Journal entry sources identify the origin of accounting entries — for example Payables, Receivables, or General Ledger — and trial balance reporting in XLA depends on being able to resolve which sources contribute to a given report definition. The package is classified as PVT, meaning it is intended for internal use by the XLA trial balance framework rather than as a public integration point, and it is documented as being referenced by no other packages, reinforcing that it operates as a low-level data maintenance utility.

Key Procedures and Functions

• INSERT_ROW — Creates a new trial balance report definition to journal entry source association. The procedure accepts a definition code, an object version number, a journal entry source name, and standard WHO audit columns (creation and last-update dates, users, and login). This is the procedure associated with the search term p_je_source_name; that parameter carries the name of the journal entry source being linked to the definition. The procedure raises NO_DATA_FOUND when the definition code is null, and it inserts into the underlying table while hard-coding the object version number to 1, explicitly ignoring the caller-supplied version value. It returns the new row identifier through an IN OUT NOCOPY rowid parameter for optimistic-locking style downstream operations.
• DELETE_ROW — Removes an existing association between a trial balance definition and a journal entry source, allowing definitions to be re-scoped or cleaned up.

Together these two procedures provide the minimal create-and-delete lifecycle for the source-to-definition mapping; no update procedure is documented, implying changes are handled by delete-and-reinsert.

Tables Accessed

The package reads and writes a single base table, XLA_TB_DEFN_JE_SOURCES, accessed through its APPS synonym. This table stores the mapping rows linking a trial balance definition code to a journal entry source name, along with the object version number and WHO audit columns. The INSERT_ROW procedure performs the insert against this table; the DELETE_ROW procedure removes rows from it. No other tables are documented as referenced, confirming the package is narrowly scoped to maintaining this one intersection table.

Usage Notes

Because the package is classified as PVT, it is not intended to be called directly from customer extensions; it is invoked internally by the XLA trial balance definition maintenance flow, typically from the Oracle Forms-based setup UI or from the framework code that manages trial balance report definitions. In Oracle EBS 12.1.1 and 12.2.2, the object version number passed by callers is ignored on insert (forced to 1), so custom code attempting to seed mappings should not rely on controlling that column. Callers must supply a non-null definition code, as a null value raises NO_DATA_FOUND. Given that the package is unreferenced by other documented packages, direct invocation from concurrent programs or custom PL/SQL should be approached cautiously; the supported path is to configure journal entry sources for trial balance definitions through the standard Subledger Accounting setup interface, which drives this package on the user's behalf. The source header indicates the package was created in 2005 and carries no later version stamps, so its behavior has remained stable across the 12.x releases.