Search Results okc_rule_pvt




Overview
Explore in AI Chat

Overview

OKC_CTI_PVT is a private (PVT-classified) PL/SQL package in the APPS schema within Oracle E-Business Suite. It belongs to the Contracts Core (OKC) module of Oracle Enterprise Contracts / Service Contracts (EBS 12.1.1 and 12.2.2). The abbreviation "CTI" refers to "Cover Times" — the package encapsulates the internal business logic governing coverage time definitions on contract lines, including time value ranges that determine when a service or coverage applies.

As a private API, it is not intended for direct external invocation; it serves as the low-level processing engine consumed by higher-level public packages. Although the user searched for "okc_rule_pvt", the documentation confirms that OKC_RULE_PVT is a dependent of OKC_CTI_PVT, not the reverse: OKC_CTI_PVT is referenced by OKC_RULE_PVT, OKC_RULE_PUB, OKC_CONTRACT_PVT, OKC_COPY_CONTRACT_PVT, OKC_VERSION_PVT, OKS_COVERAGES_PVT, and OKS_COVERAGES_MIGRATION. This positions OKC_CTI_PVT as a foundational utility underpinning contract rules, contract versioning/copying, and service coverage migration.

Key Procedures and Functions

The package exposes 16 documented procedures and functions. Documented members include:

  • QC — Quality check / internal validation routine, likely performing consistency assertions before processing.
  • CHANGE_VERSION and CREATE_VERSION — Manage versioning of cover-times records, supporting the contract versioning model in OKC_VERSION_PVT.
  • RESTORE_VERSION — Restores a prior version of cover-times data during contract version rollback.
  • API_COPY — Copies cover-times rows, used when duplicating a contract (invoked via OKC_COPY_CONTRACT_PVT).
  • INSERT_ROW, UPDATE_ROW, DELETE_ROW — Core DML operations against the underlying cover-times tables.
  • INSERT_ROW_UPG — Upgrade-specific insert routine used during data migration (referenced by OKS_COVERAGES_MIGRATION).
  • LOCK_ROW — Row-level locking to ensure concurrency control during transactions.
  • VALIDATE_ROW — Applies business validation rules to a cover-times record before commit.

The remaining documented members follow the same insert/update/validate/version pattern. No parameter lists are published; callers should not assume signatures.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

  • OKC_COVER_TIMES and OKC_COVER_TIMES_H — the base and history tables storing cover-time definitions.
  • OKC_COVER_TIMES_V — a view over cover-times used for query access.
  • OKC_K_HEADERS_B — contract header base table, providing the parent contract context.
  • OKC_RULES_B — contract rules base table, linking cover-times to rule definitions.
  • OKC_TIMEVALUES — stores time value ranges associated with cover times.
  • PLITBLM — a standard PL/SQL index-by table type utility used for bulk processing.

Usage Notes

OKC_CTI_PVT is invoked indirectly. Contract and coverage forms in the OKC/OKS modules call down through OKC_RULE_PUB, OKC_CONTRACT_PVT, or OKS_COVERAGES_PVT, which in turn call OKC_CTI_PVT to persist cover-times changes. Contract copy and versioning workflows route through API_COPY, CREATE_VERSION, CHANGE_VERSION, and RESTORE_VERSION. Data migration programs such as OKS_COVERAGES_MIGRATION invoke INSERT_ROW_UPG to load legacy coverage data during upgrades to 12.1.1/12.2.2.

Custom code should not call OKC_CTI_PVT directly; the API classification "PVT" signals that signatures may change between patches. Developers extending contract or coverage functionality should use the public packages (OKC_RULE_PUB, OKS_COVERAGES_PVT) and rely on FND_API error handling, as OKC_CTI_PVT inherits the standard FND_API/OKC_API exception model.