Search Results insert_employee_rows

Overview

PER_PEOPLE9_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM documentation as an "OTHER" API. The package forms part of the PER_PEOPLE family of worker-data manipulation packages that collectively comprise the internal processing layer of the Oracle Human Resources (PER) module. Its documented role centers on the population and maintenance of person records within the PER_ALL_PEOPLE_F entity and their associated assignment rows, distinguishing between applicant and employee populations. This distinction reflects the core EBS HR data model, in which applicants and employees are stored in the same underlying person tables but are differentiated by person type and associated assignment and recruitment records. PER_PEOPLE9_PKG is a specialized member of a numbered series (PER_PEOPLE4_PKG, PER_PEOPLE9_PKG, PER_PEOPLE11_PKG, PER_PEOPLE12_PKG), indicating that the People API has historically been partitioned across several packages to manage complexity and object size.

Key Procedures and Functions

The package exposes three documented procedures. INSERT_APPLICANT_ROWS is responsible for creating person rows that represent applicants, including the associated data required to make the applicant visible to the recruitment and applicant-tracking components of the HR module. INSERT_EMPLOYEE_ROWS performs the parallel function for employees, generating the person and supporting rows required when a worker is established as an employee rather than an applicant. UPDATE_OLD_PERSON_ROW maintains the existing person record, executing the updates necessary when an existing row must be revised rather than newly created; the naming implies a controlled update path designed to preserve data integrity on already-populated rows. No parameter lists are documented in the ETRM metadata, and callers should not assume a public signature; these procedures are intended for internal invocation by the PER_PEOPLE_PKG hierarchy rather than direct customer use.

Tables Accessed

The documented table reference for this package is PER_ALL_ASSIGNMENTS_F, the primary date-tracked assignments table in Oracle HRMS. All access is performed through APPS synonyms. The package writes and maintains assignment rows in coordination with the person rows it inserts, since an applicant or employee record in EBS is meaningful only when linked to an assignment. Because PER_ALL_ASSIGNMENTS_F is a datetracked ( _F ) table, operations against it must respect effective-date logic, and the insertion and update procedures provide the mechanism by which correctly dated assignment rows are established and adjusted.

Usage Notes

PER_PEOPLE9_PKG is an internal implementation package. The dependency listing shows that it references only SYS.STANDARD and is referenced by four packages — PER_PEOPLE4_PKG, PER_PEOPLE11_PKG, PER_PEOPLE12_PKG, and PER_PEOPLE_PKG — confirming that it is called from within the People API stack rather than from forms or concurrent programs directly. The self-reference in the dependency list indicates recursive or mutually dependent calls within the package. Customers and integrators should invoke the public People APIs (for example, the HR_EMPLOYEE_API or PER_PEOPLE_PKG entry points) rather than calling PER_PEOPLE9_PKG procedures directly, because the internal procedures assume a calling context and sequencing established by the parent packages. Standard EBS 12.1.1 and 12.2.2 patch application maintains this package; it should not be modified without an Oracle-supported change, as alterations may break the dependent People packages.