Search Results per_sbt_upd




Overview
Explore in AI Chat

Overview

PER_SBT_UPD is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports maintenance of subject-taken information within Oracle Human Resources. Its documented API classification is "OTHER," indicating that it is an internal utility package rather than a formally published public API such as those in the HR_API family. The package name follows Oracle's standard convention for update routines (the "_UPD" suffix), and its single documented procedure, UPD_TL, targets the translation ("_TL") layer of the subject-taken entity.

In Oracle EBS, subject records represent the link between a person or student and a subject of study, and because EBS is multilingual, the descriptive (translatable) columns of such records are stored separately from the base rows in translation tables. PER_SBT_UPD exists to populate and maintain those translation rows so that subject-taken descriptions display correctly in the session language. It is referenced by PER_SBT_UPD itself (recursive or overloaded usage within the package body) and by HR_QUA_AWARDS_UTIL_SS, a shared utility component used in HR qualification and award processing, indicating the package participates in broader HR qualification workflows.

Key Procedures and Functions

The ETRM metadata documents exactly one procedure or function in this package:

  • UPD_TL — The translation layer maintenance routine. Based on its documented dependency on the PER_SUBJECTS_TAKEN_TL table and its name, UPD_TL inserts or updates the translatable descriptive attributes for a subject-taken row in the language-specific translation table. Only the name and purpose are documented; the parameter list is not published and should not be assumed.

Tables Accessed

The single documented table referenced via APPS synonyms is:

  • PER_SUBJECTS_TAKEN_TL — The translation table for subjects taken. UPD_TL writes to and reads from this table to create or refresh the language-specific, translatable columns associated with a base subject-taken record. Any corresponding base-table handling is performed elsewhere; the documented scope of PER_SBT_UPD is confined to the translation layer.

Usage Notes

PER_SBT_UPD is an internal maintenance package. It is not a public HR API and is not documented for direct customer invocation. Two dependency patterns govern its lifecycle:

  • Dependencies it consumes: APPS.HR_API and SYS.STANDARD. The HR_API reference confirms reliance on Oracle's HR API error-handling and utility infrastructure, meaning calls through UPD_TL expect that error stack to be initialized by the caller.
  • Dependencies that consume it: HR_QUA_AWARDS_UTIL_SS and PER_SBT_UPD (its own package body). The link to HR_QUA_AWARDS_UTIL_SS shows the package is invoked as part of HR qualification and award utility processing, particularly where subject-taken translation data must be synchronized.

Because the package is classified as "OTHER" and exposes only one documented procedure, customers should not call it directly from forms or concurrent programs. Customizations that require translation maintenance for subjects taken should use supported HR APIs or the standard HR forms; direct calls to PER_SBT_UPD risk bypassing validation and error-handling logic. When diagnosing multilingual display issues for subject-taken records, PER_SBT_UPD and PER_SUBJECTS_TAKEN_TL are the objects to review.