Search Results per_sbt_ins




Overview
Explore in AI Chat

Overview

PER_SBT_INS is an Oracle EBS Applications (APPS) schema PL/SQL package classified under the ETRM metadata as an "OTHER" API. It is associated with the Oracle Human Resources (PER) product family, specifically the "Subjects Taken" information maintained for persons and learners. Within the PER schema naming conventions, the "SBT" segment refers to "Subjects Taken" data, and the INS suffix denotes an insert-oriented utility package. The package therefore serves as a low-level insertion helper used to create and persist translated subject-taken records, including their language-dependent descriptive information.

The package holds VALID status against owner APPS in both Oracle EBS 12.1.1 and 12.2.2. Its documented scope is narrow: rather than exposing a broad business API surface, it provides a single insert routine intended for internal consumption by higher-level HR and Oracle Learning Management utility code. This design keeps language-handling logic centralized while allowing calling packages to focus on their own transactional responsibilities.

Key Procedures and Functions

The ETRM documentation records a single program unit for this package:

  • INS_TL — The core insertion routine. Based on its name, the "_TL" suffix indicates that it operates on the translation (language-dependent) layer of the subjects-taken entity. It is designed to insert translated row data for a subject-taken record, linking the record to a specific language. The procedure encapsulates the mechanics of writing to the translation table so that callers do not duplicate language validation or attribute assignment logic. The ETRM metadata does not publish a parameter list, so no arguments are enumerated here.

The package body is marked as containing SQL statements, confirming that INS_TL performs DML directly rather than delegating to an external interface. No additional public procedures or functions are documented.

Tables Accessed

Two tables are referenced through APPS synonyms:

  • PER_SUBJECTS_TAKEN_TL — The primary target of the INS_TL routine. This is the translation table storing language-specific attributes for subjects-taken records. INS_TL inserts rows into this table, which is consistent with the routine's naming and purpose.
  • FND_LANGUAGES — The Oracle Application Object Library table of installed languages. Reference to this table indicates that INS_TL validates or resolves the language code supplied by the caller, ensuring that translated rows are only created for languages installed and enabled in the E-Business Suite instance.

The dependency listing also records SYS.STANDARD, the PL/SQL built-in package, reflecting ordinary language-level dependencies rather than a data source.

Usage Notes

PER_SBT_INS is a backend utility rather than a user-facing API. It is typically invoked indirectly by higher-level HR and learning modules that manage subject-taken and qualification data on behalf of learners. The ETRM dependency information confirms this: the package is referenced by APPS.HR_QUA_AWARDS_UTIL_SS, a shared utility in the qualifications awards area, and by the package body of PER_SBT_INS itself (reflected as a self-reference in the dependency map).

Given that only one other package references it, customizations should avoid direct calls to PER_SBT_INS. Because INS_TL writes translation rows without a documented public validation contract, callers must already have inserted the base (non-translated) subjects-taken record and must supply a language present in FND_LANGUAGES. Direct invocation bypasses any business rules enforced at higher layers, so developers extending Oracle Learning Management should prefer the supported parent APIs. Where PER_SBT_INS must be used, it should be treated as an internal, version-sensitive dependency subject to change in future EBS releases.