Search Results okc_time_util_pvt




Overview
Explore in AI Chat

Overview

OKC_TIME_UTIL_PVT is a private (PVT) PL/SQL package in the APPS schema that provides the core date, duration, and unit-of-measure calculation utilities used throughout the Oracle Contracts (OKC) and Oracle Service Contracts (OKS) modules. Its business purpose is to centralize the arithmetic logic that determines contract terms, coverage periods, renewal windows, and pricing durations so that every contracting sub-process derives dates consistently. Because it is a private API, it is not intended for direct call by external applications; instead it is consumed by public packages such as OKC_TIME_UTIL_PUB, OKC_CONTRACT_PVT, OKC_RULE_PVT, OKC_TIME_RES_PVT, and the service-side packages OKS_CON_COVERAGE_PVT, OKS_ENTITLEMENTS_PVT, OKS_RENEW_CONTRACT_PVT, and OKS_REPRICE_PVT. The ETRM 12.2.2 metadata classifies the package as API classification PVT with 12 documented procedures and functions, and confirms its status as VALID in Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented callable units cover the following functional areas:

  • GET_DURATION — returns the duration value expressed in contract time units, used when deriving term length from stored contract data.
  • GET_ENDDATE — computes the end date of a contract or coverage period from a start date and duration.
  • GET_APP_ID — resolves the application identifier, typically used to qualify flexfield and lookup context.
  • GET_RULE_DF_NAME — returns the descriptive flexfield name associated with a contract rule definition.
  • GET_RULE_DEFS_USING_VS — returns rule definitions that reference a given value set, supporting rule-driven date logic.
  • GET_DFF_COLUMN_VALUES — extracts descriptive flexfield column values needed to evaluate rule and time attributes.
  • GET_TVE_IDS — retrieves time-value-expression identifiers used in duration calculations.
  • GET_UOM_CODE — resolves the unit of measure code applicable to a time unit, enabling UOM-aware arithmetic.
  • GET_ORACLE_MONTHS_AND_DAYS — decomposes a span into Oracle calendar months and residual days, the standard mechanism EBS uses for period arithmetic.
  • GET_PRICING_DURATION — derives the duration used for pricing and repricing calculations.

Additional undocumented units complete the total of 12.

Tables Accessed

The package reads through APPS synonyms rather than base tables:

  • FND_APPLICATION — used to resolve application identifiers and context for flexfield and rule evaluation.
  • FND_FLEX_VALUE_SETS — used to validate and resolve value sets referenced by contract rule definitions.
  • OKC_TIME_CODE_UNITS_B — the base table defining contract time codes and their units, providing the UOM and unit conversion data that underpins duration and end-date calculation.

The documented dependency list also shows the package depending on OKC_API and SYS.STANDARD, and being referenced by nine other packages across the OKC and OKS families.

Usage Notes

OKC_TIME_UTIL_PVT is invoked indirectly. Service Contracts and Contracts forms that capture or modify contract terms trigger the surrounding public packages, which in turn call this utility for date and duration resolution. Concurrent programs that generate, renew, reprice, or expire contracts rely on the same call chain through OKC_CONTRACT_PVT, OKS_RENEW_CONTRACT_PVT, and OKS_REPRICE_PVT. The package is also called during entitlement and coverage computations by OKS_CON_COVERAGE_PVT and OKS_ENTITLEMENTS_PVT, and by OKC_COPY_CONTRACT_PVT when duplicating contract terms. Custom code should call OKC_TIME_UTIL_PUB rather than this private package, since the PVT layer carries no guarantee of interface stability across patches or upgrades. The documentation reference to OKC_TIME_UTIL_PUB appears twice in the dependency list, confirming that the public wrapper is the sanctioned entry point.