Results for “hxt_hxt007a_xmlp_pkg”
44 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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.
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
VIEW: APPS.PAY_PAYROLLS_X 12.2.2
-
VIEW: APPS.PAY_PAYROLLS_X 12.1.1
-
VIEW: APPS.PAY_PAYROLLS_F 12.1.1
-
VIEW: APPS.PAY_PAYROLLS_F 12.2.2
-
VIEW: APPS.HR_LOOKUPS 12.1.1
-
VIEW: APPS.HR_LOOKUPS 12.2.2
-
eTRM - HXT Tables and Views 12.1.1
A location to put an employee's work shifts on which all earnings are based.
-
eTRM - HXT Tables and Views 12.1.1
A location to put an employee's work shifts on which all earnings are based.
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person