Search Results csf_default_effort_uom

Overview

CSM_TASKS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the upward synchronization of task records from a mobile or handheld client environment into the enterprise database. It is part of the Field Service / Service (CSM) mobile synchronization framework, in which changes captured on disconnected handheld devices are queued and later uploaded to the central EBS instance. The package is the handler for the publication item CSM_TASKS, and its entry points are designed to be invoked by CSM_SERVICEP_WRAPPER_PKG, the generic wrapper that drives the publication synchronization process.

The package carries a header signature date of 2008/11/26 and was originally authored in 2002, with subsequent modifications addressing defect fixes such as Bug 5288413, which introduced private-owner validation for task types. In the 12.1.1 and 12.2.2 releases it remains classified as an OTHER API, meaning it is an internal runtime component rather than a public, documented integration interface.

Key Procedures and Functions

The documented API surface of the package consists of the procedure APPLY_CLIENT_CHANGES. This is the standard client-change application entry point used by the CSM publication framework: it is invoked by CSM_SERVICEP_WRAPPER_PKG after a batch of task changes has been read from the synchronization queue, and it dispatches each row to the appropriate DML handler. Its role is to apply inserts, updates and deletes originating on the handheld to the corresponding enterprise tables, and to raise row-level rejections or errors through OUT parameters where a record cannot be applied.

The package body also contains internal procedures such as APPLY_INSERT, which processes a single inserted record passed as a CSM_TASKS_INQ%ROWTYPE and returns an error message, a return status and a reject-row flag. APPLY_INSERT resolves the submitting user to a resource and responsibility, identifies the CSM application, validates whether the target task type is private, and populates the task and task-type columns on insertion. These internal routines are not part of the documented public interface and are reached only through APPLY_CLIENT_CHANGES.

Tables Accessed

• CSM_TASKS_INQ – the inbound synchronization interface table holding task records uploaded from the handheld; queried by transaction identifier and client user.
• JTF_TASKS_B – the base task table that stores the synchronized task records.
• JTF_TASK_TYPES_B – provides task type definitions and the PRIVATE_FLAG used to determine whether a task type restricts ownership.
• ASG_USER – resolves the handheld user name to a RESOURCE_ID, USER_ID and RESPONSIBILITY_ID.
• FND_APPLICATION – returns the APPLICATION_ID for the CSM application short name.
• CSM_UNIT_OF_MEASURE_TL_ACC, MTL_UNITS_OF_MEASURE – supply unit-of-measure definitions used when task attributes such as effort or quantity reference a UOM. These tables are relevant to the csf_default_effort_uom profile value, which supplies the default unit of measure applied when effort is captured on a task.
• CS_INCIDENTS_ALL_B – links synchronized tasks to their originating service incident.

Usage Notes

CSM_TASKS_PKG is invoked indirectly whenever a handheld client synchronizes task data upward. The synchronization engine reads pending rows, calls the wrapper package, and the wrapper delegates to APPLY_CLIENT_CHANGES. The package is not intended for direct invocation from forms, concurrent programs or custom code; it has no concurrent-program registration and no menu entry. Implementers troubleshooting task synchronization issues should inspect the reject-row output and the CSM_TASKS_INQ staging table rather than calling the API directly. Because it is classified as an OTHER API and referenced by only one other package, changes to its interface are unsupported and upgrades may alter its behavior without notice.