Search Results igs_pe_match_sets_pkg




Overview
Explore in AI Chat

Overview

The APPS.IGS_PE_MATCH_SETS_PKG package is a core data-access and validation component within the Oracle E-Business Suite (EBS) Student System / Enterprise Teradata Relationship Management (ETRM) module. The package has a status of VALID in the APPS schema and is classified as an "OTHER" API type within the documented ETRM 12.1.1 metadata, indicating that it is intended primarily for internal use by the application rather than as a published public API. Its role is to encapsulate the DML operations, row locking, constraint validation, and foreign-key resolution logic supporting the IGS_PE_MATCH_SETS entity, which stores configurations of match sets used by person-entity (PE) duplicate and near-match processing. Match sets define the criteria by which the system identifies duplicate or near-matching person records, so this package underpins the data integrity of that configuration metadata.

The package is registered in the APPS schema and depends only on SYS.STANDARD at the documented level, though its package body clearly references the underlying tables and sequences described below.

Key Procedures and Functions

The ETRM documentation records eleven procedures and functions within this package. The DML management routines are INSERT_ROW, UPDATE_ROW, and DELETE_ROW, which perform the corresponding operations against the match set records. Complementary to these are ADD_ROW, a convenience wrapper that encapsulates the full insert path, and LOCK_ROW, which acquires a row-level lock to support optimistic concurrency control during multi-user edits.

The package also provides validation-oriented functions. GET_PK_FOR_VALIDATION resolves or confirms the primary-key value used during validation checks. GET_UK1_FOR_VALIDATION serves the equivalent role for a unique key, enabling the constraint checks to confirm uniqueness before a row is committed. The foreign-key resolvers GET_FK_IGS_PE_SRC_TYPES and GET_FK_IGS_PE_DUP_PAIRS return the parent-key values associated with the source-type and duplicate-pair relationships referenced by a match set row. CHECK_CONSTRAINTS is the central validation routine invoked to enforce the entity's business and database constraints, and BEFORE_DML acts as the pre-DML trigger routine that prepares and validates a record before any insert, update, or delete is applied. Parameter lists are not documented and are intentionally omitted here.

Tables Accessed

The package operates against two base tables through APPS synonyms. IGS_PE_MATCH_SETS_ALL is the primary multi-org (or "ALL") table holding the full match set definition, and IGS_PE_MATCH_SETS_S is the corresponding security/sequence-support table typically used for primary-key generation and row-level security. DUAL is referenced for scalar evaluations and sequence lookups. Together these tables supply the data that INSERT_ROW, UPDATE_ROW, DELETE_ROW, and the validation functions read and write.

Usage Notes

This package is not typically invoked directly by end users. It is referenced by three other packages — IGS_AD_IMP_NEAR_MTCH_PKG, IGS_AD_INTERFACE_CTL_PKG, and IGS_PE_SRC_TYPES_PKG — which exercise it during admission (AD) near-match import processing, interface control, and source-type maintenance. In a 12.1.1 or 12.2.2 environment, it is most commonly reached indirectly when a match set is maintained through the Student System administrative forms or when the near-match import concurrent programs run. Custom code should treat this as an internal implementation package: modifications or direct calls risk breaking the DML and constraint-validation contract relied upon by the dependent packages, so any extension should be made through the supported forms or through the higher-level APIs that wrap it.