Results for “pay_nz_ems”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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.
-
PACKAGE: APPS.PAY_NZ_EMS 12.1.1
-
PACKAGE: APPS.PAY_NZ_EMS 12.2.2
-
PACKAGE: APPS.PAY_NZ_EMS 12.1.1
-
PACKAGE: APPS.PAY_NZ_EMS 12.2.2
-
SYNONYM: APPS.FND_SESSIONS 12.1.1
-
12.1.1 DBA Data 12.1.1
-
SYNONYM: APPS.FND_SESSIONS 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
VIEW: APPS.PER_ASSIGNMENTS_F 12.1.1
-
VIEW: APPS.PER_PEOPLE_F 12.1.1
-
VIEW: APPS.PER_PEOPLE_F 12.2.2
-
VIEW: APPS.PER_ASSIGNMENTS_F 12.2.2
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.