Search Results csm_activity_seq

Overview

APPS.CSM_TASK_EVENT_PKG is a PL/SQL package body in the Oracle E-Business Suite Applications schema (status VALID) that implements the server-side event and accounting logic for the Task Manager component of Oracle TeleService / Customer Support. Its principal business function is to bridge the operational JTF task model (JTF_TASKS_B, JTF_TASK_ASSIGNMENTS, and the related references, statuses, and types base tables) with the CSM accounting and activity-tracking layer represented by CSM_TASKS_ACC, CSM_TASK_ASSIGNMENTS_ACC, and CSM_ACTIVITY_SEQ. In doing so it maintains the accounting records, escalations, and purge operations required when service tasks are created, updated, assigned, or removed. The package is classified as an OTHER API in ETRM 12.2.2 and is referenced by four other database objects, indicating that it functions as a shared internal dependency rather than a standalone public entry point.

Key Procedures and Functions

ETRM documents seven procedures or functions in this package body. ACC_INSERT and ACC_DELETE perform the accounting accrual and reversal operations for task and task-assignment activity, writing into the CSM accounting tables. PURGE_TASKS_CONC is a concurrent-program entry point that removes eligible task records and their dependent data. CHECK_ESCALATION_TASKS_CONC is the companion concurrent entry point that evaluates tasks for escalation conditions and applies the required transitions. TASK_MAKE_DIRTY_U_FOREACHUSER marks affected task records as dirty on behalf of individual users, driving the incremental download and synchronization mechanisms. TASK_INS_INIT and TASK_DEL_INIT handle initialization work for task insert and delete events respectively, preparing the rows and accounting entries that the remaining logic consumes. No parameter signatures are published in the ETRM extract; the procedure names and their documented purposes are authoritative here.

Tables Accessed

The package references its tables through APPS synonyms. FND_USER resolves the application user identities involved in ownership and dirty-record processing. JTF_TASKS_B and JTF_TASK_ASSIGNMENTS supply the task and assignment base rows, with JTF_TASK_REFERENCES_B, JTF_TASK_STATUSES_B, and JTF_TASK_TYPES_B providing the reference, status, and type definitions that govern each record's lifecycle. CSM_TASKS_ACC and CSM_TASK_ASSIGNMENTS_ACC receive the accounting entries produced by ACC_INSERT and removed by ACC_DELETE. CSM_ACTIVITY_SEQ — the object users most often search for in connection with this package — is the activity sequence generator used to assign unique activity identifiers to task activity records, which is why the sequence appears so prominently in dependency listings. JTM_CON_REQUEST_DATA and DUAL support internal lookups and single-row evaluation, and PLITBLM is the standard PL/SQL table bulk-mapping type used for in-memory collections.

Usage Notes

CSM_TASK_EVENT_PKG is not published for customer customization or direct API invocation. It is invoked indirectly whenever task events are raised from the Task Manager forms, when the task purge and task escalation concurrent programs are submitted, and by peer packages such as CSM_TASK_ASSIGNMENT_EVENT_PKG, CSM_NOTES_EVENT_PKG, CSM_PARTY_SITE_EVENT_PKG, CSM_SR_EVENT_PKG, CSM_ACC_PKG, CSM_PROFILE_PKG, and CSM_UTIL_PKG, all of which appear in the dependency list. Custom code requiring sequence values should obtain them through the supported accounting and event paths rather than referencing CSM_ACTIVITY_SEQ directly, because sequence generation is coordinated inside this package to keep task activity identifiers consistent with the accrual rows. Diagnosing escalation, purge, or accounting synchronization issues for tasks on either 12.1.1 or 12.2.2 typically begins by confirming that this package is VALID and that no invalid dependent package bodies are blocking its execution.