Search Results csm_profile_pkg




Overview
Explore in AI Chat

Overview

CSM_PROFILE_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that serves as a centralized profile-option resolution utility for the Customer Service (CSM) module and related field service, depot repair, and tele-service functionality. Its core purpose is to abstract the retrieval of system profile option values so that callers do not need to know the exact user, responsibility, and application context in which a profile value must be evaluated. The package supplies both a general-purpose wrapper around the FND profile framework and a large family of typed convenience accessors that expose specific configuration settings as scalar values.

The body carries a header revision of 120.9.12020000.2 (dated 2013/04/09), and internal constants such as G_RESP_LEVEL_ID (10003) and G_USER_LEVEL_ID (10004) indicate the package is aware of profile hierarchy levels. System variables v_DefaultStatusResponsibility and v_CurrentUser support defaulting behavior. The package is heavily reused — it is referenced by 31 other packages — which makes it a foundational dependency for CSM configuration reads across the application.

Key Procedures and Functions

The package exposes 18 documented procedures and functions. The most significant is VALUE_SPECIFIC, which the user query highlighted. VALUE_SPECIFIC accepts a profile option name together with optional user, responsibility, and application identifiers, and returns the resolved profile value as a VARCHAR2. Its implementation opens a cursor against the ASG_USER table to derive the responsibility and application for a publication, then overlays any explicitly passed application or responsibility values before delegating to FND_PROFILE.VALUE_SPECIFIC. This makes it a context-aware wrapper rather than a simple passthrough.

Tables Accessed

The package reads from several FND and CSM tables through APPS synonyms. FND_APPLICATION and FND_RESPONSIBILITY provide application and responsibility metadata used when constructing profile context. FND_USER supplies user identifiers referenced during profile resolution. ASG_USER is queried by VALUE_SPECIFIC to derive responsibility and application identifiers for a publication user. FND_PROFILE_OPTIONS and FND_PROFILE_OPTION_VALUES hold the underlying profile definitions and values that the accessors ultimately expose. CSM_PROFILE_OPTION_VALUES_ACC stores CSM-specific profile option values, typically at the responsibility level, and is used by the specialized getter functions.

Usage Notes

CSM_PROFILE_PKG is invoked by Oracle Service forms, concurrent programs, and Java/BC4J middle-tier code whenever CSM configuration must be read. Because VALUE_SPECIFIC accepts explicit user, responsibility, and application parameters, custom code can call it to obtain a profile value in a controlled context, bypassing the ambient FND_PROFILE context. The typed getter functions (for example GET_MAX_ATTACHMENT_SIZE or GET_TASK_HISTORY_DAYS) are preferred where a specific setting is required, as they encapsulate the correct profile option name and defaulting logic. The package remains compatible with both 12.1.1 and 12.2.2, and its broad reuse across 31 dependent packages means changes to profile resolution behavior propagate application-wide.