Search Results oks_misc_util_web




Overview
Explore in AI Chat

Overview

OKS_MISC_UTIL_WEB is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the Service Contracts (OKS) module. It provides a collection of utility functions used primarily by the Oracle Service Contracts web-based user interface (the "Web" suffix in its name) to support billing, coverage, and contract-line related computations. The package consolidates helper logic that would otherwise be duplicated across the service contracts HTML/Java-based flows, such as retrieving names and descriptions, calculating billed, unbilled, discount, surcharge, and terminated amounts, and resolving duration and coverage-level attributes.

In ETRM terms, the package is classified as OTHER and is not an exposed public API. It is a reusable internal utility referenced by three other packages and calls back into itself, indicating recursive or modular helper usage. It is marked VALID in the data dictionary. Its documented procedures and functions span 17 units, all oriented toward supporting the presentation layer of Service Contracts rather than transactional processing.

Key Procedures and Functions

The seventeen documented units fall into several functional groups:

Parameter lists are not modeled in the ETRM metadata; each unit is documented by name and purpose only. Callers should consult the package specification in the APPS schema for exact signatures.

Tables Accessed

The package reads and writes a broad set of Service Contracts, Order Management, Installed Base, and Receivables tables via APPS synonyms. Contract structure tables (OKC_K_ITEMS, OKC_K_LINES_B, OKC_K_REL_OBJS, OKS_K_HEADERS_B, OKS_K_LINES_B) supply header, line, and relationship data. Billing logic relies on OKS_BILL_CONT_LINES, OKS_BILL_SUB_LINES, OKS_BILL_TRANSACTIONS, and OKS_BILL_TXN_LINES. Installed Base data comes from CSI_ITEM_INSTANCES and CSI_SYSTEMS_TL. Order information is drawn from OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL. Customer and party data is obtained from HZ_CUST_ACCOUNTS, HZ_PARTIES, and HZ_PARTY_SITES. Item and unit-of-measure descriptions come from MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_KFV, and MTL_UNITS_OF_MEASURE_TL. Receivables data is read from RA_CUSTOMER_TRX_ALL and RA_CUSTOMER_TRX_LINES_ALL to support billing amount calculations.

Usage Notes

OKS_MISC_UTIL_WEB is invoked predominantly by Service Contracts web UI components (JSP/HTML and Oracle Forms within the OKS module) and by other OKS packages that need consolidated billing, duration, or naming logic. As an internal utility rather than a public API, it should not be called directly by customizations. Because it depends on FND_PROFILE, FND_MSG_PUB, FND_LOG, FND_FLEX_SERVER, OKC_TIME_UTIL_PUB, OKS_BILL_REC_PUB, and OKS_QP_INT_PVT, any invocation occurs within an initialized Oracle Applications session. In 12.1.1 and 12.2.2, the package behavior is consistent; the 12.2.2 ETRM documentation confirms the same seventeen units and table dependencies. Custom code should instead use supported OKS public APIs such as OKS_BILL_REC_PUB and OKS_QP_INT_PVT, treating OKS_MISC_UTIL_WEB as a private implementation detail.