Search Results acct_bal_aprompt

Overview

FA_FASEXPRP_XMLP_PKG is an Oracle Application Object Library report logic package owned by APPS in Oracle E-Business Suite 12.1.1 and 12.2.2. It encapsulates the PL/SQL logic that supports the Oracle Assets (FA) concurrent program associated with the FASEXPRP report, a fixed asset reporting extract. The package is generated in the standard Oracle Reports XML Publisher pattern, where the report definition calls a database package of the same name to compute derived report values, resolve lexical parameter prompts, and control report-level initialization and finalization events.

The package is classified as OTHER in the ETRM API registry. Its primary business role is to supply formatted runtime values to a report layout: company identification, report title text, and user-facing prompt messages used in report parameters. The header comment (revision 120.1.12010000.1, dated 2008/07/28) indicates the source is shipped Oracle code and is therefore subject to standard support and patching rather than customer modification.

Key Procedures and Functions

The package exposes four public variables and seven documented procedures and functions:

• REPORT_NAMEFORMULA — Returns the display name of the report. It accepts the company name as input and derives the report name string used during report execution, typically combining company and report identifiers for the report heading.
• BEFOREREPORT — Standard Oracle Reports before-report trigger handler. It initializes package state and prepares any values required before the report query and layout begin processing.
• AFTERREPORT — Standard after-report trigger handler. It performs cleanup and finalization logic after the report body has completed.
• ACCT_BAL_APROMPT_P — Accessor function that returns the value of the ACCT_BAL_APROMPT variable, a VARCHAR2(222) field that holds the user-facing prompt text associated with the account balance parameter group. This directly explains the user's search term: "acct_bal_aprompt" is a prompt/variable exposed by this package and used by the report parameter form.
• RP_COMPANY_NAME_P — Accessor returning RP_COMPANY_NAME, the company name displayed in the report.
• RP_REPORT_NAME_P — Accessor returning RP_REPORT_NAME, the report title or identifier.
• RP_BAL_LPROMPT_P — Accessor returning RP_BAL_LPROMPT, a VARCHAR2(222) prompt string associated with the balance low prompt in the report parameters.

Parameter lists are not documented in the metadata beyond REPORT_NAMEFORMULA's company-name input; the accessors are conventional no-argument getter functions.

Tables Accessed

The only documented table reference is FND_CONCURRENT_REQUESTS, accessed through an APPS synonym. This table stores concurrent program request records and is commonly queried in Oracle Reports packages to retrieve the running request identifier (P_CONC_REQUEST_ID), execution status, printer settings, and request metadata needed for report output control and layout substitution. No other tables are documented, though the underlying report query itself is defined in the Oracle Reports file rather than in this package.

Usage Notes

FA_FASEXPRP_XMLP_PKG is not intended for direct customer invocation. It is called automatically by the Oracle Reports engine when the FASEXPRP report runs as a concurrent program, executing BEFOREREPORT and AFTERREPORT as report triggers and invoking the accessor functions and REPORT_NAMEFORMULA from within the report layout. Because the package is referenced by zero other packages per the ETRM metadata, its call graph is confined to the report definition. Customizations should not modify the shipped package; extensions should be implemented in a separate custom package or by using report-level customization supported by the XML Publisher/BI Publisher layer. When troubleshooting missing or blank report prompts such as ACCT_BAL_APROMPT or RP_BAL_LPROMPT, the values are typically set during BEFOREREPORT or from the report parameter form, so those initialization paths should be reviewed first.