Search Results get_case_resources

Overview

APPS.IEX_UTILITIES is a foundational PL/SQL utility package body within the Oracle E-Business Suite Advanced Collections (IEX) module, documented in ETRM as an OTHER-classified API and carrying a VALID status at the 12.1.1 and 12.2.2 releases. Unlike the public Collection Agent and Dunning APIs, IEX_UTILITIES functions as an internal service layer: it centralizes low-level validation, caching, profile resolution, resource assignment, and dunning evaluation logic that the remainder of the Advanced Collections code base depends upon. The ETRM dependency data confirms this role — the package is not referenced by any database object itself, yet it references a broad set of application and public objects, and it is invoked by 57 other packages. This asymmetry (many inbound callers, no outbound dependents) is characteristic of a shared utility library.

Key Procedures and Functions

ETRM documents 36 procedures and functions. The most prominent fall into distinct functional groups.

• Validation helpers: VALIDATE_ANY_ID, VALIDATE_ANY_VARCHAR, and VALIDATE_LOOKUP_CODE provide type-safe verification of identifiers, free-text values, and lookup codes respectively, returning results consistent with the FND_API error-handling conventions the package imports.
• Resource resolution: GET_ACCESS_RESOURCES, GET_ASSIGN_RESOURCES, GET_ASSIGN_ACCOUNT_RESOURCES, GET_CASE_RESOURCES, GET_ASSIGNED_COLLECTOR, and GET_DUNNING_RESOURCE resolve collector, resource, and account assignments used by collection work queues.
• Profile and configuration lookups: GET_GRACE_DAYS, GET_LOOKUP_MEANING, DUNNINGPROFILECHECK, and DUNNINGMINAMOUNTCHECK retrieve profile-option values and enforce dunning eligibility thresholds. STAGEDDUNNINGMINAMOUNTCHECK performs the equivalent test for staged dunning scenarios.
• Caching and parameter services: GET_CACHE_VALUE, PUT_PARAM_VALUE, GET_PARAM_VALUE, and DELETE_PARAM_VALUE implement a lightweight in-session parameter cache used to avoid repeated profile or setup queries.
• Delinquency evaluation: MAXSTAGEFORANDELINQUENCY derives the maximum allowable dunning stage for a delinquency record.

Tables Accessed

The package reads and writes a cross-module set of tables via APPS synonyms. Receivables tables AR_PAYMENT_SCHEDULES, AR_PAYMENT_SCHEDULES_ALL, and AR_SYSTEM_PARAMETERS_ALL supply transaction balances and system-level settings used in dunning and amount checks. Trading Community tables HZ_CUSTOMER_PROFILES, HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES, HZ_CUST_PROFILE_AMTS, HZ_CUST_SITE_USES, HZ_CUST_SITE_USES_ALL, and HZ_PARTY_PREFERENCES provide customer, site, and profile context for resource resolution. Collections-specific tables IEX_DELINQUENCIES_ALL, IEX_DUNNINGS, IEX_AG_DN_XREF, and IEX_APP_PREFERENCES_B hold delinquency, dunning, agent-to-dunning mapping, and application preference data. RA_CUSTOMER_TRX_LINES_ALL and AR_SYSTEM_PARAMETERS, GL_SETS_OF_BOOKS, and GL_CURRENCY_API support transaction and currency/ledger lookups, while DBMS_SQL, DBMS_UTILITY, and PLITBLM are used for dynamic SQL and bulk operations. FND_API, FND_GLOBAL, FND_LOG, FND_MSG_PUB, and FND_PROFILE supply the standard Oracle Application Framework error, logging, and profile services.

Usage Notes

IEX_UTILITIES is not a standalone delivered API and includes no concurrent-program entry point; it is instead invoked internally by the 57 dependent Advanced Collections packages. Typical callers include the Collections work-queue and dunning engine packages, which use GET_ASSIGNED_COLLECTOR, GET_DUNNING_RESOURCE, and the dunning check functions during batch scoring and strategy execution. Custom extensions that introduce new collection strategies or dunning profiles often call the validation and parameter-cache routines to remain consistent with seeded behavior. Because the package body is owned by APPS and depends heavily on private FND logging and caching state, custom code should call its documented procedures only as delivered, avoiding direct reference to undocumented internals that may change between the 12.1.1 and 12.2.2 releases.