Search Results update_minor_version




Overview

APPS.OKC_RULE_PVT is a private (PVT) PL/SQL package body within the Oracle E-Business Suite Contracts (OKC) module. Its primary business function is to manage the rules, rule groups, and cover-time definitions that govern contract terms and conditions during contract authoring and validation. Rules in OKC define conditional business logic applied against a contract, such as determining acceptable values, mandatory clauses, or constraint checks. The package encapsulates the procedural logic needed to create, modify, lock, and validate these rules and their associated grouping structures. Because it is classified as a private API, it is not intended for direct invocation by external or customer-facing code; rather, it supports the higher-level contracts APIs and internal processing that ultimately expose rule functionality to end users.

The excerpt provided, which corresponds to the search term "update_minor_version," demonstrates a characteristic internal utility procedure. It accepts a contract header identifier, populates a CVM (contract version management) record, and delegates to OKC_CVM_PVT.update_contract_version to bump the minor version of a contract. This illustrates how OKC_RULE_PVT coordinates with versioning infrastructure and raises standard validation exceptions back to the calling API.

Key Procedures and Functions

The package exposes twenty-six documented procedures organized into logical groupings:

Each functional family follows a consistent CRUD-plus-lock-plus-validate pattern, reflecting a uniform internal design convention. In addition to these documented procedures, the package body contains the update_minor_version helper, which is not part of the public documented set but supports contract version incrementation.

Tables Accessed

  • OKC_K_HEADERS_B: the contract header base table, accessed to anchor rules and version operations to a specific contract header.
  • OKC_RULES_B: the base table storing individual rule definitions associated with contracts.
  • OKC_RULE_DEFS_B: the rule definition base table providing the rule code, application identifier, and descriptive flexfield name metadata referenced by the package.
  • OKC_RULE_GROUPS_B: the base table storing rule group definitions that aggregate rules.
  • PLITBLM: a standard Oracle Applications temporary/logging table used for transient processing data.

Usage Notes

OKC_RULE_PVT is a private API and should not be invoked directly by custom code. It is referenced by two other packages, which call into it to perform rule maintenance and validation as part of higher-level contract operations. Typical invocation occurs through the Contracts forms (such as the contract authoring and terms/conditions setup windows), through the supported public OKC APIs that internally delegate to this package, and possibly through concurrent programs that validate or lock contract rules in batch. Developers extending rule behavior should use the corresponding public APIs rather than calling OKC_RULE_PVT procedures directly, to preserve upgrade safety and consistent exception handling.