Search Results rosetta_table_copy_out_p18

Overview

OKL_PAYMENT_PVT_W is a private PL/SQL wrapper package in the Oracle E-Business Suite Applications (APPS) schema that belongs to the Oracle Lease Management (OKL) product family. It exposes the payment creation logic of the underlying OKL_PAYMENT_PVT package through an Oracle Forms–friendly interface. In Oracle EBS, a "_W" suffix conventionally denotes a wrapper generated to bridge PL/SQL business logic to the Oracle Forms client, which cannot directly consume certain PL/SQL collection types. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer, and it is classified as an OTHER API type within the ETRM repository. Its principal business function is to create lease payment records and return the resulting payment reference and cash receipt identifiers to the calling form or program.

Key Procedures and Functions

The package declares three documented procedures:

• ROSETTA_TABLE_COPY_IN_P18 — Copies data from a set of JTF_NUMBER_TABLE parameters into the okl_payment_pvt.payment_tbl_type PL/SQL record collection. This is an inbound conversion routine that translates Forms-compatible numeric tables into the structure expected by the internal payment API.
• ROSETTA_TABLE_COPY_OUT_P18 — Performs the inverse operation, copying data from a payment_tbl_type collection back out into JTF_NUMBER_TABLE parameters for consumption by the Forms layer.
• CREATE_PAYMENTS — The primary business procedure. It accepts the standard EBS API control parameters (API version, initialization message list, commit flag, validation level) along with a set of positional input attributes and the converted numeric tables, and returns the standard output parameters (return status, message count, message data) plus the payment reference number and cash receipt identifier.

Tables Accessed

The ETRM documentation lists a single referenced table, PLITBLM, accessed through an APPS synonym. The name follows the convention of Oracle Forms PL/SQL table storage objects, used to hold the temporary collections passed between the client and the database. No other base tables are recorded as directly referenced by this wrapper, indicating that the substantive payment persistence logic resides in the underlying OKL_PAYMENT_PVT package that this wrapper delegates to.

Usage Notes

OKL_PAYMENT_PVT_W is invoked from Oracle Lease Management payment entry forms when a user records a lease payment and the application requires both a generated payment reference number and an associated cash receipt identifier. The presence of the Rosetta copy-in and copy-out routines reflects the classic EBS Forms integration pattern: data is marshalled into the expected collection type on entry and unmarshalled on exit. Because the package is not referenced by any other database package in the documented metadata, it is a terminal integration point rather than a building block for further server-side logic. Customizations that need to create lease payments programmatically should generally call the base OKL_PAYMENT_PVT API directly, since calling the wrapper outside a Forms context forfeits the benefit of the Rosetta conversions. Any extension of this package must preserve its wrapper contract, as the generated code should not be modified in place; supported extensions belong in the corresponding CUSTOM package.