Results for “okl_k_headers_b”
2 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKL_RCA_PVT is a private PL/SQL package body in the Oracle E-Business Suite Lease Management (OKL) module, part of the ETRM (Enterprise Transaction and Receivables Management) product family. The package supports the Receivables Consolidation and Application (RCA) processing area, providing the low-level data manipulation routines that underpin the public Receivables Consolidation Application programming interface. Its responsibilities center on maintaining the translation and base tables that store receipt application records, particularly the language-dependent text associated with these records, and on supporting party merge operations that consolidate duplicate trading partners within the lease management data model.
As a private (PVT) API classified object, OKL_RCA_PVT is not intended for direct invocation by external consumers. It exposes the canonical private-API surface — the standard set of row-level locking, insertion, update, deletion, and validation routines — plus language maintenance and merge utilities, which are called by the public wrapper packages that present the supported interface.
Key Procedures and Functions
- QC — A quality-control placeholder procedure, defined as a no-op (NULL body) in this version.
- CHANGE_VERSION — A version-change placeholder procedure, likewise implemented as a no-op.
- API_COPY — A copy-support placeholder procedure, implemented as a no-op in this version.
- ADD_LANGUAGE — Maintains the translation table for receipt application records. It deletes orphaned translation rows that have no corresponding base row and propagates the description from the source-language row to the target-language row when the values differ.
- INSERT_ROW — Inserts a new receipt application record into the base tables.
- LOCK_ROW — Selects the target row with a locking clause to serialize concurrent access before update or deletion.
- UPDATE_ROW — Applies modifications to an existing receipt application record.
- DELETE_ROW — Removes a receipt application record and its dependent translation rows.
- VALIDATE_ROW — Performs business-rule validation on a record before it is persisted, enforcing entity integrity and domain constraints.
- OKL_RCA_PARTY_MERGE — Handles the reassignment of receipt application records when two trading partners are merged, ensuring that references to the obsolete party are redirected to the surviving party and that consolidated receivable, stream, and receipt data remain consistent.
Tables Accessed
The package operates on the receipt application entity and its translation and merge-support structures. The base entity is stored in OKL_TXL_RCPT_APPS_B and its pre-versioned view OKL_TXL_RCPT_APPS_ALL_B, with the description translation held in OKL_TXL_RCPT_APPS_TL and FND_LANGUAGES supplying the language definitions used by ADD_LANGUAGE. Receivables consolidation data is referenced through OKL_CNSLD_AR_HDRS_B, OKL_CNSLD_AR_LINES_B, and OKL_CNSLD_AR_STRMS_B, while OKL_TRX_CSH_RECEIPT_B holds the cash receipt transaction records. HZ_MERGE_BATCH is the TCA merge batch table consulted during party merge processing, and PLITBLM is the standard PL/SQL table index-by table used for in-memory collections within the package logic.
Usage Notes
OKL_RCA_PVT is invoked indirectly. The public Receivables Consolidation API and the Lease Management forms layer call these private routines to persist and validate receipt application and consolidation data. The OKL_RCA_PARTY_MERGE routine is typically triggered by the Trading Community Architecture (TCA) party merge process, which calls registered merge handlers when duplicate parties are consolidated; this ensures lease receipt application data is reassigned correctly. The ADD_LANGUAGE procedure may be called by language installation or maintenance concurrent programs. Because the package is private, custom code should not call it directly; developers should instead use the corresponding public API, which wraps the same underlying tables and enforces the supported contract.