Search Results validate_acct

Overview

The APPS.HR_NZ_BANK_ACCT_VALIDATION package is a New Zealand-specific payroll and HR utility within Oracle E-Business Suite. Its purpose is to perform country-specific validation of New Zealand bank account details captured against employee, applicant, or payroll payment records. The package encapsulates the algorithmic validation logic required for NZ bank account numbers, ensuring that data entered into Oracle HRMS and Oracle Payroll conforms to the local numbering conventions governing New Zealand financial institutions before it is used for electronic funds transfer (EFT) and direct credit payment processing.

The package declares a single public function, VALIDATE_ACCT, and is owned by the APPS schema, consistent with other Oracle HRMS localisation packages. It is classified in the ETRM repository as an OTHER API, indicating that it is not published as a formal public interface but is nonetheless a recognised object in the EBS code base. It is referenced by one other package, which means validation logic is consumed internally by broader HRMS localisation routines rather than being invoked directly by end users.

Key Procedures and Functions

• VALIDATE_ACCT — The sole documented function in the package. It validates a New Zealand bank account, taking the bank/branch number, the account number, and the account suffix as inputs and returning a VARCHAR2 result. The function is declared with the PRAGMA RESTRICT_REFERENCES(..., WNDS) directive, confirming that it performs no database writes; it is a pure validation routine that reads no tables and mutates no data. This makes it safe for use inside SQL statements, DML triggers, and forms validation blocks where read-consistency is required.

The return value conveys the outcome of the validation check, allowing calling code to accept, reject, or flag the supplied bank account details. Because the function is free of side effects, it is well suited to repeated invocation during data entry.

Tables Accessed

Based on the documented metadata, the package references no tables through APPS synonyms. This is consistent with its design: VALIDATE_ACCT is a deterministic, algorithm-driven validation routine that evaluates the structure and format of the bank account components rather than checking them against a database table of valid bank identifiers. The WNDS pragma further guarantees no write activity. Any lookup or configuration data required for validation is handled internally by the algorithm rather than by querying the schema.

Usage Notes

The package was created in May 1999 and carries a header version of 120.0.12010000.1, reflecting its R12 lineage; it remains valid in both 12.1.1 and 12.2.2. In practice, VALIDATE_ACCT is invoked when New Zealand bank account details are entered or updated for payroll payments, typically from Oracle Forms-based HRMS screens and from the payroll EFT preparation flow. Because it is referenced by another package, the primary consumer is likely a localisation wrapper that feeds validated account data into external payment file generation.

Developers extending NZ payroll functionality may call HR_NZ_BANK_ACCT_VALIDATION.VALIDATE_ACCT directly from custom PL/SQL or forms triggers, but should note that the package is not documented as a supported public API. The return value should be inspected and handled explicitly. Given the package's WNDS restriction, invoking it within SQL is permitted. Customisations should avoid modifying the package body, as patches may overwrite the logic in future EBS maintenance releases.