Search Results ota_adt_bus




Overview
Explore in AI Chat

Overview

OTA_ADT_BUS is the business-layer PL/SQL package for the Oracle EBS Activity Definitions (OTA) module, owned by the APPS schema and delivered in a VALID state across both 12.1.1 and 12.2.2. Within the OTA family, it sits directly beneath the four table-level DML packages — OTA_ADT_INS, OTA_ADT_UPD, OTA_ADT_DEL, and OTA_ADT_SHD — and is referenced by all four, meaning it functions as the shared validation and translation services layer that the insert, update, delete, and shadow packages call upon before committing activity definition records. Its documented API classification is OTHER, distinguishing it from public, runtime APIs such as the HR or OTA activity APIs. Instead, it encapsulates the common business rules that must apply consistently whenever an activity definition or its translated (TL) rows are manipulated. As the dependency metadata confirms, it does not call a private shadow package of its own; OTA_ADT_SHD is referenced as a related object, and all package calls ultimately resolve back to the APPS synonyms for the activity definition tables.

Key Procedures and Functions

  • INSERT_VALIDATE — Validates the field-level and cross-field business rules required before a new row is inserted into the activity definitions table, typically invoked by OTA_ADT_INS.
  • UPDATE_VALIDATE — Applies the corresponding validation logic to an existing row before it is modified, ensuring changes do not violate activity definition integrity.
  • DELETE_VALIDATE — Determines whether a given activity definition may lawfully be removed, guarding against deletion of rows that are still referenced or otherwise protected.
  • CHECK_UNIQUE_NAME — Confirms that the activity definition name supplied is unique within the appropriate context, preventing duplicate business keys.
  • VALIDATE_TRANSLATION — Enforces rules for the translated counterparts of activity definitions, ensuring that translation rows are internally consistent and properly related to their base row.
  • SET_TRANSLATION_GLOBALS — Establishes the session-level globals and defaults required for translated (TL) processing, so validation and DML routines operate in the correct language context.
  • SET_SECURITY_GROUP_ID — Sets the security group identifier for the session, ensuring that validation and subsequent DML respect the data security model of the calling environment.
  • RETURN_LEGISLATION_CODE — Returns the legislation code applicable to the activity definition, allowing downstream logic to apply correct legislative rules.

Tables Accessed

Through APPS synonyms the package reads and writes two objects. OTA_ACTIVITY_DEFINITIONS is the base transaction table holding activity definition records; OTA_ADT_BUS uses it as the source for uniqueness checks, validation comparisons, and legislation resolution. OTA_ACTIVITY_DEFINITIONS_TL holds the translated text attributes for the same definitions; it is used by VALIDATE_TRANSLATION and SET_TRANSLATION_GLOBALS when processing language-specific rows. No other tables are documented as direct dependencies.

Usage Notes

OTA_ADT_BUS is an internal business-layer package and is not intended for direct invocation by end users. It is called in the normal course of activity definition maintenance, which in Oracle EBS is reached through the Activity Definitions setup windows and their underlying form logic, and through the associated DML packages OTA_ADT_INS, OTA_ADT_UPD, OTA_ADT_DEL, and OTA_ADT_SHD. It may also be invoked by concurrent programs and by custom code that manipulate activity definitions, provided the caller first establishes session context through SET_SECURITY_GROUP_ID and the translation globals where translated processing is involved. Because the procedures are validation services rather than autonomous transactions, they should always be called within the same transaction as the DML they support so that validation failures can be raised before the corresponding insert, update, or delete is committed.