Search Results load_configuration

Overview

APPS.PER_RI_CONFIG_RESPON_PKG is a configuration utility package within the Oracle E-Business Suite Human Resources (PER) product family. Its purpose is to manage the population and validation of responsibility-to-territory configuration records used by the Oracle iRecruitment (RI) module. iRecruitment relies on a mapping between a responsibility, an operating territory, and a product key so that the correct recruiting configuration is presented to users depending on where and how they access the application. This package provides the programmatic entry point for registering those mappings in a controlled manner, preventing duplicate configuration rows from being created.

The package body carries the header identifier perriconresp.pkb 120.0 dated 2005/06/01, indicating that the logic has remained stable across the 12.1.1 and 12.2.2 releases. It is classified in the ETRM repository as an "OTHER" API, meaning it is not a formally published, versioned public API but an internal configuration helper invoked by setup and migration routines.

Key Procedures and Functions

The ETRM metadata documents a single exposed procedure, LOAD_CONFIGURATION. This procedure accepts a responsibility application, a territory code, and a responsibility key, and serves as the top-level driver for establishing a configuration responsibility record. Logic within the procedure declares a cursor that queries PER_RI_CONFIG_RESPONSIBILITY for an existing row matching all three supplied values. If no matching row is found, LOAD_CONFIGURATION delegates to the private helper procedure CREATE_CONFIG_RESPONSIBILITY, passing the same three values. If a match already exists, the procedure simply returns without performing an insert, making the operation idempotent.

The private procedure CREATE_CONFIG_RESPONSIBILITY performs an additional validation step. It opens a cursor against HR_LOOKUPS restricted to lookup type PER_RI_CONFIG_PRODUCTS, cross-referencing existing rows in PER_RI_CONFIG_RESPONSIBILITY. A row is inserted into PER_RI_CONFIG_RESPONSIBILITY only when the lookup validation returns no record; otherwise the procedure returns without modification. This layered check protects against inserting configuration entries that are not recognised as valid iRecruitment configuration products.

Tables Accessed

The package interacts with two principal data sources. The first is PER_RI_CONFIG_RESPONSIBILITY, referenced through an APPS synonym. This table stores the authoritative responsibility-to-territory configuration mapping and is both read (for duplicate detection) and written (via insert) by the package.

The second is HR_LOOKUPS, accessed to validate candidate product codes against lookup type PER_RI_CONFIG_PRODUCTS. HR_LOOKUPS is the standard Oracle HR foundation table for extensible lookup values, and its use here ties the configuration load to values maintained by the system administrator. No other tables are documented as referenced by this package.

Usage Notes

Because LOAD_CONFIGURATION is not a published public API, it is generally invoked during iRecruitment setup, environment cloning, or data migration activities rather than from end-user forms. Typical callers include SQL scripts and custom concurrent programs executed by a DBA or implementation consultant when seeding or refreshing responsibility configuration. The procedure is safe to re-run: its duplicate-detection cursor ensures that repeated invocations with identical parameters do not produce redundant rows. ETRM records no other packages referencing this one, so dependencies flow inward only. When extending or troubleshooting iRecruitment responsibility setup, this package should be treated as the canonical programmatic mechanism for inserting configuration rows, with direct DML against PER_RI_CONFIG_RESPONSIBILITY discouraged.