Search Results igs_pe_person_addr_pkg




Overview
Explore in AI Chat

Overview

The package body APPS.IGS_PE_PERSON_ADDR_PKG is a PL/SQL API within the Oracle E-Business Suite 12.1.1 / 12.2.2 environment that manages person address data in the context of the Oracle Student System (formerly Oracle iLearning / Student Management) and the Trading Community Architecture (TCA) party model. Its principal business responsibility is to persist and maintain address records associated with person parties, ensuring that address information held in institution-specific staging structures is synchronized with the canonical TCA location and party site tables. The package is classified as an API of type OTHER under the APPS schema and is currently reported with a VALID status.

The package relies on the standard EBS API infrastructure, including FND_API, FND_MESSAGE, FND_MSG_PUB, FND_PROFILE, and APP_EXCEPTION, and it delegates downstream address processing to TCA public APIs such as HZ_LOCATION_V2PUB and HZ_PARTY_SITE_V2PUB. This design confirms the package's role as a wrapper or coordination layer between student-system address logic and the TCA address model.

Key Procedures and Functions

Two documented procedures are exposed by this package body:

  • INSERT_ROW — Creates a new person address record. The procedure orchestrates the creation of the underlying TCA location and party site data and then writes the institution-specific address row, applying standard API validation, message handling, and error propagation through FND_MSG_PUB and IGS_GE_MSG_STACK.
  • UPDATE_ROW — Modifies an existing person address record. It applies updates to the corresponding TCA location and party site entries and refreshes the associated staging row, again using standard message-stack and exception-handling conventions.

Parameter lists and detailed signatures are not exposed in the documented metadata and are therefore not enumerated here. Both procedures are intended to be called transactionally, with the caller responsible for savepoint and commit/rollback management.

Tables Accessed

The package reads and writes the following documented tables, accessed through APPS synonyms:

  • HZ_PARTY_SITES — The central TCA table holding the association between a party and a location. INSERT_ROW and UPDATE_ROW maintain rows here to keep party address assignments current.
  • IGS_PE_HZ_PTY_SITES — The student-system extension table that stores institution-specific attributes for a party site. This table is written to preserve attributes not held in standard TCA columns.
  • HZ_PARTY_SITE_NUMBER_S — The sequence used to generate party site numbers for newly created site records.
  • HZ_PERSON_PROFILES — Provides person-level context and validation for the party being processed.
  • DUAL — Used for standard single-row queries and sequence/utility access.

Supporting package dependencies include IGS_PE_HZ_PTY_SITES_PKG, which encapsulates logic for the extension table, and the TCA public APIs HZ_LOCATION_V2PUB and HZ_PARTY_SITE_V2PUB, which perform the authoritative insert and update operations on TCA location and site entities.

Usage Notes

This package is typically invoked from student-system forms and custom PL/SQL routines when person address information must be created or amended. Its reliance on the TCA public APIs means it should be called within the standard API transaction pattern: initialize the message stack, invoke the procedure, inspect the return status and message stack, and commit or roll back accordingly. The metadata records that the package is referenced by nine other database objects, indicating that it functions as a reusable component across multiple student-system modules rather than being called directly by end users. Direct DML against the underlying tables should be avoided in favor of this API to preserve TCA data integrity and message-stack consistency.