Search Results lookup_meaning

Overview

APPS.PAY_PYNZREC_XMLP_PKG is the generated PL/SQL package body that backs the Oracle E-Business Suite concurrent report PAYNZREC, a New Zealand payroll reconciliation report. The package is classified as OTHER in the ETRM metadata and follows the standard Oracle Reports XML Publisher (XMLP) integration pattern, in which a report definition references a database package whose formula functions supply derived column values and initialization logic at report execution time. The "PY" prefix identifies the module as Oracle Payroll, while "NZREC" denotes the New Zealand reconciliation report. The package operates within the APPS schema and is invoked at runtime by the Oracle Reports engine through the user exit mechanism that is standard for EBS report integration, as evidenced by the commented FND SRWINIT and FND SRWEXIT calls retained in the source.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions, categorized as formatting formulas and report lifecycle hooks. The two lifecycle functions, AFTERREPORT and BEFOREREPORT, bracket report execution; BEFOREREPORT initializes the substitution variables cp_input_value_name, cp_uom, and cp_report_name, while AFTERREPORT provides a termination hook, both currently containing only null placeholders for the legacy SRW user exits.

Several functions are formula callbacks that resolve display values for report columns. CF_BUSINESS_GROUPFORMULA returns the business group name by calling hr_reports.get_business_group with the p_business_group_id bind parameter. CF_PAYROLL_RUN_DISPLAYFORMULA constructs a composite payroll run label by concatenating payroll name, period name, the lookup meaning of the ACTION_TYPE lookup, and the display run number. CF_LEGISLATION_CODEFORMULA derives the legislation code from HR_ORGANIZATION_INFORMATION, and CF_SORT_ORDER_DISPLAYFORMULA and CF_CURRENCY_FORMAT_MASKFORMULA provide ordering and numeric masking values respectively. CF_PAYROLL_RUN_DISPLAYFORMULA directly references the fcl.meaning column from HR_LOOKUPS, which is the column most closely associated with the user search term "lookup_meaning."

The remaining functions are parameter accessors: CP_INPUT_VALUE_NAMEFORMULA, CP_UOMFORMULA, and CP_REPORT_NAMEFORMULA return the initialization values for the report parameters, while the companion procedures CP_INPUT_VALUE_NAME_P, CP_UOM_P, and CP_REPORT_NAME_P serve as the corresponding setters invoked during BEFOREREPORT.

Tables Accessed

The package reads from six tables through APPS synonyms. HR_ALL_ORGANIZATION_UNITS provides the business group name. HR_ORGANIZATION_INFORMATION supplies the legislation code via the org_information9 column. PAY_ALL_PAYROLLS_F, PAY_PAYROLL_ACTIONS, and PER_TIME_PERIODS are joined in the payroll_run cursor to resolve the payroll name, time period, action type, and display run number used by CF_PAYROLL_RUN_DISPLAYFORMULA. HR_LOOKUPS (referenced as fcl in the source and documented in the metadata) is joined on lookup_type and lookup_code to retrieve the lookup meaning for the payroll action type. FND_CURRENCIES supports the currency format mask formula. All access is read-only; the package performs no DML.

Usage Notes

The package is invoked exclusively by the Oracle Reports runtime when the PAYNZREC concurrent program is submitted, and it is not referenced by any other package, consistent with the documented "Referenced by 0 other packages" metadata. The naming convention of paired F/P suffixed objects (for example, CP_INPUT_VALUE_NAMEFORMULA and CP_INPUT_VALUE_NAME_P) is generated automatically when a report parameter's source is defined as a PL/SQL package function, and this convention should be preserved in any 12.1.1 or 12.2.2 customization. The behavior of the report is sensitive to the ACTION_TYPE lookup configured in HR_LOOKUPS, since any change to its lookup meanings alters the header text of every payroll run displayed. Because the package lives in the APPS schema and reads organization and payroll data, any modification requires careful validation in a test environment before deployment.