Search Results csf_util_pvt




Overview
Explore in AI Chat

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):

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.