Search Results hr_assignment




Overview
Explore in AI Chat

Overview

APPS.HR_ASSIGNMENT is a server-side PL/SQL package within the Oracle E-Business Suite Human Resources (HR) module. Its principal business function is to encapsulate the core rules governing the creation, validation, maintenance, and termination of employee and applicant assignments stored in the PER_ALL_ASSIGNMENTS_F table. An assignment is the central HR construct that links a person to an organization, job, position, grade, payroll, and location, and it drives payroll processing, compensation, and reporting downstream. Because assignment integrity affects so many dependent modules, HR_ASSIGNMENT centralizes the business logic that would otherwise be duplicated across multiple forms, APIs, and concurrent programs.

The package is classified as an OTHER API in the ETRM repository and holds a VALID status in the APPS schema. It is one of the most heavily referenced HR packages in EBS Release 12.1.1 and 12.2.2, with nineteen dependent packages identified in the ETRM metadata.

Key Procedures and Functions

The package exposes twenty-six documented procedures and functions. The principal groups are:

Tables Accessed

HR_ASSIGNMENT operates across a broad set of HR and Oracle Purchasing tables, all accessed through APPS synonyms. The primary datastore is PER_ALL_ASSIGNMENTS_F, which holds the effective-dated assignment records. PER_ALL_PEOPLE_F supplies person-level information, and PER_ASS_STATUS_TYPE_AMENDS and PER_ASS_STATUS_TYPE_AMENDS_TL supply assignment status amendment rules and their translated descriptions. Organizational context comes from HR_ALL_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS_TL, and HR_LOCATIONS_ALL_TL. Assignment classification and terms are derived from PER_JOBS_TL, PER_GRADES_TL, PER_CONTRACTS_F, PER_COLLECTIVE_AGREEMENTS, PER_PAY_BASES, PER_SPINAL_POINTS, and PER_SPINAL_POINT_STEPS_F. Payroll linkage uses PAY_ALL_PAYROLLS_F. Benefits linkage uses BEN_PGM_F, and the ledger is resolved via GL_SETS_OF_BOOKS. Additional references include HR_COMMENTS for assignment comments, and the Purchasing tables PO_HEADERS_ALL, PO_LINES_ALL, PO_VENDORS, and PO_VENDOR_SITES_ALL, which support assignment-related supplier or contract reference data.

Usage Notes

HR_ASSIGNMENT is not intended to be called directly by end users. It is typically invoked indirectly through the Oracle HRMS forms (such as the Assignment, Employee, and Termination windows), through the HR_ASSIGNMENT_API and related public APIs, and through concurrent processes that mass-maintain assignments. Custom code should prefer the documented public API HR_ASSIGNMENT_API rather than calling HR_ASSIGNMENT directly, because the internal procedures assume calling context established by the API layer. The ETRM metadata records that the package is referenced by nineteen packages, including HR_APPLICANT_API, HR_EMPLOYEE_API, HR_ASSIGNMENT_API, HR_CHANGE_START_DATE_API, and the PER_ASSIGNMENTS_F_PKG family, confirming its role as a shared internal service. Any modification to assignment logic in this package should be treated as high impact, since defects propagate to payroll, benefits, and downstream reporting across the enterprise.