Search Results cf_end_dateformula

Overview

APPS.PAY_PYAUAPL_XMLP_PKG is the packaged PL/SQL body that backs the Oracle Payroll concurrent program report "PYAUAPL" (Australian Advance Pay and Leave report). It belongs to the Oracle HRMS / Payroll family of report packages, which are generated and version-controlled by Oracle Reports and stored in the database under the APPS schema. The package serves as the programmatic interface between the XML Publisher / Oracle Reports runtime engine and the underlying payroll base tables. Its core responsibility is to fetch, format, and expose report parameters — business group name, employee number, payroll name, advance/leave flags, and date values — before the report layout is rendered. The package header comment ($Header: PYAUAPLB.pls 120.1 2008/03/25) confirms that the body is maintained as a PL/SQL file and is uploaded during the EBS patching cycle.

Key Procedures and Functions

The package exposes fifteen documented program units, the majority of which are generated by Oracle Reports as user-exit or formula columns:

• AFTERREPORT — Boolean function invoked at the end of the report execution; returns TRUE and performs no additional processing in the delivered code.
• BEFOREREPORT — Boolean function executed before report output. It assigns the concurrent request ID, resolves employee number and payroll name lookups, and initializes the displayed flags and date substitutions.
• CF_BUSINESS_GROUPFORMULA — Returns the business group name by calling HR_REPORTS.GET_BUSINESS_GROUP for the supplied business group ID.
• CF_CURRENT_FUTURE_FLAGFORMULA — Returns the display value for the current/future advance flag based on the AU_ADV_FLAG lookup.
• CF_PROCESS_FLAGFORMULA — Returns the YES/NO lookup meaning used to render the process indicator.
• CF_END_DATEFORMULA and CF_DATE_CONVERSIONFORMULA — Formula functions that convert and format date values for the report layout, applying the CP_DATE_FORMAT session convention.
• CP_LEAVE_START_DATE_P, CP_PAY_DATE_P, CP_LEAVE_END_DATE_P, CP_LV_ADV_P, CP_CURRENT_P, CP_FUTURE_P, CP_YES_P, CP_NO_P — A set of placeholder/parameter procedures that expose the resolved date, leave-advance, current, future, and yes/no values to the report data model.

Tables Accessed

The package reads from three documented APPS synonyms:

• HR_ALL_ORGANIZATION_UNITS — sourced for the business group name via HR_REPORTS.GET_BUSINESS_GROUP.
• PAY_PAYROLL_ACTIONS — accessed to resolve payroll action and advance-pay context for the reported assignment.
• PAY_ASSIGNMENT_ACTIONS — read to obtain assignment-level action records that drive the advance pay and leave balances.

The BEFOREREPORT function also queries HR_LOOKUPS (for AU_ADV_FLAG and YES_NO lookup meanings), PER_PEOPLE_F (for the employee number), and PAY_PAYROLLS_F (for the payroll name). The package is read-only; it does not mutate payroll data.

Usage Notes

PAY_PYAUAPL_XMLP_PKG is invoked exclusively by its parent concurrent program PYAUAPL, which is registered in Oracle Payroll for Australian legislations. It is not referenced by any other package in the ETRM metadata, indicating a self-contained report boundary. The "cp_date_format" search term maps to the CP_DATE_FORMAT local variable declared in BEFOREREPORT, which governs the NLS date-format string used when the report converts and prints leave and pay dates. In EBS 12.1.1 and 12.2.2 patch levels this package is delivered as-is; customizations should be applied only through Oracle Reports user exits or XML Publisher templates rather than by directly editing the package body, since the body is regenerated on patch application.