Search Results iex_case_utl_pub




Overview
Explore in AI Chat

Overview

APPS.IEX_CASE_UTL_PUB is a public PL/SQL utility package within the Oracle E-Business Suite Collections (Advanced Collections / IEX) module. Its classification as a PUB (public) API indicates that the procedures it exposes are intended for invocation by external callers, including other application modules, forms, concurrent programs, and customer extensions, rather than being restricted for internal use. The package centralizes the core case-management logic required to create, populate, modify, reassign, and close collection cases. These cases represent formal workflows applied to delinquent or high-risk customer accounts, covering specialized tracks such as bankruptcies, litigations, repossessions, and write-offs. As a shared utility layer, IEX_CASE_UTL_PUB abstracts the underlying data manipulation away from calling code, ensuring consistent validation and record maintenance across the Collections schema.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions exposed by this package:

  • CHECKCASEDEF — Validates whether a case definition exists and is usable, providing a guard check before case processing proceeds.
  • GETCASEID — Retrieves the identifier of an existing case, allowing callers to resolve a case reference to its primary key.
  • POPULATECASEDEFTBL — Loads or caches case definition records into an internal structure, supporting downstream logic that depends on case configuration.
  • CLOSECASE — Terminates an active case, applying the closure semantics required for the Collections case lifecycle.
  • CREATECASEOBJECTS — Establishes the object-level associations that link a case to the specific entities (such as contracts or delinquent items) it governs.
  • UPDATECASE — Modifies the attributes of an existing case record.
  • CREATECASECONTACTS — Creates the contact associations attached to a case, identifying the parties involved in the collection effort.
  • CHECKCONTRACT — Validates contract data, ensuring that the contract referenced by case processing is valid and accessible.
  • REASSIGNCASEOBJECTS — Moves case objects from one case context to another, supporting reassignment and reallocation scenarios.

Tables Accessed

The package reads and writes the principal Collections case tables through APPS synonyms:

Usage Notes

IEX_CASE_UTL_PUB is typically invoked from Collections forms, concurrent programs, and workflow activities, and it is also callable from custom code as a documented public API. The ETRM dependency data shows it relies on the FND_API foundation package and the SYS.STANDARD package, placing it within the standard EBS API framework. It is referenced by at least one other package, OKL_CASE_UTIL_PVT, which indicates reuse across adjacent modules such as Oracle Lease Management. Because the procedures encapsulate validation, object association, contact creation, and lifecycle transitions, callers should generally prefer these utilities over direct DML against the underlying IEX case tables to preserve data integrity and trigger consistency.