Search Results iex_stry_checklist_pub




Overview
Explore in AI Chat

Overview

APPS.IEX_STRY_CHECKLIST_PUB is a public API package body belonging to the E-Business Tax (EBTax) / ETRM collections strategy subsystem in Oracle EBS Release 12.1.1 and 12.2.2. Its name reflects two distinct components: "STRY" denotes the collections strategy framework, and "CHECKLIST" denotes the actionable checklist items that drive a collection agent's daily workload. The package therefore exists to translate strategy definition data into concrete, agent-facing checklist work items.

The public (PUB) classification indicates that the procedures in this package form a supported, callable interface intended for use by other application modules and, in limited circumstances, by customer extensions. Internally, the package depends on the private implementation packages IEX_STRATEGY_PVT and IEX_STRATEGY_WORK_ITEMS_PVT, and leverages the standard Oracle EBS technology stack: FND_API for the PL/SQL API error-handling and savepoint model, FND_MSG_PUB for message stack management, FND_PROFILE for profile option retrieval, FND_LOG and IEX_DEBUG_PUB for diagnostic logging, AS_UTILITY_PVT for common utilities, and MO_GLOBAL for multi-org (operating unit) context handling.

Key Procedures and Functions

The ETRM documentation records a single public entry point:

  • CREATE_CHECKLIST_STRATEGY — Creates a strategy-driven checklist, generating the checklist records and associated work items derived from the source strategy definition. It is the sole documented procedure/function in this package body, indicating a tightly focused responsibility: taking a strategy specification and materializing it as executable checklist work for collection agents.

No additional public procedures or functions are documented for this object. Because the ETRM parameter lists are not exposed in the available metadata, exact signatures are intentionally omitted; callers should verify argument order against the installed package specification in the target environment before invoking it directly.

Tables Accessed

The documented table dependency for this package is:

  • IEX_STRATEGY_WORK_TEMP_XREF — accessed via the APPS synonym. This cross-reference/temporary table supports the mapping between strategy definitions and generated checklist work items, effectively serving as the staging or linkage structure during checklist strategy generation. The CREATE_CHECKLIST_STRATEGY procedure writes to and/or reads from this object as part of assembling the strategy-to-work-item relationship.

Additional collection-strategy tables are accessed indirectly through the private packages IEX_STRATEGY_PVT and IEX_STRATEGY_WORK_ITEMS_PVT, which encapsulate the underlying DML against the core strategy and work-item base tables. This layered design keeps the public API insulated from the physical data model.

Usage Notes

IEX_STRY_CHECKLIST_PUB is not referenced by any other database object, confirming that it is invoked externally rather than called from within the EBS data model itself. Typical invocation paths include:

  • Advanced Collections and E-Business Tax strategy configuration flows, where a checklist strategy is generated when a strategy is applied to a collector's workload.
  • Concurrent programs that periodically materialize strategy checklists for a population of customers or transactions, subject to multi-org context established through MO_GLOBAL.
  • Custom extensions that require programmatic creation of checklist strategies, calling CREATE_CHECKLIST_STRATEGY with standard FND_API conventions (initializing the message stack, checking the return status, and issuing ROLLBACK on error).

Because the procedure participates in the FND_API transaction model, custom callers should not issue their own COMMIT inside the API call and should handle FND_MSG_PUB messages for error reporting. In both 12.1.1 and 12.2.2 the object is reported VALID in the APPS schema, and its dependency set is stable across those releases.