Search Results task_assignment_hist_del_init

Overview

APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG is a VALID PL/SQL package in the Oracle E-Business Suite Applications schema (APPS), classified as API classification OTHER. It belongs to the Oracle Field Service / TeleService event infrastructure that manages the lifecycle of task assignment records and their downstream side effects. The package functions as an event-driven orchestration layer: it intercepts changes to task assignments in the Contact Center and Field Service modules and propagates the corresponding insert, update, and delete operations into the ancillary tables that track debrief information, requirements, service history, and audit data. It also maintains the assignment "ACC" (audit/consolidation) staging tables and performs scheduled purging of historical task assignment data. Because the object is installed in APPS and is referenced by six sibling packages — CSM_SERVICE_HISTORY_EVENT_PKG, CSM_SR_EVENT_PKG, CSM_TASK_EVENT_PKG, CSM_USER_EVENT_PKG, CSM_WF_PKG, and itself — it forms a central node in the CSM event processing graph and is a dependency of the workflow integration layer.

Key Procedures and Functions

The package exposes nineteen documented procedures grouped by function:

• Assignment lifecycle: TASK_ASSIGNMENT_INITIALIZER establishes the assignment context; TASK_ASSIGNMENT_HIST_INIT and TASK_ASSIGNMENT_HIST_DEL_INIT manage task assignment history; TASK_ASSIGNMENT_PURGE_INIT and PURGE_TASK_ASSIGNMENTS_CONC support the purge cycle.
• Spawned debrief records: SPAWN_DEBRIEF_HEADER_INS, SPAWN_DEBRIEF_LINE_INS, SPAWN_DEBRIEF_HEADER_DEL, and SPAWN_DEBRIEF_LINE_DEL create or remove debrief header and line rows in response to assignment changes.
• Spawned requirement records: SPAWN_REQUIREMENT_HEADER_INS, SPAWN_REQUIREMENT_LINES_INS, SPAWN_REQUIREMENT_HEADER_DEL, and SPAWN_REQUIREMENT_LINES_DEL mirror that behavior for requirement headers and lines.
• ACC staging processing: TASK_ASSIGNMENTS_ACC_PROCESSOR drives processing of the ACC staging table, while ACC_INSERT and ACC_DELETE perform the corresponding row-level operations.
• Audit/LOB helpers: LOBS_MDIRTY_I and LOBS_MDIRTY_D mark LOB (large object) columns as modified or clean in support of audit tracking.

Tables Accessed

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

• Task and assignment core: CSM_TASKS_ACC, CSM_TASK_ASSIGNMENTS_ACC, CSM_SERVICE_HISTORY_ACC.
• Debrief staging: CSM_DEBRIEF_HEADERS_ACC and CSM_DEBRIEF_LINES_ACC for the ACC-layer debrief records, with CSF_DEBRIEF_HEADERS and CSF_DEBRIEF_LINES as the base debrief tables.
• Requirements staging: CSM_REQ_HEADERS_ACC and CSM_REQ_LINES_ACC, plus CSP_REQUIREMENT_HEADERS, CSP_REQUIREMENT_LINES, and CSP_REQ_LINE_DETAILS.
• Reference and context: ASG_USER and ASG_USER_PUB_RESPS for task ownership and public responsibility data, and CS_INCIDENTS_ALL_B for the incident/service-request association.

These tables are accessed to propagate assignment events into debrief, requirement, and history structures, and to support the ACC staging process that feeds downstream reporting and integration.

Usage Notes

Custom code should treat this package as an internal event-handler rather than a directly callable API. It is normally invoked indirectly by the CSM event infrastructure and by the packages that reference it — CSM_TASK_EVENT_PKG, CSM_SR_EVENT_PKG, CSM_SERVICE_HISTORY_EVENT_PKG, CSM_USER_EVENT_PKG, and CSM_WF_PKG (workflow). The only procedure designed for direct scheduled execution is PURGE_TASK_ASSIGNMENTS_CONC, which is intended to be registered as a concurrent program for periodic cleanup of historical task assignment data. In Release 12.1.1 and 12.2.2 the package remains VALID and unmodified in structure, so any customization should avoid altering its signature. Developers integrating with Task Assignment events should call the higher-level CSM event packages that in turn drive this one, and should account for the ACC-layer staging tables when building composite data models.