Search Results rosetta_table_copy_in_p10

Overview

AS_UTILITY_PUB_W is a public wrapper package in the Oracle E-Business Suite APPS schema that exposes the bulk data-copy routines defined by AS_UTILITY_PUB, a utility package belonging to the Applications/Service (AS) product family. Its business purpose is to move Oracle Applications data between the relational tables of the EBS database and the nested PL/SQL collection types used by Java-based, middle-tier, or service-oriented integrations. The "_W" suffix identifies it as a generated wrapper, and the "rosetta" naming convention indicates that the procedures perform columnar transformation — reading a set of array parameters and assembling them into a strongly typed record, or decomposing that record back into parallel arrays. In the ETRM classification this object carries an API classification of OTHER, reflecting that it is an internal, generated artifact rather than a supported business API. It is documented against Oracle EBS 12.1.1 and 12.2.2 and is owned by APPS.

The package is relevant to the search term "rosetta_table_copy_in_p10" because that procedure is one of its four documented entry points. It handles the bulk conversion of the ITEM_PROPERTY_TBL_TYPE structure, a table of item-property records used when Applications data is passed across the JDBC/PLSQL boundary.

Key Procedures and Functions

The package declares four procedures, all of which are overloaded variants of the two directions of the rosetta table copy:

• ROSETTA_TABLE_COPY_IN_P6 — Copies inbound data into the PROFILE_TBL_TYPE collection. The name and "_P6" suffix indicate it targets the sixth distinct record layout supported by the parent package, and it accepts six array parameters representing the attributes of the profile record.
• ROSETTA_TABLE_COPY_OUT_P6 — The inverse of the inbound routine, decomposing a populated PROFILE_TBL_TYPE collection back into its constituent arrays for return to the calling layer.
• ROSETTA_TABLE_COPY_IN_P10 — Copies inbound data into the ITEM_PROPERTY_TBL_TYPE collection. Its six array arguments supply the columns of each item-property row, and the OUT NOCOPY mode avoids a redundant copy of the assembled collection.
• ROSETTA_TABLE_COPY_OUT_P10 — Decomposes an ITEM_PROPERTY_TBL_TYPE collection into six output arrays, mirroring the inbound routine for the outbound direction.

Each procedure follows the same contract: a single strongly typed collection parameter and a fixed number of parallel array parameters whose element types are drawn from the JTF_VARCHAR2_TABLE, JTF_NUMBER_TABLE, and JTF_DATE_TABLE families. No parameter lists beyond those documented are described here.

Tables Accessed

The only table documented as referenced through APPS synonyms is PLITBLM. This table is a persistent store for PL/SQL nested table and index-by table data used by Oracle Application Object Library and related technology components, and its presence reflects the package's role in materializing and retrieving collection payloads rather than in maintaining a business entity. The rosetta procedures themselves operate on in-memory collections; PLITBLM supports the underlying collection handling performed by the AS_UTILITY_PUB infrastructure that this wrapper exposes.

Usage Notes

AS_UTILITY_PUB_W is an internal wrapper and is not intended for direct invocation by customers or partners. It is most commonly reached indirectly, either through the public AS_UTILITY_PUB package or from the Java and middle-tier components that call the generated wrapper to marshal arrays across the PL/SQL interface. Because the ETRM metadata records that the package is referenced by eight other packages, it should be treated as a shared dependency: changes to its signature or behavior propagate to all callers. Developers encountering rosetta_table_copy_in_p10 while tracing a stack should recognize it as a data-conversion step for item-property collections, and should not modify or overload it. Any enhancement should be pursued through the supported public API in AS_UTILITY_PUB, with the wrapper regenerated as required.