Search Results get_application_info

Overview

XLA_CMP_COMMON_PKG is the Oracle Subledger Accounting (XLA) Compiler Common Code package. It resides in the APPS schema and is classified as an "OTHER" API within the ETRM repository. Its role is to provide shared utility routines that support the Subledger Accounting compiler infrastructure, which is responsible for generating and maintaining the accounting definitions (such as application accounting definitions, journal line types, and account derivation rules) used throughout Subledger Accounting. Because it holds common code, the package centralises low-level operations that would otherwise be duplicated across the various XLA compiler routines.

The package defines a set of named compile status constants that reflect the lifecycle of an XLA compilation object: error ('E'), uncompiled ('N'), running ('R'), compiled ('Y'), and delete ('D'). It also declares a record type, lt_application_info, which encapsulates application-related attributes such as application identifier, name, short name, hash identifier, Oracle username, product abbreviation, and the APPS account.

Key Procedures and Functions

• GET_APPLICATION_INFO — Returns a boolean and populates an lt_application_info record for a supplied application identifier, allowing callers to resolve application attributes needed during compilation.
• GET_USER_NAME — Returns a boolean and resolves the username associated with a given user identifier, typically used for auditing or diagnostic output.
• CLOB_TO_VARCHAR2S — Converts a CLOB into a DBMS_SQL.VARCHAR2S collection, enabling large definition text to be processed in line-oriented segments.
• VARCHAR2S_TO_CLOB — Performs the inverse conversion, assembling a VARCHAR2S collection back into a single CLOB.
• DUMP_TEXT — An overloaded diagnostic procedure that outputs text, accepting input as a VARCHAR2, a DBMS_SQL.VARCHAR2S collection, or a CLOB.
• BOOL_TO_CHAR — The routine the user searched for; it converts a PL/SQL boolean value to its character representation. This is a common convenience helper, since boolean values cannot be stored directly in database columns or passed directly through many dynamic SQL contexts.
• REPLACE_TOKEN — Substitutes one token with another within a text value, supporting the template and source-line manipulation that the compiler performs.

Tables Accessed

The package references several tables through APPS synonyms. FND_APPLICATION and FND_PRODUCT_INSTALLATIONS are read to resolve application identity and installation status, feeding GET_APPLICATION_INFO. AD_PM_PRODUCT_INFO supplies product abbreviation data. FND_ORACLE_USERID and FND_USER provide user and Oracle schema information for username resolution. DBMS_SQL and PLITBLM appear as referenced objects supporting the VARCHAR2S/CLOB conversion and dynamic SQL work.

Usage Notes

XLA_CMP_COMMON_PKG is not an end-user facing API. It is invoked internally by the Subledger Accounting compiler components and is referenced by five other packages within the EBS codebase, indicating its role as a shared dependency. Customisations and extensions that build upon the XLA compiler may call these utilities, particularly BOOL_TO_CHAR and the CLOB conversion routines, when manipulating accounting definition source text. The package is compiled and delivered under the APPS schema and should not be modified; extension work should be performed in a custom package that calls these utilities.