Search Results hr_scl_shd




Overview
Explore in AI Chat

Overview

HR_SCL_SHD is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. The package name follows the convention of the HR schema's shared service libraries, and its documented identity as "HR_SCL_SHD" indicates a Shared (SHD) component associated with soft coding (SCL) logic within Oracle Human Resources. Its role is to provide a centralized, reusable utility for validating and managing soft-coded Key Flexfield segment combinations against the rules defined for the HR soft coding key flexfield. This is the mechanism that governs which combinations of segment values are permissible for a given flexfield structure, ensuring that data entered through HR forms and APIs conforms to the configured validation and cross-validation rules before it is written to the database.

The package is classified under the generic API classification OTHER in the ETRM documentation, which reflects that it is an internal supporting library rather than a documented public business API. It is marked VALID in the data dictionary and is referenced by five other database objects, indicating that it functions as a dependency in the HR soft coding call stack rather than as an entry point invoked directly by end users.

Key Procedures and Functions

Five procedures are documented for this package body. Their names and documented purposes are as follows:

  • SEGMENT_COMBINATION_CHECK — The core validation routine. It evaluates a proposed segment combination for the soft coding key flexfield and determines whether the combination satisfies the applicable validation and cross-validation constraints.
  • RETURN_API_DML_STATUS — Returns the DML status of the API operation, allowing the calling program to determine whether the preceding soft coding operation succeeded or failed before proceeding.
  • CONSTRAINT_ERROR — Handles constraint-related error conditions raised during segment combination validation, providing a controlled error path instead of an unhandled exception.
  • API_UPDATING — Indicates or manages the updating state of the API, used to distinguish insert versus update processing within the soft coding logic.
  • CONVERT_ARGS — Converts or normalizes arguments passed into the package before they are processed by the validation routines, ensuring the internal logic receives values in the expected format.

No parameter lists are documented in the ETRM metadata, and none are inferred here.

Tables Accessed

The documented table references, resolved through APPS synonyms, are used to drive soft coding validation:

  • HR_SOFT_CODING_KEYFLEX — The primary repository of soft coding key flexfield definitions; the package reads flexfield structure and segment information from it.
  • FND_SEGMENT_ATTRIBUTE_VALUES — Supplies segment attribute settings that determine how individual segments behave during validation.
  • ALL_CONSTRAINTS — Read to inspect constraint definitions relevant to the flexfield, supporting the CONSTRAINT_ERROR handling path.
  • PAY_LEGISLATION_RULES — Provides legislation-specific rules that influence whether a given combination is valid for the operating business group's legislation.

The package additionally depends on HR_API, HR_UTILITY, and PER_BUSINESS_GROUPS, which supply the surrounding API plumbing, business group context, and shared utility functions used throughout the validation flow.

Usage Notes

HR_SCL_SHD is an internal dependency rather than a user-facing API. It is typically invoked indirectly whenever an HR form or a public HR API processes a soft-coded key flexfield combination — for example, during entry or update of employee, position, or organization information that carries soft coding segments. The package's dependency on PER_BUSINESS_GROUPS confirms that it operates within a business group context and applies the legislation rules appropriate to that group.

Because the package body is not referenced by any database object per the ETRM dependency report, customizations should not call it directly. The documented practice for extending HR soft coding behavior is to use the supported public HR APIs and the flexfield configuration layer. The RETURN_API_DML_STATUS procedure is significant in this respect: calling programs rely on it to obtain a reliable success or failure signal, which is characteristic of EBS API error-handling conventions where a returned status must be checked explicitly rather than inferred from the absence of an exception. Any modification to this package body falls under the standard Oracle support policy for undocumented internal components.