Search Results chk_us_visa_rows

Overview

APPS.PER_US_VALIDATE_PEI is a United States localization validation package within the Oracle E-Business Suite Human Resources (Oracle HRMS / PER) product family. Its documented purpose is to perform record-level validation for US Visa Person Extra Information (PEI) types. The package header indicates that detailed validation rules are maintained externally at $DOCS_TOP/per/projects/visa/visahld.doc, confirming that the packaged logic implements a defined set of statutory or business rules governing visa-related extra information records.

The package is classified as an "Other" API, meaning it is not part of Oracle's public, supported API surface. The header explicitly states an "Access Status" of "Internal Table Handler Use Only," which restricts supported invocation to internal HRMS table handler mechanisms rather than direct calls from external integrations or custom code.

Key Procedures and Functions

The ETRM metadata documents a single procedure: CHK_US_VISA_ROWS. This procedure applies the defined validation rules for US Visa PEI records. Based on the package header comments, its behavior contract is as follows:

• Purpose: Record-level validation for US Visa PEI types, executed against the extra information attributes supplied at the row level.
• Inputs: The procedure accepts a person identifier along with an information type and a set of Person Extra Information attributes (documented in the source as pei_information5 through pei_information11). These attributes carry the visa-specific fields subject to validation.
• Post Success: Processing continues normally, allowing the validated record to be committed through the calling table handler.
• Post Failure: An application error is raised and processing is terminated, preventing an invalid visa PEI row from being stored.

No additional procedures or functions are documented in the ETRM object metadata.

Tables Accessed

The documented table reference is PER_PEOPLE_EXTRA_INFO, accessed via APPS synonyms. This is the HRMS table that stores the extra information (PEI) records associated with a person. The validation package reads from or checks against this table to evaluate whether the supplied visa attributes are consistent with existing person extra information data and with the applicable US Visa validation rules. Because the package operates as a table handler validation routine, its interaction with PER_PEOPLE_EXTRA_INFO occurs in the context of insert or update processing on that table.

Usage Notes

PER_US_VALIDATE_PEI is referenced by two other packages, indicating that it is invoked indirectly as part of a broader HRMS extra information validation chain rather than being called directly by end users or standalone programs. It is characterized here as an internal table handler component.

• Forms: Typical invocation occurs through the Person Extra Information windows in Oracle HRMS, where a user enters or updates US Visa information for a person. The form's underlying table handler calls the validation routine before the record is saved.
• Concurrent programs / batch: The routine may also be exercised through batch or interface processing that writes US Visa PEI rows, since the same table handler validation applies to those paths.
• Custom code: Given the "Internal Table Handler Use Only" access status, direct invocation from custom code is not a supported practice. Any custom validation or data load that must respect US Visa PEI rules should route through the supported HRMS APIs for person extra information rather than calling this package directly.

Because the documented validation rules reside in a separate design document rather than in the ETRM object metadata, implementers should treat the packaged logic as the authoritative enforcement point and avoid duplicating or pre-empting its checks.