Search Results per_pl_person_extra_info




Overview
Explore in AI Chat

Overview

PER_PL_PERSON_EXTRA_INFO is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, validated in releases 12.1.1 and 12.2.2. It belongs to the Oracle Human Resources (PER) product family and provides a localized extension to the standard person extra information APIs. The "PL" component in the package name identifies it as a regional localization module; in this case, it supports country-specific or legislation-specific handling of person extra information attributes maintained in the PER_PEOPLE_EXTRA_INFO entity. The package encapsulates the logic required to create and update extra information records for a person without requiring callers to interact directly with the underlying base tables. Its ETRM API classification is OTHER, indicating that it is a supporting package rather than a fully published public API. The package is a wrapper layer that is invoked by the forms-based business logic through the HR_PERSON_EXTRA_INFO_BK1 and HR_PERSON_EXTRA_INFO_BK2 libraries, and only a small number of other packages depend on it.

Key Procedures and Functions

Two procedures are documented for this package:

  • CREATE_PL_PERSON_EXTRA_INFO — Creates a new person extra information record, applying the localization rules associated with this package. It supplies the base-table insert semantics required by the Oracle HRMS data model for PER_PEOPLE_EXTRA_INFO.
  • UPDATE_PL_PERSON_EXTRA_INFO — Modifies an existing person extra information record, again applying localization-specific validation and defaults. Together with the create procedure, it forms the complete maintenance surface of the package.

No public parameter lists are documented in the ETRM metadata, and callers should treat the signatures as internal implementation detail. The two procedures mirror the standard create/update pattern used throughout the PER schema, where a block-level library performs validation and the package performs the database write.

Tables Accessed

The package references the following tables through APPS synonyms:

  • PER_PEOPLE_EXTRA_INFO — The primary target of insert and update activity. It stores the actual extra information records keyed to a person and an information type.
  • PER_ALL_PEOPLE_F — The date-tracked people entity, read to validate the person and to derive effective-dating context.
  • PER_PERSON_TYPES — Defines the person type classification used during validation of the record being created or changed.
  • PER_PERSON_TYPE_USAGES_F — The date-tracked assignment of a person type to a person, consulted to confirm the type is current and valid for the effective date in question.

These reads support the validation contract of the procedures, while PER_PEOPLE_EXTRA_INFO is the only table subject to write operations.

Usage Notes

Invocation of PER_PL_PERSON_EXTRA_INFO is normally indirect. The Oracle HRMS forms for person extra information call the block libraries HR_PERSON_EXTRA_INFO_BK1 and HR_PERSON_EXTRA_INFO_BK2, which in turn invoke this package to persist changes. Custom code should not call the procedures directly unless the standard libraries have been used first, because validation and effective-dating rules are enforced in the form layer. The package depends only on SYS.STANDARD, indicating a self-contained implementation with no dependency on other APPS packages. Because the package is not a published public API and no concurrent program references are documented, it is best treated as an internal extension point. Release 12.1.1 and 12.2.2 share the same documented structure; the online patching model in 12.2.2 does not change the package's role, only the editioning and patching mechanics surrounding it.