Search Results lock_contract_process

Overview

OKC_CONTRACT_PUB is the public (PUB) API package for the Oracle Contracts (OKC) module in Oracle E-Business Suite, released under the APPS schema with AUTHID CURRENT_USER. It exposes the contract authoring and lifecycle operations that Oracle Forms, concurrent programs, and external integrations rely on when creating, maintaining, and retiring contract documents. The package acts as the supported entry point into the Contract Authoring runtime, wrapping the private implementation in OKC_CONTRACT_PVT and the core services of OKC_API.

The specification declares a substantial set of shared data structures, including the Price_Table_Record/Price_Table_Type for amount manipulation in the Authoring form, and subtype aliases for the contract header (chrv), line (clev), process (cpsv), governance (gvev), and value (cacv, cvmv) record and table types. Global variables such as g_chrv_rec, g_clev_rec, g_cpsv_rec, g_gvev_rec, and their table counterparts are exposed for user hooks, alongside g_pkg_name and g_app_name. Collectively these declarations allow callers to pass populated contract structures through a single, consistent API surface rather than manipulating underlying tables directly.

Key Procedures and Functions

The documented 65 procedures and functions follow a consistent pattern across the major contract entities. The principal groups are:

• Contract Header — CREATE_CONTRACT_HEADER, UPDATE_CONTRACT_HEADER, DELETE_CONTRACT_HEADER, LOCK_CONTRACT_HEADER, and VALIDATE_CONTRACT_HEADER provide the full lifecycle for the contract header record.
• Contract Line — CREATE_CONTRACT_LINE, UPDATE_CONTRACT_LINE, DELETE_CONTRACT_LINE, LOCK_CONTRACT_LINE, and VALIDATE_CONTRACT_LINE manage individual contract lines and their pricing details.
• Governance — CREATE_GOVERNANCE, UPDATE_GOVERNANCE, DELETE_GOVERNANCE, LOCK_GOVERNANCE, and VALIDATE_GOVERNANCE maintain governance rules associated with a contract.
• Contract Process — CREATE_CONTRACT_PROCESS, UPDATE_CONTRACT_PROCESS, DELETE_CONTRACT_PROCESS, LOCK_CONTRACT_PROCESS, and VALIDATE_CONTRACT_PROCESS manage the business processes attached to a contract. DELETE_CONTRACT_PROCESS is the specific procedure surfaced by the user search term "delete_contract_process," and it performs the removal of an existing contract process record through the supported API rather than direct DML.

Each operation is implemented with the standard EBS API signature conventions, including p_api_version, p_init_msg_list, x_return_status, x_msg_count, and x_msg_data, ensuring consistent error handling and message stack reporting for every call.

Tables Accessed

The documented table reference for this package is PLITBLM, an APPS synonym used during contract processing. In practice the package operates against the OKC contract schema tables (such as OKC_K_HEADERS, OKC_K_LINES, and the associated process and governance tables) through its private implementation and the OKC_API layer. Because the package is AUTHID CURRENT_USER, object resolution and privilege checking are performed against the calling user, which is important when the API is invoked from custom schemas granted execute on OKC_CONTRACT_PUB.

Usage Notes

OKC_CONTRACT_PUB is invoked by the Contract Authoring forms, contract-related concurrent programs, and any custom code or integration that needs to create or maintain contracts through a supported interface. With 68 dependent packages, it functions as a central building block within the Contracts module. Oracle recommends that customizations call the PUB procedures rather than the underlying PVT or table structures, preserving upgrade safety and ensuring that validation, locking, and message handling are applied consistently. When implementing delete operations such as DELETE_CONTRACT_PROCESS, callers should invoke the procedure with the appropriate record identifier and inspect x_return_status and the message stack before committing.