Search Results per_time_periods_s




Overview
Explore in AI Chat

Overview

HR_BUDGET_CALENDAR is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. It supports the budget calendar functionality within Oracle HRMS and Oracle Payroll by deriving, generating, and maintaining the calendar periods against which budget values are calculated and stored. The package operates at the intersection of three data domains: payroll calendars, general HR time periods, and budget values. Its primary business purpose is to translate calendar definitions into concrete budget periods so that compensation and budgeting processes can allocate monetary or numeric budget amounts across valid time slices.

In Oracle EBS 12.1.1 and 12.2.2, this package is classified as an OTHER API rather than a public, published interface. It is an internal utility that supports the budget calendar maintenance logic exposed through Oracle HRMS administrative flows. Its status is VALID in the reference environment, indicating that the compiled body is present and usable.

Key Procedures and Functions

Four documented procedures and functions are associated with this package. The metadata documents their names and purpose only; no parameter signatures are published.

  • MIDPOINT_OFFSET — Computes a midpoint date or offset value for a given budget period. This is typically used to anchor a budget value to the center point of a time period, which is useful when a single allocation must represent the whole period.
  • NUM_OF_CAL_YRS — Returns the number of calendar years spanned by a given calendar or period set. This drives loops and range validations during generation.
  • GENERATE — The principal driver procedure. It creates or repopulates budget calendar rows for a specified calendar, period set, and range, writing the results into the underlying period and budget value tables.
  • REMOVE — Deletes previously generated budget calendar records, allowing a clean rebuild when calendar definitions, period sets, or budget values change.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

  • PAY_CALENDARS — Supplies the payroll calendar definition that establishes valid period boundaries.
  • PER_TIME_PERIODS and PER_TIME_PERIODS_S — Provide the base and translated time period records. The search term per_time_periods_s refers specifically to the translated (TL) table, which holds language-specific period names. HR_BUDGET_CALENDAR depends on it for period identification and display.
  • PER_TIME_PERIOD_SETS — Defines the grouping of time periods used to scope a budget calendar.
  • PER_TIME_PERIOD_TYPES — Classifies the period (for example, monthly, quarterly, or yearly), which affects offset and generation logic.
  • PER_BUDGET_VALUES — Stores the resulting budget amounts mapped to generated calendar periods; this is the primary write target.

The package also references FND_NUMBER and HR_UTILITY for numeric formatting and HRMS utility routines, and DUALSYSSTANDARD for basic SQL constructs.

Usage Notes

HR_BUDGET_CALENDAR is not referenced by any database object, meaning no other APPS package depends on it directly. Its documented dependence on PAY_CALENDARS, PER_TIME_PERIODS, PER_TIME_PERIODS_S, PER_TIME_PERIOD_SETS, and PER_TIME_PERIOD_TYPES confirms that it must be invoked after those calendar and period definitions exist. It is typically called from Oracle HRMS budget and compensation setup flows, from concurrent programs that regenerate budget calendars in bulk, or from custom extensions that need to rebuild budget period assignments. The GENERATE and REMOVE procedures are intended to be paired: REMOVE clears existing rows, and GENERATE rebuilds them. Because this is an internal OTHER API, custom code should treat it as unsupported and avoid embedding direct calls where possible, relying instead on the supported HRMS budget interfaces.