Results for “notes_make_dirty_i_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:
- CSM_NOTES_ACC — the primary notes accelerator table whose dirty status is set by the per-user and per-group procedures.
- CSM_OBJECT_MAPPINGS_ACC and CSM_OBJECT_MAPPINGS_ACC_S — map notes to their parent CSM objects; used by OBJECT_MAPPINGS_ACC_PROCESSOR.
- JTF_NOTES_B and JTF_OBJECT_MAPPINGS — base notes and object mapping tables in the JTF foundation layer.
- CSM_CONTR_HEADERS_ACC, CSM_DEBRIEF_HEADERS_ACC, CSM_INCIDENTS_ALL_ACC, CSM_ITEM_INSTANCES_ACC, CSM_PARTIES_ACC, CSM_TASKS_ACC — the accelerator tables representing contracts, debriefs, incidents/service requests, item instances, parties, and tasks, respectively, providing the object context for notes.
- FND_USER — resolves affected application users.
- PLITBLM — the standard Oracle PL/SQL table/array support package used internally.
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.