Search Results p_periods

Overview

HXC_TIMECARD_UTILITIES is a core PL/SQL utility package in the Oracle E-Business Suite Time and Labor module (application HXC, owned by APPS). It provides shared services for interpreting an assignment's recurring time period definition and translating working time into discrete, displayable timecard periods. The package exposes both low-level date arithmetic and higher-level period generation routines that the Timecard user interface, self-service time entry pages, and downstream processing logic rely upon when building a worker's timecard.

At the heart of the package is support for the p_periods concept referenced by the search term. The package declares a collection type periods that carries period rows, and several routines consume and return this structure. The body maintains package-level globals that cache recurring period configuration — start date, period type, duration in days, and configurable past/future entry limits — so that repeated period calculations during a single session remain consistent and performant. Date format, separator, and debug flags are also globalized to standardize formatting and diagnostics across all callers.

Key Procedures and Functions

• INIT_GLOBALS — Initializes the package-level global variables (period limits, date format, initialization flag) before other routines execute.
• GET_TIME_PERIODS — Returns the set of time periods applicable to an assignment, forming the primary entry point for populating a timecard's period list.
• GET_PERIODS — Generates the period rows for timecard display; it invokes helper logic such as get_more_period_value to determine whether a period should be flagged as "More Periods" in the UI.
• GET_CURRENT_PERIOD and FIND_CURRENT_PERIOD — Identify the period containing a given reference date, using recurring period start dates and duration arithmetic.
• GET_PERIOD_LIST — Supplies a formatted list of periods, typically for selection or navigation in the timecard interface.
• GET_ASSIGNMENT_PERIODS and PROCESS_ASSIGNMENTS — Derive and consolidate period data across one or more assignments, supporting workers assigned to multiple positions.
• GET_PTO_BALANCE — Retrieves paid-time-off balances for display alongside time entry.
• CLA_SUMMARY_ALIAS_TRANSLATION — Resolves summary alias translations used in timecard summary presentation.
• COPY_ATTACHMENTS_TO_AP — Copies supporting attachments from timecards to the associated Accounts Payable documents via the timecard-to-AP link.

The private helper get_period_by_duration computes period boundaries by adding the duration-in-days offset from the recurring start date, and get_more_period_value decides whether a period warrants the "More Periods" indicator for existing timecards.

Tables Accessed

• HXC_RECURRING_PERIODS — Defines the assignment's recurring period pattern (start date, period type, duration).
• HXC_TIME_BUILDING_BLOCKS, HXC_BLD_BLK_INFO_TYPES, HXC_TIME_ATTRIBUTES, HXC_TIME_ATTRIBUTE_USAGES — Supply existing timecard entries and attribute configuration used when generating periods.
• HXC_DATA_SETS — Provides data set context governing time entry rules.
• HXC_TIMECARD_SUMMARY — Reads/writes summary figures for the timecard.
• HXC_TC_AP_LINKS and FND_ATTACHED_DOCUMENTS — Support attachment copying to Accounts Payable.
• PAY_ACCRUAL_PLANS, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F — Drive PTO balance and element-based accrual lookups.
• PER_ALL_ASSIGNMENTS_F, PER_ASSIGNMENT_STATUS_TYPES — Provide assignment and status context for period resolution.

Usage Notes

HXC_TIMECARD_UTILITIES is referenced by six other packages and is typically invoked from the Time and Labor timecard forms and self-service pages during timecard rendering, when the application must determine which periods to show for an assignment. It is also called by processing routines that evaluate existing time-building-block entries, and by any custom code that needs to reproduce Timecard's period-boundary logic. Because the past/future entry limits are hardcoded globals (ten each by default), behavior in a given release is fixed unless the package is customized. The header identifies the shipped version as hxctcutil.pkb 120.25.12010000.2, confirming support across the 12.1.1 and 12.2.2 code lines.