Search Results c_to_date_p

Overview

OTA_EVAL_XMLP_PKG is an Oracle E-Business Suite package residing in the APPS schema that supports the XML Publisher (XMLP) based reporting infrastructure for Oracle Training Administration (OTA), part of Oracle iLearning / Learning Management. It is a generated report package of the type Oracle produces for concurrent programs whose output is rendered through a BI Publisher (XML Publisher) template. The package maintains the runtime state of the report, exposing public variables for report parameters and a set of accessor functions that return formatted values for the XML data template.

The package is declared with AUTHID CURRENT_USER and carries the header identifier otaevalxmlp.pkh, whose version string (120.2, dated 2008/01/08) confirms it is a long-standing component of the OTA reporting layer and is unchanged in the 12.1.1 and 12.2.2 releases. Functionally it serves an evaluation-type report that filters assessment data by activity, event, answer type, and a date range.

Key Procedures and Functions

The documented interface consists of five functions, all following the standard generated accessor naming convention ending in _p. Each simply returns the value of a corresponding package-level variable in a form suitable for the report layout.

• C_ACTIVITY_VERSION_NAME_P — returns the activity version name used as a report header or grouping value, sourced from the activity version lookup.
• C_EVENT_TITLE_P — returns the event title associated with the selected training event, typically displayed as report context.
• C_ANSWER_TYPE_P — returns the answer type descriptor applied as a filter on the evaluation question responses.
• C_FROM_DATE_P — returns the report's start date parameter as a formatted string; this is the accessor that corresponds to the user's search term context alongside c_to_date_p.
• C_TO_DATE_P — returns the report's end date parameter (the "to date") as a formatted string, used to delimit the evaluation data window in the report query and header.

No parameters are documented for these functions; they rely on the package globals populated at report initialization.

Tables Accessed

The report query underlying this package reads through APPS synonyms. OTA_ACTIVITY_VERSIONS_TL supplies the translated activity version names used by C_ACTIVITY_VERSION_NAME_P. OTA_EVENTS_TL supplies the translated event titles used by C_EVENT_TITLE_P. DUAL is referenced for scalar evaluation of the parameter expressions and for date/format conversions performed in the report's SELECT list. The package itself performs no transactional DML; it is read-only report infrastructure.

Usage Notes

OTA_EVAL_XMLP_PKG is not intended for direct invocation by developers or end users. It is instantiated automatically by the Oracle Reports/XML Publisher concurrent program framework when the associated evaluation report is submitted from the Submit Requests form or an OTA report-launching form. The parameter values P_ACTIVITY_ID, P_EVENT_ID, P_ANSWER_TYPE, P_FROM_DATE, and P_TO_DATE are assigned by the concurrent manager before the report query executes, and the functions are then called by the XML data template to populate the report output.

Because the package is referenced by zero other PL/SQL packages, there is no supported programmatic entry point. Customizations should be confined to the underlying report definition and its XML template rather than to this generated package, since Oracle replaces such packages during patching. Developers tracing a report defect should treat C_TO_DATE_P and its sibling accessors as read-only observability points for the parameter values actually received at runtime.