Search Results create_application

Overview

APPS.HR_APPLICANT_INTERNAL is an internal PL/SQL package within the Oracle E-Business Suite Human Resources (HR) module, classified under the generic "OTHER" API category in the ETRM repository. Its status is VALID in both 12.1.1 and 12.2.2. The package encapsulates the low-level logic that supports the public, documented HR_APPLICANT_API by handling applicant creation, person type conversion, and assignment-related processing required when an external applicant is transformed into an internal applicant or employee. It operates exclusively against APPS-owned synonyms for the core HR and Payroll tables, and it is referenced by several higher-level APIs, including HR_APPLICANT_API, HR_APPLICANT_DATAUPD, HR_ASSIGNMENT_API, and HR_EMPLOYEE_API. Because it is designated internal rather than a public API, Oracle does not guarantee backward compatibility for direct calls, so it should be treated as a supporting component of the applicant lifecycle rather than as a standalone extension point.

Key Procedures and Functions

The documented interface exposes nine procedures and functions that together manage the applicant-to-employee transition and related application records:

• GENERATE_APPLICANT_NUMBER — Produces a unique applicant identifier, typically by applying the configured applicant number generation formula or sequence.
• CREATE_APPLICANT_ANYTIME — Creates an applicant record irrespective of the current date, permitting backdated or future-dated applicant creation.
• CREATE_APPLICATION — Inserts a new job application row for an applicant, linking the person to the requisition or vacancy context.
• OVERRIDE_FUTURE_APPLICATIONS — Reconciles or overrides existing future-dated applications when a person's status changes.
• FUTURE_APL_ASG_EXIST — A validation function that determines whether future-dated applications or assignments already exist for a person.
• UPDATE_PER_PTU_RECORDS — Updates PER_PERSON_TYPE_USAGES_F rows, adjusting person type usage to reflect a change in applicant or employee classification.
• UPDATE_PER_PTU_TO_EX_APL — Converts person type usage records from an applicant type to an ex-applicant type, supporting the hire conversion flow.
• UPD_PERSON_EX_APL_AND_APL — Updates the person record, the ex-applicant designation, and associated application rows in a coordinated update.
• UPDATE_APL_ASSIGNMENTS — Adjusts application-level assignment references when the underlying person or assignment data changes.

The metadata does not expose parameter signatures, and none should be assumed.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

• PER_ALL_PEOPLE_F and PER_APPLICATIONS — the primary person and application records that the package creates and updates during applicant processing.
• PER_PERSON_TYPES and PER_PERSON_TYPE_USAGES_F — used to control person type classification and the applicant, ex-applicant, or employee transitions handled by UPDATE_PER_PTU_RECORDS and UPDATE_PER_PTU_TO_EX_APL.
• PER_ALL_ASSIGNMENTS_F — read when checking for or updating future applications and assignments (FUTURE_APL_ASG_EXIST, UPDATE_APL_ASSIGNMENTS).
• PAY_PEOPLE_GROUPS — referenced when determining the payroll people group applicable to the person during conversion.

Usage Notes

HR_APPLICANT_INTERNAL is not intended for direct invocation by end users. It is called indirectly by the public HR_APPLICANT_API and by the HR_APPLICANT_DATAUPD, HR_ASSIGNMENT_API, and HR_EMPLOYEE_API packages, which are themselves invoked from the Oracle iRecruitment and People Management forms and from concurrent programs that process applicant-to-employee conversion. Custom code should avoid calling this package directly, because internal APIs may change without notice between 12.1.1 and 12.2.2. Where business logic must be extended, the supported public APIs (for example HR_APPLICANT_API or HR_EMPLOYEE_API) should be used instead. The package depends only on the SYS STANDARD package, indicating a self-contained PL/SQL implementation with no external Java or third-party dependencies.