Search Results per_contact_extra_info_pkg




Overview
Explore in AI Chat

Overview

The APPS.PER_CONTACT_EXTRA_INFO_PKG package body is a small, single-purpose PL/SQL utility within the Oracle E-Business Suite Human Resources (Oracle HRMS) schema. Its documented responsibility is to determine the existence of supplementary contact information associated with a contact relationship. In Oracle HRMS, the PER_CONTACT_EXTRA_INFO entity stores additional, typed attributes attached to a contact relationship beyond the core contact record. The package exposes a boolean-style existence check, returning the character 'Y' when a matching extra information record exists and 'N' otherwise.

As documented in the ETRM metadata, the API classification is OTHER, indicating that it is neither a standard business object API nor a public datetracked write API, but rather an internal helper used by HRMS contact-processing logic. The package body carries the header identifier pecei01t.pkb 115.3, dated 2002, reflecting a long-stable implementation that has persisted unchanged through EBS 12.1.1 and 12.2.2. The header comment declares the package access status as Public, even though it functions as a lightweight query helper.

Key Procedures and Functions

The package body documents exactly one callable program unit: POPULATE_INFO_EXISTS.

  • POPULATE_INFO_EXISTS — A function that accepts a contact relationship identifier and an information type, and returns 'Y' if a PER_CONTACT_EXTRA_INFO record exists for that combination; otherwise it returns 'N'. It performs no inserts, updates, or deletions. Its documented prerequisites are none, and it has no output parameters other than the return value. The function is intended to let a calling process decide whether to populate or create extra information, avoiding duplicate entries.

The ETRM metadata notes that this package is referenced by zero other documented packages, so its consumption occurs through forms, concurrent programs, or custom extensions rather than through a package dependency chain.

Tables Accessed

The package references the PER_CONTACT_EXTRA_INFO_F table via an APPS synonym. In practice, the function queries PER_CONTACT_EXTRA_INFO, matching on contact_relationship_id and information_type. The _F suffix in the parameter type declarations indicates the table is treated as a datetrack (date-tracked) entity, but the existence check itself does not apply datetrack filters — it simply tests for any qualifying row. No writes are performed against this table.

Usage Notes

This helper is typically invoked from Oracle Forms personalizations, CEMLI customizations, or PL/SQL routines that manage contact extra information during contact maintenance. A common pattern is to call POPULATE_INFO_EXISTS before attempting to insert or update a contact extra information row, thereby avoiding unique-constraint violations or duplicate data. It is also useful in reporting or validation logic that must confirm whether an information type has been captured for a given contact relationship.

Because the function is coarse-grained — accepting identifier values as VARCHAR2 and returning a one-character flag — it is inexpensive and safe to call repeatedly. No exception handling is implemented beyond implicit cursor behavior, so callers should ensure valid inputs. The package should be regarded as a read-only, stable utility suitable for reuse across HRMS contact-related development in both 12.1.1 and 12.2.2.