Results for “per_person_types_s”

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

Overview

BEN_SEED_PERSON_TYPES is an Oracle Applications (APPS) PL/SQL package body that belongs to the Oracle Advanced Benefits (BEN) product family. Its function is to seed and maintain the person type definitions used by the Benefits module. In Oracle EBS, person types classify individuals tracked by Oracle HRMS — examples include Employee, Applicant, Contingent Worker, Retiree, and Beneficiary. Benefits eligibility, enrollment, and participation rules are frequently driven by the person type assigned to an individual, so the underlying person type records must exist and be consistent before Benefits configuration can reference them.

The package body carries the status VALID in the APPS schema and is classified as OTHER within the ETRM metadata, indicating it is an internal supporting routine rather than a public or a formally versioned API. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 releases, such seeding packages are typically executed as part of product installation, patching, or data upgrade flows to populate or refresh seed data in the base HRMS person type tables.

Key Procedures and Functions

The ETRM documentation records a single documented program unit within the package body:

• SEED_PERSON_TYPES — the principal procedure of the package. Its purpose is to establish the person type seed data required by the Benefits application. It operates against the person type tables to ensure that the entries Benefits depends upon are present, and it is designed to be safely re-executable during installation or patching. The metadata does not document a parameter list, and none should be assumed.

No additional procedures or functions are recorded for this package body.

Tables Accessed

The documented dependency list identifies the following objects referenced through APPS synonyms:

• PER_PERSON_TYPES — the base HRMS table that stores person type definitions, including system-defined person types used throughout Oracle HRMS. The seeding procedure writes or verifies records here.
• PER_PERSON_TYPES_S — the corresponding date-tracked (datetrack) table for person types. Because person types are date-effective objects, changes maintained in the base table are mirrored into the _S table to preserve historical and future-dated versions. This table is central to queries such as the one the user searched for, "per_person_types_s," which is commonly used to retrieve person type information as of a given effective date.

The package also references DUAL, the standard Oracle single-row utility table, and STANDARD, the standard PL/SQL package, both of which are typical in seeding routines for simple queries or common operations.

Usage Notes

BEN_SEED_PERSON_TYPES references HR_UTILITY and is referenced by no other database object, confirming that it is a leaf-level utility rather than a dependency of other application logic. It is normally invoked internally by HRMS or Benefits setup and installation processes — for example, during the seeding steps of a product install, an upgrade to 12.1.1 or 12.2.2, or the application of a patch that introduces or corrects person type seed data.

Because it is not documented as a public API and carries the OTHER classification, it should not be called directly from custom forms, concurrent programs, or customer extensions. Developers who need to read or validate person types should query PER_PERSON_TYPES or PER_PERSON_TYPES_S directly rather than executing this package. Any manual execution should be confined to Oracle-supported patching and diagnostic procedures, since re-running a seeding routine outside its intended context risks duplicate or inconsistent person type records.