Search Results rosetta_table_copy_out_p15

Overview

IBY_DBCCARD_PVT_W is a public wrapper package in the Oracle Payments (IBY) module of Oracle E-Business Suite. It exposes a set of PL/SQL procedures that support the reporting and diagnostic analysis of payment card transactions processed through the Payments debit/credit card subsystem. The package is declared with AUTHID CURRENT_USER, meaning that its procedures execute with the privileges of the invoking user rather than the package owner, which is characteristic of generated wrapper interfaces intended to be called from Forms, OAF pages, or other client-side components.

A distinctive structural feature of this package is its use of Rosetta-generated conversion routines. Each logical record type defined in the underlying IBY_DBCCARD_PVT specification is paired with a ROSETTA_TABLE_COPY_IN_xx and ROSETTA_TABLE_COPY_OUT_xx procedure. These routines translate between the package's private PL/SQL record collections and the generic JTF typed table structures (JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100) that Oracle EBS framework components can marshal across call boundaries. The user search term rosetta_table_copy_out_p15 corresponds directly to one of these generated converters, which handles the transaction failure record type.

Key Procedures and Functions

• ROSETTA_TABLE_COPY_IN_P13 — Converts JTF typed tables into the summary_tbl_type collection used internally by the package.
• ROSETTA_TABLE_COPY_OUT_P13 — Performs the inverse conversion, returning summary_tbl_type rows as separate JTF tables.
• ROSETTA_TABLE_COPY_IN_P14 — Populates the trxnsum_tbl_type transaction summary collection from JTF input tables.
• ROSETTA_TABLE_COPY_OUT_P14 — Converts trxnsum_tbl_type rows back into JTF tables for the caller.
• ROSETTA_TABLE_COPY_IN_P15 — Populates the trxnfail_tbl_type transaction failure collection from JTF inputs.
• ROSETTA_TABLE_COPY_OUT_P15 — The searched procedure; converts the trxnfail_tbl_type failure collection into four JTF number tables and one JTF_VARCHAR2_TABLE_100 table representing failure attributes.
• GET_TRXN_SUMMARY — Returns transaction summary information for a given payee and accounting period, delivering results through multiple JTF output tables.
• GET_FAILURE_SUMMARY — Returns failure summary data for a given payee and period, structured for graphical or tabular presentation.
• GET_CARDTYPE_SUMMARY — Aggregates transaction activity by payment card type.
• GET_PROCESSOR_SUMMARY — Aggregates transaction activity by card processor.

Tables Accessed

The documented table reference for this package is PLITBLM, accessible through an APPS synonym. This is the standard PL/SQL table management table used by the JTF/Forms infrastructure to bind PL/SQL index-by tables to client-side components. It supports the transport of the JTF table parameters returned by the summary procedures. No other base tables are documented as directly referenced by the wrapper; the substantive card transaction data is read by the underlying IBY_DBCCARD_PVT implementation that this wrapper invokes.

Usage Notes

The package is classified as OTHER within the ETRM API registry and is referenced by no other packages, indicating it is a terminal wrapper rather than a shared library. It is typically invoked from Oracle Payments credit/debit card inquiry forms or OAF regions where users view transaction, failure, card type, and processor summaries. The ROSETTA_TABLE_COPY_OUT_P15 routine, matched by the user's search, is called internally whenever the framework must materialize failure detail rows for display. Custom code should generally call the higher-level GET_*_SUMMARY procedures rather than the individual Rosetta converters, since the converters exist primarily to bridge the wrapper's collection types to the generic JTF table interface. Because the package runs with definer-style delegation through AUTHID CURRENT_USER, invoking sessions require appropriate execute privileges on the package and its underlying objects.