Search Results g_resource_id

Overview

The APPS.IEX_UWQ_VIEW_PKG package body is a component of the Advanced Collections (IEX) module in Oracle E-Business Suite, providing the core query and aggregation logic used to populate the Unified Work Queue (UWQ) and related collections dashboards. The package exposes a set of standalone functions that return counts, monetary sums, scores, and identifiers for a given customer, party, site, or collector context. These functions are consumed by the Collections Agent and Collections Manager user interfaces to compute the summary metrics displayed in delinquency and bankruptcy work queues. The $Header annotation (iextuvwb.pls 120.5.12010000.6, dated 2010/02/16) indicates the package was maintained through the 12.1.x release stream and carried forward into 12.2.x with the file version stamp intact.

Key Procedures and Functions

• GET_DEL_COUNT — Returns the number of delinquency records for a party, customer account, or site, honoring the IEX_BANKRUPTCY_FILTER and IEX_UWQ_COMPLETION_DAYS profile options. The source excerpt shows dynamic SQL that filters out statuses CURRENT and CLOSE, reflecting a fix for Bug#4408860.
• GET_PRO_COUNT — Returns the count of open promise-to-pay records associated with the supplied collection context.
• GET_STR_COUNT — Returns a strategy or status-related count used in UWQ metric columns.
• CONVERT_AMOUNT — Converts a monetary value between currencies, typically using the AR system currency conversion setup.
• GET_LAST_PAYMENT_AMOUNT — Returns the amount of the most recent payment recorded against the customer.
• GET_LAST_PAYMENT_NUMBER — Returns the identifying number of the most recent payment (e.g., receipt number).
• GET_SCORE — Returns the latest scoring value for the customer from the score history repository.
• GET_BROKEN_PRM_AMT — Returns the aggregate amount of promises that were broken or not honored.
• GET_PRM_AMT — Returns the total amount of active promise-to-pay records.
• GET_CASE_COUNT — Returns the number of collection cases associated with the customer context.
• GET_CONTRACT_COUNT — Returns the count of contracts tied to the customer, sourced from the OKC contract headers.

Tables Accessed

The package reads from several base and interface tables via APPS synonyms. IEX_DELINQUENCIES_ALL and IEX_PROMISE_DETAILS supply delinquency and promise-to-pay data central to collections aging. IEX_SCORE_HISTORIES provides prior scoring results for GET_SCORE. Customer identity and account context are resolved through HZ_CUST_ACCOUNTS and FND_USER. Resource-to-user mapping for collectors is obtained from JTF_RS_RESOURCE_EXTNS, which is queried by the package cursor c_get_resource_id using the global variable g_resource_id. Currency and system configuration parameters are read from AR_SYSTEM_PARAMETERS, and contract data is drawn from OKC_K_HEADERS_B.

Usage Notes

These functions are typically invoked from the Advanced Collections HTML and Forms-based work queue pages, where each metric column triggers a call to the corresponding function. They are also referenced by one other package within the IEX schema, indicating use as a shared utility layer. The package relies on session globals (g_user_id, g_person_id, g_resource_id) set by the caller context, so it must be initialized within an active collections session. The g_resource_id global and c_get_resource_id cursor are the points of interest when tracing the resource identifier passed into these queries, resolving a JTF resource from the current employee and user combination. Profile options IEX_BANKRUPTCY_FILTER and IEX_UWQ_COMPLETION_DAYS govern filtering behavior and should be reviewed when metric results appear inconsistent.