Search Results cp_input_value_nameformula




Overview
Explore in AI Chat

Overview

PAY_PYNZREC_XMLP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the "OTHER" API category. It functions as the generated report logic package (the "_XMLP_PKG" suffix indicates an Oracle XML Publisher / BI Publisher concurrent report wrapper) for the New Zealand Payslip / Payroll Reconciliation report, identified by the source header "PYNZRECS.pls". The package encapsulates the server-side PL/SQL that drives the report's data retrieval, formula evaluation, and formatting at runtime, including the two mandatory report triggers AfterReport and BeforeReport.

The business purpose is to produce a New Zealand statutory payroll reconciliation output driven by a concurrent request. Correspondingly, the package declares global state variables such as P_BUSINESS_GROUP_ID, P_SORT_ORDER, P_PAYROLL_ACTION_ID and P_CONC_REQUEST_ID, which carry the concurrent program's input parameters from the request into the report queries. Three character parameters — CP_input_value_name, CP_UOM and CP_report_name — hold display values that are resolved by dedicated formula functions and exposed to the report template, while CF_legislation_codeFormula and cf_currency_format_maskformula derive the legislation and currency formatting appropriate to the New Zealand (NZ) localization.

Key Procedures and Functions

  • BeforeReport — Standard report trigger executed prior to data retrieval; establishes setup context before the query runs.
  • AfterReport — Standard report trigger executed after data retrieval completes; performs post-processing/cleanup.
  • CF_business_groupFormula — Resolves the business group display value from the business group identifier.
  • CF_payroll_run_displayFormula — Derives the payroll action/run display label for the report.
  • CF_legislation_codeFormula — Returns the legislation code used to drive localization-specific behavior.
  • CF_sort_order_displayFormula — Formats the sort order value for presentation on the report.
  • cf_currency_format_maskformula — Accepts a legislation code and returns the currency format mask, providing localized currency rendering.
  • CP_input_value_nameFormula, CP_UOMFormula, CP_report_nameFormula — Compute the display values for the corresponding concurrent program inputs (value name, unit of measure, and report name).
  • CP_input_value_name_p, CP_UOM_p, CP_report_name_p — Accessor functions that return the current value of the corresponding parameter variables.

Tables Accessed

The package references the following tables through APPS synonyms:

Usage Notes

This package is invoked indirectly: it is not called by other PL/SQL packages (referenced by 0 packages per the ETRM metadata). It is executed when the associated XML Publisher concurrent program for the NZ payroll reconciliation is submitted. The concurrent manager passes the business group, sort order, payroll action and request identifiers into the package globals; the report engine then fires BeforeReport, evaluates the formula functions to populate the report template placeholders (including the cp_input_value_name, uom and report_name display values), and finally fires AfterReport.

Because the object is classified OTHER, it is not a supported public API. Customizations should be limited to configuration of the concurrent program and its template; direct calls or extensions to the package functions are not recommended, as Oracle may regenerate the package when the underlying XML Publisher report definition changes. In EBS 12.1.1 and 12.2.2 the package resides in the APPS schema and is invoked under the standard Apps database session context.