Search Results cf_detail_hoursformula

Overview

HXT_HXT007A_XMLP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, residing in the Oracle Time and Labor (OTL / HXT) product family. The package encapsulates the report logic for the XML Publisher (BI Publisher) concurrent program HXT007A, a timecard-related report that extracts and formats time and labor data for presentation. Because it belongs to the XMLP (XML Publisher) package naming convention, it is instantiated as the data model package for the corresponding XML Publisher report definition. The package is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, and carries an API classification of OTHER, indicating it is report-internal infrastructure rather than a public API. It is not referenced by any other package in the application, confirming that its role is limited to supporting its own report template.

Key Procedures and Functions

Six documented procedures and functions constitute the package interface:

• CF_PAYROLLFORMULA — A column/formula function returning the payroll formula value associated with the report's timecard data, typically used to display payroll-defined calculation context on the output.
• CF_DETAIL_HOURSFORMULA — A column/formula function that resolves and formats the hours formula at the detail level of the report, governing how hours worked are displayed.
• CF_BEE_LINE_HOURSFORMULA — A line-level formula function corresponding to the BEE (business event/entry) line within the timecard extract, supplying hours formula context for that row.
• BEFOREREPORT — A standard Oracle Reports/XML Publisher trigger executed before data retrieval; it performs initialization and setup tasks for the report run.
• AFTERREPORT — The companion trigger executed after data retrieval completes, used for cleanup or final processing.
• C_REPORT_SUBTITLE_P — A function supplying the report subtitle value, making the report caption dynamically derived from parameters or session context.

Tables Accessed

The package reads timecard and payroll data through APPS synonyms. Time and labor transactional data is drawn from HXT_TIMECARDS_F and HXT_DET_HOURS_WORKED_F, the latter supplying detailed hours-worked records per timecard. Payroll configuration and processing data is obtained from PAY_ELEMENT_TYPES_F (element definitions), PAY_INPUT_VALUES_F and its translated table PAY_INPUT_VALUES_F_TL (input value definitions and language-specific descriptions), and PAY_BATCH_LINES, which links payroll batch processing to the underlying timecard entries. These accesses allow the report to correlate reported hours with the payroll elements and formulas that consume them.

Usage Notes

HXT_HXT007A_XMLP_PKG is invoked indirectly by the XML Publisher runtime when the HXT007A concurrent program is submitted. The BEFOREREPORT and AFTERREPORT procedures are called automatically at the start and end of the data extraction phase, while the CF_* functions are invoked by the report's data template to compute derived column values. Because the package is not referenced by other application packages, it should be treated as private report infrastructure: customizations should extend it only through the supported report definition mechanism, and direct calls from custom code are not recommended. Administrators troubleshooting HXT007A output should look to this package's formula functions when hours or payroll formula values display incorrectly.