Search Results check_title_is_unique

Overview

APPS.OTA_ENT_BUS is the business-layer PL/SQL package body that supports the Oracle E-Business Suite (EBS) Enterprise Training Management (OTRM) module, specifically the management of training events. It belongs to the OTA (Oracle Training Administration) schema family and carries an API classification of "OTHER," indicating that it is not strictly a public, supported Business API but rather an internal business-rule container invoked by generated table handlers and higher-level APIs. The package consolidates validation, uniqueness checking, and multi-lingual support (MLS) logic for training event records. It acts as the business-rules counterpart to the entity-level table handler code, ensuring that records inserted, updated, or deleted against the events tables satisfy OTRM business constraints before they are committed. The header comment ($Header: otentrhi.pkb 115.1 2003/04/24) indicates the package originated in the 11.5 development stream and has been retained largely unchanged into 12.1.1 and 12.2.2.

Key Procedures and Functions

• SET_SECURITY_GROUP_ID — Sets the session security context used by the package for row-level access to event data.
• RETURN_LEGISLATION_CODE — Returns the legislation code used in localization validation; the declared globals g_legislation_code and g_event_id support this logic.
• INSERT_VALIDATE — Performs business-rule validation prior to insertion of a training event record.
• UPDATE_VALIDATE — Performs business-rule validation prior to updating an existing training event record.
• DELETE_VALIDATE — Performs validation checks (such as referential dependencies) before a training event record is deleted.
• SET_TRANSLATION_GLOBALS — Initializes global variables (g_business_group_id, g_parent_event_id) that drive the multi-lingual translation widget for event titles and descriptions.
• VALIDATE_TRANSLATION — Executes the MLS validation logic for translated attributes, relying on the translation globals set above.
• CHECK_TITLE_IS_UNIQUE — Confirms that the title supplied for an event does not duplicate an existing title within the relevant scope, driving the uniqueness rule users search for.
• UNIQUE_EVENT_TITLE — The companion function that enforces/returns the unique event title constraint, complementing CHECK_TITLE_IS_UNIQUE.

Tables Accessed

The package operates against two documented base tables through APPS synonyms:

• OTA_EVENTS — The core training event table holding event attributes, business group, and security group information. Validation routines read this table to enforce uniqueness and business rules during insert, update, and delete.
• OTA_EVENTS_TL — The multi-lingual translation table storing event titles and descriptions per language. It is queried and validated by the translation routines and is directly relevant to check_title_is_unique, which must consider translated titles.

Usage Notes

OTA_ENT_BUS is not typically called directly from a form or concurrent program. Instead, it is invoked automatically by the OTRM table-handler and entity-layer code whenever training event records are created, modified, or removed, and by the MLS translation widget when event text is maintained in multiple languages. Custom developers may call check_title_is_unique or unique_event_title when building bespoke event-maintenance logic, and the package is referenced by three other documented packages within the OTA schema. Because the API classification is "OTHER," direct calls should be treated as dependent on internal implementation and re-validated during upgrades between 12.1.1 and 12.2.2.