Search Results cp_period_end_date_p

Overview

The APPS.PAY_PYNZ345_XMLP_PKG package is a PL/SQL package specification that backs the Oracle E-Business Suite concurrent program associated with report PYNZ345, a New Zealand payroll statutory report delivered within the Oracle Payroll (PAY) product family. The package encapsulates the public variables, report-level triggers, and formula functions required by the Oracle Reports XML Publisher (XMLP) integration layer to produce the report output. Its internal naming convention — the PYNZ prefix combined with the XMLP_PKG suffix — identifies it as a report-serving package rather than a general-purpose business API, and the header comment (PYNZ345S.pls 120.0) confirms a New Zealand legislative reporting artifact maintained under the PAY schema.

Because the package is a report back-end, it does not expose reusable business logic to other modules. Instead, it exists to declare bind parameters, resolve display values, and compute derived report columns at runtime, all under the Oracle Reports PL/SQL execution model used in EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package specification documents nine callable program units, all of which are standard members of the XMLP report package pattern:

• BeforeReport — Report-level trigger executed prior to report data retrieval; used to initialize session state and derived package variables.
• AfterReport — Report-level trigger executed on report completion; used for cleanup and resource release.
• cf_total_deductionsformula — A report formula (cell formula) that aggregates the individual statutory deduction components — PAYE deductions, child support deductions, student loan deductions, and SSCWT (specified superannuation contribution withholding tax) deductions — into a single total deductions value for display. This is the object most directly matching the user search term cf_total_deductionsformula.
• CF_business_groupFormula — Returns the character description of the selected business group for report display.
• CF_registered_employerFormula — Returns the registered employer description, resolved from the employer identification parameter supplied by the concurrent program.
• CP_CURRENCY_FORMAT_p — Accessor returning the formatted currency mask applied to monetary columns.
• CP_CURRENCY_CODE_p — Accessor returning the currency code used to label report amounts.
• CP_PERIOD_START_DATE_p — Accessor returning the derived start date of the reporting period.
• CP_PERIOD_END_DATE_p — Accessor returning the derived end date of the reporting period.

The four CP_-prefixed accessors correspond to the package-level variables CP_CURRENCY_FORMAT, CP_CURRENCY_CODE, CP_PERIOD_START_DATE, and CP_PERIOD_END_DATE declared in the specification, together with the input parameters P_Business_Group_ID, P_REGISTERED_EMPLOYER_ID, P_PERIOD_END_DATE, and P_CONC_REQUEST_ID.

Tables Accessed

Two base tables are referenced through APPS synonyms:

• FND_CURRENCIES — Consulted to resolve currency precision, format mask, and code information for the monetary columns of the report.
• HR_ORGANIZATION_INFORMATION — Consulted to resolve organization-level descriptive attributes, in particular the business group and registered employer details returned by the corresponding formula functions.

No other table access is documented; the substantive payroll deduction data itself is supplied by the report's SQL query, with cf_total_deductionsformula operating purely on values passed into it.

Usage Notes

The package is not referenced by any other documented package (referenced by 0), confirming that it functions solely as a report execution artifact. It is invoked indirectly whenever the PYNZ345 concurrent program is submitted from Payroll Manager responsibilities or via the standard Submit Request form. Custom code should not call these program units directly, because their signatures and behavior are tied to the report definition and may change between legislation patch levels. For diagnostic purposes, the package body is the relevant object to inspect for the logic behind cf_total_deductionsformula; the specification only declares the interface. Because the report serves New Zealand statutory reporting, its applicability is limited to legislation-enabled installations with a New Zealand business group configured.