Search Results validate_link_asset

Overview

OKL_LA_VALIDATION_UTIL_PVT is a private (PVT) PL/SQL utility package in the APPS schema that centralizes validation logic for the Oracle Lease and Finance Management (OKL) module, part of Oracle E-Business Suite 12.1.1 and 12.2.2. Despite the "LA" prefix, which in other EBS modules denotes Lease Accounting, this package serves the broader OKL contract lifecycle: it validates legal entities, parties, contacts, deals, services, fees, credit lines, and rules before those records are committed to the lease or loan contract. As an internal helper package, it is not exposed through a public API; instead it is invoked by higher-level OKL public and private packages during contract creation, quotation, amendment, and migration. It also provides reference-data lookups (such as JTOT metadata and party data) used to drive dynamic validation rules.

Key Procedures and Functions

The package exposes 17 documented procedures and functions, grouped by purpose:

• Rule and metadata retrieval: GET_RULE_JTOT_METADATA, GET_PARTY_JTOT_DATA (return metadata/party details used to drive validation checks)
• Entity validation: VALIDATE_LEGAL_ENTITY, VALIDATE_PARTY, VALIDATE_CONTACT, VALIDATE_DEAL, VALIDATE_SERVICE, VALIDATE_FEE
• Rule/role/style validation: VALIDATE_RULE, VALIDATE_ROLE_JTOT, VALIDATE_CONTACT_JTOT, VALIDATE_STYLE_JTOT
• Asset and credit-line validation: VALIDATE_LINK_ASSET, VALIDATE_CREDITLINE, VALIDATE_CRDTLN_WRNG, VALIDATE_CRDTLN_ERR

Each procedure performs field-level and cross-field edits against OKL and OKC (Contracts Core) data, raising errors when an input fails a business rule. The JTOT procedures handle dynamically defined rule attributes, while the credit-line routines validate and surface warnings/errors.

Tables Accessed

The package reads and references data through APPS synonyms across several schemas:

• Contracts Core (OKC): OKC_K_HEADERS_B, OKC_K_LINES_B, OKC_K_LINES_TL, OKC_K_ITEMS, OKC_K_PARTY_ROLES_B, OKC_GOVERNANCES — the header, line, item, party role, and governance tables that define a contract's structure.
• Rules and styles: OKC_RULE_DEF_SOURCES, OKC_SUBCLASS_RG_DEFS, OKC_LINE_STYLES_B, OKC_LINE_STYLE_SOURCES — used by the rule/style validation routines.
• Party and reference data: JTF_RS_SALESREPS_MO_V, JTF_OBJECTS_B, FND_LOOKUP_VALUES — lookup and sales-representative data.
• Application framework: AK_REGIONS, AK_REGION_ITEMS — used with the JTOT metadata retrieval routines.

Usage Notes

OKL_LA_VALIDATION_UTIL_PVT is referenced by 14 other packages, including OKL_CONTRACT_PVT, OKL_DEAL_CREATE_PUB, OKL_DEAL_CREAT_PVT, OKL_CREDIT_PUB, OKL_QUOTE_TO_CONTRACT_PVT, OKL_SEC_AGREEMENT_PVT, OKL_SERVICE_INTEGRATION_PVT, OKL_UBB_INTEGRATION_PVT, OKL_VENDOR_PROGRAM_PVT, OKL_INS_QUOTE_PVT, OKL_MLA_CREATE_UPDATE_PUB, OKL_QA_DATA_INTEGRITY, and the shared OKL_OKC_MIGRATION_PVT. Notably, OKL_OKC_MIGRATION_PVT depends on this package, which is why a search for "okl_okc_migration_pvt" surfaces OKL_LA_VALIDATION_UTIL_PVT. In practice, validation is triggered from the Lease Management forms, concurrent programs (such as data-integrity and migration routines), and custom code that calls the public OKL packages. Because the package is a _PVT (private) API, direct invocation from custom extensions is not supported; developers should call the documented public entry points that internally route through these validation routines.