Results for “inv_tax”

18 results




Overview
Explore in AI Chat

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

Overview

XLA_00222_AAD_S_000008_PKG is a generated PL/SQL package body owned by APPS within the Oracle E-Business Suite Subledger Accounting (XLA) architecture. It is one of the many accounting program packages that Oracle generates automatically from an Accounting Definition configured in the Subledger Accounting setup. The header comment block identifies the source definition as the "Multi-Fund Account Receivables Accrual - Balancing Method" with the internal code MFAR_ACCRUAL_BALANCING, owned by the PRODUCT application, and generated on 30 March 2009.

The package belongs to the family of XLA_<application_id>_AAD_S_<sequence>_PKG packages, where the naming convention ties the package to a specific application and accounting definition. In this instance the 00222 prefix corresponds to the Receivables application (Oracle Receivables is typically registered as application 222). The package is classified as OTHER in the ETRM 12.2.2 metadata and exposes two documented program units: GETMEANING and CREATEJOURNALENTRIES.

Key Procedures and Functions

  • GETMEANING — Returns the meaning associated with a lookup code, used to translate stored lookup values into descriptive text during journal entry construction. This is a conventional helper routine in generated XLA accounting packages, supporting the resolution of reference attributes and descriptive flexfield values.
  • CREATEJOURNALENTRIES — The core accounting engine of this package. It is invoked by the Subledger Accounting program to build journal entry lines and headers from subledger event data, applying the Multi-Fund Account Receivables Accrual balancing method. This routine consumes the event and event-class data supplied in the global temporary table and produces the corresponding XLA_AE_HEADERS and XLA_AE_LINES rows that constitute the subledger journal.

The package body also declares a PL/SQL record type, t_rec_array_event, which corrals parallel arrays of legal entity, entity, event, class, date, and reference number/character attributes drawn from the XLA_AE_JOURNAL_ENTRY_PKG array types. This structure is populated during journal entry generation and demonstrates that the package is designed to process events in bulk arrays rather than one row at a time.

Tables Accessed

The documented table references reflect the package's operational dependencies:

  • XLA_EVENTS_GT — a global temporary table holding the subledger events currently being processed. The package reads from this table to obtain source transactions for journal creation.
  • FND_LOOKUP_VALUES — supplies lookup code and meaning pairs, which drives the GETMEANING routine.
  • ALL_OBJECTS — used for metadata validation, typically to confirm the existence of referenced database objects at runtime.
  • XLA_DIAG_SOURCES — a diagnostics table used by XLA to trace the origins of journal entry values for debugging and audit purposes.
  • FND_ORACLE_USERID — stores Oracle user identifiers referenced during package execution or logging.
  • PLITBLM — the PL/SQL implementation of DBMS_LOB routines, invoked when handling large character columns during journal line construction.

Usage Notes

This package is not intended for direct invocation by end users or by custom code. It is called by the Subledger Accounting engine (the Create Accounting program, XLAACCUP or equivalent) when processing Receivables transactions under the Multi-Fund Account Receivables Accrual definition. The package is generated and can be regenerated whenever the accounting definition is modified through the Accounting Methods Builder (AMB), as indicated by the AMB Context Code: DEFAULT in its header. The metadata records zero packages referencing this object, confirming its status as a leaf-level generated artifact consumed only by the XLA accounting runtime. Because the code is generated, any manual amendment would be overwritten on regeneration, and customization should instead be pursued through the underlying accounting definition.