Search Results c_company_name_header

Overview

APPS.PA_PAXRWCTY_XMLP_PKG is the generated PL/SQL package body that supports the Oracle E-Business Suite XML Publisher (BI Publisher) concurrent report PAXRWCTY, a Project Accounting report that prints company-related header information drawn from the General Ledger set of books. In Oracle EBS 12.1.1 and 12.2.2, XML Publisher reports are built on Oracle Reports executables whose data model logic is frequently migrated to a server-side PL/SQL package rather than left in the report trigger. This package is the container for that server-side logic.

The package body provides the report-level entry points that XML Publisher and the Oracle Reports runtime expect (BeforeReport and AfterReport), a data-fetch function that populates the report's company name value (GET_COMPANY_NAME), and an accessor function that exposes that value to the report layout as a placeholder (C_COMPANY_NAME_HEADER_P). The header comment identifies the source file as PAXRWCTYB.pls with version 120.0, dated 2008/01/02, which is consistent with a report whose definition has been stable across the 12.1 and 12.2 releases.

Key Procedures and Functions

• GET_COMPANY_NAME — Returns a BOOLEAN indicating success or failure. It declares a local variable of type GL_SETS_OF_BOOKS.NAME%TYPE, retrieves the company (set of books) name, assigns it to the package-level variable C_COMPANY_NAME_HEADER, and returns TRUE. An exception handler catches WHEN OTHERS and returns FALSE, so a failure to resolve the set of books name does not abort the report.
• BEFOREREPORT — The report's BeforeReport trigger function. It returns BOOLEAN. The original Oracle Reports FND SRWINIT user exit call is commented out and replaced with a null statement, reflecting that initialization is now handled by the XML Publisher/Concurrent Manager infrastructure rather than by the SRW user exit layer.
• AFTERREPORT — The report's AfterReport trigger function, also returning BOOLEAN. As with BeforeReport, the corresponding FND SRWEXIT user exit call is commented out and replaced with a null statement.
• C_COMPANY_NAME_HEADER_P — A placeholder accessor function returning VARCHAR2. It simply returns the package-level variable C_COMPANY_NAME_HEADER, allowing the XML Publisher layout template to reference the company name header without direct access to the package variable.

Tables Accessed

The package queries the General Ledger table GL_SETS_OF_BOOKS through its APPS synonym, reading the NAME column. The purpose is to resolve the descriptive name of the accounting set of books (in 12.x terminology, the ledger/legal entity context) so that it can be printed in the report header. No INSERT, UPDATE, or DELETE operations are present; the package is strictly read-only. No other application tables are referenced by the documented package body, and the ETRM metadata records no referenced-by relationships from other packages.

Usage Notes

This package is invoked automatically by the XML Publisher/Concurrent Manager runtime when the PAXRWCTY report is submitted. The BeforeReport trigger fires once at the start of the report execution, AfterReport at the end. The layout template obtains the company name by evaluating the placeholder function C_COMPANY_NAME_HEADER_P, whose value is populated by GET_COMPANY_NAME. Because GET_COMPANY_NAME swallows all exceptions and returns FALSE on error, a missing or inaccessible set of books results in a blank or default header value rather than a report failure. Customizations should avoid modifying the generated package directly; changes are overwritten when the report definition is regenerated. Extensions that require additional header attributes should instead be implemented through a custom package layered over the standard report or through a customized XML Publisher data template.