Search Results per_sbt_del




Overview
Explore in AI Chat

Overview

PER_SBT_DEL is an Oracle EBS PL/SQL package owned by the APPS schema that supports maintenance of subject-taken (SBT) translation data within Oracle Human Resources. The package name derives from the PER_SUBJECTS_TAKEN entity, and its documented purpose is to delete translation-layer rows from the subject-taken tables. Specifically, PER_SBT_DEL operates against PER_SUBJECTS_TAKEN_TL, the multilingual translation table that stores language-specific display values for subjects an employee or applicant has taken.

The object is classified as OTHER in the ETRM metadata, meaning it is a supporting utility rather than a public, business-facing API. It holds VALID status in both Oracle EBS 12.1.1 and 12.2.2 and contains a single documented procedure, DEL_TL. Its dependency footprint is deliberately narrow: at the database level it references only SYS.STANDARD, and at the application level it is referenced by HR_QUA_AWARDS_UTIL_SS and by PER_SBT_DEL itself. This narrow footprint is consistent with a low-level cleanup routine invoked by higher-level HR utilities rather than directly by end users.

Key Procedures and Functions

The documented interface exposes one procedure, DEL_TL. In keeping with the naming convention used throughout Oracle HR translation-handling code, the "_TL" suffix indicates that the procedure targets the translation table, and the "DEL" prefix indicates a deletion operation. DEL_TL is therefore understood to remove translation rows from PER_SUBJECTS_TAKEN_TL for one or more subject-taken records supplied by the caller. It is an internal maintenance routine used to keep the translation table synchronized when the corresponding base subject-taken data is removed or reorganized.

Consistent with its OTHER API classification, DEL_TL is not a public, certified interface. It does not expose the standard row-versioning or business-rule validation parameters found in Oracle's published HR APIs. Its behavior is bound to the structures it serves, and its signature is intended for consumption by Oracle-delivered code such as HR_QUA_AWARDS_UTIL_SS rather than by customer extensions. No parameter list is documented in the ETRM metadata, and none should be assumed.

Tables Accessed

The single documented table reference is PER_SUBJECTS_TAKEN_TL, accessed through the APPS synonym layer. This table stores translated descriptions for subject-taken records, one row per language installed in the E-Business Suite instance. DEL_TL removes rows from this table so that no orphaned translations remain after the parent subject-taken data is deleted or the associated language is no longer required. Because the metadata lists only this one table, the package should be regarded strictly as a translation-table maintenance utility. It does not appear to read or write the base PER_SUBJECTS_TAKEN table or any other HR subject tables as part of its documented behavior.

Usage Notes

PER_SBT_DEL is not intended for direct invocation by end users, Oracle Forms, or customer-written concurrent programs. Its documented caller is HR_QUA_AWARDS_UTIL_SS, an Oracle-delivered utility associated with the HR qualifications and awards functionality, which indicates that DEL_TL is reached indirectly through Oracle's own subject-taken maintenance flows. The self-reference shown in the dependency listing reflects internal package calls within PER_SBT_DEL's own body.

Because DEL_TL performs unrecoverable deletion against a translation table, it should not be invoked from custom code. Where custom logic must remove subject-taken records, the supported approach is to use Oracle's published HR APIs and let the delivered utilities manage dependent translation rows. Administrators diagnosing stale or duplicate translation entries in PER_SUBJECTS_TAKEN_TL should treat PER_SBT_DEL as an Oracle-internal component: it exists to service delivered HR functionality, its interface is uncertified, and its behavior may change between maintenance releases or patch levels.