Search Results p_postcode_p




Overview
Explore in AI Chat

Overview

APPS.PAY_PYNZSOE_XMLP_PKG is a report-support PL/SQL package used by the Oracle E-Business Suite Payroll module for the New Zealand Statutory Order of Earnings (SOE) report. It follows the standard Oracle XML Publisher (XMLP) concurrent program architecture, in which a database package supplies the report parameters, initialization logic, format triggers, and computed formula columns, while the XML Publisher template handles the visual presentation. The package is declared AUTHID CURRENT_USER and executes with the privileges of the invoking user, which in this context is normally the APPS schema through a concurrent program request.

The package was created to retrieve payroll data, calculate cumulative balances, and format monetary and address values required by the New Zealand statutory earnings statement. The header comment referencing PYNZSOES.pls and a 2007 revision date places the package within the New Zealand localization for Release 12. The package is self-contained and is not referenced by any other database package, meaning it functions solely as the data source for its associated report definition.

Key Procedures and Functions

The documented 32 procedures and functions fall into several logical groups:

  • BeforeReport and AfterReport — Standard XML Publisher report entry points. BeforeReport performs report-level initialization, including setting up the WHERE and ORDER BY clauses and other global variables. AfterReport provides cleanup or final processing when the report completes.
  • F_GET_DETAILSFORMULA — Returns assignment-level detail used in the report body, taking assignment, person, and location identifiers along with the date earned and a home office indicator.
  • F_GET_CUMULATIVE_LEAVE_BALFORM — Calculates the cumulative leave balance for an assignment based on leave absence type, payroll, business group, accrual plan, and period end date.
  • CF_GET_MISCELLANEOUS_VALUESFOR — The formula the user searched for. It is a format/computed formula that retrieves miscellaneous payroll values for display on the report, typically elements or balances that do not fall into the standard earnings or deduction categories.
  • Balance and amount formulas — CF_AMOUNT_PAIDFORMULA, CF_NET_THIS_PAYFORMULA, CF_NET_YTDFORMULA, and CF_CURRENCY_FORMAT_MASKFORMULA compute amount paid, net pay for the current period, net pay year-to-date, and the applicable currency format mask.
  • Parameter and group filters — G_ASG_PAYMENTS_BREAK_GGROUPFIL defines the group filter; the P_ and CP_ prefixed procedures (P_ADDRESS_LINE_1_P through P_POSITION_NAME_P, and CP_NON_TAX_ALLOW_THIS_PAY_P through CP_GROSS_YTD_P) are parameter-validation and format-trigger procedures that populate or validate the corresponding package-level variables.

Tables Accessed

The package references two documented tables through APPS synonyms:

  • FND_CURRENCIES — Consulted to derive currency information and the currency format mask, supporting the CF_CURRENCY_FORMAT_MASKFORMULA logic and correct monetary formatting on the report.
  • PAY_PAYROLL_ACTIONS — Used to validate and resolve payroll action identifiers supplied as report parameters, supporting the payroll action and payroll name determination for the SOE run.

Usage Notes

PAY_PYNZSOE_XMLP_PKG is invoked indirectly whenever the New Zealand Statutory Order of Earnings concurrent program is submitted. The Oracle Reports or XML Publisher runtime engine calls BeforeReport at the start of execution, uses the formula functions to derive computed columns in the data model, and calls AfterReport at the end. The package should not be called directly from custom forms or ad-hoc code, since its variables are populated by the report runtime environment. Developers extending the report must use the same parameter names defined in the package, as the concurrent program and report data model bind directly to them. Any modification should be treated as a localization customization and reapplied after patching.