Search Results okl_setupovdtemplates_pvt




Overview
Explore in AI Chat

Overview

OKL_OVD_RUL_TMLS_PUB is a public PL/SQL package in the APPS schema that supports Oracle Lease and Finance Management (OKL/ETRM) setup for Override Rule Templates. It serves as the public API layer through which override rule template records are created, maintained, and validated during lease authoring and contract setup. The package encapsulates data manipulation against the underlying override rule template tables while delegating transactional integrity and error handling to companion private packages such as OKL_OVT_PVT and OKC_API. In Oracle EBS 12.1.1 and 12.2.2, this package is central to the configuration of override rules that govern how contract terms and pricing values may be overridden manually during the lease lifecycle.

Key Procedures and Functions

  • INSERT_OVD_RUL_TMLS — Creates a new override rule template record, establishing the template definition used to drive override behavior for a lease or contract.
  • UPDATE_OVD_RUL_TMLS — Modifies an existing override rule template, allowing administrators to adjust rule configurations without recreating the record.
  • DELETE_OVD_RUL_TMLS — Removes an override rule template that is no longer required, with validation performed before deletion.
  • LOCK_OVD_RUL_TMLS — Acquires a row-level lock on the override rule template to prevent concurrent modification during an update or delete transaction.
  • VALIDATE_OVD_RUL_TMLS — Performs business-rule validation against the override rule template data, ensuring referential and logical consistency before the record is persisted or changed.
  • ADD_LANGUAGE — Inserts translated (MLS) rows for override rule template attributes, supporting multilingual deployments of the setup data.

These procedures are the documented entry points; parameter lists are not reproduced here as they are defined within the package specification. The package depends on OKC_API and OKL_OVT_PVT to complete its processing.

Tables Accessed

The package references the table synonym PLITBLM, which stores multilingual or translation-related rows used to maintain language-specific descriptions of override rule templates. Records in this table are written during ADD_LANGUAGE processing and read during template retrieval. Additional data is accessed indirectly through OKL_OVT_PVT and OKC_API, which manage the primary override rule and contract data structures. The public package thereby acts as a controlled gateway rather than accessing all base tables directly.

Usage Notes

OKL_OVD_RUL_TMLS_PUB is typically invoked from the ETRM Setup responsibility, particularly through the Override Templates setup form, which calls OKL_SETUPOVDTEMPLATES_PVT. That private package in turn references OKL_OVD_RUL_TMLS_PUB, forming the standard call chain from the UI to the public API. Custom integrations and extension code may call the public procedures directly to bulk-load or maintain override rule templates. Because the package maintains language rows and performs validation, callers should invoke VALIDATE and LOCK procedures before update or delete operations to ensure data consistency. As a public (PUB) classified API, it is considered a supported, stable interface for external callers within the ETRM module, and it is referenced by dependency packages including OKL_OPT_RUL_TMP_PVT.