Search Results set_notification_resources

Overview

APPS.IEX_STRY_CUWF_PUB is a public PL/SQL package body in the Oracle EBS Advanced Collections (IEX) module. Its name reflects its role as a "Custom Workflow" (CUWF) publication layer for strategy processing. The package encapsulates the server-side logic that allows Oracle Advanced Collections strategies to participate in Oracle Workflow–driven processes. It bridges the Collections strategy engine with the Workflow engine by starting custom workflows, sending Workflow signals, and managing the state of strategy work items. The package is classified as PUB, confirming it is a published API and therefore safe for external invocation by other EBS modules or custom code. The header comment places the source file (iexpscwb.pls) and its last ship date in the 12.1.1 timeframe, and the package remains documented under 12.2.2.

Key Procedures and Functions

The documented interface exposes four procedures:

• START_CUSTOMWF — Initiates a custom workflow associated with a Collections strategy. This is the entry point used when a delinquency or strategy rule requires an external workflow to be launched for a customer or payment schedule.
• WF_SEND_SIGNAL — Publishes a Workflow signal (event) to a running or waiting workflow process. This supports the event-driven handoff between the strategy engine and the workflow engine.
• START_PROCESS — Starts a Workflow process in the context of strategy execution, allowing the strategy to invoke standard or custom workflow definitions.
• WAIT_ON_HOLD_SIGNAL — Places a strategy work item into a wait state that is resumed only when a designated hold signal is received. This provides the mechanism for pausing Collections processing until a business condition is satisfied.

No parameter lists are documented, and none should be assumed. The package body also contains private helper procedures (AddInvalidArgMsg, AddMissingArgMsg, AddNullArgMsg) used to standardize error messages via FND_MESSAGE and FND_MSG_PUB, but these are not part of the public API.

Tables Accessed

The package references several Advanced Collections and Receivables tables through APPS synonyms:

• AR_PAYMENT_SCHEDULES — the payment schedule (transaction) records against which delinquency and collection activities are evaluated.
• HZ_PARTIES — the customer or party identity associated with a strategy run.
• IEX_DELINQUENCIES / IEX_DELINQUENCIES_ALL — the delinquency records that trigger or drive strategy execution.
• IEX_STRATEGIES — the strategy definitions governing the workflow rules.
• IEX_STRATEGY_WORK_ITEMS — the individual work items generated by a strategy, including those placed on hold or awaiting signals.
• JTF_RS_RESOURCE_EXTNS — the resource (collector/agent) extension information, used for routing or assignment of work items.

These tables give the package context for deciding when a custom workflow should start, which party is involved, and which work item state must be updated.

Usage Notes

IEX_STRY_CUWF_PUB is normally invoked indirectly from Advanced Collections strategy processing rather than from a form directly. It is called by the Collections engine and by other published packages (one package is documented as referencing it). Typical invocation scenarios include launching a custom workflow from a strategy rule, sending a signal to release a waiting workflow, or pausing a work item until a hold signal arrives. Because it is a PUB API, customers may call it from custom concurrent programs, Oracle Workflow function activities, or custom Collections extensions, provided the calling context supplies valid strategy and work-item identifiers. When the search term set_notification_resources is used, it is important to note that this package does not contain a documented procedure by that name; resource-notification handling in Advanced Collections is generally associated with resource extension data (JTF_RS_RESOURCE_EXTNS) rather than with the four documented procedures in IEX_STRY_CUWF_PUB.