Search Results get_resources_to_schedule

Overview

APPS.CSF_RESOURCE_PUB is a public PL/SQL API package within the Oracle E-Business Suite Field Service (CSF) module. Its status is VALID, and it is classified as a PUB-type API, indicating it is intended for invocation by external callers, concurrent programs, forms, and other EBS packages rather than being restricted to internal implementation use. The package centralizes access to field service resource data — technicians, crews, and other service personnel — resolving identifiers, names, types, addresses, skills, time zones, and geographic attributes associated with a resource. It also exposes logic for identifying which resources are eligible to be scheduled or dispatched to a task.

Because it is a public package, CSF_RESOURCE_PUB acts as a stable integration surface: dependent objects such as CSF_ALERTS_PUB, CSF_TRIPS_PUB, CSF_GANTT_DATA_PKG, CSR_SCHEDULER_PVT, and views such as CSF_PLAN_OPTIONS_V, CSF_SELECTED_RESOURCES_V, and CSR_WTP_DISPLAY_V rely on it to obtain consistent resource information. The metadata records 22 documented procedures and functions and 15 referencing packages, underscoring its role as a shared utility layer for the Field Service resource domain.

Key Procedures and Functions

The documented API surface includes the following (parameter lists are defined in the package specification):

• RS_CATEGORY_TYPE, RESOURCE_ID, RESOURCE_TYPE — establish the resource category and resolve the internal identifier and type of a resource.
• GET_RESOURCE_NAME, GET_RESOURCE_TYPE_NAME — return the display name of a resource and the descriptive name of its resource type.
• GET_RESOURCE_PARTY_ADDRESS, GET_RESOURCE_INFO — retrieve address data tied to the resource's party record and consolidated resource attributes.
• CONVERT_TIMEZONE — normalize time values between time zones for scheduling purposes.
• GET_RES_QUALIFIER_TABLE, GET_QUALIFIED_TASK_REC — return qualifier and skill-related data and identify tasks for which a resource qualifies.
• GET_RESOURCES_TO_SCHEDULE, GET_RESOURCES_TO_SCHEDULE_PVT — the public and private entry points for determining resources available for scheduling.
• GET_RESOURCE_SHIFTS — return shift information for a resource.
• GET_LOCATION, GET_LOCATION_ATTRIBUTES, GEO_DISTANCE — resolve location details, location attributes, and the geographic distance between points.
• GET_THIRD_PARTY_ROLE — return role information for third-party resources.

Tables Accessed

Documented table references, accessed through APPS synonyms, include JTF_OBJECTS_B (resource object metadata), JTF_RS_RESOURCE_EXTNS and JTF_RS_RESOURCE_EXTNS_TL (resource extension and translated attributes), the CSF GPS tables (CSF_GPS_DEVICES, CSF_GPS_DEVICE_ASSIGNMENTS, CSF_GPS_LOCATION_FEEDS), and the skills tables (CSF_SKILLS_B, CSF_SKILL_LEVELS_B, CSF_REQUIRED_SKILLS_B, CSF_RESOURCE_SKILLS_B, CSF_R_RESOURCE_RESULTS). Incident-related data is sourced from CS_INCIDENTS_ALL, CS_INCIDENTS_ALL_B, and CS_INCIDENTS_ALL_TL, while HZ_CODE_ASSIGNMENTS supplies code assignment values. The package thereby reads resource, skill, location, and incident context to support scheduling and qualification decisions.

Usage Notes

CSF_RESOURCE_PUB is typically invoked from Field Service forms, concurrent programs, scheduling and dispatch components (notably CSR_SCHEDULER_PVT), Gantt and work-plan views, and custom extensions that require authoritative resource data. Because it is a PUB package, custom code may call it directly; however, callers should treat the documented procedures as the supported interface and avoid dependencies on referenced private helpers such as GET_RESOURCES_TO_SCHEDULE_PVT. The presence of CSF_UTIL_PVT among its dependents reflects reuse through shared utility logic, and any changes should be evaluated against the 15 referencing packages and views dependent on this API.