Search Results person_check_nra_status_create




Overview
Explore in AI Chat

Overview

APPS.PAY_US_EXTRA_PER_INFO_LEG_HOOK is a United States legislation hook package within the Oracle Payroll (PAY) application. Its purpose is to enforce and evaluate Non-Resident Alien (NRA) tax status rules at the point where person extra information records are created or modified. The package is not a standalone business API; it functions as an intercepting hook invoked from the Person Extra Information framework. Specifically, it is called from the Before Process Hook of hr_person_extra_info_api.create_person_extra_info and hr_person_extra_info_api.update_person_extra_info for US legislation, allowing the system to validate or derive NRA status before the extra information row is persisted.

The package operates with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, and it is owned by the APPS schema. Its source header (pyusnra.pkh) dates to 2006, with the hook introduced under bug 5601735 and corrected shortly afterward under bug 5607135.

Key Procedures and Functions

The package exposes two documented procedures:

  • PERSON_CHECK_NRA_STATUS_CREATE — Executes the NRA status check logic when a new person extra information record is being created. Based on the person identifier and the extra information type/category values being supplied, it determines or validates the employee's Non-Resident Alien status for US payroll tax purposes.
  • PERSON_CHECK_NRA_STATUS_UPDATE — Performs the equivalent NRA status evaluation when an existing person extra information record is being updated, using the person extra information identifier and associated attribute values to reassess status.

No parameter lists are reproduced here; the procedures accept person identity, extra information type/category, and other extra information attribute values as their inputs, as reflected in the documented signatures. No functions are documented.

Tables Accessed

The package references the following tables through APPS synonyms:

  • PER_PEOPLE_EXTRA_INFO — The core extra information store whose create and update operations trigger the hook; the package reasons about the record being processed.
  • PER_ALL_PEOPLE_F — Supplies person-level attributes needed to evaluate the individual's status.
  • PER_ALL_ASSIGNMENTS_F — Provides assignment context (including payroll/legislative information) relevant to US tax treatment.
  • PAY_US_EMP_FED_TAX_RULES_F — The US employee federal tax rules table, used to determine the applicable federal tax rule set that NRA status affects.
  • DUAL — Used for single-row evaluations and simple derivations.

Usage Notes

This package is not intended to be called directly by end users. It is invoked automatically by the Person Extra Information API for US legislation, meaning any form, concurrent program, or custom code that creates or updates person extra information through that API will indirectly trigger it. ETRM records indicate the package is referenced by two other packages, confirming it participates in a wider dependency chain rather than standing alone. Because the logic is embedded in a Before Process Hook, its evaluations occur before the extra information row is committed, allowing the outcome to influence whether and how the record is written. In 12.1.1 and 12.2.2 environments, administrators and developers should treat it as a seeded, Oracle-owned extension point: modifying or bypassing it can affect federal tax rule determination for non-resident alien employees, so changes should be confined to supported personalization or extension mechanisms.