Results for “okc_rule_pvt”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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.
-
VIEW: APPS.OKC_COVER_TIMES_V 12.1.1
-
VIEW: APPS.OKC_COVER_TIMES_V 12.2.2
-
VIEW: APPS.OKC_RULE_DEFS_V 12.1.1
-
PACKAGE: APPS.OKC_RULE_PVT 12.1.1
-
PACKAGE: APPS.OKC_RULE_PVT 12.2.2
-
VIEW: APPS.OKC_RULE_DEFS_V 12.2.2
-
PACKAGE: APPS.OKS_QP_PKG 12.1.1
-
12.2.2 DBA Data 12.2.2
-
PACKAGE: APPS.OKS_QP_PKG 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
SYNONYM: APPS.OKC_RULES_B 12.1.1
-
SYNONYM: APPS.OKC_RULES_B 12.2.2
-
VIEW: APPS.OKC_RULES_V 12.2.2
-
VIEW: APPS.OKC_RULES_V 12.1.1
-
eTRM - OKC Tables and Views 12.1.1
Intersection entity between templates and rules.
-
eTRM - OKC Tables and Views 12.1.1
Intersection entity between templates and rules.