Search Results update_pref

Overview

WF_PREF is a Workflow-supplied PL/SQL package body owned by the APPS schema that implements the Oracle E-Business Suite "Workflow Preferences" self-service page. It manages user-level workflow configuration — e-mail notification preferences, LDAP password settings, language and territory selections, and directory manager (DM) node selection — and renders the associated HTML/JavaScript for the Oracle Application Framework page. In ETRM 12.1.1 and 12.2.2 the package is classified as OTHER, meaning it is not a public API but is documented because the page's helper routines (notably the LOV window JavaScript generators) are referenced by other forms and pages. The package depends on HTP for web output and WF_CORE for error context and translation, and it is referenced by 14 other packages, reflecting its role as a shared preference-handling utility across the Workflow product family.

Key Procedures and Functions

The package exposes twelve documented procedures and functions:

• EDIT / EDIT_FORM — Entry points that render the Workflow Preferences page and its form, wiring the HTML regions and the form's submit behaviour.
• GET_OPEN_LOV_WINDOW_HTML — Emits the JavaScript function (fnd_open_dm_window) that opens a List of Values window and writes the selected value back into the page's hidden DM home field, followed by a NOSCRIPT fallback translated through WF_CORE.
• LANG_LOV, TERR_LOV, DM_LOV — List-of-Values handlers for language, territory (NLS) and directory manager node selection respectively.
• UPDATE_PREF, UPDATE_PREF_FWK, UPDATE_PREF_FWK2 — Persist preference changes; the two FKx variants are Oracle Application Framework (OA Framework) adaptations used by later EBS releases.
• CREATE_REG_BUTTON — Generates the registration/submit button, and the associated validate_password helper enforces the minimum LDAP password length and the new/confirm password match (Bug# 2127392).
• GET_PREF, GET_PREF2 — Retrieval functions that read stored preference values for a given user profile option.

Tables Accessed

The package operates against the following objects via APPS synonyms:

• FND_USER_PREFERENCES — Stores and retrieves per-user profile option values, the primary persistence target for GET_PREF and UPDATE_PREF.
• FND_DM_NODES — Supplies the directory manager node values presented by DM_LOV.
• WF_RESOURCES — Provides translated message strings used in alerts, labels and NOSCRIPT text.
• DUAL — Used for scalar lookups and simple selection queries.
• HTP — The Oracle PL/SQL Web Toolkit package used to write HTML and JavaScript into the page response.

Usage Notes

WF_PREF is invoked indirectly through the Workflow Preferences self-service page and the FKx-based OA Framework equivalents; it is not normally called directly from custom code. When a user opens the preferences page, EDIT and EDIT_FORM render the regions, GET_PREF supplies current values, the LOV procedures and GET_OPEN_LOV_WINDOW_HTML generate the JavaScript that drives language, territory and DM selection, and the UPDATE_PREF variants commit changes to FND_USER_PREFERENCES. Customisations should prefer the documented OA Framework-based UPDATE_PREF_FWK variants where available, and any direct call should replicate the package's exception handling pattern of setting WF_CORE context before re-raising. Because the package is referenced by 14 other packages, modifications carry broad impact and should be regression-tested against Workflow notification and directory integration flows.