Search Results get_language_info

Overview

OKS_RENEW_UTIL_PVT is a private utility package within the Oracle E-Business Suite Service Contracts (OKS) module. It provides the internal renewal-processing engine that supports the Service Contracts renewal workflow, supplying the helper logic consumed by public APIs, concurrent programs, and the Renewal form. The package is declared with AUTHID CURRENT_USER and resides under the APPS schema; its header carries the revision marker OKSRRUTS.pls 120.7.12000000.1, indicating maintenance through the 12.1.1 code line and continued availability in 12.2.2. Its principal role is to resolve the rules, defaults, and configuration values that govern how a contract is renewed — including renewal pricing behavior, template assignment, payment terms, period handling, and function-level access checks — and to evaluate preconditions before a renewal transaction is committed. Because it is classified as a private (PVT) package, it is not intended as a published integration surface; it is called by Oracle's own renewal stack and by dependent packages rather than by customer-facing APIs.

Key Procedures and Functions

The documented interface exposes twelve units. GET_RENEW_RULES is the central retrieval routine that returns the renewal rule record (rnrl_rec_type) assembled from the OKS_K_DEFAULTS setup, which the header comment shows was extended in Release 12 with fields such as cdt_type, jtot_object_code, base_currency, approval types, payment instrument flags, and period attributes. UPDATE_RENEWAL_STATUS writes back status transitions during the renewal lifecycle. GET_PAYMENT_TERMS resolves the applicable payment terms for the renewed contract. CAN_UPDATE_CONTRACT performs an eligibility check determining whether the contract may be modified in the current context. GET_PERIOD_DEFAULTS supplies period type, start, and unit-of-measure defaults. GET_TEMPLATE_SET and GET_TEMPLATE_SET_ID resolve the renewal template set, while GET_TEMPLATE_LANG returns the language associated with the template. GET_RENEW_RULES is complemented by LOG_RULES, which records the resolved rule set for audit and debugging. EVALUATES applies the configured rule logic to determine renewal outcome. GET_FUNCTION_ACCESS implements the function-security check that callers use to verify whether a user may perform a given renewal-related function; this is the routine most directly associated with the "get_function_access" search. GET_LANGUAGE_INFO returns language metadata used when rendering renewal documents.

Tables Accessed

The package reads and writes through APPS synonyms. OKS_K_DEFAULTS is the primary source of renewal rule and default configuration, and OKS_K_HEADERS_B supplies contract header data for the renewal in process. OKC_K_HEADERS_ALL_B and OKC_K_PARTY_ROLES_B are consulted for the core contract header and its party roles, so that renewal eligibility and access decisions can be evaluated against the correct parties. OKS_TEMPLATE_SET and XDO_TEMPLATES_B resolve the template set and its templates. FND_LANGUAGES provides language lookups for GET_LANGUAGE_INFO, and PLITBLM is used for PL/SQL table buffering of collected values during rule evaluation.

Usage Notes

OKS_RENEW_UTIL_PVT is invoked internally rather than called directly by end users. It is executed from the Service Contracts renewal forms, from renewal-related concurrent programs, and from Oracle's public renewal packages; the ETRM metadata records that fourteen other packages reference it. Customizations should avoid direct calls to this private package and instead use the supported renewal APIs, since signatures and internal record types (notably rnrl_rec_type) are subject to change across 12.1.1 and 12.2.2 without prior notice.