Search Results jtf_time_uom_class

Overview

CSM_PROFILE_EVENT_PKG is an Applications-level PL/SQL package body owned by APPS that supports profile option management within the Oracle E-Business Suite customer service and interaction center modules. Its principal business purpose is to synchronize the "accelerator" profile cache tables (CSM_PROFILES_ACC_S and CSM_PROFILE_OPTION_VALUES_ACC) with the authoritative profile option definitions and values held in FND_PROFILE_OPTIONS and FND_PROFILE_OPTION_VALUES. The package identifies stale or orphaned accelerator rows — for example, entries whose corresponding seeded profile option has been end-dated, removed, or never defined — and refreshes them so that runtime profile resolution remains consistent. The naming convention and the referenced profile options (CSF_M_RECIPIENTS_BOUNDARY, JTF_TIME_UOM_CLASS, CSM_SEARCH_RESULT_SET_SIZE, SERVER_TIMEZONE_ID, and others) confirm that the package is scoped to the customer service (CSM/CSF), interaction center, and task-tracking product families. It is classified as OTHER in the ETRM API registry rather than as a public or private API.

Key Procedures and Functions

Two documented entry points are exposed by this package body:

• REFRESH_ACC — Refreshes the accelerator profile tables at a global level. It reconciles rows in CSM_PROFILE_OPTION_VALUES_ACC against FND_PROFILE_OPTION_VALUES and FND_PROFILE_OPTIONS, removing accelerator records that no longer have a valid underlying profile option definition or value, and repopulating entries as required. This is the primary maintenance routine for the accelerator cache.
• REFRESH_USER_ACC — Performs the equivalent reconciliation for a specific user context, operating on the user-level rows identified by access_id and user_id. It allows an individual user's accelerator profile snapshot to be rebuilt without forcing a global refresh.

Both procedures rely on the internal cursor l_profiles_del_csr, which drives deletion of stale accelerator rows via a UNION of two anti-join queries against FND_PROFILE_OPTION_VALUES and FND_PROFILE_OPTIONS. Parameter lists are not documented in the available metadata and are therefore not reproduced here.

Tables Accessed

• CSM_PROFILE_OPTION_VALUES_ACC — the accelerator staging table holding profile option values keyed by access_id, user_id, profile_option_id, application_id, level_id, and level_value; read to identify stale entries and written during refresh.
• CSM_PROFILES_ACC_S — the accelerator sequence/table that supplies generated access identifiers used when new accelerator rows are created.
• FND_PROFILE_OPTIONS — the seeded profile option definitions; queried with start_date_active/end_date_active filters and a whitelist of relevant profile_option_name values.
• FND_PROFILE_OPTION_VALUES — the authoritative stored values by level; used to verify that each accelerator row has a matching source value.
• ASG_USER — the resource/user table used to resolve user identities during user-level refresh.
• JTM_CON_REQUEST_DATA — referenced in the broader package logic, typically for interaction or request context data.
• PLITBLM — the standard PL/SQL index-by table of VARCHAR2 used for in-memory collections within the package.

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2, CSM_PROFILE_EVENT_PKG is invoked as a background maintenance utility rather than from end-user forms. Typical call sites are concurrent programs, profile-option save event handlers, and custom extension code that needs to force profile accelerator synchronization after administrative changes to customer service profile options. Because the ETRM registry records the package as referenced by two other packages, it is also called programmatically by dependent CSF/CSM components. The header revision string (csmeprfb.pls 120.32.12020000.3, dated 2013/04/09) indicates a mature, low-change module. Note that the user search term "csf_uom_minutes" does not appear among the profile options enumerated in the visible source; the closest related seeded option handled by this package is JTF_TIME_UOM_CLASS, which governs the unit-of-measure class used for time durations (including minutes) in task and interaction processing. Administrators investigating minute-based UOM behavior should confirm whether CSF_UOM_MINUTES exists as a customer-defined profile option, since the package's refresh logic is driven by the profile_option_name whitelist shown in the cursor definition.