Search Results rosetta_table_copy_in_p29

Overview

OKL_FORMULAVALIDATE_PVT_W is a private PL/SQL wrapper package owned by the APPS schema in Oracle E-Business Suite, part of the Oracle Knowledge Leverage (OKL) module — most commonly associated with the Contracts (OKC/OKL) and leasing-related functionality shipped with EBS 12.1.1 and 12.2.2. The package is classified as an “OTHER” API, indicating it is not intended as a public, supported integration interface but rather as an internal helper invoked by other EBS objects.

The package’s role is to bridge PL/SQL collection types used internally by the OKL formula-validation logic with the generic JTF_NUMBER_TABLE collection type exposed by the Oracle JTF (Java-based technology foundation) layer. This bridging is accomplished through generated “rosetta” procedures, which are standard Oracle wrapper artifacts produced when a PL/SQL package is exposed to a Java or web-service consumer that cannot natively understand PL/SQL record or table types. The package contains no business logic of its own; it is a marshalling layer that converts data between the strongly typed OKL_FORMULAVALIDATE_PVT.fmaopd_tbl collection and the JTF_NUMBER_TABLE array.

Key Procedures and Functions

The ETRM metadata documents two procedures for this wrapper package:

• ROSETTA_TABLE_COPY_IN_P29 — Copies an inbound JTF_NUMBER_TABLE collection into the internal OKL_FORMULAVALIDATE_PVT.fmaopd_tbl table type. It is the entry-half of the marshalling pair, used when an external caller supplies numeric data that must be consumed by the underlying formula-validation logic.
• ROSETTA_TABLE_COPY_OUT_P29 — Performs the inverse operation, copying the internal fmaopd_tbl collection back into an outbound JTF_NUMBER_TABLE collection. This is used when the results of formula validation must be returned to the external Java or web-service caller.

The “P29” suffix is a generated sequence identifier, typical of the Rosetta tooling used throughout EBS to disambiguate multiple overloaded collection-copy routines within the same package. Neither procedure implements validation, calculation, or persistence logic.

Tables Accessed

The only documented table reference is PLITBLM, accessed through an APPS synonym. PLITBLM is the Oracle / Oracle Forms “PL/SQL Interface Table” — a standard infrastructure table used by the Oracle Forms and PL/SQL web toolkit to store and manage PL/SQL table (collection) handler information. Because the Rosetta wrapper exists solely to convert between PL/SQL and JTF collection representations, its interaction with PLITBLM is procedural rather than business-data oriented; no OKL contract, formula, or validation data is persisted here. The metadata records no other table references, confirming that the package does not read or write OKL business entities.

Usage Notes

OKL_FORMULAVALIDATE_PVT_W is an internal, generated wrapper and is not intended for direct invocation by customer code. Typical invocation paths include:

• Internal calls from OKL_FORMULAVALIDATE_PVT — The “_W” (wrapper) suffix and the matching fmaopd_tbl type indicate the primary caller is the corresponding private validation package, which offloads collection marshalling to this wrapper.
• Java or web-service consumers — Because JTF_NUMBER_TABLE is the JTF-visible collection type, procedures in this package are the bridge point when an OAF page, JTT-based servlet, or web service must pass numeric arrays into OKL formula validation.
• Not invoked by concurrent programs or forms directly — The metadata records zero packages referencing this wrapper, and no form or concurrent-program registration, consistent with a low-level generated shim.

Because the package is classified as OTHER and its source is generated, customers should not modify or call it directly. Any upgrade in 12.1.1 or 12.2.2 may regenerate these procedures, and reliance on the P29 sequence identifier is not supported across patches. Supportable interaction with formula validation should go through the documented OKL public APIs.