Search Results tasks_trigger_handler

Overview

ASG_SERVICE_ACC is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to manage access control and synchronization logic for mobile service users and for service request entities managed through the TeleService and Field Service (ASG) modules. The package coordinates security and access records associated with parties, incidents, tasks, and task assignments, and exposes trigger handler interfaces that the surrounding ASG framework invokes during database events.

An important historical note is embedded in the package header comment, which states that the package was replaced by CSF_ACCESS_PKG in November 2001. Despite this replacement notice, the documented metadata shows that ASG_SERVICE_ACC remains instantiated with twelve functional entry points and is retained for backward compatibility with existing callers, triggers, and integrations that reference the older interface.

Key Procedures and Functions

• UPDATEMOBILEUSERACC — Updates mobile user access records for a given resource and server context.
• INCIDENT_PRE_UPDATE — A pre-update hook on incident records that returns a status indicator to the calling framework.
• INCIDENT_POST_UPDATE — Post-update processing for incident records, typically used to propagate access or synchronization changes.
• TASKS_POST_INSERT — Executed after a task row is inserted to apply associated access logic.
• TASKS_PRE_UPDATE — Pre-update processing for task records.
• TASK_ASSIGN_POST_INSERT — Post-insert logic for task assignment rows.
• TASK_ASSIGN_PRE_UPDATE — Pre-update processing for task assignment rows.
• TASK_ASSIGN_PRE_DELETE — Pre-delete processing for task assignment rows, used to clean up dependent access data.
• INCIDENT_TRIGGER_HANDLER — Trigger entry point that dispatches incident-related access maintenance.
• TASKS_TRIGGER_HANDLER — Trigger entry point that dispatches task-related access maintenance; this is the object most directly associated with the user search term "tasks_trigger_handler".
• TASK_ASSIGN_TRIGGER_HANDLER — Trigger entry point for task assignment access maintenance.
• SR_CONTACT_TRIGGER_HANDLER — Trigger entry point managing contact associations on service requests.

The package body also contains legacy helper routines such as run_command, IsExisting, InsertAcc, UpdateAcc, IsMobileUser, GetServerId, and UpdateAccesses variants for party, incident, and task identifiers. In the documented source these are implemented with NULL bodies, confirming that the substantive logic was migrated to CSF_ACCESS_PKG.

Tables Accessed

The ETRM metadata for this package does not enumerate referenced tables via APPS synonyms. The package name and its procedure inventory indicate that it operates against ASG access, task, task assignment, incident, and mobile user tables, but no explicit table list is documented. The NULL helper implementations further indicate that direct DML against base tables is no longer performed within this package body.

Usage Notes

ASG_SERVICE_ACC is not referenced by any documented calling packages, indicating that invocation occurs through database triggers, forms-level events, or older custom code rather than through inter-package APIs. The trigger handler procedures are the practical integration surface: trigger definitions on the incident, task, and task assignment tables call these handlers to keep access records synchronized. Because the legacy helpers are stubs, administrators should treat CSF_ACCESS_PKG as the authoritative implementation and regard ASG_SERVICE_ACC as a compatibility shim. New development should reference CSF_ACCESS_PKG directly.