Search Results duration_period

Overview

OKS_MISC_UTIL_WEB is a utility package in the APPS schema that supports the Oracle E-Business Suite Service Contracts (OKS) and Telecommunications/Contracts (OKC) module set. It consolidates a set of reusable helper routines used by Service Contracts web-based flows, mass update processing, and installed base utilities. Its classification in ETRM is OTHER, indicating it is not a formal public API but an internal utility layer invoked by dependent packages and views rather than by end users directly.

The package is documented as VALID in the APPS schema and depends on FND_API, OKC_API, and the SYS.STANDARD library. FND_API supplies the standard EBS error-handling and message stack conventions (for example, the FND_API.G_RET_STS_SUCCESS / G_RET_STS_ERROR result codes), while OKC_API supplies common contract header and line interrogation logic. This dependency pattern confirms the package functions as a presentation-and-calculations helper for contract data rather than as an owner of contract business rules.

Key Procedures and Functions

The package exposes 17 documented procedures and functions, grouped by purpose:

• Duration and period derivation: DURATION_PERIOD, DURATION_UNIT, and GET_DURATION_PERIOD compute and return the effective duration of a contract or line, together with the unit of measure in which that duration is expressed.
• Amount and adjustment calculations: ADJUSTED_DISCOUNT, ADJUSTED_SURCHARGE, ADJUSTED_TOTAL, GET_ADJUSTMENT_AMOUNT, GET_TOTAL_AMOUNT, and GET_TERMINATED_AMOUNT derive pricing values for a contract line, applying discounts, surcharges, and termination effects to produce adjusted totals.
• Billing aggregation: GET_LINE_BILLED_AMOUNT, GET_LINE_UNBILLED_AMOUNT, GET_HEADER_BILLED_AMOUNT, and GET_HEADER_UNBILLED_AMOUNT aggregate billed and unbilled balances at both the line and contract header level.
• Descriptive lookups: GET_COVLVL_NAME, GET_NAME, and GET_COMMIMENT_NUMBER (as documented, spelled with the double "M") resolve descriptive names and commitment identifiers for use in UI display and reporting.
• Validation: VALIDATE_COMPONENT_YN returns a Yes/No determination of whether a component is valid for the operation being performed.

Parameter lists are not reproduced here; callers should consult the package specification in the database for exact signatures.

Tables Accessed

The package reads and writes through APPS synonyms across three functional areas:

• Installed base and inventory: CSI_ITEM_INSTANCES, CSI_SYSTEMS_TL, MTL_SYSTEM_ITEMS_B, MTL_SYSTEM_ITEMS_KFV, and MTL_UNITS_OF_MEASURE_TL supply instance, system, item, and unit-of-measure attributes.
• Contracts: OKC_K_ITEMS, OKC_K_LINES_B, and OKC_K_REL_OBJS provide contract line, item, and relationship data that form the core of the amount and duration calculations.
• Billing: OKS_BILL_CONT_LINES and OKS_BILL_SUB_LINES hold billing schedule and sub-line records used by the billed/unbilled aggregation routines.
• Order and party data: OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, HZ_CUST_ACCOUNTS, HZ_PARTIES, and HZ_PARTY_SITES resolve ordering context and customer, party, and site identity for display and validation.

Usage Notes

OKS_MISC_UTIL_WEB is referenced by the view OKS_CONTRACT_UPD_DTLS_V and by the packages OKS_IB_UTIL_PVT and OKS_MASS_UPDATE_PVT, and it references itself. The presence of the view tie-in is significant: the user search term "oks_contract_upd_dtls_v" corresponds to a contract update details view whose column derivations are supplied by this utility package, so the package effectively feeds contract mass-update and detail screens.

Typical invocation paths are therefore Service Contracts forms and web pages, the mass update concurrent programs that drive OKS_MASS_UPDATE_PVT, and installed base utilities. Because the package is not a public API and its dependencies are standard internal components, customizations should call it only through the supported dependent packages where possible, and should validate behavior after patching, since the document contains no formal interface guarantee.