Search Results get_company_name

Overview

The PL/SQL package body APPS.PA_PAPWPRIREP_XMLP_PKG supports the Oracle Projects reporting framework in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It is the generated package that accompanies an Oracle Reports XML Publisher (BI Publisher) concurrent program definition, conventionally named PAPWPRIREP or PAPWPREP, as indicated by the header identifier PAPWPREPB.pls. The package encapsulates supporting PL/SQL logic that the report invokes at runtime, principally the derivation of a company name value used as a report header or parameter default. The object is classified as OTHER in the ETRM documentation, meaning it is not an exposed public API but an internal report support package owned by the APPS schema. Its footprint is deliberately small: it exists to isolate report-specific queries and cleanup logic from the report definition itself, which is standard practice for XML Publisher reports delivered with Oracle Projects.

Key Procedures and Functions

• GET_COMPANY_NAME — Returns a VARCHAR2 value representing the company name for the reporting context. Under the documented implementation, the function selects the name from the general ledger sets of books joined to the Oracle Projects implementation, truncating the value to fifty characters before returning it. This function is the object the user searched for under the term "get_company_name," and it provides the human-readable company identifier that appears on the printed or published report output, allowing a single report definition to adapt to whichever ledger the implementation is configured against.
• CLEANUP — Performs end-of-run housekeeping for the report package. Report support packages typically use a cleanup routine to release package-level state, reset globals, or remove temporary data established during formatting. It is called after the report completes to leave the session in a consistent state.

Both routines are documented without parameter lists in the ETRM metadata; the source excerpt confirms that GET_COMPANY_NAME takes no arguments and returns a VARCHAR2.

Tables Accessed

• PA_IMPLEMENTATIONS — The Oracle Projects implementation table, which stores the set of books identifier in use by the Projects application. It is queried to tie the report to the correct accounting ledger.
• PA_PWP_RELEASE_REPORT — A Projects table associated with the release reporting process that this XML Publisher report supports. It supplies the report data set consumed during execution.

Access to these objects is performed through APPS synonyms, which is the expected pattern for a package compiled in the APPS schema. The join to GL_SETS_OF_BOOKS for the company name is visible in the source excerpt, though the general ledger table is not enumerated in the documented table list.

Usage Notes

PA_PAPWPRIREP_XMLP_PKG is not intended for direct invocation by end users or by custom code. It is called by the Oracle Reports and XML Publisher runtime when the associated concurrent program is submitted from the Submit Requests form or from the concurrent manager. Because the ETRM metadata records zero referencing packages, the only expected callers are the report definition and the standard report execution engine. Customizations should avoid modifying this package directly, since it is a CEMLI-sensitive generated object and patching may overwrite changes. Where sites require a different company name derivation, the recommended approach is a custom copy of the report and its supporting package rather than an edit in place.