Search Results check_unique_name

Overview

APPS.OTA_ADT_BUS is the business-layer PL/SQL package body that supports the Oracle E-Business Suite (EBS) Activity Definitions entity, part of the Oracle Learning Management (OLM) schema. It encapsulates the server-side business rules governing the creation, maintenance, validation, and translation of activity definition records used in training and learning administration. The package acts as the programmatic interface between the OLM forms and the underlying base tables, centralizing row-level validation, MLS (Multi-Language Support) translation validation, legislation derivation, and security group enforcement.

The package follows standard Oracle EBS "BUS" (business) layer conventions, evidenced by its use of hr_utility.set_location instrumentation, a global package name constant (g_package), and private global variables reserved for translation and legislation processing. The header comment (otadtrhi.pkb) indicates the object was last updated in 2004 and is present in both EBS 12.1.1 and 12.2.2 environments.

Key Procedures and Functions

• SET_SECURITY_GROUP_ID — Establishes the security group context (business group) for subsequent operations, ensuring that data access respects the user's security profile.
• RETURN_LEGISLATION_CODE — Derives and returns the applicable legislation code, relying on the private globals g_legislation_code, g_activity_id, and g_language. This supports legislative/regulatory context for activity definitions.
• INSERT_VALIDATE — Performs row-level validation prior to inserting a new activity definition record.
• UPDATE_VALIDATE — Validates attribute changes before an existing activity definition is updated.
• DELETE_VALIDATE — Validates whether an activity definition may be deleted, checking referential and business constraints.
• SET_TRANSLATION_GLOBALS — Initializes the global g_business_group_id used by translation validation routines.
• CHECK_UNIQUE_NAME — Enforces uniqueness of the activity definition name, most likely scoped by business group and language context. This is the routine users reach when searching for "check_unique_name."
• VALIDATE_TRANSLATION — Called from the MLS widget to validate translated (TL) rows, ensuring translation entries conform to MLS requirements before commit.

Tables Accessed

• OTA_ACTIVITY_DEFINITIONS — The base (non-translated) table holding activity definition records; read and written by the insert, update, delete, and uniqueness routines.
• OTA_ACTIVITY_DEFINITIONS_TL — The translated table storing MLS name/description values; accessed by VALIDATE_TRANSLATION and the translation global routines.

Both tables are referenced through APPS synonyms, consistent with EBS schema-access conventions.

Usage Notes

OTA_ADT_BUS is not a public API in the classical sense; it is classified as OTHER and is referenced by three other packages, indicating it is primarily invoked indirectly. In practice, it is called from the OLM Activity Definitions maintenance form (the MLS widget and form-level validation triggers), which invoke INSERT_VALIDATE, UPDATE_VALIDATE, DELETE_VALIDATE, and CHECK_UNIQUE_NAME during user interaction. The MLS widget specifically calls SET_TRANSLATION_GLOBALS and VALIDATE_TRANSLATION when users enter translated values.

Custom code should avoid calling this package directly; instead, use the supported OTA public APIs. Where uniqueness or translation concerns arise, understanding CHECK_UNIQUE_NAME and VALIDATE_TRANSLATION is essential for troubleshooting duplicate-name or translation errors surfaced to end users.