Search Results per_us_visa_details

Overview

APPS.PER_US_VALIDATE_PEI is a United States localization package body within the Oracle E-Business Suite Human Resources (PER) product family. Its business function is to enforce country-specific data validation rules for US Visa Person Extra Information (PEI) records stored against the PER_PEOPLE_EXTRA_INFO entity. The package belongs to the "OTHER" API classification in ETRM, indicating it is an internal, non-public interface rather than a supported integration API.

The package is part of the US legislative/regulatory layer that captures visa and passport details for employees and applicants. Its central responsibility is record-level validation of US Visa PEI types, ensuring that user-entered visa data conforms to the documented validation rules before it is persisted. The rules themselves are documented externally in $DOCS_TOP/per/projects/visa/visahld.doc, referenced directly in the package header, and include date-range consistency checks across related PEI entities. The package carries the noship header tag, confirming it ships with the application but is not exposed as a public API.

Key Procedures and Functions

• CHK_US_VISA_ROWS — The single documented procedure in the package. It performs record-level validation for US Visa PEI types, inspecting the person identifier, the information type, and the incoming PEI information columns (information5 through information11) that carry the visa attributes. On success, processing continues normally. On failure, the procedure raises an application error and terminates processing. The procedure also validates START_DATE and END_DATE values for the related PER_US_PASSPORT_DETAILS, PER_US_VISA_DETAILS, and PER_US_VISIT_HISTORY PEI entities, and applies canonical date conversion to the relevant PEI information columns, addressing the fix tracked under WWBUG 2097669. Its access status is documented as "Internal Table Handler Use Only."

Tables Accessed

• PER_PEOPLE_EXTRA_INFO — The sole referenced table, accessed via its APPS synonym. This is the generic Person Extra Information store that holds flexfield-style attribute records for a person. The package reads and validates PEI rows for visa and related information types from this table. It does not maintain a dedicated US visa table; visa data is modeled as PEI information type records, which is why validation logic operates on the generic PEI structure and the indexed information columns.

Usage Notes

PER_US_VALIDATE_PEI is an internal table handler intended to be invoked by the US localization data-entry paths rather than called directly from custom code. In practice it is triggered when US Visa PEI records are created or updated through the relevant person information forms (typically the Person Extra Information / visa maintenance windows in the US HRMS localization), or when the supporting PL/SQL processing that manages US visa details performs record validation. Because the procedure raises an application error on failure, it acts as a gatekeeper: invalid or inconsistent visa rows, including bad start/end date combinations across passport, visa, and visit-history records, are rejected before commit.

The ETRM metadata records that this package is referenced by two other packages, confirming its role as a shared validation primitive within the US PER localization dependency chain. When searching for "per_us_visa_details," users are typically looking for the visa data structure; this package is the validation component associated with it. Oracle does not document CHK_US_VISA_ROWS as a public API, so customizations should target the supported person extra information APIs and forms rather than invoking this procedure directly. Given its dependency footprint, any modification should be treated as a localization patch subject to Oracle support impact.