Search Results oks_contract_line_pub




Overview
Explore in AI Chat

Overview

The APPS.OKS_CONTRACT_LINE_PUB package body is the public, externally callable API for managing service contract lines within the Oracle E-Business Suite Service Contracts (OKS) module. It exposes the business logic required to create, maintain, validate, and delete individual contract lines — the fine-grained service, warranty, and subscription entitlements that sit beneath a service contract header. In the Oracle EBS 12.1.1 and 12.2.2 releases, this package is classified as a PUB (public) API, meaning it is intended for supported invocation by other application modules, concurrent programs, and customer extensions rather than being reserved for internal use only.

The package delegates persistence and lower-level processing to internal private packages and shared APIs, most notably OKS_KLN_PVT, OKC_API, and OKC_UTIL. It also depends on the common API infrastructure in FND_API for standard return-status handling, message propagation, and error management. Its status is VALID, confirming it compiles and operates correctly against the referenced schema objects.

Key Procedures and Functions

The ETRM metadata documents 18 procedures and functions in total. The principal public routines include:

  • CREATE_LINE — Inserts a new contract line, applying the contract's business rules and defaulting logic during creation.
  • UPDATE_LINE — Modifies attributes of an existing contract line, subject to validation of the changed values.
  • DELETE_LINE — Removes a contract line, including any associated processing required to maintain integrity.
  • VALIDATE_LINE — Performs business-rule validation on line data without committing changes, typically used before create or update operations.
  • LOCK_LINE — Acquires the locking semantics needed to prevent concurrent modification of a contract line during transactional processing.
  • ADD_LANGUAGE — Inserts translated (TL) rows for contract line descriptive content, supporting the multi-language tables referenced by the package.
  • INSERT_ROW_UPG and CREATE_LINE_VERSION_UPG — Upgrade-support routines used during patching or data-conversion activity to populate base rows and generate line versions.

This package is referenced by 14 other packages, reflecting its role as a reusable integration point within the OKS and broader Service Contracts dependency chain.

Tables Accessed

The package operates against the following tables (accessed through APPS synonyms):

  • OKS_K_LINES_B — The base table holding the core, non-translated columns for each contract line.
  • OKS_K_LINES_BH — The history table for the base line data, supporting versioning and audit retrieval.
  • OKS_K_LINES_TL — The translation table containing language-specific (typically name and description) columns for contract lines.
  • OKS_K_LINES_TLH — The history/translation table for line descriptive content.
  • FND_LANGUAGES — The language definition table, used primarily by ADD_LANGUAGE to identify valid installed languages for translation rows.
  • PLITBLM — A standard Oracle-supplied table used for multi-row / bulk processing support.

Usage Notes

OKS_CONTRACT_LINE_PUB is typically invoked from Service Contracts forms and concurrent programs when contract lines are created or revised, and it serves as the supported entry point for custom code that must insert or maintain contract line records programmatically. Because it is a PUB API, callers should use it in preference to direct DML against the underlying OKS_K_LINES tables. Callers should expect the standard FND_API return-status and message conventions, and should honor the locking and validation routines (LOCK_LINE, VALIDATE_LINE) in the sequence prescribed by the API. As the package is not referenced by any database object, it functions purely as a callable interface rather than as a trigger or view dependency target.