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:
- Rule operations: CREATE_RULE, UPDATE_RULE, DELETE_RULE, LOCK_RULE, and VALIDATE_RULE manage the lifecycle of individual contract rules, including persistence, concurrency locking, and business-rule validation.
- Rule group operations: CREATE_RULE_GROUP, UPDATE_RULE_GROUP, DELETE_RULE_GROUP, LOCK_RULE_GROUP, and VALIDATE_RULE_GROUP manage the grouping construct that collects related rules for evaluation together.
- Rule-group mode/party-role operations: CREATE_RG_MODE_PTY_ROLE, UPDATE_RG_MODE_PTY_ROLE, DELETE_RG_MODE_PTY_ROLE, LOCK_RG_MODE_PTY_ROLE, and VALIDATE_RG_MODE_PTY_ROLE manage the association of rule groups with operating modes and party roles, determining when and for whom a group applies.
- Cover-time operations: CREATE_COVER_TIME, UPDATE_COVER_TIME, DELETE_COVER_TIME, LOCK_COVER_TIME, and VALIDATE_COVER_TIME manage the coverage time windows that define the effective duration over which rules apply.
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.
-
APPS.OKC_RULE_PVT SQL Statements
12.1.1
-
APPS.OKC_RULE_PVT SQL Statements
12.2.2
-
APPS.OKC_SECTIONS_PVT SQL Statements
12.2.2
-
APPS.OKC_OUTCOME_PVT SQL Statements
12.1.1
-
APPS.OKC_OUTCOME_PVT SQL Statements
12.2.2
-
APPS.OKC_CONDITIONS_PVT SQL Statements
12.2.2
-
APPS.OKC_SECTIONS_PVT SQL Statements
12.1.1
-
APPS.OKC_CONDITIONS_PVT SQL Statements
12.1.1
-
APPS.OKC_CVM_PVT SQL Statements
12.2.2
-
APPS.OKC_CONTRACT_PVT SQL Statements
12.1.1
-
APPS.OKC_CVM_PVT SQL Statements
12.1.1
-
PACKAGE BODY: APPS.OKC_RULE_PVT
12.1.1
-
PACKAGE BODY: APPS.OKC_RULE_PVT
12.2.2
-
APPS.OKC_CONTRACT_PVT SQL Statements
12.2.2
-
PACKAGE BODY: APPS.OKC_OUTCOME_PVT
12.2.2
-
PACKAGE BODY: APPS.OKC_OUTCOME_PVT
12.1.1
-
PACKAGE BODY: APPS.OKC_SECTIONS_PVT
12.1.1
-
PACKAGE BODY: APPS.OKC_SECTIONS_PVT
12.2.2
-
PACKAGE BODY: APPS.OKL_EXTRN_PVT
12.1.1
-
PACKAGE BODY: APPS.OKL_EXTRN_PVT
12.2.2
-
PACKAGE BODY: APPS.OKC_CONDITIONS_PVT
12.1.1
-
PACKAGE BODY: APPS.OKL_INCSH_PVT
12.1.1
-
PACKAGE BODY: APPS.OKL_INCSH_PVT
12.2.2
-
PACKAGE BODY: APPS.OKC_CONDITIONS_PVT
12.2.2
-
PACKAGE BODY: APPS.OKL_ACC_GEN_RULE_PVT
12.2.2
-
PACKAGE BODY: APPS.OKL_ACC_GEN_RULE_PVT
12.1.1
-
APPS.OKC_STATUS_CHANGE_PVT SQL Statements
12.1.1
-
PACKAGE: APPS.OKC_CVM_PVT
12.1.1
-
PACKAGE: APPS.OKC_CVM_PVT
12.2.2
-
PACKAGE BODY: APPS.OKC_CONTRACT_PVT
12.1.1
-
PACKAGE BODY: APPS.OKC_CONTRACT_PVT
12.2.2
-
PACKAGE BODY: APPS.OKL_TMPT_SET_PVT
12.2.2
-
PACKAGE BODY: APPS.OKC_CVM_PVT
12.2.2
-
PACKAGE BODY: APPS.OKL_ACCT_EVENT_PVT
12.2.2
-
PACKAGE BODY: APPS.OKC_CVM_PVT
12.1.1
-
PACKAGE BODY: APPS.OKL_ACCT_EVENT_PVT
12.1.1
-
PACKAGE BODY: APPS.OKL_TMPT_SET_PVT
12.1.1
-
APPS.OKC_STATUS_CHANGE_PVT SQL Statements
12.2.2
-
APPS.OKC_CVM_PVT dependencies on OKC_DEBUG
12.2.2
-
APPS.OKC_CVM_PVT dependencies on OKC_DEBUG
12.1.1
-
APPS.OKC_RULE_PVT dependencies on OKC_CVM_PVT
12.1.1
-
APPS.OKC_RULE_PVT dependencies on OKC_API
12.1.1
-
APPS.OKC_RULE_PVT dependencies on OKC_API
12.2.2
-
APPS.OKC_RULE_PVT dependencies on OKC_CVM_PVT
12.2.2
-
APPS.OKC_SECTIONS_PVT dependencies on OKC_API
12.1.1
-
APPS.OKC_SECTIONS_PVT dependencies on OKC_API
12.2.2
-
APPS.OKC_CONDITIONS_PVT dependencies on OKC_API
12.1.1
-
APPS.OKC_CVM_PVT dependencies on FND_API
12.2.2
-
APPS.OKC_CVM_PVT dependencies on FND_API
12.1.1
-
APPS.OKC_CONDITIONS_PVT dependencies on OKC_API
12.2.2