Search Results pa_calendar_utils




Overview
Explore in AI Chat

Overview

PA_CALENDAR_UTILS is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It provides utility logic for managing Oracle Projects calendars and the shifts and exceptions that define working and non-working time. Calendars in Oracle Projects underpin scheduling, resource assignment, effort forecasting, and date-based calculations performed by the project management and costing modules. The package acts as an integration layer between the Projects scheduling engine and the underlying JTF calendar repository, translating generic calendar constructs into the shift and exception records that Project Management uses for valid working-day derivation.

Its dependency list confirms that it is not a self-contained utility. It calls FND_API and FND_MSG_PUB for the standard EBS API error-handling and message-stack conventions, and it references PA_SCHEDULE_UTILS and PA_SCHEDULE_GLOB for shared scheduling logic and global constructs. The ETRM classifies it with an API classification of OTHER, indicating that it is an internal helper package rather than a formally published public API.

Key Procedures and Functions

The package exposes five documented procedures and functions:

  • GET_CALENDAR_SHIFTS — Retrieves the shift definitions associated with a calendar, returning the working-time constructs used to determine availability for scheduling purposes.
  • GET_CALENDAR_EXCEPT — Retrieves calendar exception records, that is, the dates or periods that deviate from the standard shift pattern, such as holidays or special working days.
  • GEN_CALENDAR_SCH — Generates the calendar schedule by expanding shift constructs and exception assignments into concrete shift assignment records over a date range.
  • APPLY_CALENDAR_EXCEPT — Applies exception definitions to a calendar so that generated schedules reflect the designated deviations from normal working time.
  • CHECK_CALENDAR_NAME_OR_ID — Validates a calendar name or identifier, providing a lookup/validation service used before other calendar operations are performed.

Consistent with the dependency on FND_API and FND_MSG_PUB, these routines follow standard EBS API conventions for result reporting and error propagation.

Tables Accessed

All table references are made through APPS synonyms. The package reads and writes the JTF calendar base table JTF_CALENDARS_B together with its translation view JTF_CALENDARS_VL. Shift data is held in JTF_CAL_SHIFT_CONSTRUCTS, which defines the shift pattern, and JTF_CAL_SHIFT_ASSIGN, which records the materialized shift assignments for specific dates. Exceptions are stored in JTF_CAL_EXCEPTIONS_B, with JTF_CAL_EXCEPTION_ASSIGN linking exception definitions to calendar instances. PLITBLM is a standard PL/SQL-supplied table used for index-by table support. Collectively, these tables form the calendar persistence model that PA_CALENDAR_UTILS maintains and queries.

Usage Notes

Because PA_CALENDAR_UTILS is referenced by five other packages and does not itself reference any database object outside the listed dependencies, it functions as a lower-level building block invoked by higher-level Projects scheduling and calendar maintenance processes. It is typically called from Project Management calendar setup forms, from concurrent programs that generate or refresh calendar schedules, and from other Projects packages that require validated calendar definitions. Custom code requiring calendar shift or exception data should generally call the supported public Projects APIs rather than this internal package, since it is not a published interface. Implementations upgrading from 12.1.1 to 12.2.2 should note that the object remains VALID in both releases and that its behavior is tied to the JTF calendar schema, which is shared across EBS modules.