Search Results asg_service_acc

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. It is a component of the telephony and field service integration layer, historically part of the Advanced Service Gateway (ASG) product family. The package operates with AUTHID CURRENT_USER and serves as a service account access and event-handling utility, providing the database-side logic needed to synchronize user account access and to respond to DML activity on incident, task, and task assignment entities.

A critical fact documented in the package header is that, as of 26-NOV-2001, ASG_SERVICE_ACC was superseded by CSF_ACCESS_PKG. The package is therefore retained as an existing object for backward compatibility and continues to be present in the ETRM 12.2.2 inventory, but it represents legacy functionality. Its procedures are invoked primarily by database triggers and integration logic that predate the CSF replacement framework. The package is classified as OTHER in the ETRM API classification, meaning it is not a formally published or supported public API.

Key Procedures and Functions

The package exposes twelve documented procedures. They fall into three functional clusters.

• UpdateMobileUserAcc — Processes mobile user account access updates keyed by resource and server identifiers and an operation code, supporting the synchronization of field service or mobile resource credentials.
• Incident event handlers — INCIDENT_PRE_UPDATE and INCIDENT_POST_UPDATE execute before and after updates to incident records, returning a status through an OUT NOCOPY parameter. INCIDENT_TRIGGER_HANDLER accepts incident, old and new customer identifiers, and a trigger mode, providing trigger-level dispatch on incident changes.
• Task and task assignment event handlers — TASKS_POST_INSERT and TASKS_PRE_UPDATE respond to task record DML. TASK_ASSIGN_POST_INSERT, TASK_ASSIGN_PRE_UPDATE, and TASK_ASSIGN_PRE_DELETE respond to task assignment DML. TASKS_TRIGGER_HANDLER and TASK_ASSIGN_TRIGGER_HANDLER receive old and new column values plus a trigger mode, serving as centralized trigger dispatch points for their respective entities.
• Service request contact handler — SR_CONTACT_TRIGGER_HANDLER processes contact changes associated with a service request incident and an operation code.

All procedures report outcome through an OUT NOCOPY VARCHAR2 return status, the standard EBS convention for communicating success, warning, or error to the calling trigger.

Tables Accessed

The ETRM metadata does not enumerate the underlying tables referenced through APPS synonyms. Based on the procedure semantics, the package operates against the service request/incident tables, the task tables, and the task assignment tables within the Service and Telephony schemas, along with the resource and access-control structures used by UpdateMobileUserAcc. Because the access paths are made through APPS synonyms, no direct schema-qualified references are exposed in the package metadata. The package is not documented as being referenced by any other package (zero inbound dependencies), confirming its role as a leaf-level utility rather than a shared library.

Usage Notes

ASG_SERVICE_ACC is invoked indirectly rather than called directly by application code. Its trigger handler and pre/post event procedures are designed to be called from database triggers on the incident, task, and task assignment tables, where the Trigger_Mode parameter distinguishes INSERT, UPDATE, and DELETE processing. Customizations and integrations should avoid new dependencies on this package given its replacement by CSF_ACCESS_PKG; any custom code currently calling these procedures should be re-pointed to the supported replacement API. Where it remains installed in 12.1.1 or 12.2.2, it should be treated as legacy infrastructure supporting pre-existing triggers, and its execution should be validated against the CSF access framework to avoid duplicate processing of account access changes.