Search Results cf_legislation_codeformula

Overview

APPS.PAY_PYAUFBR_XMLP_PKG is a report-support PL/pgSQL package body associated with an Oracle Payroll XML Publisher (BI Publisher) concurrent program. The suffix XMLP_PKG identifies it as the generated data-definition/helper package for a specific concurrent report, in this case the "PYAUFBR" report (Australian jurisdiction, based on the "PYAU" prefix typically used for Australian Payroll localizations). The package encapsulates the report's formula columns and lifecycle triggers needed to prepare binding parameters, fetch descriptive business-group attributes, and format output values before the XML template is rendered.

The object contains seven documented procedures/functions. Its formula functions are invoked by the XML Publisher engine at report execution time to populate dynamic columns, and its initialization logic populates the concurrent program parameters prior to data retrieval.

Key Procedures and Functions

• AFTERREPORT — Report-level trigger executed after all data is processed; it simply returns TRUE, providing a placeholder for post-report processing.
• BEFOREREPORT — Report-level trigger executed before data retrieval. It formats the start and end date parameters into 'DD-MON-YYYY' character format and captures the concurrent request ID using FND_GLOBAL.CONC_REQUEST_ID.
• CF_BUSINESS_GROUPFORMULA — Formula column that resolves and returns the business group name by calling HR_REPORTS.GET_BUSINESS_GROUP with the business group ID parameter.
• CF_LEGISLATION_CODEFORMULA — Formula column that returns the legislation code from HR_ORGANIZATION_INFORMATION. It is the object associated with the "cf_legislation_codeformula" search term, since the report formula name maps directly to this PL/SQL function.
• CF_CURRENCY_FORMAT_MASKFORMULA — Formula column that derives a currency formatting mask based on the legislation/territory code by querying FND_CURRENCIES for the matching issuing territory.
• CF_EXISTSFORMULA — Formula column that determines whether a qualifying record exists, returning a boolean-style indicator for the report output.
• CP_CURRENCY_CODE_P — Concurrent program parameter/procedure used to supply or resolve the currency code value consumed elsewhere in the report.

Tables Accessed

• HR_ALL_ORGANIZATION_UNITS — Read to retrieve the organization unit name, used by CF_BUSINESS_GROUPFORMULA via HR_REPORTS.GET_BUSINESS_GROUP.
• HR_ORGANIZATION_INFORMATION — Read to obtain the legislation code stored in ORG_INFORMATION9, filtered by organization ID and the 'Business Group Information' context. This supplies the CF_LEGISLATION_CODEFORMULA value.
• FND_CURRENCIES — Read to map the issuing territory code (derived from the legislation code) to a currency code, which drives the currency format mask.

Usage Notes

PAY_PYAUFBR_XMLP_PKG is invoked indirectly through the Oracle Payroll concurrent manager when the associated XML Publisher report is submitted. The Oracle Reports/XML Publisher runtime automatically calls the BEFOREREPORT and AFTERREPORT triggers, and invokes each CF_* formula function for the corresponding template field. The report is not called programmatically by other packages (referenced by zero packages in ETRM), and it should not be modified directly by custom code without re-generation through the appropriate Oracle Payroll localization patch, as the $Header line indicates Oracle-managed source versioning. Administrators should note that the legislation code retrieved with the 'Business Group Information' context must be populated in HR_ORGANIZATION_INFORMATION for the report parameters to resolve correctly.