Search Results fa_fasexprp_xmlp_pkg




Overview
Explore in AI Chat

Overview

APPS.FA_FASEXPRP_XMLP_PKG is the generated PL/SQL package body that backs the Oracle E-Business Suite XML Publisher (BI Publisher) concurrent program for the Fixed Assets FASEXPRP report. In Oracle EBS 12.1.1 and 12.2.2, the naming convention <report>_XMLP_PKG identifies the data-definition wrapper package that Oracle's XML Publisher engine executes at runtime to produce the report's XML output. FASEXPRP is associated with the Fixed Assets asset-expense or asset-inquiry reporting family, and this package encapsulates the after-report processing, before-report initialization, report identity resolution, and prompt-driven parameter handling needed by the XML Publisher template.

The object resides in the APPS schema with a status of VALID. It is documented in ETRM with an API classification of OTHER, indicating it is an internal report-support construct rather than a public, callable business API. Its primary role is to bridge the concurrent manager request context and the SQL query that feeds the XML template.

Key Procedures and Functions

The package body exposes seven documented program units:

  • BEFOREREPORT — Executed prior to the report data fetch; performs package-level initialization and setup of session or report state.
  • AFTERREPORT — Executed after the report data has been generated; performs cleanup and any post-processing required by the concurrent request.
  • REPORT_NAMEFORMULA — Resolves the report name used within the XML output, typically driving the report title or template-level naming in the generated document.
  • RP_REPORT_NAME_P — A report parameter/attribute accessor that surfaces the report name to the XML Publisher data model.
  • RP_COMPANY_NAME_P — Returns the company (legal entity/organization) name associated with the reporting context, used for the report header and XML metadata.
  • ACCT_BAL_APROMPT_P — Handles the accounting-balance or account-related prompt value supplied at submission time.
  • RP_BAL_LPROMPT_P — Handles the balance-related list-of-values prompt parameter passed to the report.

These units follow the standard XML Publisher PL/SQL package pattern, in which BEFOREREPORT and AFTERREPORT bracket execution and the _P accessors expose concurrent program parameters to the XML template.

Tables Accessed

Per the documented dependency list, the package references FND_CONCURRENT_REQUESTS (through the APPS synonym), which it reads to obtain the executing concurrent request context — the request identifier and associated runtime attributes needed to resolve report identity and parameters. The dependency metadata also lists FND_CONCURRENT_PROGRAMS_VL and FND_GLOBAL, reflecting the use of concurrent program definition data and session/user context (application, responsibility, and user identifiers). Standard SYS.STANDARD constructs are referenced for base PL/SQL types. The package writes no application data tables; its read-only access pattern is consistent with a reporting data-definition wrapper.

Usage Notes

FA_FASEXPRP_XMLP_PKG is invoked indirectly by the XML Publisher concurrent program infrastructure, not by user code. When a user submits the associated Fixed Assets XML report from the Submit Request form or the Fixed Assets application menus, the concurrent manager starts the XML Publisher data-definition program, which calls BEFOREREPORT, generates the XML dataset, resolves the parameter accessors, and then calls AFTERREPORT. The package body is not referenced by any other database object, confirming it is a terminal consumer rather than a shared utility. Customization should not modify the generated package directly; report changes belong in the XML Publisher data model, template, or a custom copy of the concurrent program. Because the object is regenerated by Oracle's report-definition utilities, any manual edits can be overwritten during patching or upgrade in both 12.1.1 and 12.2.2.