Search Results raise_event

Overview

The APPS.FND_FUNCTION_SECURITY_CACHE package body is an internal Oracle E-Business Suite infrastructure component that maintains the application's function security cache and simultaneously broadcasts change events through the Oracle Workflow Business Event System. Function security in EBS governs which users and responsibilities are permitted to access specific functions, menus, and menu entries. Because this security data changes at runtime, dependent caches and listeners must be notified so they can invalidate stale entries and refresh their contents. FND_FUNCTION_SECURITY_CACHE fulfils this role by packaging each security mutation into a corresponding Workflow event, raised via the standard WF_EVENT.RAISE API. It is classified under ETRM as an OTHER API, reflecting its internal, system-facing nature rather than its role as an end-user interface. The package body is versioned 120.2 (header dated 2005/11/09) and resides in the APPS schema.

Key Procedures and Functions

The package exposes a symmetric set of procedures, each corresponding to an insert, update, or delete operation on a specific security artifact. The documented set includes DELETE_FUNCTION, INSERT_FUNCTION, and UPDATE_FUNCTION; DELETE_GRANT, INSERT_GRANT, and UPDATE_GRANT; DELETE_MENU, INSERT_MENU, and UPDATE_MENU; DELETE_MENU_ENTRY, INSERT_MENU_ENTRY, and UPDATE_MENU_ENTRY; DELETE_RESP, INSERT_RESP, and UPDATE_RESP; DELETE_SECGRP, INSERT_SECGRP, and UPDATE_SECGRP; and DELETE_USER, INSERT_USER, and UPDATE_USER. Each procedure identifies the affected record by a key such as a function ID, grant GUID, or grantee key, then constructs a parameter list and raises a namespaced event (for example oracle.apps.fnd.function.insert, oracle.apps.fnd.function.update, or oracle.apps.fnd.function.delete). A shared private helper, RAISE_EVENT, centralises the call to WF_EVENT.RAISE and silently suppresses any exceptions thrown during event publication, ensuring that a notification failure cannot roll back or block the underlying security change.

Tables Accessed

The only documented table reference is WF_PARAMETER_LIST_T, accessed through an APPS synonym. This is the Oracle Workflow PL/SQL collection type used to assemble and pass name/value parameter pairs to the Business Event System. Within this package it is used to carry the identifying keys — such as FND_FUNCTION_ID or FND_GRANT_GUID — that subscribers need in order to determine which security objects changed. The package does not itself read or write the base function security tables directly; its responsibility is event publication rather than persistence.

Usage Notes

FND_FUNCTION_SECURITY_CACHE is invoked indirectly whenever function security data is modified through the standard EBS administrative forms or supported APIs. It is referenced by eleven other packages according to ETRM metadata, indicating that it forms a shared notification layer relied upon by the Function Security and related administration modules. Custom code that manipulates function security tables directly should call the appropriate insert, update, or delete procedure here so that downstream subscribers receive the corresponding business event; bypassing the package leaves caches and event consumers unaware of the change. Because RAISE_EVENT suppresses exceptions, callers cannot rely on the package to report event delivery failures, and the procedures should be treated as best-effort notification hooks rather than transactional operations.