Results for “eng_workflow_ntf_util”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.ENG_WORKFLOW_NTF_UTIL package is a utility package within the Oracle E-Business Suite Engineering (ENG) module. It provides a centralized set of helper routines used to construct and deliver Oracle Workflow notifications related to Engineering Change Orders (ECOs) and Engineering Change management. Its principal responsibility is to assemble dynamic message content — plain text and HTML bodies, action URLs, and recipient lists — that the Workflow notification engine then renders and routes to the appropriate approvers, reviewers, and change participants. In Oracle EBS 12.1.1 and 12.2.2 the package is registered in the APPS schema with status VALID, and is operationally classified as a utility (UTIL) API rather than a user-facing business API.

Key Procedures and Functions

The ETRM metadata documents six callable units, all treated as accessors or content builders:

• GETMESSAGETEXTBODY — returns the plain-text rendition of the notification body, used by the Workflow Mailer for text-only delivery channels.
• GETMESSAGEHTMLBODY — returns the HTML rendition of the notification body, producing the formatted notification shown when the recipient opens the worklist message in a browser or HTML-capable client.
• GETRUNFUNCURL — builds the base runnable function URL that launches the relevant Engineering Change Order form or page directly from the notification.
• GETCHANGERUNFUNCURL — builds a runnable URL scoped to a specific engineering change, enabling the recipient to open the change record in context.
• GETCHANGESUMMARYRUNFUNCURL — builds a runnable URL that opens the change summary view, typically used for consolidated or digest-style notifications.
• GETNTFRECIPIENT — resolves and returns the notification recipient(s), encapsulating the logic that determines which user or role should receive a given ECO notification.

Tables Accessed

The package reads from several Engineering and Workflow tables through APPS synonyms to assemble notification payloads and to resolve routing:

• ENG_ENGINEERING_CHANGES — the master engineering change header, supplying change number, description, and status used in the message body and runnable URLs.
• ENG_CHANGE_ORDER_TYPES — defines the type of change order and its associated behavior, used to determine message content and action links.
• ENG_CHANGE_TYPE_APPLICATIONS — maps change types to the applications or contexts in which they apply, supporting correct URL and recipient resolution.
• WF_MESSAGE_ATTRIBUTES — stores the attribute values attached to a workflow notification, read to obtain the data placeholders rendered into the message body.
• WF_NOTIFICATIONS — the Workflow notification instance, used to identify the notification being processed and its associated recipients.

Usage Notes

ENG_WORKFLOW_NTF_UTIL is invoked primarily by Oracle Workflow notification activities defined for the Engineering Change Order workflow, rather than directly from Forms. When the ECO workflow raises a notification, these utility routines are called to populate the message text, HTML body, action URLs, and recipient list before the Workflow engine sends the notification. The metadata indicates the package references only SYS.STANDARD and is in turn referenced by ENG_WORKFLOW_UTIL, which serves as the higher-level orchestration package for the Engineering workflow. Customizations that extend ECO notification content or routing should prefer delegating to these utilities to remain consistent with standard behavior. Because it is a utility package, Oracle does not document it as a public API; direct calls from custom code are technically possible but not supported for upgrade compatibility.