Search Results csm_user_pkg




Overview
Explore in AI Chat

Overview

CSM_USER_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Customer Relationship Management (CRM) service module family, as indicated by the CSM prefix shared with packages such as CSM_SERVICEP_WRAPPER_PKG and the CSM Service request objects. Its documented purpose is to manage the application of user-related attribute changes on behalf of the CRM user interface and wrapper layers. The package is classified as OTHER in the ETRM registry rather than as a public API, which indicates that it is an internal implementation package supporting the service user interface and its associated wrappers, and that Oracle does not publish it as a supported customer extension point.

Key Procedures and Functions

ETRM documents one procedure or function for this package.

  • APPLY_CLIENT_CHANGES — This routine commits client-side modifications made in the CRM user interface back to the database. It is the single entry point through which the service module propagates changed user data, ensuring that edits captured in the browser or client tier are persisted consistently against the underlying CRM user records. Because the package is classified as OTHER, the procedure is intended for internal invocation by the service wrapper layer rather than for direct calls from custom code.

No additional public procedures or functions are registered in the ETRM metadata, and no parameter signatures are documented. Customizations should therefore treat APPLY_CLIENT_CHANGES as an opaque internal interface.

Tables Accessed

The package accesses the following tables through APPS synonyms:

  • ASG_USER — Stores user assignment and responsibility-related data used by the CRM service application. CSM_USER_PKG reads and updates this table when applying client changes to user profiles and assignments.
  • CSF_M_USER_INQ — A mobile and field service inquiry table from the CSF (Field Service) schema family, used for user inquiry and lookup information. The package references it to resolve user context and retrieve the current state of user inquiry records.
  • FND_APPLICATION — The Oracle Application Object Library table that registers applications and their identifiers. It is referenced to resolve application identifiers and validate the CRM application context under which user changes are being applied.

Usage Notes

CSM_USER_PKG is invoked through the CRM service user interface and its supporting wrapper package, CSM_SERVICEP_WRAPPER_PKG, which is documented as referencing this package. In typical deployments the procedure is called during the save or commit cycle when a user modifies service-related user data in the CRM forms-based interface. The package also appears in its own dependency list, indicating internal self-reference within its PL/SQL body.

The only documented external references are the SYS.STANDARD package and internal APPS packages. Because the package is classified as OTHER and is not a published API, customizations should not call APPLY_CLIENT_CHANGES directly. Instead, clients should invoke the supported wrapper package or the standard CRM service user interface, allowing Oracle to manage validation and commit semantics. Direct invocation risks bypassing validation logic and can produce inconsistent user assignment data across ASG_USER and the associated inquiry records. As with all APPS-schema packages, the definition resides in the APPS schema and is compiled against the application's synonym layer, so dependency validation through the ETRM registry is advisable before any patching or upgrade activity.