Search Results rosetta_table_copy_in_p30

Overview

OKL_STREAMS_UTIL_W is a PL/SQL wrapper package owned by the APPS schema in Oracle E-Business Suite, and is part of the Oracle Lease and Finance Management (OKL) module, commonly referred to as Oracle Lease Management. The package belongs to the ETRM (Enterprise Transaction and Reference Model) family of objects and is classified under the API classification category "OTHER." Its header comment, bearing the identifier OKLESULS.pls 120.1 and dated October 30, 2005, indicates that the object has been in place since the earlier 11i release cycle and was carried forward largely unchanged into EBS 12.1.1 and 12.2.2.

The package functions principally as an interoperability bridge for stream-processing logic. In Oracle Lease Management, "streams" refers to the sets of cash flows, payment schedules, and accounting distributions generated for lease contracts, assets, and related instruments. The OKL_STREAMS_UTIL_W package exposes a consistent set of conversion routines that translate between the strongly typed PL/SQL collections used internally by OKL_STREAMS_UTIL and the generic JTF collection types exposed to the outside world. This design allows callers such as concurrent programs, OAF pages, and Forms-based UI layers to pass bulk data back and forth without depending on internal OKL collection definitions.

Key Procedures and Functions

The package declares 49 documented procedures in total, all of which follow the ROSETTA_TABLE_COPY_IN_Pn and ROSETTA_TABLE_COPY_OUT_Pn naming pattern. The table copy pairs are used to move data into and out of an internal OKL collection type from a matching generic JTF collection type.

• ROSETTA_TABLE_COPY_IN_P1 / OUT_P1 — Convert between OKL_STREAMS_UTIL.LOG_MSG_TBL and JTF_VARCHAR2_TABLE_4000. These handle the log message table used for recording stream-processing diagnostics.
• ROSETTA_TABLE_COPY_IN_P21 / OUT_P21 — Convert between OKL_STREAMS_UTIL.CLOBTABTYP and JTF_CLOB_TABLE, supporting large-character payloads.
• ROSETTA_TABLE_COPY_IN_P22 / OUT_P22 — Convert between OKL_STREAMS_UTIL.DATETABTYP and JTF_DATE_TABLE for date-valued stream columns.
• ROSETTA_TABLE_COPY_IN_P23 / OUT_P23 and P24 / OUT_P24 — Convert between NUMBERABTTYP/NUMBER15TABTYP and JTF_NUMBER_TABLE for numeric stream values.
• ROSETTA_TABLE_COPY_IN_P25 through P29 (and their OUT counterparts) — Convert between the various fixed-width VARCHAR2 collection types (VAR10, VAR12, VAR120, VAR15) and the matching JTF_VARCHAR2_TABLE_100 or _200 types. The "_W" suffix on the package name indicates these are the wrapper-side equivalents of the underlying OKL_STREAMS_UTIL operations.

Tables Accessed

Per the ETRM metadata, the only table referenced by this package via APPS synonym is PLITBLM. This is the standard Oracle Applications "PL/SQL Integer Table" used by many EBS utilities for bulk-bind and bulk-collect operations. In this context it supports the row-by-row transfer of collection elements during the Rosetta table copy conversions. The package does not directly read or write lease contract, stream, or accounting tables; those operations are performed by the parent OKL_STREAMS_UTIL package, and the wrapper simply marshals the data across the API boundary.

Usage Notes

OKL_STREAMS_UTIL_W is not typically invoked directly by end users. It is called programmatically by Oracle Lease Management forms, OAF-based pages, and concurrent programs that need to pass bulk stream data across the PL/SQL-to-JTF type boundary. Customizations that must interact with lease stream data should generally call the parent OKL_STREAMS_UTIL package or the higher-level OKL public APIs rather than these low-level conversion routines, unless the caller is already working with JTF collection types. The package is referenced by zero other documented packages, confirming that it is a leaf-level utility. Because the object is marked noship in its header, it is shipped as part of the base product but is not intended for direct customer extension.