Search Results per_applications_s




Overview
Explore in AI Chat

Overview

PER_APL_INS is a private PL/SQL package body owned by the APPS schema that encapsulates the insert-time validation and row-handling logic for the PER_APPLICATIONS entity — the "Application" records maintained by Oracle Human Resources (Oracle HRMS) and shared across the E-Business Suite. Applications in this context are not EBS product registrations but the HRMS-level "Application" rows that group or categorise applicant and employee data used by recruitment, applicant tracking and related HR processes.

Within the Oracle EBS 12.1.1 and 12.2.2 architecture, the PER_APL_* package family follows the standard Oracle Forms / Table Handler pattern generated for the PER_APPLICATIONS table. PER_APL_INS is the "Insert" member of that family: it is responsible for applying the business rules that must be enforced when a new Application row is created, before the row is physically written by the corresponding Row-Level Insert (RKI) package, PER_APL_RKI. The package is classified as OTHER in the ETRM repository and is documented as VALID in the APPS schema.

Key Procedures and Functions

The ETRM metadata records a single documented program unit in this package body:

  • INS — the insert handler for the Application entity. It performs pre-insert processing for a new PER_APPLICATIONS record: it applies HRMS API-level validation, invokes the HRMS error/message stack (HR_MULTI_MESSAGE, HR_API, HR_UTILITY) to raise or collect user-facing errors, resolves derived or system-maintained columns, and then delegates the actual physical row insertion to PER_APL_RKI. The procedure operates in coordination with the business-rules package PER_APL_BUS and respects the shadow/audit table handler PER_APL_SHD.

Because the source extract documents only the INS procedure name, no parameter list, overloads or additional private helpers are asserted here; additional internal units may exist in the compiled body but are not part of the documented public contract.

Tables Accessed

  • PER_APPLICATIONS — the base transactional table holding Application rows. PER_APL_INS initiates the creation of a record here, working in conjunction with the RKI package that performs the actual DML.
  • PER_APPLICATIONS_S — the corresponding date-tracked shadow (audit) table. Writes to PER_APPLICATIONS are mirrored here through the PER_APL_SHD handler so that historical, effective-dated versions of each Application record are preserved. This is the object most commonly associated with the user search term "per_applications_s".
  • DUAL — referenced for single-row expression evaluation (for example, sequence or SYSDATE-based value resolution) typical of HRMS row handlers.

Usage Notes

PER_APL_INS is not intended for direct invocation by end users or by custom code. It is an internal worker invoked by the HRMS Application forms (such as the Applicant/Application maintenance windows) and by the surrounding PER_APL_* handler family whenever a new Application row is committed. The documented dependency chain shows PER_APL_INS depends on PER_APL_BUS, PER_APL_RKI and PER_APL_SHD, and the repository notes that the package body is referenced by four other database objects, confirming its role as a shared, low-level component rather than an entry point.

Because it is a package body with private scope and no documented public API classification, customers should treat PER_APL_INS as Oracle-owned internals: extending or calling it directly is unsupported and vulnerable to change between 12.1.1 and 12.2.2 patch levels. Integrations that need to create Application records should use the supported HRMS public APIs (for example, the PER_APPLICATIONS_API family) instead, allowing PER_APL_INS to execute transparently through the standard validation and shadow-table path.