Search Results hz_cust_account




Overview
Explore in AI Chat

Overview

The APPS.IGS_PE_PERSON_PKG package body is a core member of the Oracle E-Business Suite (EBS) Student System "People" (IGS_PE) module, which is responsible for managing the person records that underpin students, prospects, applicants, and staff across the institution. In EBS 12.1.1 and 12.2.2, this package acts as a data-access layer that bridges the institution's native person entities and the Oracle Trading Community Architecture (TCA) model delivered through the HZ_% tables. Its primary business function is to create, maintain, and validate person rows, while keeping the Student System representations synchronized with the corresponding TCA party and person profile records.

The metadata classifies the API as "OTHER," indicating that it is not part of a formally published public API surface but rather an internal, dependency-driven package used by higher-level Student System logic. It is documented as VALID and carries an unusually heavy footprint: it is referenced by 107 other database objects, confirming its role as a foundational utility within the People domain.

Key Procedures and Functions

The ETRM metadata documents four procedures or functions:

  • INSERT_ROW — Creates a new person record, inserting the institution-specific person row and the associated supporting records required for a complete person definition.
  • UPDATE_ROW — Modifies an existing person record, applying changes to the person and its dependent detail rows while preserving referential integrity.
  • GET_PK_FOR_VALIDATION — Returns the primary key of a person row so that validation routines can confirm the record exists and is eligible for the requested operation.
  • BEFORE_DML — A pre-DML hook invoked prior to INSERT or UPDATE processing, used to enforce business rules, seed mandatory columns, and prepare the row for persistence.

Parameter lists are not documented and must not be assumed; callers should inspect the validated package specification in the target instance.

Tables Accessed

  • HZ_PARTIES and HZ_PERSON_PROFILES — the TCA tables holding the party and person-profile records that back every institutional person.
  • IGS_PE_PERSON_TYPES — defines the person type classifications assigned to the record.
  • IGS_PE_ALT_PERS_ID — stores alternate person identifiers such as legacy or external IDs.
  • IGS_PE_HZ_PARTIES — the mapping table that links Student System persons to their TCA party records.

Usage Notes

This package is invoked indirectly rather than by end users. It is called by forms and concurrent programs in the Student System, by higher-level packages such as IGS_PE_HZ_PARTIES_PKG and IGS_PE_ALT_PERS_ID_PKG, and by custom extensions that insert or update person data. The dependency on HZ_PARTY_V2PUB, FND_API, FND_MSG_PUB, and IGS_GE_MSG_STACK indicates that it participates in the standard EBS API error-handling and message-stack conventions. Custom code should invoke it as an internal API and, because its signature is undocumented, verify the specification in the target release.