Search Results c_to_date

Overview

APPS.OTA_FRM_XMLP_PKG is a report-supporting PL/SQL package body belonging to the Oracle Learning Management (OLM) module of Oracle E-Business Suite. Its documented source is a thin wrapper layer whose sole purpose is to expose the three hidden data columns and formatting values required by the XML Publisher (BI Publisher) report template for the forum listing report. The package name encodes this role: the OTA_FRM prefix identifies the OLM Forum entity, and the XMLP suffix identifies the package as an XML Publisher data-source helper. In EBS releases 12.1.1 and 12.2.2 the package body is shipped as version 120.2 (header dated 08-Jan-2008), consistent with the long-standing OLM report code line.

The package does not perform business transactions, validation, or DML. It exists to convert stored values into the display formats demanded by the report template, and to resolve the descriptive name of a forum from its key. Because XML Publisher extracts columns from a query, the report definition declares these functions as SELECT-list columns rather than embedding the logic in the report SQL.

Key Procedures and Functions

Three documented functions make up the entire body:

• C_FORUM_NAME_P — Opens and fetches from an internal cursor that selects the forum name from OTA_FORUMS_TL for the forum identifier supplied by the report parameter P_FORUM_ID, restricted to the session language obtained through USERENV('LANG'). It returns the translated forum name to the report for display.
• C_FROM_DATE_P — Converts the report parameter P_FROM_DATE, taken as the first ten characters of the parameter string in yyyy/mm/dd format, into the EBS display-date format by calling FND_DATE.DATE_TO_DISPLAYDATE, and returns the formatted value.
• C_TO_DATE_P — Performs the identical operation for the parameter P_TO_DATE, returning C_TO_DATE formatted for display. This is the function users reach when they search the c_to_date identifier, the package variable populated by this function.

No parameter lists are declared on these functions; each reads the relevant report parameter or lexical global supplied by the XML Publisher engine at run time.

Tables Accessed

• OTA_FORUMS_TL — the translation (TL) table for OLM forums. The function reads name for a specific forum_id and language, guaranteeing that the forum title displayed in the report matches the user's session language in a multi-language installation.
• DUAL — used as the syntactic vehicle for the FND_DATE.DATE_TO_DISPLAYDATE conversion of each date parameter. No application data is read from DUAL; it provides a single-row context for the SELECT INTO construct.

Access is read-only. The package holds no insert, update, or delete logic against any application table.

Usage Notes

The package is invoked indirectly, as the PL/SQL source attached to the Oracle Learning Management forum XML Publisher report definition. The report's data model (or its underlying query) references C_FORUM_NAME_P, C_FROM_DATE_P, and C_TO_DATE_P as computed columns; the XML Publisher engine calls each once per report execution and substitutes the returned values into the RTF or XSL-FO template. The functions are also visible as named columns through the EBS Concurrent Programs / Request and the Reports (XML Publisher) administration forms and through the Oracle EBS data dictionary views (ALL_OBJECTS, DBA_SOURCE) during impact analysis.

Because the functions depend on the FND_DATE API and on USERENV('LANG'), they must run inside an EBS session with the Applications schema initialized. They are not intended for direct invocation from SQL*Plus or from custom concurrent programs, and the metadata records no downstream packages referencing this body. Any custom report reusing this logic should preserve the ten-character substring and format mask so that the date conversion remains tolerant of the full timestamp carried in the report parameters.