Search Results period_start_stop

Overview

HXC_PERIOD_EVALUATION is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the API classification "OTHER." It forms part of the Oracle Time and Labor (OTL / HXC) module, which manages timecard entry, time collection, and time-related period logic. The package's central responsibility is the evaluation of time periods — determining period start and end dates, resolving recurring period types, and generating lists of periods for a given date range. This logic underpins the derivation of timecard periods, recurring time entry defaults, and the scheduling framework that determines which periods are available for employee time entry or processing.

The package is declared with AUTHID CURRENT_USER, meaning its execution privileges and unqualified object resolution follow the invoking user's schema rather than the defining schema. This is a common convention in EBS packages that are intended to be called from a variety of runtime contexts, including concurrent programs and forms-based sessions.

Key Procedures and Functions

• MAKE_DATE — A helper function that constructs a DATE value from separate day and month/year string components. It abstracts the parsing and assembly of calendar dates used throughout the package.
• GET_PERIOD_LIST — The primary function and the object of the user's search. It returns a period_list collection (a table of period records, each holding a START_DATE and END_DATE). It resolves the set of periods applicable to a given current date, recurring period type, duration in days, recurrence start date, and bounding maximum dates in the future and past. An overloaded variant appears in the source but is commented out, indicating it is not part of the active interface.
• GET_PERIOD_DETAILS — A procedure that derives the base period type and a multiple value from a supplied processing period type. It exposes the underlying mapping used to translate a configured period type into base period semantics.
• PERIOD_START_STOP — Available in two overloaded forms, this procedure computes the start and end dates of a period given a current date and recurring period start date, together with a base period type. The second overload accepts an additional p_multiple parameter, allowing the period window to be scaled or shifted.

Tables Accessed

The package references PER_TIME_PERIOD_TYPES, the OTL configuration table that stores the definition of time period types and the number of periods per fiscal year. A record type and global associative array in the package are anchored to this table's NUMBER_PER_FISCAL_YEAR column, confirming that period-type metadata is loaded and evaluated here. The package also references PLITBLM, a general-purpose PL/SQL index-by table utility. No direct writes to application data tables are documented.

Usage Notes

HXC_PERIOD_EVALUATION is referenced by six other packages, indicating it serves as a shared utility layer for period computation across the OTL module. It is typically invoked indirectly through timecard processing, recurring time entry, and period-driven concurrent programs rather than being called directly by end users. Custom extensions that need to reproduce OTL period boundaries or build period picklists should call GET_PERIOD_LIST and PERIOD_START_STOP rather than reimplementing the underlying date arithmetic. Because the package uses AUTHID CURRENT_USER and relies on APPS synonyms, custom callers must execute with appropriate APPS-level grants. The header revision ($Header: hxcperevl.pkh 115.3) indicates a long-stable interface carried forward across releases 12.1.1 and 12.2.2.