Search Results get_period_defaults

Overview

OKS_RENEW_UTIL_PUB is the public (PUB) API package within the Oracle E-Business Suite Service Contracts (OKS) module that exposes renewal utility functionality to external callers. It is owned by APPS and, as indicated by the AUTHID CURRENT_USER clause in its specification, executes with the privileges of the invoking schema while resolving unqualified references through the caller. The package is closely coupled with the private implementation package OKS_RENEW_UTIL_PVT, from which it re-exports the Rnrl_rec_type record subtype used to carry renewal rule data across the API boundary. It relies on shared error-handling and message constants from OKC_API, including tokens for SQLCODE, SQLERRM, column names, required values, and invalid values, and it defines standardized global messages such as G_UNEXPECTED_ERROR. The package centralizes logic for retrieving renewal rules, evaluating renewal eligibility, and updating the renewal status of contracts, and is referenced by nineteen other packages, confirming its role as a foundational utility layer for the Service Contracts renewal process.

Key Procedures and Functions

• GET_RENEW_RULES — Retrieves the renewal rules applicable to a given contract, party, and operating unit as of a specified date. It accepts the standard API versioning and message-list parameters, contract and party identifiers, an organization identifier, and a date defaulting to SYSDATE, taking an input renewal record and returning an output renewal record.
• UPDATE_RENEWAL_STATUS — Updates the renewal status associated with a contract or renewal record. This is the procedure most commonly sought by users searching for renewal status maintenance within Service Contracts.
• CAN_UPDATE_CONTRACT — Determines whether a contract is in a state that permits update, serving as a validation gate before renewal-related changes are applied.
• GET_PAYMENT_TERMS — Returns payment terms information used in the renewal evaluation and pricing context.
• GET_PERIOD_DEFAULTS — Supplements caller-supplied inputs with default period values required by the renewal process.
• GET_TEMPLATE_SET — Retrieves the contract template set applicable to the renewal scenario.
• GET_TEMPLATE_SET_ID — Returns the identifier of the relevant template set.
• GET_TEMPLATE_LANG — Returns the language associated with template retrieval, supporting multilingual template selection.
• EVALUATES — Performs evaluation logic that determines renewal outcomes or rule applicability.

Tables Accessed

The ETRM metadata for this package does not enumerate the underlying tables directly. As a renewal utility layer, it operates against the Service Contracts renewal rule and contract data model, delegating much of the physical access to OKS_RENEW_UTIL_PVT, which reads and writes the renewal rule and contract records used to derive status and rule values. All table references are made through APPS synonyms rather than fully qualified schema names.

Usage Notes

OKS_RENEW_UTIL_PUB is intended for invocation from Service Contracts forms, concurrent programs, and custom extensions that need to read renewal rules or update renewal status without directly manipulating base tables. Callers should follow the standard EBS API conventions: pass a meaningful p_api_version, honor p_init_msg_list to control message stack initialization, and inspect x_return_status along with x_msg_count and x_msg_data after every call. Because the package is referenced by nineteen other packages, changes to its behavior have broad downstream impact, and custom code should treat the documented signatures as the supported integration surface.