Search Results get_total_rcvble_for_case

Overview

IEX_CASE_INFO_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Advanced Collections (IEX) application and serves as a programmatic interface for retrieving aggregated financial and contractual information associated with a collections case. The package exposes a set of read-only accessors that allow callers — typically forms, concurrent programs, or custom extensions — to obtain monetary totals relevant to a delinquent customer case without directly querying the underlying transaction tables.

The package is classified as a PUB (public) API, indicating that Oracle supports its invocation as a documented interface point. It reports a status of VALID in the ETRM metadata. Internally it depends on the SYS schema and the STANDARD package, and it is referenced by the IEX_PROFILE_CASE_DEL_V view as well as by one additional package within the APPS schema.

Key Procedures and Functions

The package documents nine callable program units, all of which appear to be getter-style functions that return calculated values for a given collections case:

• GET_AMOUNT_OVERDUE — Returns the overdue monetary amount associated with the case.
• GET_TOTAL_RCVBLE_FOR_CASE — Returns the total receivable balance for the case. A companion function, GET_TOTAL_RCVBLE_FOR_CASE_FN, exposes the same calculation through a function-based invocation, supporting use in SQL contexts such as view definitions.
• GET_TOTAL_NET_BOOK_VALUE — Returns the aggregate net book value of the assets or contracts tied to the case.
• GET_CONTRACT_OEC — Returns the original equipment cost component for the associated contract.
• GET_CONTRACT_TRADEIN — Returns the trade-in value component of the contract.
• GET_CONTRACT_CAPITAL_REDUCTION — Returns the capital reduction amount recorded against the contract.
• GET_CONTRACT_FEES_CAPITALIZED — Returns the capitalized fees attributed to the contract.
• GET_TOTAL_CAPITAL_AMOUNT — Returns the total capital amount for the case.

Parameter lists are not revealed in the available metadata; callers should consult the package specification in the database for exact signatures. Functionally, the package centres on lease and contract financial summarisation for collections processing.

Tables Accessed

The documented table references resolve through APPS synonyms:

• IEX_CASE_OBJECTS — The central link table that maps objects (such as contracts, invoices, or lease agreements) to a collections case. The package uses it to identify which objects belong to the case being queried.
• OKL_K_LINES — The Oracle Lease Management contract line table. The package reads this to derive contract-level values such as OEC, trade-in, capital reduction, capitalized fees, and net book value.

Consistent with its read-only accessor role, the package is designed to query rather than modify these tables.

Usage Notes

IEX_CASE_INFO_PUB is typically invoked from Advanced Collections case management forms and from concurrent or custom programs that need case-level financial roll-ups without re-implementing complex lease calculations. Because a companion view (IEX_PROFILE_CASE_DEL_V) references the package, some of its functions are callable directly from SQL against that view, which is why function variants such as GET_TOTAL_RCVBLE_FOR_CASE_FN exist.

Custom code should call the public functions rather than querying IEX_CASE_OBJECTS and OKL_K_LINES directly, since the package encapsulates the aggregation logic and remains the supported interface. As with all PUB APIs in EBS 12.1.1 and 12.2.2, the specification should be reviewed in the target instance before use, as signatures may vary between patch levels.