Search Results apl_asg

Overview

APPS.HRHIRAPL is a PL/SQL package body in Oracle E-Business Suite (documented across 12.1.1 and 12.2.2) that supports the Hire Applicant (Employee/Applicant) business flow within Oracle Human Resources (PER) and iRecruitment. The package encapsulates the server-side logic that must run when an applicant record is transitioned into an employee assignment, when unaccepted applicant assignments are closed, and when booking and list-processing operations are completed. Its header comment identifies the primary entry point, employ_applicant, as the procedure "fired when an applicant is hired," indicating that HRHIRAPL sits behind the Hire/Rehire and applicant-conversion functionality surfaced through the People and iRecruitment forms.

Because hiring an applicant touches many interconnected HR entities — the person, the assignment, the assignment status, payroll proposals, events, and descriptive flexfield context — the package is classified as an "OTHER" API rather than a standard public interface. It is referenced internally by three other packages, meaning it is predominantly a supporting component of the HR application codebase rather than a standalone integration point, though it may be called directly from custom extensions that automate hiring.

Key Procedures and Functions

The ETRM documentation records four procedures in this package body:

• EMPLOY_APPLICANT — The central routine executed when an applicant is hired. It drives creation and update of the new primary assignment, applies the assignment status type, assigns the employee number, sets the start date and the end-of-time date, optionally updates the primary assignment flag, and processes the temporary PL/SQL table of applicant/assignment information passed in by the caller. It also resolves the applicant-to-employee distinction (EMP_APL versus APL) and the current session, set of books, and business group context.
• END_UNACCEPTED_APP_ASSIGN — Terminates applicant assignments that were never accepted, cleaning up assignment statuses and related rows so that stale applicant activity does not remain active.
• INS_PER_LIST — Inserts rows into the PER list structures used by the hiring flow, maintaining the list detail associated with the person or assignment being processed.
• END_BOOKINGS — Closes booking records (PER_BOOKINGS) associated with the applicant/assignment, ensuring resource and facility bookings tied to the applicant lifecycle are ended.

Tables Accessed

The package reads and writes a broad set of APPS synonymous tables reflecting the breadth of the hire transaction:

• PER_ALL_ASSIGNMENTS_F — The core assignment record created or updated during hiring.
• PER_APPLICATIONS — Applicant/application data being converted to an employee.
• PER_ASSIGNMENT_STATUS_TYPES and IRC_ASSIGNMENT_STATUSES — Valid status values applied to new and ended assignments.
• PER_ASS_STATUS_TYPE_AMENDS — Status change amendments recorded as part of the hire or termination.
• PER_PAY_PROPOSALS — Payroll proposal rows generated for the new employee.
• PER_BOOKINGS — Booking records closed by END_BOOKINGS.
• PER_EVENTS — HR events raised by the hiring and termination actions.
• PAY_ASSIGNMENT_ACTIONS and PAY_PAYROLL_ACTIONS — Payroll-side records synchronized with the assignment.
• PAY_PEOPLE_GROUPS — Payroll people group resolution for the new employee.
• FND_DESCRIPTIVE_FLEXS, FND_DESCR_FLEX_COLUMN_USAGES, FND_DESCR_FLEX_CONTEXTS — Descriptive flexfield metadata used to validate and store flexfield segment values (a cursor over people group segments is declared for this purpose).
• FND_SESSIONS — Session context used for audit and concurrent-processing identification.

Usage Notes

HRHIRAPL is invoked automatically by Oracle HR and iRecruitment forms and concurrent processes during the Hire Applicant and applicant-assignment termination flows; it is not intended as a general-purpose public API. ETRM records it as "OTHER" classification with three dependent packages, confirming its role as an internal worker called from higher-level HR APIs and UI logic.

Custom code should generally call the supported HR_EMPLOYEE_APPLICANT_API and related public APIs rather than HRHIRAPL directly, because the internal procedures assume a fully populated session and business-group context and expect the caller to have already built the applicant/assignment PL/SQL table. When troubleshooting hiring issues on 12.1.1 or 12.2.2, tracing into HRHIRAPL.EMPLOY_APPLICANT (backed by source file pehirapl.pkb) is the standard method for diagnosing assignment creation, status, payroll proposal, and flexfield validation failures.