Search Results get_assignment_id

Overview

APPS.PAY_US_EXTRA_PER_INFO_LEG_HOOK (source file pyusnra.pkb) is a US-legislation PL/SQL package supplied by Oracle Payroll. It implements the "Before Process" hooks attached to the HR person extra information API, specifically hr_person_extra_info_api.create_person_extra_info and hr_person_extra_info_api.update_person_extra_info. Its stated purpose is to check the Non Resident Alien (NRA) status of an employee and to perform the necessary validation checks whenever the corresponding extra information records are created or updated for US payroll purposes.

It is classified in the Oracle E-Business Suite Electronic Technical Reference Manual (ETRM) as an "OTHER" API under the APPS schema. The package was originally created in December 2006 (version 115.0, bug 5601735) and was subsequently revised in February 2008 (version 115.2, bug 6794488) when the FIT (federal income tax) check was removed. The current header reflects a 12.1.1 build level, and the object remains present in 12.2.2.

Key Procedures and Functions

Two documented procedures constitute the public interface of the package:

• PERSON_CHECK_NRA_STATUS_CREATE — Invoked from the Before Process hook of hr_person_extra_info_api.create_person_extra_info. It evaluates the employee's non-resident status at the point an extra information record is created and applies the necessary US legislative checks. The local variable l_assignment_id is declared within this procedure to receive the assignment identifier, which explains the "get_assignment_id" search interest.
• PERSON_CHECK_NRA_STATUS_UPDATE — Invoked from the Before Process hook of hr_person_extra_info_api.update_person_extra_info. It performs the equivalent NRA validation when an existing extra information record is modified.

The procedures rely on local variables mirroring the columns of PER_PEOPLE_EXTRA_INFO, including information type, category, and PEI_INFORMATION5 / PEI_INFORMATION9, together with a filing status code, withholding allowances, FIT-exempt flag, withholding allowances (WA) federal indicator, student flag, and assignment ID used to resolve the current effective assignment via PER_ALL_ASSIGNMENTS_F.

Tables Accessed

• PAY_US_EMP_FED_TAX_RULES_F — Read to obtain federal withholding allowances and the FIT exemption indicator that together drive the NRA determination.
• PER_ALL_ASSIGNMENTS_F — Read to resolve the current assignment (l_assignment_id) for the person, providing the payroll/assignment context required by the tax rules lookup.
• PER_ALL_PEOPLE_F — Read for the person identifier and effective person record.
• PER_PEOPLE_EXTRA_INFO — The driving table for the hook; the information type, category, and information5/information9 segments are inspected and validated.
• DUAL — Used for single-row evaluations in the package logic.

Usage Notes

This package is not called directly by end users. It is registered as a Before Process hook against the person extra information API so that HR or payroll forms (and any custom code) that create or update NRA-related extra information for US employees automatically trigger the validation. Because it is an APPS-owned hook, customization should be avoided; extending behavior is normally done by cloning or wrapping the hook rather than editing the seeded body. The package is referenced by two other packages according to the ETRM metadata, confirming its role as a supporting validation layer. The absence of the "get_assignment_id" string in the documented body excerpt, despite the user's search, indicates that assignment resolution occurs through the assignment ID local variable rather than a public function of that name, so searches for a procedure named get_assignment_id within this package should not be expected to return results.