Search Results chk_integrity

Overview

APPS.PER_RIC_PKG is a public PL/SQL package in Oracle E-Business Suite that supports the People (PER) product's referential integrity and record identification framework. Its name reflects its role as the "RIC" (Referential Integrity Check) utility package within the Human Resources foundation layer. The package provides the data structures and helper logic used to describe column-level values and the entities that reference them, allowing Oracle EBS to verify that relationships between HR entities remain consistent when records are created, updated, or deleted.

The package is defined with AUTHID CURRENT_USER and carries a header revision of pericpkg.pkh 120.1 dated 2011/04/28. Its API classification is OTHER, indicating it is an internal framework utility rather than a business-facing transactional API. It is not intended for direct invocation by end-user extensions; its structures and functions are consumed by the broader HR integrity-checking infrastructure.

Key Procedures and Functions

ETRM documents eight program units on this package, three of which are named in the metadata extract:

• COL_INFO_REC — A function that turns individual attribute arguments into a populated column_info_rec record. It constructs the record structure used to describe a single column value, supporting VARCHAR2, NUMBER, and DATE forms. This is the primary public builder function and is documented as "Internal Table Handler Use Only."
• REF_INFO_REC — A companion function that builds a ref_entity_rec record, capturing a referencing entity together with its associated collection of column information. It assembles the "referenced table" side of the integrity model.
• CHK_INTEGRITY — The integrity-checking entry point. This is the procedure that performs the actual referential integrity validation using the entity and column information assembled by the builder functions.

The package additionally declares two collection types, column_info_tbl and ref_entity_tbl, and two package-level global variables (g_column_info_tbl and g_ref_entity_tbl) that accumulate integrity information during processing.

Tables Accessed

The only table documented as referenced through APPS synonyms is PLITBLM, an Oracle-supplied index-organized table commonly used as temporary storage for structured PL/SQL collections. PER_RIC_PKG uses this table as working storage for the column and entity collections it builds during integrity checks, enabling the package to persist and correlate integrity data within a session.

Usage Notes

PER_RIC_PKG is an internal framework package. It is referenced by 104 other packages in the ETRM inventory, confirming its role as a widely depended-upon utility rather than a standalone API. Typical invocation occurs indirectly: HR forms, concurrent programs, and validation routines that need to confirm referential integrity call the builder functions to assemble column and entity information, then invoke CHK_INTEGRITY to perform the check. Because the package operates as AUTHID CURRENT_USER and is marked for internal table handler use, custom development should not call it directly; instead, developers should rely on the higher-level HR APIs that consume it. Any change to the record structures or the global collections should be treated as a framework-level modification with broad downstream impact.