Search Results csm_party_site_event_pkg




Overview
Explore in AI Chat

Overview

APPS.CSM_PARTY_SITE_EVENT_PKG is a PL/SQL package in the Oracle E-Business Suite Applications schema (APPS) that forms part of the Customer Service Management (CSM) event infrastructure. Its business function is to publish Workflow event messages when party site, party, and location records change, so that downstream service request, task assignment, and location-processing logic can react to those changes in a coordinated manner. The package is a native-integration component rather than a user-facing API: it is invoked by table-triggered event logic or by other CSM packages and raises Oracle Workflow business events through the WF_EVENT_T datatype. The ETRM 12.2.2 metadata classifies it as an OTHER API type, status VALID, indicating it is a supported internal package rather than a formally published public API. Its naming convention — the _EVENT_PKG suffix — is consistent with the other CSM event packages in the same family (CSM_PO_LOCATIONS_EVENT_PKG, CSM_SR_EVENT_PKG, and others), which together implement event-driven propagation across the CSM data model.

Key Procedures and Functions

Five packaged subprograms are documented, three of which are the standard event-handling triplets for the party-sites account entity:

  • PARTY_SITES_ACC_I — Handles the insert event for party site account records. Fires the creation event so that dependent CSM entities, such as incidents and tasks, can associate the newly created party site account.
  • PARTY_SITES_ACC_D — Handles the delete event for party site account records. Publishes the removal event so downstream consumers can clean up or revalidate references to the deleted record.
  • PARTY_SITES_ACC_U — Handles the update event for party site account records. Publishes a change event carrying the updated context for consumers such as service requests.
  • LOCATION_UPD_WF_EVENT_SUB — A Workflow event subscription routine that processes inbound location-update events, providing the CSM layer's response to changes originating on the location/party-site side.
  • PARTY_SITE_UPD_WF_EVENT_SUB — A Workflow event subscription routine that processes inbound party-site-update events, allowing the package to react to changes raised elsewhere and to propagate them into CSM processing.

The presence of both _I/_D/_U publisher routines and _WF_EVENT_SUB subscription routines indicates a bidirectional event pattern: the package both raises and consumes Workflow events within the CSM event mesh. Note that no parameter lists are defined in the ETRM metadata, so the exact signatures must be confirmed from the deployed package body.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

  • WF_EVENT_T — The Oracle Workflow event datatype, used to construct and raise business events.
  • CSM_PARTY_SITES_ACC — The CSM party-sites account entity whose inserts, updates, and deletes are the primary source of the published events.
  • CSM_INCIDENTS_ALL_ACC — The CSM incidents table, accessed to associate or revalidate service requests against changed party sites.
  • CS_INCIDENTS_ALL_B — The base incidents table, used for incident context during event processing.
  • HZ_PARTIES and HZ_PARTY_SITES — The TCA registry party and party-site tables, providing the master data against which site changes are resolved.
  • FND_USER — Used to resolve the application user identity associated with the event, supporting audit and security context.

Usage Notes

CSM_PARTY_SITE_EVENT_PKG is an internal, event-driven package and is not intended for direct invocation by end users. It is typically triggered from DML logic on the CSM party-site account tables, from concurrent processing, or from Workflow event subscriptions configured in Oracle Workflow Administrator. Custom code should not call it directly; instead, extensions should subscribe to the raised Workflow events. Because it is referenced by seven other packages, including CSM_PO_LOCATIONS_EVENT_PKG, CSM_SR_EVENT_PKG, CSM_TASK_ASSIGNMENT_EVENT_PKG, CSM_USER_EVENT_PKG, and CSM_WF_PKG, any modification to its behavior has broad impact across the CSM module. In EBS 12.1.1 and 12.2.2 the package remains VALID and should be treated as a sealed integration point; customization should be limited to event subscription rules rather than changes to the packaged code itself.