Search Results delete_contract

Overview

The APPS.OKC_DELETE_CONTRACT_PUB package body is the public API layer of the Oracle E-Business Suite Contract Lifecycle Management (formerly ETRM / OKC) module responsible for the deletion of contract records. It is classified as a PUB (public) API, meaning it is intended for external invocation by Oracle forms, concurrent programs, workflows, and customer-written extensions rather than being an internal-only implementation detail. In Oracle EBS 12.1.1 and 12.2.2, deletion of a contract is a business-sensitive operation that must respect referential integrity across the contract hierarchy, associated deliverables, parties, and dependent transactional data. This package encapsulates that logic and exposes a controlled, versioned entry point conforming to the standard EBS API design pattern, including API version negotiation, message list initialization, and standardized return-status semantics.

Key Procedures and Functions

ETRM metadata documents two overloaded variants of a single procedure, DELETE_CONTRACT:

• DELETE_CONTRACT (single-record form, p_chrv_rec) — Accepts a scalar contract header record of type OKC_CONTRACT_PUB.chrv_rec_type and deletes the corresponding single contract. The public procedure calls the private implementation OKC_DELETE_CONTRACT_PVT.delete_contract after wrapping the call with OKC_API.START_ACTIVITY and OKC_API.END_ACTIVITY to manage the FND message stack.
• DELETE_CONTRACT (bulk/table form, p_chrv_tbl) — Accepts a PL/SQL table of contract header records (OKC_CONTRACT_PUB.chrv_tbl_typ) for mass deletion of multiple contracts in a single call, using the same activity and error-handling framework.

Both variants share the standard EBS API signature: p_api_version, p_init_msg_list, x_return_status, x_msg_count, and x_msg_data. Return status is reported using OKC_API.G_RET_STS_SUCCESS, G_RET_STS_ERROR, and G_RET_STS_UNEXP_ERROR. Exception handling is centralized through OKC_API.HANDLE_EXCEPTIONS, ensuring consistent error messaging regardless of caller.

Tables Accessed

Per the documented package metadata, the only table referenced via APPS synonyms is PLITBLM, a generic temporary/plsql table used internally for bulk data passing. The substantive contract table DML (deletion from OKC_K_HEADERS and its child entities) is performed by the private package OKC_DELETE_CONTRACT_PVT, which this PUB body delegates to. Consequently, referential integrity enforcement, cascading deletes of contract lines, parties, and deliverables, and any derived column maintenance occur inside the private layer rather than this public wrapper.

Usage Notes

This package is typically invoked in the following contexts:

• Oracle Forms — Contract workbench and authoring forms call the single-record variant when a user deletes a contract from the UI, passing the current header record.
• Concurrent programs — Bulk purge or data-migration concurrent managers invoke the table variant to remove many contracts in a batch.
• Custom PL/SQL extensions — Integrators writing custom deletion logic should call this PUB API rather than issuing direct DELETE statements, as the private layer enforces validation, versioning, and audit logging. Callers must check x_return_status and inspect x_msg_count/x_msg_data for diagnostics. The package is referenced by two other packages within ETRM, confirming it is a shared dependency in the contract lifecycle.