Search Results per_ri_adi_wrapper_pkg




Overview
Explore in AI Chat

Overview

PER_RI_ADI_WRAPPER_PKG is an Oracle E-Business Suite PL/SQL wrapper package owned by the APPS schema that serves as a programmatic interface for loading and maintaining Oracle Human Resources (PER) flexfield value set data. Its name reflects its role as an Application Data Interface (ADI) wrapper — a layer that abstracts and simplifies the underlying ADI business logic used by the Oracle HRMS value set value upload process. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer, which is typical for interfaces designed to be called from multiple contexts within the EBS application stack.

The package corresponds to the header file periwrap.pkh (version 120.0, dated 2005/05/31), indicating it is a long-standing component of the HR value set infrastructure. It is classified in the ETRM metadata as an "OTHER" API, meaning it is not a public, formally versioned Open Interface API but is nonetheless available for supported internal and custom invocation. The primary purpose of the package is to wrap the ADI upload routines so that HR value set values can be created or updated programmatically — for example, during data conversion, mass maintenance, or integration with external systems.

Key Procedures and Functions

The ETRM documentation lists two procedures for this package: UP_VSET_VALUE and CREATE_ORGANIZATION.

  • UP_VSET_VALUE — The principal procedure of the package, and the one associated with the search term up_vset_value. It is the routine that uploads (inserts or updates) a value into a flexfield value set. The procedure signature exposes a very large parameter list covering the upload phases and modes (p_upload_phase, p_upload_mode, p_custom_mode), the target value set (p_flex_value_set_name), the value itself and its parent (p_flex_value, p_parent_flex_value_low, p_parent_flex_value_high), ownership and audit fields (p_owner, p_last_update_date), status flags (p_enabled_flag, p_summary_flag), effective dates (p_start_date_active, p_end_date_active), rollup/hierarchy attributes (p_rollup_hierarchy_code, p_hierarchy_level), and a full range of descriptive flexfield attribute columns (p_attribute1 through p_attribute40 and beyond). This breadth allows callers to populate any combination of standard and descriptive value set attributes in a single invocation.
  • CREATE_ORGANIZATION — The second documented procedure, which supports organization-related setup that is required before or alongside value set value uploads. It provisions the organizational context into which HR value set values are loaded.

Tables Accessed

The only documented table accessed by this package (through an APPS synonym) is FND_FLEX_VALUE_SETS. This Oracle Application Object Library table stores the definitions of key and descriptive flexfield value sets, including the value set name, validation type, format type, and associated configuration. The wrapper reads from FND_FLEX_VALUE_SETS to validate the target value set specified by p_flex_value_set_name and to determine the correct handling for the uploaded value. While the ETRM excerpt lists only this table, the underlying ADI interface that the wrapper delegates to would typically also touch value-related tables such as FND_FLEX_VALUES and FND_FLEX_VALUES_TL; however, according to the documented metadata, FND_FLEX_VALUE_SETS is the referenced object for this package.

Usage Notes

PER_RI_ADI_WRAPPER_PKG is normally invoked indirectly rather than through a dedicated concurrent program. Typical invocation paths include:

  • Custom PL/SQL conversion or data-load scripts that need to create or update HR value set values in bulk.
  • Interfaces built on top of the Oracle HRMS Application Data Interface, where the wrapper provides a stable, named entry point instead of calling the underlying ADI code directly.
  • Form-based or concurrent processing that requires programmatic value set maintenance, where the caller supplies the upload phase/mode and the full set of value attributes.

Because the package uses AUTHID CURRENT_USER, the invoking session must have appropriate privileges on the referenced APPS objects. Callers should supply the upload phase and mode parameters correctly, as these govern whether the procedure inserts a new value, updates an existing one, or performs validation only. Given the very large attribute list (attribute1–attribute40 and beyond), custom code must pass or default every parameter consistently to avoid unintended null updates. The package is referenced by zero other documented packages, underscoring that it is a leaf-level interface intended for direct invocation by custom code or the ADI framework rather than by other packaged APIs.