Search Results g_itemtype

Overview

APPS.IBE_OM_INTEGRATION_GRP is a group-type PL/SQL package body in the Oracle iStore (IBE) module that provides integration logic between iStore's order capture flows and Oracle Order Management (OM). Its primary business function is to raise and manage Oracle Workflow business events and notifications associated with the approval or rejection of Return Merchandise Authorization (RMA) requests originating from iStore. The package acts as a bridge between the transactional order data held in Order Management and the Workflow notification infrastructure, ensuring that return order approvals and rejections are communicated to the appropriate users and subscribers.

The package declares two global constants that are central to its operation: G_PKG_NAME set to 'IBE_OM_INTEGRATION_GRP', and g_ItemType set to 'IBEALERT', which identifies the Workflow item type used for iStore alert notifications. A third global, g_processName, is set to 'PROCESSMAP', indicating the associated Workflow process. The package body header carries a version of 120.1, ships with EBS 12.1.1 and 12.2.2, and is owned by APPS.

Key Procedures and Functions

NOTIFY_RMA_REQUEST_ACTION — This is the single documented procedure in the package body. Its purpose is to notify the concerned party or workflow participant about the outcome of an RMA request action, such as an approval or rejection. The procedure accepts an API version number, an initialization message list, the order header identifier, a notification context string, free-text comments, and a reject reason code as inputs. It returns a standard EBS API-style output triplet: return status, message count, and message data.

Internally, the procedure resolves the order number and organization identifier from the order header, derives the party (customer) identifier by joining the order header's created_by column to FND_USER, and looks up the descriptive meaning of the reject reason code from the OE_RMA_REJECTION_REASON lookup. It constructs the Workflow item key, sets the event type to RETURNORDERAPPROVED, validates the notification is enabled, and raises the appropriate Workflow event or notification using the IBEALERT item type. An owner is defaulted to SYSADMIN when a specific user is not resolvable.

Tables Accessed

The package reads from the following tables, accessed through APPS synonyms:

• OE_ORDER_HEADERS_ALL — Source of the order number, organization identifier, and the created_by user used to determine the requesting party for a given order header.
• FND_USER — Used to resolve the party/customer identifier from the order creator's user ID.
• WF_ITEMS — Referenced for Workflow item key datatypes supporting the notification event lifecycle.
• WF_MESSAGES — Referenced for the message name used when sending the Workflow notification.

Additional lookups against WF_LOOKUPS, WF_USERS, and WF_LOOKUPS are performed within cursors and local variable assignments, though these are not listed among the primary documented table references.

Usage Notes

Because this package is classified as a GRP (group) package and is referenced by zero other packages, it functions as a self-contained integration utility rather than a reusable library. It is typically invoked from iStore return/order management flows—such as order capture forms, return-related concurrent processes, or Workflow notification activities—whenever an RMA request transitions to an approved or rejected state and a notification must be dispatched. Developers extending iStore's RMA notification behavior should call NOTIFY_RMA_REQUEST_ACTION directly, supplying the order header ID, notification context, comments, and reject reason code, and must handle the returned status, message count, and message data per standard EBS API conventions. The g_ItemType value of 'IBEALERT' should be referenced when subscribing to or configuring the resulting Workflow events in the Business Event System.