Search Results insert_ovd_rul_tmls

Overview

OKL_OVD_RUL_TMLS_PUB is a public PL/SQL API package in the Oracle E-Business Suite Oracle Lease and Finance Management (OKL) module. It belongs to the ETRM (Enterprise Transaction and Rules Management) subsystem that governs the handling of override rules and their associated terms and time limits within lease and finance contracts. The package exposes a standardized, FND_API-compliant interface for maintaining override rule term lines (OVD RUL TMLS), allowing business users and calling programs to create, modify, and remove these rules while preserving the multi-tier data model.

The "_PUB" suffix indicates that this is the publicly callable wrapper layer, designed to be invoked by forms, concurrent programs, and custom code. Internally it delegates the physical DML to a corresponding private package (OKL_OVT_PVT), providing the conventional Oracle Application Architecture separation between validation/API layers and the underlying private implementation. This design ensures consistent error handling, savepoint management, and message capture across all ETRM rule maintenance operations.

Key Procedures and Functions

• INSERT_OVD_RUL_TMLS — Creates a new override rule term line record. It accepts a standard API version parameter, optional message list initialization, and an input record of type ovtv_rec_type. On success it returns the populated record through the output parameter, having written the row via the private API.
• UPDATE_OVD_RUL_TMLS — Modifies an existing override rule term line, applying changes to the identified record and returning the updated structure to the caller.
• DELETE_OVD_RUL_TMLS — Removes an override rule term line from the repository, typically identified by the record's primary key.
• LOCK_OVD_RUL_TMLS — Acquires a concurrency lock on the specified rule line so that subsequent updates proceed safely without conflicting with other sessions.
• VALIDATE_OVD_RUL_TMLS — Performs business rule validation of override rule term lines prior to persistence, ensuring that data meets the expected format, uniqueness, and referential criteria required by lease override processing. This is the procedure referenced by the search term "validate_ovd_rul_tmls".
• ADD_LANGUAGE — A multilingual seed procedure retained for Translation (TL) support. In this version it is effectively a no-op, having been retained for API standardization.

Every procedure follows the FND_API conventions: it accepts p_api_version, p_init_msg_list, returns x_return_status, x_msg_count, and x_msg_data, and raises the standard FND_API exceptions (G_EXC_ERROR and G_EXC_UNEXPECTED_ERROR).

Tables Accessed

The package references the APPS synonym PLITBLM, the foundation message table used by FND_MSG_PUB and FND_API for storing and retrieving error, warning, and informational messages generated during API execution. This table is read whenever the package populates x_msg_data via FND_MSG_PUB.Count_and_get on exception, and is written when FND_MSG_PUB.ADD_EXC_MSG records an unexpected error. The actual override rule term lines are written through OKL_OVT_PVT into the underlying OKL tables, so direct APPS table access by this public package is limited to the message infrastructure.

Usage Notes

OKL_OVD_RUL_TMLS_PUB is invoked whenever override rule terms must be maintained programmatically. Typical callers include the Oracle Lease Management override rule setup forms, concurrent programs that batch-load or migrate rule data, and custom extensions requiring validated rule inserts. The package is referenced by three other packages within the ETRM application, indicating its role as a shared maintained interface.

Because it is a "_PUB" API committing to the FND_API signature, custom code should call these procedures rather than accessing the underlying OKL tables directly. Callers must always pass a valid p_api_version, check x_return_status for G_RET_STS_ERROR or G_RET_STS_UNEXP_ERROR, and handle x_msg_count/x_msg_data to surface diagnostic messages. This ensures savepoint-based rollback semantics remain intact and avoids partial updates. The package is available in both EBS 12.1.1 and 12.2.2 since the underlying OKL API architecture is consistent across these releases.