Search Results resourcedt_to_serverdt

Overview

APPS.JTF_CALENDAR_PUB is the Joint Task Force (JTF) core Calendar Public API within Oracle E-Business Suite. Its purpose is to determine the availability and working shift hours of a given resource across a specified period. The package is classified as a public API, meaning it is exposed for supported external invocation by forms, concurrent programs, and custom code rather than being restricted to internal use. The header identifies the source as jtfclavb.pls (version 120.4, dated 2005/12/12), with an initial creation date of 09/29/99 and a series of maintenance revisions spanning 2001 through 2005, including a MOAC-related change that replaced jtf_rs_resources_vl with jtf_task_resources_vl (bug# 4455792). The user's search term, "resourcedt_to_serverdt," corresponds directly to the RESOURCEDT_TO_SERVERDT procedure added to the package on 08/11/03, which supports conversion between a resource-relative date and a server-recognized date.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions. Their purposes are:

• IS_RES_AVAILABLE — determines whether a given resource is available during a specified interval.
• GET_AVAILABLE_TIME — returns the aggregate available time for a resource over a requested period.
• GET_AVAILABLE_SLOT — identifies specific available time slots within the requested range.
• GET_RESOURCE_SHIFTS — retrieves the shift assignments associated with a resource; the header notes that attribute1 through attribute15 were returned from this API as of 03/05/02.
• GET_RES_SCHEDULE — returns a resource's schedule, with cursors revised across 2003 revisions.
• GET_G_FALSE, GET_G_MISS_NUM, GET_G_MISS_CHAR, GET_G_MISS_DATE — utility accessors returning default/placeholder values (a boolean false and missing numeric, character, and date values respectively).
• GET_RES_TIMEZONE_ID — returns the time zone identifier associated with a resource.
• RESOURCEDT_TO_SERVERDT — converts a resource-local date into the corresponding server date, addressing time zone offsets between resource and server.
• VALIDATE_CAL_DATE — validates a calendar date used in scheduling logic.

Internal helper routines include sort_tab, sort_tab_attr, and bubble procedures supporting shift-table ordering, and a declared exception G_EXC_REQUIRED_FIELDS_NULL.

Tables Accessed

The package reads and writes calendar and resource scheduling data through APPS synonyms. JTF_CALENDARS_B, JTF_CAL_EXCEPTION_ASSIGN, JTF_CAL_RESOURCE_ASSIGN, JTF_CAL_SHIFT_ASSIGN, and JTF_CAL_SHIFT_CONSTRUCTS form the core calendar model, providing calendars, exception assignments, resource assignments, shift assignments, and shift construct definitions used to compute availability and shift hours. JTF_RS_RESOURCE_EXTNS and JTF_RS_GROUPS_B supply resource and group attributes. Task-related tables—JTF_TASKS_B, JTF_TASK_ASSIGNMENTS, and JTF_TASK_STATUSES_B—support schedule and assignment resolution. The header history explicitly notes the change from jtf_task_assignments to jtf_task_all_assignments and its subsequent reversal, and later the move from jtf_rs_resources_vl to jtf_task_resources_vl for MOAC compliance. DUAL and PLITBLM support utility and PL/SQL table operations.

Usage Notes

JTF_CALENDAR_PUB is invoked whenever calling applications need to determine resource availability, working hours, time zone offsets, or schedule details. Typical callers include Oracle Field Service, service scheduling forms, and task assignment components, and the ETRM metadata records that the package is referenced by six other packages. Custom code should call the public procedures rather than the sort/bubble helpers, which are internal implementation details. Because the availability logic depends on calendar and resource assignments, results reflect current calendar configuration; callers should invoke the API at runtime rather than caching results across configuration changes. The RESOURCEDT_TO_SERVERDT routine should be used wherever resource-local dates must be normalized to server time before comparison or storage.