Search Results c_rule_name_p

Overview

PA_PAXAARUL_XMLP_PKG is an Oracle EBS Projects (PA) package that supports the XML Publisher (BI Publisher) concurrent report associated with the "PAXAARUL" short name, reflected in its header comment (PAXAARULS.pls, version 120.0, dated 2008/01/02). The package is declared with AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the invoking user rather than the package owner, which is standard for report driver packages in the APPS schema that must respect the calling session's security context.

The primary business function of this package is to drive the layout and content of a Projects-related XML report, supplying the values needed for the report's cover page and controlling the overall report execution lifecycle (before and after report processing). It exposes several package-level variables and functions that the XML Publisher template references to render dynamic content, including the company name header, a rule name, a no-data-found message, and a dummy data indicator.

Key Procedures and Functions

The package documents eight procedures and functions. BEFOREREPORT and AFTERREPORT are the standard report trigger routines invoked at the start and end of concurrent report execution, used to initialize and clean up report state. GET_COVER_PAGE_VALUES and GET_COMPANY_NAME populate cover-page and header information, returning BOOLEAN to signal success or failure. The remaining four are accessor functions exposed to the XML template: C_COMPANY_NAME_HEADER_P (returns the company name header value), C_NO_DATA_FOUND_P (returns the no-data-found message), C_DUMMY_DATA_P (returns the dummy data numeric indicator), and C_RULE_NAME_P (returns the rule name, backed by the C_rule_name variable of type varchar2(60)).

The user's search term "c_rule_name_p" corresponds directly to this last accessor. It is a getter function that returns the C_rule_name package variable, which holds the name of the rule being reported on. The report accepts a P_RULE_ID parameter (varchar2(40)) that drives the underlying query; C_rule_name_p surfaces the corresponding rule name for display in the report output. Other reported parameters include P_rule_optimizer, P_debug_mode, and P_CONC_REQUEST_ID.

Tables Accessed

The only documented table referenced through APPS synonyms is PA_RULES. This is consistent with the report's purpose: PA_RULES stores rule definitions in Oracle Projects, and the package reads it to derive the rule name (C_rule_name) and related report data keyed by the P_RULE_ID parameter. No write operations are documented.

Usage Notes

This package is not an API for general application use. It is a report driver package, invoked automatically by the XML Publisher concurrent program engine when the associated Projects report is submitted. Because it is classified as OTHER, it carries no public API support guarantee, and direct calls from forms or custom code are discouraged. Customizations should target the underlying XML template or concurrent program definition rather than the package itself. Any modification would be overwritten during patching, which is why the header carries the "noship" designation.