Search Results purge_tasks

Overview

CSL_JTF_TASKS_ACC_PKG is an APPS-owned PL/SQL package within the Oracle E-Business Suite Customer Care / Service (CSL) schema family. It belongs to the ETRM (E-Business Suite Technical Reference Manual) classification of OTHER, indicating it is an internal supporting package rather than a public, supported API. Its principal business purpose is to maintain the accessibility and replication of task records stored in the JTF Tasks framework — the shared task and appointment infrastructure used across TeleService, Field Service, and related modules. The package coordinates the insertion, update, deletion, and replication of task data into the CSL_JTF_TASKS_ACC shadow table, which supports accessibility, audit, or synchronization requirements for service tasks associated with incidents and service requests.

Key Procedures and Functions

Eleven procedures and functions are documented within the package. Their names follow a consistent event-driven naming convention:

• REPLICATE_RECORD — Copies or mirrors a task record into the accessibility table, ensuring the CSL_JTF_TASKS_ACC structure stays in step with the base task data.
• PRE_INSERT_CHILD / POST_DELETE_CHILD — Handle child (dependent) records, preparing data before insertion and cleaning up after removal.
• PRE_INSERT_TASK / POST_INSERT_TASK — Perform pre- and post-processing around the insertion of a task, typically validating prerequisites before insert and finalizing replicated or dependent data afterward.
• PRE_UPDATE_TASK / POST_UPDATE_TASK — Surround task updates, synchronizing the accessibility records before and after the change.
• PRE_DELETE_TASK / POST_DELETE_TASK — Manage the removal of tasks, including dependent-record cleanup.
• INSERT_ALL_ACC_RECORDS — A bulk operation that populates the accessibility table, likely used for backfill or initial synchronization.
• PURGE_TASKS — Removes obsolete or stale task accessibility records, supporting housekeeping and data-retention requirements.

The package depends on CSL_CS_INCIDENTS_ALL_ACC_PKG, indicating the task accessibility logic is tied to the incident accessibility framework.

Tables Accessed

The following tables are referenced through APPS synonyms:

• JTF_TASKS_B — The base task table holding the primary task definition and identifiers.
• CSL_JTF_TASKS_ACC — The accessibility shadow table maintained by this package, the principal write target of the replication procedures.
• JTF_TASK_ASSIGNMENTS — Stores task assignments; accessed to manage child assignment records during insert and delete operations.
• JTF_TASK_STATUSES_B and JTF_TASK_TYPES_B — Lookup tables for task status and task type, used for validation and classification.
• ASG_USER — The resource/user table supporting assignment and ownership context.
• DBMS_SQL and PLITBLM — Oracle-supplied packages used for dynamic SQL and PL/SQL table (index-by table) handling respectively, supporting the package's dynamic or bulk operations.

Usage Notes

CSL_JTF_TASKS_ACC_PKG is not intended for direct invocation by end users or custom code; it is an internal package invoked by other CSL packages and by the JTF Tasks framework itself. The ETRM dependency data confirms it is referenced by CSL_JTF_TASK_ASS_ACC_PKG, CSL_SERVICE_HISTORY_PKG, and CSL_USER_PKG, and it references itself recursively. The event-style procedures (PRE_/POST_INSERT/UPDATE/DELETE) suggest the package is called from task lifecycle trigger or handler code — typically from the Oracle Forms UI (TeleService task and appointment forms) or from concurrent programs that batch-maintain task data. The INSERT_ALL_ACC_RECORDS and PURGE_TASKS procedures are suited to data-migration or housekeeping concurrent programs run by administrators during implementation, patching, or periodic maintenance. Because the package is classified as OTHER and not a public API, any customization should invoke it only indirectly through the supported JTF Tasks framework to avoid breaking the synchronization between JTF_TASKS_B and CSL_JTF_TASKS_ACC.