Results for “notes_make_dirty_d_grp”

8 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSM_NOTES_EVENT_PKG is an APPS-owned PL/SQL package within the Oracle E-Business Suite Customer Service (CSM) module. Its primary business function is to manage the event-driven propagation of note changes across the Customer Service application tables. When notes are created, updated, or deleted against a source object — such as a service request, task, debrief, party, or contract — the package determines the affected users and groups and marks the corresponding note records as "dirty" so that downstream synchronization and processing can pick them up. This reflects the Service (CSM) architecture's use of staging or accelerator (_ACC) tables, which hold denormalized or synchronized copies of base data. The package status is VALID in both 12.1.1 and 12.2.2, and it is classified as an API of type OTHER, indicating it is intended for internal call rather than direct end-user or external invocation.

Key Procedures and Functions

The ETRM metadata documents five packaged units. Their names indicate their roles:

  • NOTES_MAKE_DIRTY_I_FOREACHUSER — Handles the insert (I) case of marking note records as dirty on a per-user basis. It drives the propagation of newly created notes to each affected user.
  • NOTES_MAKE_DIRTY_U_FOREACHUSER — Handles the update (U) case of marking note records as dirty on a per-user basis, propagating changed notes to each affected user.
  • NOTES_MAKE_DIRTY_I_GRP — Handles the insert case of marking notes as dirty at the group level, propagating new notes to affected user groups.
  • NOTES_MAKE_DIRTY_D_GRP — Handles the delete (D) case of marking notes as dirty at the group level, reflecting removal or invalidation of notes for groups.
  • OBJECT_MAPPINGS_ACC_PROCESSOR — Processes object mapping records in the accelerator tables, resolving the relationships between notes and their target CSM objects (service requests, tasks, parties, and so on).

These procedures collectively implement the "dirty flag" pattern used by CSM to signal that note data requires reprocessing or resynchronization. Parameter lists are not documented and are therefore not enumerated here.

Tables Accessed

The package reads and writes through APPS synonyms over several CSM accelerator (_ACC) tables and related base tables:

Usage Notes

CSM_NOTES_EVENT_PKG is an internal event-handling package. It is referenced by seven other packages, including CSM_CONCURRENT_JOBS_PKG, CSM_DEBRIEF_HEADER_EVENT_PKG, CSM_PARTY_EVENT_PKG, CSM_SR_EVENT_PKG, CSM_TASK_ASSIGNMENT_EVENT_PKG, CSM_TASK_EVENT_PKG, and CSM_WF_PKG. This dependency pattern confirms that it is invoked as part of the broader CSM event and workflow processing flow, typically triggered when notes change on customer service objects and the corresponding users or groups must be notified or have their synchronized data refreshed. It may be reached through concurrent programs managed by CSM_CONCURRENT_JOBS_PKG or through Workflow (CSM_WF_PKG) activity processing. Because it is an API of classification OTHER and operates on accelerator tables, it should not be called directly from custom code without understanding the CSM synchronization model; customizations should instead rely on the supported CSM public APIs, which in turn invoke this package.