Search Results wfa_html
Overview
APPS.WFA_HTML is the package body behind the Oracle Workflow HTML interface — the browser-based notification "Worklist" and notification-response pages exposed by the Oracle E-Business Suite Workflow Notification System. In EBS 12.1.1 and 12.2.2 the package renders the HTML worklist used by users to review notifications, open notification details, view message attributes, and submit responses or forwards. Its prefix (WFA — Workflow Agent) and its documented procedures such as HOME, WORKLIST, LOGIN, and LOGOUT confirm that the package implements the servlet-style entry points invoked by the Oracle Workflow web agent.
The object is a compensating control point for the notification subsystem: rather than exposing a conventional PL/SQL API, it emits HTML/JavaScript framesets that drive the Worklist UI. It is classified as OTHER in the ETRM metadata, meaning it is an internal implementation package, not a supported public API.
Key Procedures and Functions
LOGIN/LOGOUT— establish and terminate the web session for the Worklist interface, binding the caller to a validated workflow role.HOME/HOMEMENU/HOME_FLOAT— render the Worklist home page, its menu bar, and the floating navigation frame respectively.HEADER— produce the standard page header used across all Worklist screens.WORKLIST— list the notifications currently assigned to the user, the core screen of the notification Worklist.VIEWER— display a selected notification in read-only form.FIND— provide the notification search/lookup facility.DETAILFRAME,RESPONSEFRAME,FORWARDFRAME— emit the framed layout containers that host the detail, response, and forward panes.DETAIL,DETAIL2,DETAILLINK— render the notification body and its attribute links.ATTRIBUTEINFO— show the value and metadata of an individual message attribute.SUBMITFORWARD,SUBMITRESPONSE,SUBMITSELECTEDRESPONSE,FORWARDNIDS— process user actions: forwarding one or many notifications and returning an approved/rejected response to the workflow engine.
Tables Accessed
WF_NOTIFICATIONS,WF_NOTIFICATION_ATTRIBUTES— the persistent store of notifications and their message attribute values; read for the Worklist, detail, and attribute screens, and updated when a response is submitted.WF_MESSAGE_ATTRIBUTES— attribute definitions used to format the detail and attribute screens.WF_ROLES,WF_ROLE_LOV_VL,WF_USERS,WF_USER_ROLES— role and user validation for login, notification ownership, and forward-recipient selection.- Infrastructure objects —
DBMS_LOBandDBMS_SESSIONfor large-object handling and session state,DBMS_LOB/WPG_DOCLOADfor content delivery, andOWA_UTIL,HTP,HTF, andPLITBLMfor HTML generation and URL escaping.
Usage Notes
WFA_HTML is invoked by the Oracle Workflow web agent, which maps HTTP requests (for example wfa_html.home or wfa_html.worklist) onto the corresponding procedures. It is not intended for direct invocation from forms, concurrent programs, or custom code. Developers integrating with Worklist behaviour should restrict themselves to the supported Workflow APIs — WF_NOTIFICATION, WF_CORE, WF_MAIL, and WF_DIRECTORY, all of which WFA_HTML itself depends on. Because the package is a dependent object and not referenced by any other database object, modifications should be avoided; changes to the Look-and-Feel of the Worklist must use Oracle's supported personalization mechanisms rather than package edits. The package is VALID in the documented environment.
-
PACKAGE BODY: APPS.WFA_HTML
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WFA_HTML, status:VALID,
-
PACKAGE BODY: APPS.WFA_HTML
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WFA_HTML, status:VALID,
-
PACKAGE: APPS.WFA_HTML
12.2.2
owner:APPS, object_type:PACKAGE, object_name:WFA_HTML, status:VALID,
-
PACKAGE: APPS.WFA_HTML
12.1.1
owner:APPS, object_type:PACKAGE, object_name:WFA_HTML, status:VALID,
-
SYNONYM: PUBLIC.WPG_DOCLOAD
12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:WPG_DOCLOAD, status:VALID,
-
PACKAGE BODY: APPS.FND_DM_REPOSITORY_PKG
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FND_DM_REPOSITORY_PKG, status:VALID,
-
PACKAGE: APPS.WFA_HTML_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:WFA_HTML_UTIL, status:VALID,
-
SYNONYM: PUBLIC.WPG_DOCLOAD
12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:WPG_DOCLOAD, status:VALID,
-
PACKAGE: APPS.WF_MAIL_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:WF_MAIL_UTIL, status:VALID,
-
PACKAGE BODY: APPS.FND_DM_REPOSITORY_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FND_DM_REPOSITORY_PKG, status:VALID,
-
PACKAGE: APPS.WF_LOV
12.2.2
owner:APPS, object_type:PACKAGE, object_name:WF_LOV, status:VALID,
-
PACKAGE: APPS.WF_FORMS
12.1.1
owner:APPS, object_type:PACKAGE, object_name:WF_FORMS, status:VALID,
-
PACKAGE BODY: APPS.WF_LOV
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WF_LOV, status:VALID,
-
PACKAGE BODY: APPS.WF_ITEM_DEFINITION_UTIL_PUB
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WF_ITEM_DEFINITION_UTIL_PUB, status:VALID,
-
PACKAGE BODY: APPS.WF_FORMS
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WF_FORMS, status:VALID,
-
PACKAGE BODY: APPS.FND_APPLET_LAUNCHER
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FND_APPLET_LAUNCHER, status:VALID,
-
PACKAGE BODY: APPS.OKE_PRINT_CONTRACT_WF
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OKE_PRINT_CONTRACT_WF, status:VALID,
-
PACKAGE: APPS.WF_MAIL_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:WF_MAIL_UTIL, status:VALID,
-
PACKAGE BODY: APPS.FND_DOCUMENT_MANAGEMENT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FND_DOCUMENT_MANAGEMENT, status:VALID,
-
PACKAGE: APPS.WF_MAIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:WF_MAIL, status:VALID,
-
PACKAGE BODY: APPS.FND_DOCUMENT_MANAGEMENT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FND_DOCUMENT_MANAGEMENT, status:VALID,
-
PACKAGE BODY: APPS.DOM_ATTACHMENT_UTIL_PKG
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:DOM_ATTACHMENT_UTIL_PKG, status:VALID,
-
PACKAGE BODY: APPS.WFE_HTML_UTIL
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WFE_HTML_UTIL, status:VALID,
-
PACKAGE BODY: APPS.WFE_HTML_UTIL
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WFE_HTML_UTIL, status:VALID,
-
PACKAGE BODY: APPS.FND_APPLET_LAUNCHER
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FND_APPLET_LAUNCHER, status:VALID,
-
PACKAGE: APPS.WF_LOV
12.1.1
owner:APPS, object_type:PACKAGE, object_name:WF_LOV, status:VALID,
-
PACKAGE BODY: APPS.WF_FORMS
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WF_FORMS, status:VALID,
-
PACKAGE BODY: APPS.BIS_PMV_PAGE_PARAMS_PUB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BIS_PMV_PAGE_PARAMS_PUB, status:VALID,
-
PACKAGE BODY: APPS.QA_SS_LOV
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QA_SS_LOV, status:VALID,
-
PACKAGE BODY: APPS.WFA_HTML_UTIL
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WFA_HTML_UTIL, status:VALID,
-
PACKAGE BODY: APPS.OKE_PRINT_CONTRACT_WF
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OKE_PRINT_CONTRACT_WF, status:VALID,
-
PACKAGE: APPS.FND_DOCUMENT_MANAGEMENT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_DOCUMENT_MANAGEMENT, status:VALID,
-
PACKAGE BODY: APPS.WF_ITEM_DEFINITION
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WF_ITEM_DEFINITION, status:VALID,
-
PACKAGE BODY: APPS.WF_INITIATE
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WF_INITIATE, status:VALID,
-
PACKAGE BODY: APPS.WF_FWKMON
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WF_FWKMON, status:VALID,
-
PACKAGE BODY: APPS.WF_ITEM_DEFINITION_UTIL_PUB
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WF_ITEM_DEFINITION_UTIL_PUB, status:VALID,
-
PACKAGE BODY: APPS.WF_LOV
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WF_LOV, status:VALID,
-
PACKAGE BODY: APPS.FND_SSO_MANAGER
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:FND_SSO_MANAGER, status:VALID,
-
PACKAGE BODY: APPS.WFA_HTML_UTIL
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WFA_HTML_UTIL, status:VALID,
-
PACKAGE BODY: APPS.QA_SS_LOV
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QA_SS_LOV, status:VALID,
-
PACKAGE BODY: APPS.WF_FWKMON
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WF_FWKMON, status:VALID,
-
PACKAGE BODY: APPS.FND_RUN_FUNCTION
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:FND_RUN_FUNCTION, status:VALID,
-
PACKAGE BODY: APPS.QA_SS_OM
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:QA_SS_OM, status:VALID,
-
PACKAGE BODY: APPS.QA_SS_OM
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:QA_SS_OM, status:VALID,
-
PACKAGE BODY: APPS.WF_PREF
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WF_PREF, status:VALID,
-
PACKAGE BODY: APPS.WF_ITEM_DEFINITION
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WF_ITEM_DEFINITION, status:VALID,
-
PACKAGE BODY: APPS.WF_INITIATE
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WF_INITIATE, status:VALID,
-
PACKAGE BODY: APPS.WF_PREF
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WF_PREF, status:VALID,
-
PACKAGE BODY: APPS.ECX_WORKFLOW_HTML
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:ECX_WORKFLOW_HTML, status:VALID,
-
PACKAGE: APPS.WF_MAIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:WF_MAIL, status:VALID,