Search Results rosetta_table_copy_in_p74




Overview
Explore in AI Chat

Overview

The APPS.OKL_POOLCONC_PVT_W package body is a private PL/SQL wrapper belonging to the Oracle Lease and Finance Management (OKL) module of Oracle E-Business Suite. Its name derives from the pool concentration and pooling functionality used in lease contracts and asset pools. The package provides the interface layer that supports pool contents maintenance screens, supplying both the conversion utilities required to marshal Oracle Forms data structures into PL/SQL collections and the public entry points used by the UI to add or clean up pool contents.

The "_W" suffix and the "rosetta" helper routines identify this object as part of the Oracle ETRM/Forms-to-PLSQL integration framework. This framework translates between Java or Forms table structures (JTF_VARCHAR2_TABLE_2000) and PL/SQL associative-array types used by the underlying business logic. The package is classified as an OTHER API rather than a public or private API, indicating it is an internal support package not intended for direct customer invocation, though it remains visible in the data dictionary.

Key Procedures and Functions

  • ROSETTA_TABLE_COPY_IN_P74 — Converts an inbound JTF_VARCHAR2_TABLE_2000 collection into the OKL_POOLCONC_PVT.ERROR_MESSAGE_TYPE associative array used internally by pool concentration processing. It iterates across the source collection from FIRST to LAST and copies each element into the target index structure.
  • ROSETTA_TABLE_COPY_OUT_P74 — The inverse operation. It accepts an OKL_POOLCONC_PVT.ERROR_MESSAGE_TYPE parameter and populates an out JTF_VARCHAR2_TABLE_2000 collection. If the source is null or has zero elements, the target is initialized as an empty table; otherwise it is extended and filled index by index. This is the routine referenced when a caller resolves the object through documentation lookup keyed on rosetta_table_copy_out_p74.
  • ADD_POOL_CONTENTS_UI — The user-facing entry point invoked to attach assets or lines to a lease pool from the pool contents form. It coordinates validation and persistence against the POOL contents records.
  • CLEANUP_POOL_CONTENTS_UI — Removes or resets pool content entries originating from the UI session, ensuring transient staging data and pooled line assignments are cleared consistently.

In addition, two private date and number mapping helpers (ROSETTA_G_MISS_DATE_IN_MAP and ROSETTA_G_MISS_NUM_MAP) are defined to normalize sentinel values such as FND_API.G_MISS_DATE and FND_API.G_MISS_NUM, working around known JDBC handling issues for boundary date values.

Tables Accessed

The package references a single documented table via APPS synonyms: PLITBLM. This is the Oracle Forms/PL/SQL interoperability table used by the Rosetta framework to convey bulk collections between the middle tier and the database. It is consulted during the copy-in and copy-out marshalling operations that move error message and pool data collections across the API boundary. No direct DML on OKL pool base tables is documented in the wrapper itself; persistent changes to pool contents are delegated to the underlying OKL_POOLCONC_PVT package.

Usage Notes

This package is invoked indirectly rather than directly. In a typical Oracle E-Business Suite 12.1.1 or 12.2.2 environment, the pool contents maintenance form calls the add and cleanup entry points, which in turn invoke the Rosetta conversion routines to populate error message collections returned to the form for display. Because the package is classified as OTHER and is referenced by zero other packages, it should not be called from custom concurrent programs or third-party code. Any customization that needs to manipulate pool contents should be built on the supported public APIs in OKL_POOLCONC_PVT instead. The package is compiled on the 12.1.1 and 12.2.2 technology stacks without changes; its header revision ($Header: OKLESZCB.pls 120.2) reflects a 2007 build that remains compatible with both releases.