Results for “pe_pei_ins”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

PE_PEI_INS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its name follows the Oracle HRMS naming convention in which the "PE" prefix denotes the People/Per‑sonal Information product family and "PEI" is an abbreviation for Person Extra Information. The package therefore provides the lowest‑level insertion routine for the extra information (descriptive flexfield) records that are attached to a person in Oracle Human Resources.

Extra Information Types (EITs) are the configurable flexfield segments that store supplemental person data such as nationality, ethnicity, security clearance, or customer‑defined attributes. The public HRMS API that developers normally call for this purpose is HR_PERSON_EXTRA_INFO_API. PE_PEI_INS is the internal insert‑only worker that the API delegates to when an EIT row must be created. ETRM classifies it as an "OTHER" API type, confirming that it is a supporting/internal object rather than a documented public interface.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents a single program unit inside this package:

• INS — the insert routine. It performs the physical creation of a PER_PEOPLE_EXTRA_INFO row for a given person, extra information type, and effective date. It is the implementation layer behind the "Insert" operation exposed by HR_PERSON_EXTRA_INFO_API, and is normally invoked indirectly through that API rather than called directly by custom code.

No additional public procedures or functions are documented, which is consistent with the object's status as a private helper package. Because the documented parameter list is not published in the ETRM extract, the exact signature is intentionally not reproduced here; integrators should reference the public HR_PERSON_EXTRA_INFO_API wrapper instead.

Tables Accessed

The documented table references, resolved through APPS synonyms, are:

• PER_PEOPLE_EXTRA_INFO — the base table that holds person extra information rows. PE_PEI_INS writes the new EIT record here.
• PER_PEOPLE_EXTRA_INFO_S — the corresponding shadow/date‑tracked table used by the HRMS date‑tracking architecture to preserve the audit history of changes to the base row. The insert routine maintains this table alongside the base table.
• FND_USER — read to capture the current application user, which is stamped into the WHO columns (created_by, last_updated_by) of the new record.

In addition, the ETRM dependency listing shows that PE_PEI_INS references the PE_PEI_SHD package (the shadow‑table maintenance layer) and the SYS.STANDARD package, reflecting Oracle‑supplied infrastructure used during the insert.

Usage Notes

PE_PEI_INS is not intended to be called directly from forms, concurrent programs, or custom PL/SQL. The standard integration path is the public API HR_PERSON_EXTRA_INFO_API, which in turn invokes PE_PEI_INS.INS to materialize the EIT record. Referenced‑by analysis confirms exactly this relationship: HR_PERSON_EXTRA_INFO_API is the only documented consumer, while the package also self‑references, indicating internal recursion or helper calls.

Developers should always prefer the public API because it enforces validation, date‑tracking, and business‑rule checks that the internal insert does not fully replicate. Direct calls to PE_PEI_INS risk bypassing those safeguards. The package is valid and present in both Oracle EBS 12.1.1 and 12.2.2, and no version‑specific behavioral differences are documented in the ETRM metadata.