Search Results cp_gre

Overview

APPS.PER_PERCACEI_XMLP_PKG is an Oracle E-Business Suite PL/SQL package that supports the XML Publisher (BI Publisher) concurrent program known internally as PERCACEI. The report it accompanies covers payroll consolidation and payroll-related employee assignment detail, commonly referred to as the Payroll Archive / Consolidation Employee Information extract. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking schema, which in the EBS concurrent manager context resolves to APPS.

Its role is strictly that of a report-supporting stub: it packages the bind parameters passed from the concurrent program definition, exposes formatting and report-header values to the XML template, and provides the standard before/after report and before/after form trigger functions required by Oracle Reports-style XML Publisher layouts. The header comment ($Header: PERCACEIS.pls 120.0) indicates the file is a generated XML Publisher shell script, a pattern Oracle uses to wrap a database package around an underlying report query.

Key Procedures and Functions

The package exposes eight documented entry points, including four lifecycle trigger functions and four report-value accessors.

• BEFOREPFORM — Executes before report parameter validation; typically used to initialize package state prior to the Oracle Reports parameter form being processed.
• AFTERPFORM — Executes after the parameter form has been accepted. It is the conventional location for validating and normalising the payroll, tax unit, consolidation set and hire-date parameters before the query executes.
• BEFOREREPORT — Runs before the main report query. This is where the sort-tag logic (P_SORT_TAG := '5, 4') and ordering derivations are finalised and populated.
• AFTERREPORT — Runs after the report completes, allowing cleanup of package-level state at end of run.
• CP_REPORT_TITLE_P — Returns the value of the public variable CP_REPORT_TITLE, supplying the report heading displayed on the XML output.
• CP_CONSOLIDATION_P — Returns CP_CONSOLIDATION, the consolidation set description shown in the report header.
• CP_PAYROLL_NAME_P — Returns CP_PAYROLL_NAME, the formatted payroll name used on the report.
• CP_GRE_P — Returns CP_GRE, a general reporting element or grouping label, defaulted to the literal 'All'.

The accessor functions exist solely because XML Publisher cannot reference package variables directly; the query must call a function returning a scalar value so that header values can be embedded in the data model.

Tables Accessed

• FND_SESSIONS — Read to retrieve the current concurrent request session context, allowing the package to attribute output to the correct request and user.
• PAY_CONSOLIDATION_SETS — Read to resolve the consolidation set parameter into its descriptive name for the header, and to restrict the query population to the selected set.

Both are accessed through APPS synonyms, consistent with the package's APPS ownership and the standard EBS integration pattern.

Usage Notes

The package is invoked exclusively through the concurrent program definition for PERCACEI. When a user submits the report, the concurrent manager calls the report executable, which in turn references this package's trigger functions and header accessors. It is not designed for direct call from application Forms, and no other packages reference it, so it carries no downstream dependency risk.

Because the object is a generated XML Publisher shell with version 120.0, customisations should be applied through the XML template or via a wrapper, not by editing the package body. Substituting a modified template is the supported path for changing report layout, while the header accessor functions must remain intact for the data model to resolve the CP_* placeholders, including CP_REPORT_TITLE_P, which is the specific accessor surfaced by the parameter search.