Results for “result_ptd”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PAY_NZ_REC_PKG is a New Zealand localization package within the Oracle E-Business Suite Payroll (PAY) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. Its header reference (pynzrec.pkh, version 115.2, dated December 2002) confirms it as a long-standing component of the New Zealand payroll statutory framework. The package provides calculation and reconciliation functions that support New Zealand-specific payroll processing, particularly around payment dating, assignment action sequencing, and period-to-date (PTD) and year-to-date (YTD) balance derivation.

The classification of OTHER indicates it is not a public, fully supported API in the strictest sense, but rather an internal calculation package invoked by seeded payroll formulas, balance feeds, or concurrent processes unique to the NZ legislation. It acts as a bridge between the core payroll engine tables and the reporting or compliance logic that New Zealand payroll requires.

Key Procedures and Functions

• PERIOD_PAYMENT_DATE — Returns the regular payment date associated with a given time period, allowing payroll processes to resolve the correct pay date for a period.
• FIRST_ACTION_SEQUENCE — Retrieves the earliest action sequence for an assignment within a time period, used to identify the starting point of payroll processing for that assignment.
• LAST_ACTION_SEQUENCE — Retrieves the latest action sequence for an assignment within a payroll action, used to identify the terminating action in a run.
• RESULT_PTD — Returns the period-to-date result value for an assignment and element type, supporting cumulative period reporting.
• RESULT_YTD — Returns the year-to-date result value for an assignment and element type, supporting cumulative annual reporting.
• SINGLE_FEED_BALANCE — Determines whether a single balance feed exists for a given assignment action and element type, returning the associated assignment action, balance type, and effective start date.
• VALUE_PTD — Returns the period-to-date value for an assignment and element type, typically sourced from balance or run result data.
• VALUE_YTD — Returns the year-to-date value for an assignment and element type.

Tables Accessed

The package reads and references several core payroll tables through APPS synonyms. PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS provide the payroll run and assignment action context that drives sequencing and result lookup. PAY_ELEMENT_TYPES_F supplies element type definitions for the PTD/YTD functions. PAY_BALANCE_FEEDS_F, PAY_BALANCE_TYPES, and PAY_BALANCE_CLASSIFICATIONS underpin the balance feed logic in SINGLE_FEED_BALANCE. PAY_RUN_RESULTS and PAY_RUN_RESULT_VALUES supply the underlying result data for RESULT_PTD, RESULT_YTD, VALUE_PTD, and VALUE_YTD. PER_TIME_PERIODS provides the payment date used by PERIOD_PAYMENT_DATE, and PAY_INPUT_VALUES_F supports element input value resolution.

Usage Notes

Given its internal classification and zero documented dependents, PAY_NZ_REC_PKG is ordinarily invoked indirectly by seeded New Zealand payroll formulas, balance feeds, or FastFormula constructs rather than by user-facing forms or standalone concurrent programs. Custom code extending NZ payroll reconciliation should call these functions only where the seeded formulas already rely on them, to preserve calculation consistency. Because the package is AUTHID CURRENT_USER, execution inherits the privileges of the calling user, which matters when invoked from custom PL/SQL executed under a non-APPS schema. Its presence in both 12.1.1 and 12.2.2 reflects continuity of the NZ localization across releases.