Search Results per_apl_ins




Overview
Explore in AI Chat

Overview

PER_APL_INS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the Oracle Human Resources (PER) product family by virtue of its PER_ prefix. Its name abbreviates "Person Application Insert," identifying it as a low-level insert handler for records in the PER_APPLICATIONS entity — the table that stores applicant and application data used by Oracle iRecruitment and the Oracle HRMS recruitment modules. In releases 12.1.1 and 12.2.2 the package carries a VALID status in the ETRM data dictionary, confirming it is a compiled, supported database object rather than a stale or disabled artifact.

The package is not intended for direct customer-facing use. It functions as an internal building block consumed by the public HRMS application programming interfaces (APIs) that manage applicants, assignments, and contingent workers. Its principal role is to encapsulate the mechanics of creating application rows — including the shadow-table synchronization required by Oracle's table-shadowing mechanism — so that higher-level APIs can insert applicant data consistently and without duplicating that logic.

Key Procedures and Functions

The documented metadata identifies two program units, both exposed through the INS subprogram name (one likely in the package specification and its implementation in the package body).

  • INS — The insertion routine. It performs the core work of the package: creating a new application record for an applicant within the Oracle HRMS data model, applying the validation and defaulting rules that the recruitment schema expects. Because the package is classified as OTHER rather than as a public API, the INS routine is treated as a private implementation detail whose interface may change between patch levels and should not be called directly by custom code.
  • Package body / dependent subprograms — The package body also interacts with APPS.PER_APL_SHD, the shadow-table companion object. The shadow table is maintained by database triggers so that the applications table can be audited or replicated; the package body ensures that this synchronization occurs as part of the insert path.

Tables Accessed

The ETRM documentation records two tables referenced through APPS synonyms:

  • PER_APPLICATIONS — The primary applications table, holding applicant-to-requisition and general application records. PER_APL_INS writes new rows here.
  • PER_APPLICATIONS_S — The shadow table for PER_APPLICATIONS. The "_S" table is populated by shadow triggers to support data auditing and seed-data migration; the package's insert logic must respect this shadowing so that both physical tables remain consistent.

The package also references APPS.PER_APL_SHD according to the documented dependency list, reinforcing that shadow-table handling is an integral part of its insert behavior. No other application tables are documented for this package, and no direct reads of lookup or flexfield tables are recorded.

Usage Notes

PER_APL_INS is referenced by four other packages, all of which sit above it in the HRMS API stack: HR_APPLICANT_API, HR_APPLICANT_INTERNAL, HR_ASSIGNMENT_API, and HR_CONTINGENT_WORKER_API. This indicates that applicant creation flows initiated through the standard HRMS candidate and assignment APIs eventually delegate to PER_APL_INS for the physical insert. It is also referenced within its own package lineage (the PER_APL_INS self-reference), reflecting internal call structure.

  • Forms — The Oracle iRecruitment and HRMS applicant entry forms indirectly trigger this package when a user saves a new applicant record, since those forms call the HR_APPLICANT_API family.
  • Concurrent programs — Interface and import concurrent programs that load applicants from external sources typically invoke HR_APPLICANT_API, and therefore reach PER_APL_INS during batch processing.
  • Custom code — Customizations should call the documented public APIs (HR_APPLICANT_API, HR_ASSIGNMENT_API) rather than PER_APL_INS directly. Because the package is classified as OTHER and is not part of the supported public interface, Oracle may alter its signature without notice in patches or upgrades.

In summary, PER_APL_INS is an internal HRMS insert utility supporting applicant and application creation across Oracle EBS 12.1.1 and 12.2.2, and should be regarded as implementation detail behind the supported HRMS APIs.