Search Results is_terr_selected

Overview

CSF_UTIL_PVT is a private (PVT) utility package body in the Oracle E-Business Suite APPS schema that supports the Oracle TeleService / Field Service / Customer Support "CSF" product family, and in particular the territory, resource, and effort-tracking infrastructure built on the CSF and JTF schema objects. It is classified as a private package, meaning it is intended for internal use by the CSF application modules rather than as a public, customer-facing API. The package exposes a collection of small helper functions and utility routines that are consumed by other CSF packages, forms, and concurrent programs within the same application. Notably, it is referenced by 21 other packages, confirming its role as a shared internal utility layer. A defining characteristic of the body is its centralization of FND profile option lookups and FND API constants. Two profile values are resolved at package initialization: CSF_UOM_MINUTES, bound to the constant g_uom_minutes, and CSF_DEFAULT_EFFORT_UOM, bound to g_default_uom. The former governs the conversion of effort measurements into minutes, which is directly relevant to the "get_uom_minutes" search term — the g_uom_minutes constant is the package-level representation of that profile setting.

Key Procedures and Functions

The documented API surface consists of 35 procedures and functions. Because the package is private and the metadata does not expose parameter lists, only the documented names and purposes are described here.

• GET_MISS_NUM, GET_MISS_CHAR, GET_MISS_DATE — Return the FND_API "missing" sentinel values, allowing callers to compare incoming attribute values against the null placeholder used by the FND API framework.
• GET_VALID_LEVEL_NONE, GET_VALID_LEVEL_FULL — Return the FND_API validation-level constants, used by callers to control how strictly an API validates its input.
• GET_RET_STS_SUCCESS, GET_RET_STS_ERROR, GET_RET_STS_UNEXP_ERROR — Return the standard FND_API return-status codes so that callers can interpret and propagate API results uniformly.
• GET_TRUE, GET_FALSE — Return the FND_API boolean constants.
• GET_FIRST, GET_NEXT, GET_LAST — Return the FND_MSG_PUB message-stack navigation constants (g_first, g_next, g_last) used when traversing the message stack.
• GET_ADDRESS — A utility routine for retrieving address information, typically used in support of territory or resource resolution.
• ADD_TIMER — Registers a timer entry, interacting with the CSR_TIMERS_B table.
• IS_TERR_SELECTED, GET_SELECTED_TERR, GET_SELECTED_TERR_TABLE, SET_SELECTED_TERR — A group of routines for managing the user's currently selected territories, reading and writing CSF_USER_SELECTED_TERRS and related territory objects.
• GET_OBJECT_NAME — Returns a descriptive object name used for diagnostic or display purposes.

Tables Accessed

The package reads and writes a documented set of tables through APPS synonyms. Territory selection routines use CSF_USER_SELECTED_TERRS, CSF_PLAN_TERRS, and CSF_PLAN_TASK_OWNERS. CSF_DC_QUERIES_B and CSF_DC_QUERY_EXTNS support the data-collection query definitions. Timer functionality relies on CSR_TIMERS_B and V$TIMER. Time zone resolution uses FND_TIMEZONES_B. Resource group membership is read from JTF_RS_GROUP_MEMBERS, and JTF_TERR_QTYPE_USGS_ALL supports territory qualifier-type usage. PLITBLM is a PL/SQL internal table type used for bulk operations.

Usage Notes

CSF_UTIL_PVT is invoked internally by dependent CSF packages (21 documented references) rather than being called directly by end users. It is typically reached from Oracle Forms event handlers and concurrent programs that perform territory selection, effort/UOM conversion, and timer registration. Custom code may reference its FND constant accessors as a convenience, but because the package is private, Oracle does not guarantee interface stability across patches and upgrades. The CSF_UOM_MINUTES profile option is the configuration point that controls minute-based effort conversion, and the g_uom_minutes constant is read only once at package load, so changes to the profile require a new session to take effect.