Search Results update_config_information




Overview
Explore in AI Chat

Overview

APPS.PER_RI_CONFIG_INFORMATION_API is a public PL/SQL API package belonging to the Oracle Human Resources (PER) product family, specifically the Regulatory Information (RI) subsystem. Its business purpose is to maintain the configuration information rows that drive the Regulatory Information configuration framework within Oracle E-Business Suite. That framework lets implementers define configuration codes and configuration information categories — for example country-specific or legislation-specific reporting attributes — which are then consumed by Regulatory Information workbench items and related HR regulatory processes. The package provides a controlled, validated data-access layer over the underlying configuration tables rather than requiring direct DML against them. The source header (pecniapi.pkb, version 120.0, dated 2005/05/31) confirms it is a long-standing seeded API carried forward through release 12.1.1 and 12.2.2, and the ETRM classification of "API" confirms it is intended for programmatic invocation by Oracle forms, concurrent programs, and customer extensions.

Key Procedures and Functions

The package exposes three documented procedures, corresponding to the standard create/update/delete maintenance pattern:

  • CREATE_CONFIG_INFORMATION — Inserts a new configuration information row for a given configuration code, configuration information category, and configuration sequence. It accepts up to seventeen generic p_config_information1 through p_config_information17 attribute columns plus a p_validate flag, allowing the caller to exercise the business logic in validation-only mode before committing.
  • UPDATE_CONFIG_INFORMATION — Modifies an existing configuration information row identified by its configuration code, category, and sequence. This is the procedure most commonly targeted by callers searching for that keyword, and it is the supported alternative to a direct UPDATE on the underlying configuration table.
  • DELETE_CONFIG_INFORMATION — Removes a configuration information row, again keyed by configuration code, category, and sequence, with the same validation-only option.

Supporting the procedures, the package body declares private globals including g_business_group_id and g_legislation_code used for translation validation, and g_package for error message prefixing.

Tables Accessed

The ETRM metadata documents three tables referenced through APPS synonyms:

  • HR_LOCATIONS_ALL — the base HR locations table, read for location-based validation and configuration lookups.
  • HR_LOCATIONS_ALL_TL — the translated (language) variant of HR locations, used to validate translated configuration values against the session's legislation and business group context.
  • PER_RI_WORKBENCH_ITEMS_TL — the translated Regulatory Information workbench items table, which links the defined configuration information to the workbench items presented to end users.

Usage Notes

The package is documented as referenced by three other packages, indicating it sits low in the Regulatory Information dependency chain and is called by higher-level RI setup logic. It is typically invoked when defining or maintaining Regulatory Information configuration data — from the relevant HR setup forms, from concurrent programs that load configuration information, or from custom PL/SQL during implementation and data migration. Callers should always pass p_validate >= TRUE first to trap validation errors, supply the correct business group and legislation context so translation validation succeeds, and commit only after a successful validated call. Because it is a registered API, it should be preferred over direct DML against PER_RI_WORKBENCH_ITEMS_TL, HR_LOCATIONS_ALL, or HR_LOCATIONS_ALL_TL for configuration maintenance.