Search Results iex_strategy_work_items_pvt




Overview
Explore in AI Chat

Overview

IEX_STRATEGY_WORK_ITEMS_PVT is a private PL/SQL package in the APPS schema that supports the Collections Strategy Management functionality within Oracle E-Business Suite Advanced Collections (part of the ETRM/Receivables family of modules). Its role is to encapsulate the low-level data manipulation of strategy work items — the discrete activities or tasks that make up a collections strategy executed against a delinquent customer account.

The package is classified as a PVT (private) API, meaning it is not intended to be called directly by external consumers. Instead, it is consumed internally by public APIs such as IEX_STRY_API_PUB, IEX_STRY_CHECKLIST_PUB, IEX_STRY_UTL_PUB, IEX_API_RECORDS_PVT, IEX_STRY_UWQ_PVT, and IEX_STRATEGY_WF. It provides a controlled, DML-centralized layer for creating, maintaining, and removing strategy work item records, ensuring consistency across the various public interfaces that manipulate strategies and their associated tasks. The package is documented as VALID in the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes three documented procedures, all following the standard Oracle Applications API naming convention:

  • CREATE_STRATEGY_WORK_ITEMS — Inserts new work item records into the strategy work items tables. It is used when a strategy is authored or instantiated and its constituent tasks must be persisted.
  • UPDATE_STRATEGY_WORK_ITEMS — Modifies existing work item attributes, such as task status, assignee, due date, or sequencing, as a strategy progresses through its lifecycle.
  • DELETE_STRATEGY_WORK_ITEMS — Removes work item records, typically when a strategy is revised, cancelled, or retired.

No parameter signatures are documented in the ETRM metadata; the procedures conform to the FND_API error-handling and validation conventions (FND_API is listed as a referenced dependency).

Tables Accessed

Access is performed through APPS synonyms over the following base tables:

  • IEX_STRATEGY_WORK_ITEMS — The primary transactional table storing the actual work item rows. It is the target of the CREATE, UPDATE, and DELETE operations.
  • IEX_STRATEGY_WORK_ITEMS_S — The corresponding sequence/intersection table used to generate or maintain unique identifiers for work item records.
  • DUAL — Used for scalar queries, sequence value retrieval, and similar PL/SQL constructs.

The package does not appear to read strategy definition tables directly; those responsibilities are handled by the calling public packages, while this PVT package focuses on work item persistence.

Usage Notes

Because IEX_STRATEGY_WORK_ITEMS_PVT is a private package, it should not be invoked directly from custom code. Instead, integrations and extensions should call the public wrappers such as IEX_STRY_API_PUB or IEX_STRY_CHECKLIST_PUB, which in turn delegate DML to this package. Typical execution contexts include the Advanced Collections strategy authoring UI (Oracle Forms), the Strategy Workflow (IEX_STRATEGY_WF), the Universal Work Queue (IEX_STRY_UWQ_PVT), and batch/concurrent processing of collections strategies. Referencing the private package directly risks bypassing validation and error-handling logic enforced at the public API layer. The dependency on FND_API confirms adherence to the standard EBS API error stack (FND_MSG_PUB) and savepoint-based rollback conventions.