Search Results increment_minor_version

Overview

OKE_CONTRACT_PVT is the private application programming interface for the Oracle E-Business Suite Contracts (OKE) module, which supports the authoring, revision control, and administration of project contracts, deliverables, and billing arrangements. The package is declared with AUTHID CURRENT_USER and is classified as a PVT (private) API, meaning it is intended for internal consumption by the Contracts application and its sibling packages rather than for direct invocation by external integrations. In practice, the private layer performs the low-level validation, versioning, entity locking, and DML against the Contracts base and history tables, while the corresponding public API (typically OKE_CONTRACT_PUB) exposes a narrower, supported surface to callers.

The metadata indicates that OKC_CONTRACT_PVT is referenced by two other packages, confirming its role as a shared internal service layer. In Oracle EBS 12.1.1 and 12.2.2 the file header identifies the source as OKEVCCCS.pls, and the package defines subtypes over OKE_CHR_PVT and OKE_CLE_PVT record types, signalling that contract header and contract line data structures are shared across the Contracts private packages.

Key Procedures and Functions

The documented interface contains 31 procedures and functions. The header-level operations are CREATE_CONTRACT_HEADER, UPDATE_CONTRACT_HEADER, DELETE_CONTRACT_HEADER, and VALIDATE_CONTRACT_HEADER. As shown in the source excerpt, the create and update procedures are overloaded: one form accepts a single record (p_chr_rec IN OKE_CHR_PVT.chr_rec_type) and returns x_chr_rec, while the other accepts a table of records (p_chr_tbl IN OKE_CHR_PVT.chr_tbl_type) and returns x_chr_tbl. All standard forms accept p_api_version, p_init_msg_list, and return x_return_status, x_msg_count, and x_msg_data, following the EBS PL/SQL API conventions.

The line-level counterparts are CREATE_CONTRACT_LINE, UPDATE_CONTRACT_LINE, DELETE_CONTRACT_LINE, and VALIDATE_CONTRACT_LINE, which are the procedures most closely associated with the search term "create_contract_line". These operate against the contract line structures defined in OKE_CLE_PVT (subtyped as cle_rec_type and cle_tbl_type). Deliverable processing is handled by CREATE_DELIVERABLE, UPDATE_DELIVERABLE, DELETE_DELIVERABLE, VALIDATE_DELIVERABLE, and LOCK_DELIVERABLE. Supporting routines include INCREMENT_MINOR_VERSION, which manages contract version numbering, and DELETE_MINOR_ENTITIES and DELETE_VERSION_RECORDS, which perform cleanup of subordinate records when a version is removed.

Tables Accessed

The package reads and writes a range of Contracts tables through APPS synonyms. Contract structure is maintained in OKC_K_LINES_B and its history table OKC_K_LINES_BH, along with OKC_K_GRPINGS for line groupings. Deliverable data resides in OKE_K_DELIVERABLES_B and its history and translation tables OKE_K_DELIVERABLES_BH and OKE_K_DELIVERABLES_TLH. Billing configuration is stored in OKE_K_BILLING_EVENTS, OKE_K_BILLING_METHODS, and OKE_K_BILLING_METHODS_H. Change tracking and audit support are provided by OKE_CHG_LOGS, OKE_CHG_REQUESTS, and OKE_K_FIFO_LOGS, while OKE_DEPENDENCIES records inter-entity dependencies and OKE_K_COMMUNICATIONS and OKE_K_FUNDING_SOURCES_H support contact and funding source history.

Usage Notes

Because OKC_CONTRACT_PVT is a private API, it is normally invoked indirectly. The Contracts authoring forms and related concurrent programs call the public API, which delegates to this package. Custom code that requires contract line creation should call the supported public entry points rather than calling CREATE_CONTRACT_LINE directly, since the private interface carries no compatibility guarantee across patches. Code that does invoke the package directly must initialize the message list, check x_return_status after every call, and use OKE_API to retrieve messages when x_msg_count exceeds zero.