Search Results fnd_db_wallet_dir

Overview

APPS.IRC_XML_UTIL is a utility package body within the Oracle E-Business Suite iRecruitment schema (IRC) that provides reusable XML handling capabilities to other components of the application. Its principal business function is to bridge Oracle Workflow event data with XML-based parsing and extraction routines, enabling iRecruitment and related modules to read values out of structured XML documents carried by workflow events. In practice the package supports integration flows where recruitment transactions — such as applicant status changes, requisition approvals, or third-party job board exchanges — pass structured payloads between the EBS database tier and external systems.

In Oracle EBS 12.1.1 and 12.2.2 the object resides in the APPS schema and is classified as a UTIL-type API under the ETRM repository. The header comment embedded in the source ($Header: irxmlutl.pkb 120.2 2006/03/11) confirms the package has been part of the codebase since the early 11i/12.x lineage and has not required functional revision since that release. It operates entirely on the server side and does not expose a concurrent program or form of its own.

Key Procedures and Functions

The ETRM documentation lists four documented entry points for this package body, alongside two additional internal members. The principal procedures are:

• GETWFXMLELEMENT — A workflow-callable procedure invoked in RUN function mode. It reads the TAG, ATTR, and EVENT activity attributes for the current workflow activity, retrieves the associated event payload as a CLOB, and delegates the actual extraction to VALUEOF. It then writes the extracted value back to the workflow item attribute named by ATTR using WF_ENGINE.SETITEMATTRTEXT, and returns 'COMPLETE' to signal normal completion to the Workflow engine. An exception handler frees the XML parser and DOM document resources on failure.
• VALUEOF — The helper that parses the XML document (CLOB) against an XPath-style tag and returns the corresponding string value. This is the routine that does the actual payload dissection; GETWFXMLELEMENT calls it directly.
• HTTP_GET — A convenience wrapper that performs an outbound HTTP request and returns the response, used when iRecruitment must fetch an XML document from a remote endpoint.
• HTTP_GET_PIECES — A variant of HTTP_GET intended for responses returned in multiple chunks, reassembling the pieces before returning the combined result.

Two further members are not surfaced as separate ETRM entries but appear in the header: the package-level globals g_proxy, g_wallet_path, and g_wallet_password, which hold HTTP proxy and Oracle Wallet credentials used by the HTTP routines.

Tables Accessed

The package does not read or write conventional application tables. Its documented dependencies are via APPS synonyms to the following database objects:

• UTL_HTTP — used by HTTP_GET and HTTP_GET_PIECES to perform outbound HTTP calls to XML endpoints.
• XMLPARSER — the Oracle XML parser package, used to instantiate a parser and free it after processing.
• XMLDOM — the DOM API used to build and free the in-memory XML document from the workflow event CLOB.
• WF_EVENT_T — the Workflow event object type, referenced to hold the current event and its event data.
• XSLPROCESSOR — referenced for XSL transformation support in XML processing paths.

In addition, the package calls WF_ENGINE procedures (GETACTIVITYATTRTEXT, GETACTIVITYATTREVENT, SETITEMATTRTEXT) to read and write item attributes; these are not counted among the table references because they are PL/SQL API calls, not direct DML.

Usage Notes

IRC_XML_UTIL is invoked predominantly from Workflow procedure activities inside iRecruitment process definitions (for example, when an event delivers an XML document and a downstream activity needs to extract a named element and store it as an item attribute). Developers configuring such activities reference GETWFXMLELEMENT directly, populating the TAG, ATTR, and EVENT activity attributes accordingly. The ETRM records show seven other packages depend on this utility, indicating it is a shared foundation for iRecruitment XML integration rather than an end-user feature.

Because the package uses UTL_HTTP and the Oracle Wallet, deployments must ensure the FND_DB_WALLET_DIR context is valid and that the wallet path and password globals are initialised before HTTP_GET or HTTP_GET_PIECES are exercised. Custom code should not override the package globals directly; instead, configuration is implied by the wallet setup associated with the EBS instance. When called from outside the Workflow engine, VALUEOF is the safest entry point because it performs pure parsing without side effects on item attributes.