Search Results resource_cache_tbl_type

Overview

CSF_RESOURCE_PUB is a public PL/SQL package in the Application Object Library (APPS) schema that provides the field service and resource management foundation for Oracle E-Business Suite. Its primary responsibility is to expose resource-related information — identity, type, name, address, time zone, location, skills, qualifiers, and scheduling availability — to Oracle Forms, concurrent programs, and other PL/SQL packages within the Service (CS) and Field Service (CSF) product family. The package spec is classified as PUB, meaning its procedures and functions form a supported interface intended for reuse by external callers, rather than being internal-only helper routines.

The package body declares several global constants and collection types that shape its behavior. The assignment document type is fixed to 'SR' (Service Request), and Earth-radius and PI constants support geographic calculations performed by the GEO_DISTANCE routine. Cached record types such as RESOURCE_CACHE_REC_TYPE and RESOURCE_CACHE_TBL_TYPE hold resource identifier, type, name, number and address, while qualifier and resource-type name collections provide lookup caching across calls. These structures reflect the package's role as a central resource information broker, minimizing repeated queries against the same base tables.

Key Procedures and Functions

• RS_CATEGORY_TYPE, RESOURCE_ID, RESOURCE_TYPE — Return the resource category, identifier, and type respectively, establishing the basic context for a given resource.
• GET_RESOURCE_NAME, GET_RESOURCE_TYPE_NAME — Resolve the display name of a resource and of a resource type, using the translated name tables where applicable.
• GET_RESOURCE_PARTY_ADDRESS — Retrieves the address associated with the party behind a resource, combining resource and Trading Community Architecture (TCA) data.
• GET_RESOURCE_INFO — Populates the resource cache record with the consolidated view of a resource and its address.
• CONVERT_TIMEZONE — Translates a timestamp between time zones, supporting accurate scheduling and dispatch across geographies.
• GET_RES_QUALIFIER_TABLE — Returns the table of qualifiers applicable to a resource.
• GET_QUALIFIED_TASK_REC — The routine sought by the search term; it determines the qualified task record for a resource, identifying which tasks a resource is qualified to perform based on skills and qualifiers.
• GET_RESOURCES_TO_SCHEDULE, GET_RESOURCES_TO_SCHEDULE_PVT, GET_RESOURCE_SHIFTS — Identify available resources and their shifts for scheduling purposes; the private variant supports internal logic.
• GET_LOCATION, GET_LOCATION_ATTRIBUTES, GEO_DISTANCE — Return location data and compute geographic distance using the declared Earth-radius constant.
• GET_THIRD_PARTY_ROLE — Returns role information for third-party resources.

Tables Accessed

The package reads from JTF_OBJECTS_B for object codes, JTF_RS_RESOURCE_EXTNS and JTF_RS_RESOURCE_EXTNS_TL for resource and translated resource data, and CSF_GPS_DEVICES, CSF_GPS_DEVICE_ASSIGNMENTS and CSF_GPS_LOCATION_FEEDS for GPS device and location feeds. Skills and qualifiers are sourced from CSF_REQUIRED_SKILLS_B, CSF_RESOURCE_SKILLS_B, CSF_SKILLS_B and CSF_SKILL_LEVELS_B, while CSF_R_RESOURCE_RESULTS holds cached query results. Incident context is drawn from CS_INCIDENTS_ALL, CS_INCIDENTS_ALL_B and CS_INCIDENTS_ALL_TL, and HZ_CODE_ASSIGNMENTS supports party classification.

Usage Notes

CSF_RESOURCE_PUB is referenced by at least fifteen other packages and is invoked from Oracle Forms and concurrent programs in the Service and Field Service modules. Custom code should call only the public routines, relying on the cached collections for efficiency, and should not depend on internal record structures, which are implementation details.