Search Results c_event_title_p

Overview

OTA_EVAL_XMLP_PKG is a report-support package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle Training Administration (OTA) module and serves as the PL/SQL backend for an XML Publisher (XMLP) concurrent report used to render evaluation-related information. The package follows the standard Oracle Reports/XML Publisher generated package pattern, in which a companion package specification declares one function per report formula column or parameter, and the body implements the corresponding data-retrieval logic. Its purpose is to resolve foreign-key identifiers supplied as report parameters into human-readable display values, and to format date parameters for presentation. Each function is self-contained, executing a single-row lookup or a scalar conversion and returning a varchar2 result.

Key Procedures and Functions

• C_ACTIVITY_VERSION_NAME_p — Returns the display name of an activity version. It opens a cursor against ota_activity_versions_tl, filtering by activity_version_id and the session language, and returns the version_name into the package variable c_activity_version_name. The lookup is skipped when the driving parameter P_ACTIVITY_ID is null, in which case the function returns the current (unset) value.
• C_EVENT_TITLE_p — Returns the title of an event. It queries ota_events_tl by event_id and language = userenv('LANG'), fetching the title into c_event_title. This resolves the event identifier used on the report into its translatable title.
• C_ANSWER_TYPE_p — Returns the meaning of the lookup value supplied through the P_ANSWER_TYPE parameter. The cursor c_lookup_code selects es.meaning from hr_lookups where lookup_type = 'OTA_EVAL_REPORT_TYPE', restricted to currently active rows (sysdate between the start and end dates, both defaulted to sysdate via NVL) and enabled_flag = 'Y', matching lookup_code against P_ANSWER_TYPE. This function is the object most directly associated with the user's search term, "c_answer_type_p".
• C_FROM_DATE_p — Converts the P_FROM_DATE parameter into display format. It truncates the parameter to its first ten characters, converts the value with a 'yyyy/mm/dd' mask, and applies fnd_date.date_to_displaydate, returning the formatted string in C_FROM_DATE.
• C_TO_DATE_p — Performs the same conversion as above for the P_TO_DATE parameter, returning the formatted value in C_TO_DATE.

Tables Accessed

• OTA_ACTIVITY_VERSIONS_TL — the translatable activity version table, read to obtain version_name for the selected activity version.
• OTA_EVENTS_TL — the translatable events table, read to obtain the event title.
• HR_LOOKUPS — read by C_ANSWER_TYPE_p to translate the OTA_EVAL_REPORT_TYPE lookup code into its meaning.
• DUAL — used by the date-conversion functions as the single-row source for the fnd_date.date_to_displaydate expression.

Usage Notes

The package is invoked indirectly by the XML Publisher concurrent program that consumes the associated report definition; the report engine calls each function at run time to populate formula columns, group headers, and parameter displays. Because all functions are read-only and depend only on report parameters, no commit or exception-handling logic is required. When troubleshooting the report, verify that P_ACTIVITY_ID, P_EVENT_ID, and P_ANSWER_TYPE are populated with valid identifiers, that the HR_LOOKUPS entry for OTA_EVAL_REPORT_TYPE is enabled and currently effective, and that the date parameters conform to the expected yyyy/mm/dd substring. Custom code should not call these functions directly, as they rely on session-level package state and the userenv('LANG') setting.