Search Results cust_cont

Overview

WFA_HTML_JSP is an Oracle E-Business Suite workflow utility package owned by APPS and classified as OTHER in the ETRM repository for release 12.2.2 (with equivalent availability in 12.1.1). The package body implements helper logic used by the Oracle Workflow HTML/JSP notification layer. Its principal purpose is to resolve a Workflow notification identifier from a set of business keys — typically the user name, item type, and item key — so that an external or embedded page (such as a Self-Service Procurement "Orders to Approve" view) can link directly to the correct notification. The header comment in the source explicitly states the function was "Created for integration with SSP Orders to Approve," confirming that the package exists to support cross-module notification navigation rather than to expose a general-purpose workflow API. The package is not intended for broad reuse; it is tightly coupled to the HTML notification rendering path and to the directory structures that resolve user identities.

Key Procedures and Functions

• GETSSPNID — Returns a notification identifier for a given user name, item type, and item key. It first decodes the supplied user name into a Workflow role orig_system and orig_system_id using WF_ROLES, explicitly excluding system roles such as HZ_PARTY, POS, ENG_LIST, AMV_CHN, HZ_GROUP, and CUST_CONT. It then searches WF_NOTIFICATIONS, matching either notifications whose more_info_role equals the user name or, when that attribute is null, notifications whose recipient role is one of the roles assigned to that user. Results are filtered by a context pattern built from the item type and item key, and the maximum notification_id is returned. The routine cannot be rewritten against WF_DIRECTORY because of its PRAGMA WNPS constraint, so it queries WF_ROLES directly.
• GETSSPOPENNID — A companion function documented in the same package metadata, providing the corresponding "open notification" lookup used by the SSP approval integration. It follows the same identity-resolution and context-matching pattern as GETSSPNID.

Tables Accessed

The package reads WF_NOTIFICATIONS, accessed through the APPS synonym. This table supplies the notification_id, context, more_info_role, and recipient_role columns required to locate the correct notification. Identity resolution relies additionally on WF_ROLES (and, indirectly, WORKFLOW user-role assignments) to convert a user name into the originating system identifiers needed to correlate user roles. The query deliberately excludes several seeded directory systems, including CUST_CONT, which prevents customer-contact and similar party-oriented roles from being treated as valid notification owners during the lookup. No writes are performed; the package is read-only with respect to persistent data.

Usage Notes

WFA_HTML_JSP is invoked from the Oracle Workflow HTML/JSP notification framework and from the Self-Service Procurement "Orders to Approve" integration, where a page must translate business context into a specific notification link. It is not exposed as a public API and is referenced by no other documented packages in the ETRM repository, indicating call-site integration rather than package-to-package dependency. Custom code should therefore avoid direct invocation; the supported approach is to let the standard notification pages invoke it. Because the identity lookup depends on WF_ROLES and role assignments, results reflect the directory state at execution time, and the excluded system list (including CUST_CONT) should be treated as fixed behavior. Any wrapper or extension should account for the PRAGMA WNPS restriction that prevents reuse of WF_DIRECTORY.