Search Results undo_line

Overview

OKS_COVERAGES_PUB is the public (PUB) PL/SQL API package for Oracle Service Contracts coverage processing within Oracle E-Business Suite. It exposes a set of commitment-oriented entry points that let calling code create, modify, version, restore, and remove service coverage records without directly manipulating the underlying contract tables. The package operates under AUTHID CURRENT_USER and delegates most of its business logic to the private implementation package OKS_COVERAGES_PVT, while adopting the standard Oracle Contracts error-handling framework through the OKC_API.G_APP_NAME constant and the conventions of x_return_status, x_msg_count, and x_msg_data. Standard tokens such as G_SQLERRM_TOKEN and G_SQLCODE_TOKEN, together with the G_EXCEPTION_HALT_VALIDATION exception, provide a consistent diagnostic surface across all entry points. The package header also exposes an ac_rec_type subtype derived from OKS_COVERAGES_PVT, which is used to pass coverage attribute data into the create and adjusted-coverage procedures.

Key Procedures and Functions

• CREATE_ACTUAL_COVERAGE — Creates an actual coverage record from an input coverage record of type ac_rec_type, returning the generated actual coverage identifier.
• UNDO_HEADER — Reverses coverage actions performed against a contract header, identified by header ID.
• UNDO_LINE — Reverses coverage actions performed against a specific contract line.
• UPDATE_COV_EFF — Updates the effective dates (new start and end date) of coverage associated with a service line.
• INSTANTIATE_COVERAGE — Instantiates coverage, typically during contract authoring or fulfillment, generating the concrete coverage records from templates or defaults.
• DELETE_COVERAGE — Removes a coverage record.
• CHECK_COVERAGE_MATCH — Validates whether coverage records match expected criteria, supporting duplicate and consistency checking.
• CREATE_ADJUSTED_COVERAGE — Creates an adjusted coverage record, used when coverage terms are modified or re-rated.
• OKS_BILLRATE_MAPPING — Provides bill rate mapping logic tied to coverage records.
• VERSION_COVERAGE — Creates a new version of an existing coverage record, preserving history for audit and change tracking.
• RESTORE_COVERAGE — Restores a previously saved or versioned coverage record.
• DELETE_HISTORY — Purges historical coverage versions.
• DELETE_SAVED_VERSION — Removes a saved coverage version that is no longer required.

Tables Accessed

The package accesses contract data through APPS synonyms. OKC_K_ITEMS holds contract line item and coverage-related item information, and OKC_K_LINES_B stores the base contract line records that coverage is attached to. These tables are the primary persistence points for the header- and line-level undo, instantiation, and versioning operations described above.

Usage Notes

OKS_COVERAGES_PUB is normally invoked from service contract forms, concurrent programs, and other internal service applications rather than being called directly by end users. The ETRM metadata records that it is referenced by eleven other packages, indicating it serves as a shared dependency within the Service Contracts module and related contract-processing flows. Custom extensions should call these public procedures rather than writing directly to the underlying tables, and should always inspect x_return_status and the associated message stack to handle validation halts and unexpected errors correctly.