Search Results c_error_buf_p

Overview

The package APPS.PA_PAUBRUER_XMLP_PKG is the generated PL/SQL package that backs the Oracle E-Business Suite XML Publisher (BI Publisher) report PAUBRUER, a Project Accounting billing and revenue reporting concurrent program. The prefix PA identifies the Project Accounting application, while the suffix _XMLP_PKG distinguishes the report's generated Data Model package, which is produced automatically by the Oracle Reports-to-XML Publisher migration utilities. As declared in the source header, the package is defined AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema — typically the APPS schema in a standard installation.

The package has no database-visible business API status: ETRM classifies it as OTHER, and it is not referenced by any other package. Its role is confined to supporting a single XML Publisher concurrent program, supplying runtime parameter values, cover-page metadata, currency context, and error-handling buffers to the report template.

Key Procedures and Functions

The package declares eleven documented program units, split between report-lifecycle triggers and accessor functions that expose global package variables to the XML Publisher engine.

• GET_COVER_PAGE_VALUES — populates the variables used to render the report cover page, such as company name and reporting period.
• BEFOREREPORT — the standard Oracle Reports/Xmlp trigger executed before the report data model is executed; it initialises context from concurrent program parameters.
• GET_ALL_NAMES — retrieves the lookup or descriptive name values required by the report.
• BEFOREPFORM — a before-parameter-form trigger used to query or default parameter values when the report's submission form is opened.
• AFTERREPORT — the closing trigger executed once report processing completes.
• C_COMPANY_NAME_HEADER_P — accessor returning the company name header string.
• C_NO_DATA_FOUND_P — accessor returning the "no data found" message string, used when the report returns no qualifying rows.
• C_DUMMY_DATA_P — accessor returning a numeric dummy-data flag.
• C_RETCODE_P — accessor returning the report return code.
• CURR_CODE_P — accessor returning the functional currency code.
• C_ERROR_BUF_P — accessor returning the error buffer, the function associated with the user's search term c_error_buf_p.

Tables Accessed

ETRM documents only one table accessed through APPS synonyms: PA_IMPLEMENTATIONS. This table stores Project Accounting implementation options, including organisation-level defaults and currency settings. The package reads it to derive the functional currency code (CURR_CODE) and related organisational context needed for the report's calculations and display.

Usage Notes

PA_PAUBRUER_XMLP_PKG is not intended for direct invocation from custom code. It is invoked implicitly by the XML Publisher runtime when the PAUBRUER concurrent program executes; the runtime calls BEFOREREPORT, the data model queries, and AFTERREPORT in sequence. The _P accessor functions such as C_ERROR_BUF_P are called by the report template or by the XML Publisher engine to retrieve global values rather than by end users.

Because the package body is regenerated whenever the underlying report definition changes, customisations should never modify it in place. The global variables — including C_ERROR_BUF, C_RETCODE, and CURR_CODE — are populated at runtime and lose their values between report invocations. The package is effectively a private implementation artefact of one concurrent program, with zero inbound package dependencies.