Results for “child_support”

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

Overview

APPS.PAY_NZ_EMS is a New Zealand localization package within the Oracle E-Business Suite Payroll module. Its internal header comment — "EMS mag tape writer stuff" — identifies its purpose precisely: it generates the magnetic tape (and equivalent electronic file) output historically required by the New Zealand Inland Revenue Department's Electronic Filing Service, commonly abbreviated EMS. The package assembles payroll results, tax codes, student loan deductions, and period-of-service data into a flat-file layout suitable for submission to the Inland Revenue, replacing paper-based employer monthly schedules. The header carries a copyright date of 1999 and a last source revision of April 2007 (version 120.0.12000000.3), confirming the package has been part of the NZ payroll solution since the earliest releases of the product line and remains present through EBS 12.1.1 and 12.2.2.

The change history embedded in the package source evidences sustained maintenance across a decade of statutory and defect-driven work. Entries reference student loan tax calculation rules (reference 1864377), EMS issue fixes (2135629), correction of reporting start and finish dates (2276649), handling of employees with multiple assignments (2306743), and the treatment of employees whose start dates precede the payroll start date (2352807, raised against a TAR). Several revisions address performance, notably the removal of a dynamic view (2154439) and repeated adjustments to the c_detail cursor that supplies tax code, special tax code, and tax rate values.

Key Procedures and Functions

The ETRM metadata for this object lists no publicly documented procedures or functions; the package is classified as OTHER rather than as a callable API. The header excerpt and change list show that the substantive logic resides in internal constructs, principally the cursor c_detail, which is the query that drives the detail records written to the EMS output. Successive bug fixes were applied directly to this cursor, affecting how tax codes, special tax codes, tax rates, and student loan deductions are selected. One documented rule requires that the STC (special tax code) be displayed only where the student loan indicator is 'Y' and a PAYE tax rate is present; otherwise the ordinary tax code is reported. Another rule suppresses redundant columns in line with view changes, and a further fix ensures negative values in student loan deductions are handled correctly. The package also includes logic to report negative values in exception reporting. Because no parameter lists are exposed in the metadata, implementers should treat all entry points as internal to the NZ payroll file-generation flow.

Tables Accessed

The package reads from and writes to a defined set of payroll and HR tables through APPS synonyms. PAY_RUN_RESULTS and PAY_RUN_RESULT_VALUES provide the calculated earnings, deductions, and tax values for each assignment. PAY_ELEMENT_TYPES_F and PAY_INPUT_VALUES_F supply element and input value definitions, including the balancing and classification attributes needed to distinguish taxable pay, PAYE, and student loan components. PAY_ASSIGNMENT_ACTIONS and PAY_PAYROLL_ACTIONS establish the payroll run context and the set of assignments processed. PER_PERIODS_OF_SERVICE and PER_TIME_PERIODS supply the start and finish dates whose correct reporting was the subject of several bug fixes. PER_TIME_PERIODS records are also the source of the pay period boundaries used to date-stamp each returned record. HR_ORGANIZATION_INFORMATION and HR_SOFT_CODING_KEYFLEX resolve the employing organization and its IRD number and address details. FND_APPLICATION, FND_PRODUCT_INSTALLATIONS, and FND_SESSIONS are consulted for application context and installation checks.

Usage Notes

PAY_NZ_EMS is not intended for direct invocation by end users or by custom code. It is called from the New Zealand payroll file-generation programs that run during or immediately after the payroll action, drawing on the completed run results to produce the EMS output file. In a typical implementation it is invoked through a concurrent program rather than a form, and it is executed by the payroll administrator after the payroll run and any subsequent rollback or adjustment has been finalized. The referenced-by count of zero confirms the package is a top-level consumer of payroll data rather than a dependency of other packages. When troubleshooting EMS output — for example, mismatched tax codes, missing student loan deductions, incorrect start or finish dates, or omissions for employees with multiple assignments — the c_detail cursor should be the first area of investigation, as nearly all documented corrections to this package were applied there. Because the package name contains no version suffix and the header reflects a 2007 revision, the same source is expected to compile unchanged across both 12.1.1 and 12.2.2, with behavior governed by the underlying HR and PAY schema objects rather than by the package itself.