Search Results oks_coverages_migration




Overview
Explore in AI Chat

Overview

OKC_RIL_PVT is a private PL/SQL package in the APPS schema that implements the runtime rule and reaction-interval engine for Oracle Contracts (OKC) within Oracle E-Business Suite 12.1.1 and 12.2.2. The "RIL" in the name refers to reaction interval logic, which controls the scheduling of recurring clauses, deliverables, and rule evaluations across the life of a contract. Reaction intervals establish when a contract rule fires, how often it recurs, and what happens when a milestone or event date is reached.

As a PVT (private) API package, OKC_RIL_PVT is not intended for direct invocation by external applications. Instead, it exposes the low-level row operations and versioning logic that public packages such as OKC_RULE_PUB, OKC_RULE_PVT, OKC_CONTRACT_PVT, and OKC_VERSION_PVT consume. This layering follows the standard EBS API architecture in which a public package validates input and delegates to a private package for transactional DML.

Key Procedures and Functions

The package documents 16 procedures and functions. The core data-manipulation routines are INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW, which provide the standard insert-update-delete-lock quartet for a single reaction-interval record. VALIDATE_ROW performs attribute-level validation before a row is committed, while QC is the quality-check routine that verifies data consistency. INSERT_ROW_UPG supports the upgrade path for pre-existing reaction-interval data.

Versioning is handled by CREATE_VERSION, CHANGE_VERSION, RESTORE_VERSION, and API_COPY. CREATE_VERSION snapshots the current reaction-interval configuration, CHANGE_VERSION advances a contract to a new version and reassigns the associated intervals, and RESTORE_VERSION rolls back to a prior version. API_COPY replicates reaction intervals between contract versions or templates, and is therefore central to amendment and copy-contract behavior.

Tables Accessed

OKC_RIL_PVT reads and writes OKC_REACT_INTERVALS, the primary transactional table holding reaction-interval definitions, along with its historical counterpart OKC_REACT_INTERVALS_H, which preserves prior versions. The view OKC_REACT_INTERVALS_V is referenced for query access. OKC_RULES_B stores the contract rules to which intervals are bound, while OKC_K_HEADERS_B holds the contract header context. OKC_TIMEVALUES supplies the date and time values used to compute interval schedules. PLITBLM is the standard PL/SQL index-by table used for bulk processing.

Usage Notes

Because OKC_RIL_PVT is a private package, it is invoked indirectly. The most relevant caller for the search term oks_coverages_migration is OKS_COVERAGES_MIGRATION, which references OKC_RIL_PVT to migrate service coverage and reaction-interval data between releases, particularly during upgrades from 12.1.1 to 12.2.2. Other consumers include OKC_RULE_PUB, OKC_RULE_PVT, OKC_CONTRACT_PVT, OKC_COPY_CONTRACT_PVT, OKC_VERSION_PVT, and OKS_MASSCHANGE_PVT.

Customizations should call the public wrapper packages rather than OKC_RIL_PVT directly, since the private package does not guarantee API-level validation or backward compatibility. The package is normally reached during contract authoring, amendment, versioning, and mass update of contract rules in the Contracts and Service (OKS) modules.