Search Results get_defaults

Overview

APPS.OTA_GENERAL is a shared Oracle Training Administration (OTA) utility package delivered as part of the Oracle E-Business Suite 12.1.1 and 12.2.2 codebase. Its declared purpose, per the package header comment, is "to provide widely used functions in a single shared area." Historically maintained since 1994, the package centralizes low-level validation and lookup logic that would otherwise be duplicated across the many training-related forms, concurrent programs, and PL/SQL modules that make up the OTA product family. It is compiled with AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the calling schema rather than the defining owner—consistent with the standard APPS-tier convention for shared utility packages.

The package is heavily reused: ETRM records indicate it is referenced by 107 other packages, underscoring its role as a foundational dependency within the OTA module and adjacent HR and Financials integrations. The user search term "fnd_currency_name" corresponds directly to one of the package's lookup functions, FND_CURRENCY_NAME, added in version 115.3 (12-OCT-99) alongside FND_LANG_CODE and HR_ORG_NAME.

Key Procedures and Functions

ETRM documents 40 procedures and functions in OTA_GENERAL, classified as API classification OTHER. They fall into distinct functional categories:

• Date and time validation: CHECK_START_END_DATES, CHECK_START_END_TIME, CHECK_PAR_CHILD_DATES, and CHECK_PAR_CHILD_DATES_FUN verify that start/end ranges are internally consistent, including parent-child date relationships.
• Person and user validation: CHECK_PERSON, CHECK_CURRENT_EMPLOYEE, CHECK_FND_USER, and GET_FND_USER validate or retrieve identity information for employees and application users. GET_SESSION_DATE returns the effective session date for the current FND session.
• Currency, language, and domain validation: VALID_CURRENCY, CHECK_CURRENCY_IS_VALID, VALID_LANGUAGE, and CHECK_DOMAIN_VALUE provide validation against reference data. The FND_CURRENCY_NAME function returns the descriptive name for a currency code.
• Vendor validation: VALID_VENDOR and CHECK_VENDOR_IS_VALID assess supplier validity, including effective-date checks (per bug fix 3953333).
• Name and location lookups: GET_EVENT_NAME, GET_OFFERING_NAME, GET_COURSE_NAME, GET_LOCATION, GET_TRAINING_CENTER, GET_LEGISLATION_CODE, and GET_FINANCE retrieve descriptive or configuration data for training entities.
• Conversion and generic helpers: CHAR_TO_NUMBER converts character strings to numeric values; VALUE_CHANGED supports form-level change detection.

Tables Accessed

The package reads from a curated set of reference and transactional tables via APPS synonyms. Foundation tables include FND_CURRENCIES and FND_LANGUAGES for currency and language validation, FND_SESSIONS for session-date logic, and FND_USER for user lookups. HR tables—HR_ALL_ORGANIZATION_UNITS, HR_ALL_ORGANIZATION_UNITS_TL, HR_LOCATIONS_ALL, HR_LOCATIONS_ALL_TL, HR_ORGANIZATION_INFORMATION, and PER_ALL_PEOPLE_F—support organization, location, and person validation. OTA training tables include OTA_EVENTS, OTA_ACTIVITY_VERSIONS_TL, OTA_OFFERINGS_TL, and the finance tables OTA_FINANCE_HEADERS and OTA_FINANCE_LINES, used by the name-lookup and finance-retrieval functions.

Usage Notes

OTA_GENERAL is typically invoked from OTA forms and concurrent programs that require consistent validation of user input or retrieval of descriptive values without embedding duplicate SQL. Because it holds broad reuse across 107 dependent packages, customizations should treat it as a stable utility surface. The FND_CURRENCY_NAME function is the appropriate entry point when a form or custom concurrent program needs to resolve a currency code to its display name, rather than querying FND_CURRENCIES directly. All calls execute under the caller's privileges, so grants on underlying tables must be in place for the invoking schema.