Search Results update_wf_attributes

Overview

The APPS.IEX_STRY_UTL_PUB package is a public PL/SQL API within the Oracle E-Business Suite Collections (Advanced Collections / IEX) module. Its principal business function is to manage the lifecycle of collection strategies and their associated work items. A collection strategy in Advanced Collections represents an ordered set of actions (work items) that a collector follows to pursue payment on a delinquent customer account. The package provides programmatic control over retrieving the next set of work items for a strategy, closing strategies and their work items, reassigning strategies between collectors, and refreshing or clearing the underlying Unified Work Queue (UWQ) summary data that drives the collector's user interface. The package is declared AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the calling schema rather than the definer, and it is versioned in the file header as iexpsuts.pls.

Key Procedures and Functions

The package exposes fourteen documented, public procedures. Their responsibilities cluster around strategy and work item maintenance:

• GET_NEXT_WORK_ITEMS — Returns a collection of work items for a given strategy using the package's work_item_rec_type record and work_item_tab_type index-by table, honouring a default fetch size of 30 records.
• CLOSE_STRY_AND_WITEMS — Updates the status of all work items and the parent strategy based on the status value passed in.
• CLOSE_STRATEGY — Updates the strategy status alone according to the supplied status.
• UPDATE_WORK_ITEM and UPDATE_NEXT_WORK_ITEM — Modify work item records, including the work_item_id and sequencing of the next item to be actioned.
• CHECK_WORK_ITEM_STATUS — Validates the current status of a work item.
• GET_DATE — Returns a date value used in work item scheduling logic.
• CREATE_WORKITEM_CHECK and CREATE_WORKITEM_COMPLETE — Support the creation and completion handling of work items.
• CLEAR_UWQ_STR_SUMM and REFRESH_UWQ_STR_SUMM — Clear and rebuild the Unified Work Queue summary rows that feed the collector work queue UI.
• REASSIGN_STRATEGY — Moves a strategy from one resource (collector) to another.
• UPDATE_AND_SENDSIGNAL — Updates status and raises a workflow event signal to notify downstream processes.
• UPDATE_WF_ATTRIBUTES — Updates the workflow attributes associated with a strategy or work item, keeping the Oracle Workflow item attributes synchronised with Collections data.

Tables Accessed

The package operates against both Collections-owned and shared EBS tables through APPS synonyms:

• IEX_STRATEGIES — the master strategy records whose status is updated by the close procedures.
• IEX_STRATEGY_WORK_ITEMS and IEX_STRY_TEMP_WORK_ITEMS_B — the work item definitions and strategy-to-template associations.
• IEX_STRATEGY_USER_ITEMS and IEX_STRY_TEMP_WORK_ITEMS_B — user-specific work item and template cross-reference data.
• IEX_DLN_UWQ_SUMMARY — the summary table cleared and refreshed by the UWQ procedures.
• WF_EVENT_T — the Oracle Workflow event queue, populated when UPDATE_AND_SENDSIGNAL raises a signal.
• JTF_RS_RESOURCE_EXTNS — resource (collector) information used by REASSIGN_STRATEGY.
• MTL_UOM_CONVERSIONS — unit-of-measure conversion data, and DUAL for single-row lookups.

Usage Notes

IEX_STRY_UTL_PUB is invoked from Collections forms (such as the Strategy and Work Queue windows), from concurrent programs that refresh the UWQ summary, and from custom or integration code that drives strategy progression. The UPDATE_WF_ATTRIBUTES procedure is typically called whenever strategy or work item state changes, so that Oracle Workflow notifications and the Workflow attribute model remain consistent with the Collections tables. All update procedures follow the standard EBS API contract: an p_api_version input, p_commit and p_init_msg_list flags (defaulting to FND_API.G_FALSE or G_TRUE), and x_return_status, x_msg_count and x_msg_data outputs, so callers should always inspect x_return_status and use FND_MSG_PUB to retrieve messages. Seven other packages reference this API, confirming it as a shared utility layer within Advanced Collections.