Search Results raise_wf_event

Overview

ITG_OUTBOUND_UTILS is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is a utility layer that assembles the payload used to raise Oracle Workflow business events from outbound integration transactions. The package is closely tied to the ECX (E-Commerce Gateway / XML Gateway) and CLN (Custom Logistics / outbound) naming conventions visible in the source header and parameter constants. Its principal responsibility is to translate an outbound document context — transaction type, subtype, document identifier, organization, document and release numbers, and up to five caller-supplied parameters — into the standard Workflow parameter list (WF_PARAMETER_LIST_T) required by WF_EVENT.RAISE.

The header identifies the file as itgoutub.pls (CVS revision 1.29) and defaults the debug level to profile option CLN_DEBUG_LEVEL. A series of constants (c_off_ttype through c_off_param5) define positional offsets for the event parameter array, indicating the package historically worked with both a typed Workflow parameter list and an offset-indexed structure.

Key Procedures and Functions

• GET_PARAMETER_LIST — Builds and returns a WF_PARAMETER_LIST_T collection populated with standard event attributes such as ECX_TRANSACTION_TYPE, ECX_TRANSACTION_SUBTYPE, ECX_DOCUMENT_ID, CLN_ORGANIZATION_ID, CLN_DOC_TYPE, CLN_TYPE, CLN_DOC_NUM, CLN_REL_NUM, ECX_PARTY_ID, and ECX_PARTY_SITE_ID. This is the core function that assembles the event payload from the caller's arguments.
• CHANGE_PARAMETER_LIST — Modifies an existing parameter list, allowing callers to override or add individual parameter values after initial assembly without rebuilding the entire collection.
• RAISE_WF_EVENT_PARAMS — Raises a Workflow event using a supplied parameter list. This is the primary entry point associated with the search term raise_wf_event_params, and it encapsulates the call to WF_EVENT.RAISE together with the assembled parameters.
• RAISE_WF_EVENT — A convenience wrapper that raises a Workflow event directly from the primitive arguments, constructing the parameter list internally before dispatching to the event engine.

Tables Accessed

• WF_PARAMETER_LIST_T / WF_PARAMETER_T — Workflow object types used to construct and return event parameter collections.
• WF_EVENT_T — Workflow event object type passed to WF_EVENT.RAISE.
• WF_AGENT_T — Workflow agent object type, used to identify the event recipient or owner.
• ITG_OUTBOUND_SEQ — Sequence supplying unique identifiers for outbound transactions.
• DUAL — Used for element-level evaluations and sequence value retrieval.

No base application tables are updated by this package; its role is transactional assembly and event dispatch rather than persistent data manipulation.

Usage Notes

ITG_OUTBOUND_UTILS is invoked programmatically rather than through a form or concurrent program UI. It is referenced by eleven other packages, confirming its position as a shared integration utility. Typical invocation occurs from outbound processing logic that has already resolved an outbound document and now needs to notify subscribers via Oracle Workflow. A caller either passes primitive attributes to RAISE_WF_EVENT, or builds a list via GET_PARAMETER_LIST, optionally adjusts it with CHANGE_PARAMETER_LIST, and dispatches with RAISE_WF_EVENT_PARAMS. Because the package relies on ECX_* and CLN_* parameter names, subscribing workflows must be configured with matching event subscription parameters. Debug output is governed by the CLN_DEBUG_LEVEL profile option, with lower values producing more verbose logging through ITG_DEBUG_PUB.