Search Results c_period_start_date_p




Overview
Explore in AI Chat

Overview

PAY_PAYUSEAR_XMLP_PKG is a generated PL/SQL package in the APPS schema that backs the Oracle Payroll XML Publisher (BI Publisher) report commonly identified as "Payroll Action Usage" or the associated US Payroll Action report (report short name PAYUSEAR). In Oracle EBS 12.1.1 and 12.2.2, XML Publisher concurrent programs are implemented as PL/SQL packages produced by the XML Publisher template/definition generator. The package name suffix _XMLP_PKG identifies it as a report-support package whose public functions are invoked by the Oracle Reports/XML Publisher runtime during execution of the concurrent program.

The business purpose of this package is to supply the after-processing logic and data-select wrappers for a payroll report that lists payroll actions together with tax unit information, consolidation set, payroll, and time-period context. It receives user-supplied runtime parameters (such as business group, payroll action, consolidation set, time period, tax unit, and element type) and resolves them into descriptive values used by the report layout.

Key Procedures and Functions

  • BeforeReport — Fired before the report data query executes; typically used to initialize package-level globals and perform setup validation.
  • AfterReport — Fired after report generation; used to release resources and finalize processing.
  • tax_unit_addressformula — A formula function that returns a tax unit address string given a location identifier.
  • c_valueformula — A value-formatting formula that accepts a value, a unit of measure, and a currency and returns a formatted display string. This is the function associated with the user's search term "c_valueformula".
  • G_tax_unit_headerGroupFilter — A group filter used to conditionally include or exclude rows in the tax unit header group of the report.
  • C_TAX_UNIT_ADDRESS2_p, C_BUSINESS_GROUP_NAME_p, C_CONSOLIDATION_SET_NAME_p, C_TIME_PERIOD_NAME_p, C_PAYROLL_NAME_p, C_PAYROLL_ACTION_p, C_TAX_UNIT_p, C_PERIOD_START_DATE_p, C_PERIOD_END_DATE_p, C_ELEMENT_TYPE_NAME_p — Accessor ("_p") functions that expose the corresponding package-level lexical variables to the report layout as columns or parameters.

Tables Accessed

The ETRM metadata for this object does not enumerate referenced tables through APPS synonyms. In practice, the underlying data query joins payroll and HR tables such as PER_BUSINESS_GROUPS, PAY_PAYROLL_ACTIONS, PAY_PAYROLLS_F, PAY_CONSOLIDATION_SETS, PAY_TIME_PERIODS, PAY_TAX_UNITS, and PAY_ELEMENT_TYPES to populate the lexical variables declared at the top of the package. Because the package is a report wrapper, most data access occurs in the SQL query rather than inside the PL/SQL functions themselves; the functions primarily format and expose already-retrieved values.

Usage Notes

This package is not intended to be called directly by custom code. It is invoked by the Oracle XML Publisher / Oracle Reports runtime when the associated concurrent program is submitted from the Payroll responsibility. Report definitions reference the public functions (for example, c_valueformula and the _p accessors) directly in their data templates and RTF layouts.

Customizations should be avoided in the APPS-owned package; instead, developers typically copy the report definition or extend the template. The package carries the standard Oracle proprietary header and is supported across both 12.1.1 and 12.2.2 releases. It is referenced by zero other packages, confirming it is a terminal report-support unit rather than a shared library.