Search Results cp_nodatafound

Overview

PA_PARGCALG_XMLP_PKG is an Oracle E-Business Suite package that resides in the APPS schema and is declared with AUTHID CURRENT_USER. Its name identifies it as the generated PL/SQL package associated with an Oracle Reports executable (the "_XMLP_PKG" suffix is the standard convention for BI Publisher / XML Publisher report packages produced from Oracle Reports source). The report it supports is the Project Accounting "Project and Contract Calendar" calculation listing (PARGCALG), and the package supplies the report-level logic required to execute the query, format derived columns, and control report output. Its header comment dates the original source revision to 2008, and the object remains present and documented in both EBS 12.1.1 and 12.2.2.

The package is not a business API. It contains no public procedures and exposes no business transactions. It functions purely as a report-support container: report parameters are declared as package globals, group-level formula logic is exposed as a function, and the report's BeforeReport and AfterReport triggers are implemented as Boolean functions. These package globals are populated by the report's parameter form and are read during report execution.

Key Procedures and Functions

• BEFOREREPORT — The report-level BeforeReport trigger function. It performs report initialization work such as resolving context before the main query is executed, and returns a Boolean to indicate success.
• AFTERREPORT — The report-level AfterReport trigger function. It executes once the report has completed and returns a Boolean, typically used to finalize report state or release resources.
• CF_COMPANY_NAME_FORMULA — A column formula function (the "CF_" prefix designates a computed formula column) that returns a Char value for the company name shown on the report output.
• CP_COMPANY_NAME_P — A report parameter accessor returning a varchar2. It exposes the CP_company_name package global so the report layout can reference the company name value.
• CP_NODATAFOUND_P — A report parameter accessor returning a varchar2. It exposes the CP_NODATAFOUND package global, which is initialized to the literal string 'No Data Found' and is used to render the standard message displayed when the report query returns no rows. This is the accessor referenced by the search term "cp_nodatafound_p".

Tables Accessed

The only documented table referenced through APPS synonyms is PA_IMPLEMENTATIONS. This is the Project Accounting configuration table that stores the currently installed implementation details, including the operating unit and chart of accounts context. The package reads it to resolve implementation-level attributes — most notably the chart of accounts identifier used to drive calendar and company presentation on the report. No other base or interface tables are documented as being accessed by this package.

Usage Notes

PA_PARGCALG_XMLP_PKG is invoked indirectly. It is executed by the Oracle Reports runtime when the associated PARGCALG concurrent program or report definition is submitted; the report engine calls BeforeReport and AfterReport and evaluates the formula and accessor functions as it lays out the output. It is not intended to be called from custom forms, concurrent programs, or other PL/SQL packages, and the metadata records it as referenced by zero other packages, confirming it sits at the leaf of the call graph.

Because the package is generated and report-specific, its logic should not be modified directly; changes belong in the underlying report definition and the package should be regenerated. It carries no application-programming-interface classification (OTHER) and is not exposed for external integration. Organizations upgrading between 12.1.1 and 12.2.2 should treat it as internal report plumbing, ensuring only that the underlying report and PA_IMPLEMENTATIONS data remain consistent.