Search Results per_sbt_shd




Overview
Explore in AI Chat

Overview

PER_SBT_SHD is a shadow (or "shadowing") package body owned by the APPS schema in Oracle E-Business Suite. In the Oracle HRMS (Human Resources Management System) architecture, shadow packages follow a consistent naming convention where the "_SHD" suffix identifies a package whose primary purpose is to manage the translation and language-installation lifecycle of a corresponding base package or entity. The PER_SBT_SHD package specifically supports the subjects-taken feature of Oracle Learning Management (OLM), which tracks the competencies, training courses, and academic subjects that an employee or applicant has completed.

The package is registered as a VALID object in both EBS 12.1.1 and 12.2.2 and is classified under the API classification OTHER, meaning it is an internal utility rather than a business-facing PL/SQL API intended for direct customer invocation. Its functional role is to handle multilingual support for the PER_SUBJECTS_TAKEN entity, allowing subjects-taken records to be enabled, seeded, and converted across the languages installed in an EBS instance.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within APPS.PER_SBT_SHD:

  • CONSTRAINT_ERROR — Handles constraint violations raised during operations performed by the package, providing a controlled exception path rather than allowing raw Oracle errors to propagate.
  • API_UPDATING — Signals whether the package is currently executing an API-level update, used to guard against recursive or conflicting modifications to subjects-taken data.
  • LCK — Implements locking logic to serialize concurrent operations against the subjects-taken tables.
  • ADD_LANGUAGE — Adds a new language row for the subjects-taken entity, typically invoked when a language is installed or when translation rows need to be seeded.
  • CONVERT_ARGS — Converts or normalizes arguments passed into the language-processing logic, ensuring that values are correctly formatted before they are written to the translated tables.

Consistent with Oracle convention for shadow packages, these procedures are helper routines rather than public business APIs, and no parameter lists are documented in the ETRM metadata.

Tables Accessed

The dependency listing identifies four APPS-synonym tables referenced by the package:

  • PER_SUBJECTS_TAKEN — The base subjects-taken table storing non-translated attributes of completed subjects.
  • PER_SUBJECTS_TAKEN_TL — The translated table holding language-specific text for subjects-taken records, which is where ADD_LANGUAGE and CONVERT_ARGS operations target their writes.
  • FND_LANGUAGES — The Oracle Application Object Library languages table, queried to determine installed languages and language codes during the add-language processing.
  • ALL_CONSTRAINTS — The data dictionary view used to inspect constraint definitions, supporting the CONSTRAINT_ERROR handling logic.

In addition, the package references FND_MESSAGE, HR_API, HR_UTILITY, and the base PER_SBT_SHD package, reflecting its dependence on Oracle HRMS message-handling and utility code.

Usage Notes

PER_SBT_SHD is not intended for direct invocation by end users or by custom application code. It is typically called internally by Oracle Learning Management and HRMS language-installation routines, and it is referenced by four other database packages within the EBS schema. Its execution paths are triggered by language installation and translation-maintenance activities rather than by forms or concurrent programs exposed to users. Developers troubleshooting translation gaps or constraint errors in the subjects-taken tables may encounter PER_SBT_SHD through its dependent packages; direct modification or invocation is neither necessary nor supported.