Search Results csm_query_event_pkg




Overview
Explore in AI Chat

Overview

APPS.CSM_QUERY_EVENT_PKG is a PL/SQL package that resides in the APPS schema and carries a VALID status in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Oracle Field Service / Customer Service (CSM) module family and supports the query and event management infrastructure used for defining, storing, and refreshing user-defined queries and their associated events. In the ETRM repository the package is classified under API classification OTHER, indicating that it is an internal supporting package rather than a public, documented application programming interface.

The package operates alongside CSM_USER_EVENT_PKG, which references it, and forms part of the broader CSM query framework concerned with account-level and user-level query results. Its core responsibility is the maintenance of query access records and user query assignments, ensuring that the query definitions maintained in the CSM query tables remain synchronized with the accounts and users entitled to execute them.

Key Procedures and Functions

The ETRM metadata documents two procedures within this package. No parameter lists are published, and callers should rely only on the documented signatures available in the database rather than assuming argument structures.

  • REFRESH_ACC — Refreshes the account-scoped query access data. It is responsible for rebuilding or revalidating the records that determine which queries are available to which accounts, drawing on the account tables and the CSM query access and results tables.
  • REFRESH_USER — Refreshes the user-scoped query access data. It performs the equivalent maintenance for user assignments, updating the user event configuration so that each user’s available queries and results are current.

The two procedures are complementary: one acts on the account dimension and the other on the user dimension of the same query access model.

Tables Accessed

Access to the underlying objects is performed through APPS synonyms. The documented tables referenced by the package are:

These tables indicate that the package joins query definitions, variables, and account results into a consolidated access view for the CSM query engine.

Usage Notes

CSM_QUERY_EVENT_PKG is an internal package and is not intended for direct invocation by end users or custom integrations. It is referenced by CSM_USER_EVENT_PKG and is therefore most commonly called indirectly from the CSM user event processing flow, where account and user query caches must be refreshed after query definitions or assignments change. In a 12.1.1 or 12.2.2 environment, invocation typically occurs during concurrent program execution or form-driven event handling that triggers query re-evaluation. Because the package maintains derived access and result data, direct calls should be avoided unless the calling code can guarantee consistent transaction boundaries. Before invoking REFRESH_ACC or REFRESH_USER from custom code, confirm the current signature in the target database, since the ETRM repository does not publish parameter metadata for this object.