Search Results pay_nz_ems




Overview
Explore in AI Chat

Overview

APPS.PAY_NZ_EMS is a stub package body within the Oracle E-Business Suite New Zealand payroll module. Its header comment identifies it as "EMS mag tape writer stuff," indicating that it was designed to produce the Electronic Magnetic media Submission (EMS) output file used for New Zealand Inland Revenue Department (IRD) statutory reporting. EMS is the legacy media format through which New Zealand employers electronically deliver PAYE, employer superannuation contribution (ESCT), and related deduction information to the IRD. The package body, last modified under version 120.0.12000000.1 on 17 January 2007, contains no executable logic beyond the package header and a single terminating end pay_nz_ems; statement. It represents a placeholder or a package whose implementation was superseded by an alternative delivery mechanism for IRD electronic filing. In Oracle EBS 12.1.1 and 12.2.2 the package remains in the APPLSYS/APPS schema as a compiled but inert object.

Key Procedures and Functions

The ETRM metadata for this package documents zero procedures or functions. The source excerpt confirms this: after the package declaration and header comments, the body proceeds directly to the closing end statement, with no internal subprogram definitions. Consequently, there are no public or private callable units to describe, and no parameter lists can be documented. Any historical interface that may have existed — for example, a routine to format or write EMS magnetic media records — is not present in the shipped body. Developers should therefore treat PAY_NZ_EMS as an empty namespace rather than a callable API.

Tables Accessed

Although the package body contains no executable code, the ETRM metadata lists the following referenced tables via APPS synonyms: FND_APPLICATION, FND_PRODUCT_INSTALLATIONS, FND_SESSIONS, HR_ORGANIZATION_INFORMATION, HR_SOFT_CODING_KEYFLEX, PAY_ASSIGNMENT_ACTIONS, PAY_ELEMENT_TYPES_F, PAY_INPUT_VALUES_F, PAY_PAYROLL_ACTIONS, PAY_RUN_RESULTS, PAY_RUN_RESULT_VALUES, PER_PERIODS_OF_SERVICE, and PER_TIME_PERIODS. These references reflect the data set an EMS filing routine would require: run results and input values to compute PAYE and ESCT; element type definitions; payroll action and assignment action context; periods of service and time periods for pay-period alignment; organization information and soft coding key flexfield values for employer identification; and the FND tables for application registration, installation status, and session context. Because the current body performs no reads or writes, these dependencies are latent and do not affect runtime behavior.

Usage Notes

PAY_NZ_EMS is not invoked by any documented concurrent program, form, or package call in the 12.1.1 / 12.2.2 reference metadata; the ETRM record shows zero packages referencing it. It is not exposed through a PL/SQL API classification beyond OTHER. Customers upgrading from earlier releases who encounter the package name in historical SQL, wrapper scripts, or internal documentation should verify whether their localization requires a supported New Zealand IRD electronic filing path, such as the delivered payroll archiver or the applicable IRD gateway integration, rather than attempting to call this body. Customizations must not add logic to an Oracle-owned APPS package; such changes are unsupported and are overwritten during patching. Where an EMS-format extract is genuinely required, the appropriate approach is a separate custom package or concurrent program that selects from the same payroll and HR tables identified above.