Search Results f4_p_name1




Overview
Explore in AI Chat

Overview

APPS.PER_PERCAEER_XMLP_PKG is a report-support package that backs an Oracle Human Resources legislative reporting concurrent program, identified by the source header as PERCAEERS.pls and dated 2007/12/28, revision 120.0. The "PERCAEER" prefix denotes a Person/HR (PER) CA (Canada) Employee Earnings Report, and the "_XMLP_PKG" suffix confirms it is the generated PL/SQL package that Oracle Reports associates with an XML Publisher (XMLP) report definition. In Oracle EBS 12.1.1 and 12.2.2, concurrent programs that run Oracle Reports often emit a data model implemented through such a package; the report template invokes package-level functions to compute column values for the output layout.

The package declares an AUTHID CURRENT_USER specification, meaning it executes with the privileges of the calling user, consistent with APPS-schema concurrent processing conventions. Its body of package-level variables holds bind and report-parameter values (business group, session date, report title, concurrent request ID, reporting year, NAIC code, and date ranges for all and temporary employees) plus computed global variables for business group name and report subtitle. These globals are populated by the BeforeReport function and then consumed by the report's column formulas.

Key Procedures and Functions

The documented interface contains 30 procedures and functions, divided into formatting formulas and aggregation formulas. Each is a report formula column invoked by the XML Publisher/Oracle Reports engine during report execution.

  • BEFOREREPORT — the standard report trigger function; initializes package globals and prepares the parameter state before rows are fetched.
  • CF_F5_N_PROMPTFORMULA — the formula the user searched for; a character-valued function that renders the prompt/label text associated with the F_5 repeating group in the report layout.
  • CF_F5_N_* series — numeric aggregation formulas covering totals, medical aid (MA), foreign earnings (FE), and additional benefits (AB) dimensions, each supplied in total, medical-aid, foreign-earnings, and additional-benefit variants (TOTALFORMULA, TOTMAFORMULA, TOTFEFORMULA, TOTABFORMULA, MAABFORMULA, FEABFORMULA, TOTVIFORMULA, MAVIFORMULA, FEVIFORMULA, TOTDIFORMULA, MADIFORMULA, FEDIFORMULA). Each returns a number and accepts an F4_N_TYPE discriminator to select the earnings or deduction category to sum.
  • CF_F5_P_* series — the parallel set of formulas for the P (period/person) repeating frame, whose signatures also accept an F4_P_TYPE and F4_P_NAME1 value so aggregation can be scoped to a specific named element.

The consistent CF_F5 naming indicates the report's fifth repeating frame, F_5, whose columns are populated exclusively through these functions.

Tables Accessed

The package references three objects through APPS synonyms:

  • PER_CA_EE_REPORT_LINES — the Canadian employee earnings report detail table; the primary source of the earnings, medical aid, foreign earnings, and benefit amounts that the CF_F5 aggregation formulas sum.
  • DUAL — used for single-row lookups and scalar initialization within formulas.
  • PLITBLM — an Oracle Reports internal table used in conjunction with report-level summary and aggregate processing.

The ETRM metadata records reads against these objects; no insert, update, or delete activity is documented, consistent with the report-only role of the package.

Usage Notes

PER_PERCAEER_XMLP_PKG is not an application programming interface. It is generated report infrastructure and is not referenced by any other package (ETRM records zero referencing packages), nor should it be called from forms or custom code. It is invoked indirectly when the associated Canadian Employee Earnings Report concurrent program is submitted, at which point the Oracle Reports runtime calls BEFOREREPORT and then the CF_F5 formulas for each row of the F_5 frame. Because the package is AUTHID CURRENT_USER and compiled into APPS, any customization or debugging should be performed through the report definition and the concurrent program parameters (business group, year, NAIC code, session date, employee date ranges) rather than by modifying the package directly, since a report regeneration will overwrite it.