Search Results sort_pref_table

Overview

HXC_TPD_END is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the OTHER API category within the ETRM repository. The package sits within the Oracle Time and Labor (OTL) module family, as evidenced by its HXC prefix and its reliance on time-building-block and timecard summary structures. Its principal business role is to support the completion, archival verification, and reconciliation of timecard processing periods. Specifically, the package handles the identification and population of "missing" time periods so that timecard data spanning a given range is not silently lost during archiving or retrieval cycles.

The package declares a record type, period_dates, that captures start time, stop time, and resource identifier together, and a collection type, time_periods_table, used to hold multiple such records indexed by binary integer. These structures support the package's central responsibility of tracking periods at the resource granularity, ensuring that missing timecard periods are recovered only for the resource to which they belong.

Key Procedures and Functions

• RETURN_ARCHIVED_STATUS — Accepts a date and returns a varchar2 value describing the archival status associated with that date. This is the function most commonly sought by developers investigating timecard archival behavior.
• POPULATE_MISSING_TIME_PERIODS — Populates missing time periods for a given resource, assignment, and date range, returning a numeric result.
• RETRIEVE_MISSING_TIME_PERIODS — Retrieves missing periods for a resource and row number, returning a varchar2 value.
• APPL_ID — Returns an application identifier for a supplied person identifier.
• GET_SUPERVISOR_NAME — Returns the supervisor's name for a supervisor identifier and effective date.
• CHECK_TC_REQUIRED, CHECK_APPLN_SET, CHECK_APPLN_SET_ID — Validation routines that test whether a timecard is required and whether an application set or application set identifier is valid.
• LOAD_PREFERENCES and SORT_PREF_TABLE — Load and order user preference data used during timecard processing.
• CLEAR_GLOBAL_TABLES — Clears package-level global structures, including the time periods collection.
• GET_FULL_NAME, PERSON_TYPE, GET_PAYROLL_NAME, GET_ORG_NAME, GET_LOCN_NAME — Attribute lookup functions returning descriptive names for persons, person types, payrolls, organizations, and locations.

Tables Accessed

The package reads from and writes to several core OTL and HR tables through APPS synonyms. HXC_TIME_BUILDING_BLOCKS is the primary timecard storage table and supplies the column definitions for the period_dates record, reflecting the package's focus on start and stop times per resource. HXC_DATA_SETS defines the timecard data sets against which processing occurs, while HXC_RECURRING_PERIODS and HXC_TIMECARD_SUMMARY support period definition and summarized timecard reporting. FND_LOOKUP_VALUES supplies lookup codes used in validation, and PER_ALL_PEOPLE_F, PER_ASSIGNMENT_STATUS_TYPES, PER_PERSON_TYPES, and PER_PERSON_TYPE_USAGES_F provide person, assignment, and person-type information used by the attribute and validation functions. DUAL and PLITBLM are used for basic expression evaluation and PL/SQL table support respectively.

Usage Notes

HXC_TPD_END is referenced by one other package, indicating it operates primarily as a supporting utility rather than as a top-level entry point. It is typically invoked indirectly during timecard processing flows, particularly when archived data must be reconciled and missing periods recovered. Developers investigating the RETURN_ARCHIVED_STATUS function should note that it returns only a status string for a supplied date; the surrounding archival logic resides in the calling components. As an undocumented-standard (OTHER) API, the package is not part of Oracle's committed public interface, and customizations that call it directly should treat the signature as subject to change across patch levels.