Search Results igs_pe_hz_rel_pkg

Overview

IGS_PE_HZ_REL_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Student System / People Enterprise (IGS) product family and serves as a data-access layer between the institution's student and person records and the Oracle Trading Community Architecture (TCA) relationship model held in the HZ_ schema. Its core purpose is to maintain the link records stored in IGS_PE_HZ_REL, which associate an IGS person record with a corresponding TCA party and relationship entry. The package encapsulates the standard insert, update, delete, and locking logic required to keep that link consistent, and it performs validation and defaulting before the DML reaches the base table. The object holds a VALID status in the ETRM repository and is classified under the "OTHER" API classification rather than as a formal public interface. It references the STANDARD package in the SYS schema and is referenced internally by IGS_PE_RELATIONSHIPS_PKG, indicating it is one building block within the wider IGS person and relationship processing chain.

Key Procedures and Functions

• INSERT_ROW — Inserts a new association row into the IGS relationship store, applying the standard WHO columns and row defaults expected by the surrounding IGS data model.
• LOCK_ROW — Obtains a row-level lock on an existing record so that concurrent updates from multiple sessions cannot silently overwrite one another.
• UPDATE_ROW — Modifies an existing relationship link record, typically after retrieval and locking through the companion procedures.
• ADD_ROW — Provides the higher-level "create" entry point that combines validation and defaulting with the underlying insert operation.
• DELETE_ROW — Removes the relationship link record from IGS_PE_HZ_REL.
• GET_PK_FOR_VALIDATION — Resolves or confirms the primary key of the target row so that validation and subsequent DML operate against a known, unambiguous record.
• BEFORE_DML — Centralises pre-DML logic such as attribute defaulting, mandatory-value checks, and lookup validation, invoked ahead of the insert, update, and delete paths.

The ETRM metadata does not publish parameter lists for these units, so they should be inspected in the database before being called directly.

Tables Accessed

• IGS_PE_HZ_REL — The principal base table managed by this package; it holds the link between IGS person data and TCA relationship data.
• HZ_RELATIONSHIPS — The TCA relationship table holding party-to-party relationship definitions; read and possibly written so the IGS link stays synchronised with the TCA model.
• HZ_PARTIES — The TCA party master, consulted to validate the party referenced by a relationship and to confirm it exists and is active.
• FND_LOOKUP_VALUES — The Oracle EBS lookup repository, used to validate user-entered codes (for example relationship type or status codes) against the values defined for the relevant lookup type.

These objects are addressed through APPS synonyms, which is the expected pattern for a package residing in the APPS schema that must read both IGS and HZ tables.

Usage Notes

The package is not a standalone user-facing API. It is normally invoked indirectly from Oracle Student System forms and related PL/SQL packages when a user creates, amends, or removes a person relationship that must be reflected in TCA. The documented dependency on IGS_PE_RELATIONSHIPS_PKG confirms that at least one higher-level package calls into these routines rather than applications calling them directly. Because the procedures carry no documented public signature and the object is classified as "OTHER", custom code should treat it as an internal implementation detail and, where possible, use the supported IGS relationship APIs instead. When direct invocation is unavoidable, callers should follow the prescribed sequence of validating and locking the row before performing updates or deletes, so that the standard BEFORE_DML logic and concurrency controls are honoured. Migrations or data-fix scripts touching IGS_PE_HZ_REL should route through this package to preserve consistency with the referenced TCA party and relationship records.