Search Results ins_per_list

Overview

APPS.HRHIRAPL is a PL/SQL package in Oracle E-Business Suite that supports the hiring of applicants within Oracle HRMS. Its documented purpose is to contain procedures invoked when hiring an applicant whose PER_SYSTEM_STATUS is APL, or an employee-applicant whose PER_SYSTEM_STATUS is EMP_APL. The package therefore sits at the boundary between the recruitment and core HR modules, converting a person record held as an applicant into an active employee assignment while coordinating the related payroll, booking, and event side effects. The header records the package as originating in Oracle Corporation UK Ltd. and traces its change history to the early 1990s, indicating a long-standing, stable component of the HRMS data model. In ETRM terms the package is classified as OTHER, meaning it is a documented API-style package rather than a pure concurrent program or form library.

Key Procedures and Functions

Four procedures are documented for this package. Parameter lists are not reproduced here; the descriptions reflect the documented purpose of each entry point.

• EMPLOY_APPLICANT — The principal hiring procedure. It performs the transition of an applicant or employee-applicant into an employed person, driving the creation and update of the core HR records required to complete the hire.
• END_UNACCEPTED_APP_ASSIGN — Terminates an applicant assignment that was not accepted, cleaning up the assignment state so that the applicant record is not left in a conflicting status. This procedure appears early in the change history, having been added shortly after the package was created.
• INS_PER_LIST — Handles insertion into the PER list structures associated with the hire. The change history notes that it was made externally visible and later corrected to work correctly with EMP_APL records, confirming its role in processing employee-applicants as well as plain applicants.
• END_BOOKINGS — Ends bookings associated with the person or assignment as part of the hire or cleanup flow. Booking records in HRMS represent scheduled time such as absence or other personnel bookings.

Tables Accessed

The package reads and writes a broad slice of the HRMS and related schema objects through APPS synonyms. Core person and assignment tables include PER_ALL_ASSIGNMENTS_F, PER_APPLICATIONS and PER_ASSIGNMENT_STATUS_TYPES, which hold the assignment, application and status information being transformed during the hire. Status amendment history is captured in PER_ASS_STATUS_TYPE_AMENDS, and applicant/assignment status codes come from IRC_ASSIGNMENT_STATUSES. Payroll-related effects are handled through PER_PAY_PROPOSALS, PAY_PAYROLL_ACTIONS, PAY_ASSIGNMENT_ACTIONS and PAY_PEOPLE_GROUPS. Booking records are managed in PER_BOOKINGS, and HRMS events are written to PER_EVENTS. The package also consults Flexfield metadata via FND_DESCRIPTIVE_FLEXS, FND_DESCR_FLEX_CONTEXTS and FND_DESCR_FLEX_COLUMN_USAGES, and uses FND_SESSIONS for session context.

Usage Notes

HRHIRAPL is typically invoked indirectly rather than called directly by end users. The Oracle HRMS hire and applicant flows, together with related concurrent programs and forms, call these procedures to complete the hire transaction. Because the package is referenced by three other packages, it also forms part of the internal HRMS call graph. Custom extensions that need to emulate or intercept the standard hire should call the documented procedures rather than manipulating the underlying tables directly, so that status amendments, payroll proposals, bookings and events remain consistent. The historical note on INS_PER_LIST and the reversion of an earlier change underline the importance of testing against both APL and EMP_APL system statuses in 12.1.1 and 12.2.2.