Search Results hr_assignment_internal




Overview
Explore in AI Chat

Overview

HR_ASSIGNMENT_INTERNAL is a private implementation package in the APPS schema that underpins Oracle E-Business Suite's assignment management functionality within Oracle HRMS. Assignment records, stored primarily in PER_ALL_ASSIGNMENTS_F, represent the relationship between a person (employee, contingent worker, or applicant) and an organization, position, job, and payroll. Because assignment creation and maintenance involve complex validation, date-tracked record handling, payroll linkage, and status derivation across many dependent entities, Oracle encapsulates the low-level logic in this package and exposes the supported entry points through the public HR_ASSIGNMENT_API wrapper.

The package is classified as an internal API (API classification OTHER) and is not intended for direct customer invocation. It serves as the shared engine that other HRMS APIs and business processes call to create default assignments, terminate assignments, manage spinal point placements, and enforce deletion preconditions. Its widespread reuse — referenced by seventeen other packages including HR_EMPLOYEE_API, HR_CONTINGENT_WORKER_API, HR_APPLICANT_API, HR_PERIODS_OF_SERVICE_API, PQH_ASG_WRAPPER, and IRC_OFFERS_API — demonstrates that it is a foundational component of the HRMS data model.

Key Procedures and Functions

The documented 24 procedures and functions cluster into several functional groups:

Tables Accessed

The package reads and writes PER_ALL_ASSIGNMENTS_F, the core date-tracked assignment table, and PER_SPINAL_POINT_PLACEMENTS_F for grade placement data. It consults PER_ALL_PEOPLE_F for person attributes and PER_ASG_SHD (a shadow table for concurrent processing). Payroll integration relies on PAY_ASSIGNMENT_ACTIONS, PAY_ASSIGNMENT_LINK_USAGES_F, PAY_COST_ALLOCATIONS_F, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_GRADE_RULES_F, and PAY_PERSONAL_PAYMENT_METHODS_F. Benefits checks reference BEN_PER_IN_LER, recruitment checks reference IRC_ASSIGNMENT_STATUSES, and vacancy and budget validation use PER_ALL_VACANCIES and PER_ASSIGNMENT_BUDGET_VALUES_F. FND_NEW_MESSAGES supplies user-facing error messages.

Usage Notes

HR_ASSIGNMENT_INTERNAL is invoked indirectly. Standard callers include the Assignment and Employee forms, the Hire Applicant and Terminate Employee concurrent programs, the HR_ASSIGNMENT_API public wrapper, and Payroll and Benefits processes that reconcile assignment actions. Custom integrations should call HR_ASSIGNMENT_API or HR_EMPLOYEE_API rather than this internal package, since its signatures and behavior are not part of Oracle's supported public interface and may change between releases such as 12.1.1 and 12.2.2.