Search Results per_ri_config_location_api




Overview
Explore in AI Chat

Overview

The APPS.PER_RI_CONFIG_LOCATION_API package is a public PL/SQL API belonging to the Oracle Human Resources (PER) product family, specifically supporting the Oracle iRecruitment and Recruitment configuration infrastructure. Its name — PER (Human Resources), RI (Recruitment iRecruitment), CONFIG_LOCATION — indicates that it manages the configuration of location data used within the recruitment configuration model. In Oracle EBS 12.1.1 and 12.2.2, this package is classified as a public API within the ETRM documentation, meaning it is intended to be invoked programmatically rather than called only internally. It exposes a controlled, business-rule-aware interface for creating, updating, and deleting recruitment configuration locations, shielding callers from the underlying table structures and validation logic. As a wrapper over location data, it ensures that recruitment-specific configuration records remain consistent with the global HR locations model.

Key Procedures and Functions

Three documented procedures constitute the public interface of this package:

  • CREATE_LOCATION — Creates a new recruitment configuration location record, applying the necessary validations and defaulting rules before persisting the data.
  • UPDATE_LOCATION — Modifies an existing recruitment configuration location record, ensuring that changes conform to the same validation and integrity rules enforced at creation time.
  • DELETE_LOCATION — Removes a recruitment configuration location record, managing the associated dependencies so that referential integrity is preserved.

The ETRM metadata does not publish parameter lists for these procedures. Callers must consult the package specification in the database or the Oracle Integration Repository for exact signatures before use.

Tables Accessed

The package operates against the following tables through APPS synonyms:

  • HR_LOCATIONS_ALL — the base location definition table, which stores the core location attributes for the enterprise.
  • HR_LOCATIONS_ALL_TL — the translation table holding the language-specific descriptive text for each location.
  • PER_RI_WORKBENCH_ITEMS_TL — a recruitment workbench translation table that supports the configuration workflow and its translatable display items.

These references confirm that the API both reads existing location definitions and writes recruitment configuration records, keeping the recruitment configuration layer synchronized with the underlying HR location data.

Usage Notes

PER_RI_CONFIG_LOCATION_API is referenced by several other packages in the APPS schema, including PER_RI_CONFIG_IMPORT_PKG, PER_RI_CONFIG_LOCATION_API itself (internal recursion), PER_RI_CONFIG_LOCATION_SWI, and PER_RI_MNG_CFG_PKG. The presence of a Software Interface (SWI) package and an import package indicates that this API is typically invoked during recruitment configuration import and management operations rather than directly by end users. It is not normally attached to a form or concurrent program directly; instead, it is called by higher-level configuration management and import routines that drive the iRecruitment configuration process. The package depends on HR_API, the standard HR API utility package, and on SYS.STANDARD, confirming that it follows Oracle's standard API error-handling and validation conventions. Custom code should invoke this API rather than performing direct DML on the underlying tables, so that all recruitment configuration validations and derived data are applied consistently. Because the package is documented as a public API, Oracle supports its use by external callers, but only through the published procedures; internal dependencies remain subject to change across releases.