Search Results per_ric_pkg




Overview
Explore in AI Chat

Overview

APPS.PER_RIC_PKG is a PL/SQL package body residing in the APPS schema within Oracle E-Business Suite, verified as VALID in both the 12.1.1 and 12.2.2 releases. It belongs to the Oracle Human Resources (PER) product family and is classified under the ETRM API taxonomy as "OTHER," indicating it is an internal or utility package rather than a formally published public API. The name component "RIC" reflects its role in the record information / integrity checking infrastructure used by the HR module, where it supports validation and structural consistency of record-level data consumed by payroll and HR processing logic. The package depends on APPS.HR_UTILITY, a general-purpose HR helper library, which confirms its positioning as a subordinate utility invoked by higher-level HR business logic rather than a top-level entry point. It does not depend on any other APPS package body directly, and no database object references it within the documented dependency tree, meaning it is called exclusively from the eight documented procedures and from external callers such as forms and concurrent logic.

Key Procedures and Functions

The ETRM repository documents eight procedures and functions within this package body. Three are named in the metadata excerpt:

  • COL_INFO_REC — operates on column-level information for a record, handling the retrieval or consolidation of record metadata used by downstream HR routines.
  • REF_INFO_REC — processes reference information associated with a record, supporting lookup and cross-reference resolution against HR reference structures.
  • CHK_INTEGRITY — performs an integrity check, validating that record data conforms to expected structural or referential rules before processing continues. This is typically the gatekeeper routine invoked prior to committing sensitive HR record changes.

The remaining five documented program units are not individually named in the available metadata. No parameter lists are published; parameter signatures must be confirmed by inspecting the package specification source in the target instance.

Tables Accessed

Only one table is documented as referenced through APPS synonyms:

  • PLITBLM — a PL/SQL internal table (index-by table) type declared for use within the package. Although listed in the table dependency section, PLITBLM is a PL/SQL collection construct rather than a physical database table, indicating the package relies on in-memory collections to buffer record information during processing.

No physical application tables are documented as direct dependencies. Any additional data access occurs indirectly through the APPS.HR_UTILITY calls, which encapsulate the underlying HR schema reads and writes.

Usage Notes

PER_RIC_PKG is referenced by 104 other packages according to the ETRM dependency record, making it a heavily reused internal utility within the HR module. It is typically invoked from HR forms, payroll concurrent programs, and custom HR extensions that require record information retrieval or record-level integrity validation. Because it depends on HR_UTILITY, any runtime call must occur in a session where APPS synonyms and the HR utility package are valid and initialized.

As an "OTHER"-classified package with no external references back to it at the database dependency level, PER_RIC_PKG should be treated as an internal implementation unit. Custom code should prefer documented public HR APIs; direct invocation of this package is appropriate only when replicating standard HR processing behavior, and callers must derive parameter signatures from the package specification rather than from documentation. Because the package is VALID across both 12.1.1 and 12.2.2, no version-specific incompatibility is indicated in the ETRM record.