Search Results rosetta_table_copy_out_p1

Overview

The APPS.AMS_IBA_SEGMENTS_PUB_W package body belongs to the Oracle Advanced Marketing (AMS) module and forms part of the Marketing Segmentation infrastructure. Its principal role is to expose PL/SQL table data associated with party marketing segments to Java-based or middleware callers through the Rosetta-style JDBC wrapper convention. In Oracle EBS 12.1.1 and 12.2.2, packages suffixed with _PUB_W act as public wrappers that bridge the strongly typed PL/SQL collection types used internally by the AMS private APIs and the generic JTF_NUMBER_TABLE structures consumed across the JTT/JTF technology stack.

The package is classified under the ETRM metadata as API classification OTHER. It is not an end-user business API in the conventional sense; rather it is a generated Rosetta bridge layer. This is evident from the naming conventions and the presence of the so-called "mistake date" sentinel values rosetta_g_mistake_date and rosetta_g_miss_date, which are date constants used to detect and translate the FND_API.G_MISS_DATE sentinel across the JDBC boundary.

Key Procedures and Functions

• ROSETTA_TABLE_COPY_IN_P1 — Copies an inbound generic JTF number table structure into the strongly typed AMS segment collection (AMS_MKT_SEGMENTS_PVT.PARTYMKTSEGTABTYP). It iterates over the inbound arrays and maps values into the target segment identifier and campaign identifier attributes. Sentinel numeric values are normalized through the ROSETTA_G_MISS_NUM_MAP helper.
• ROSETTA_TABLE_COPY_OUT_P1 — The inverse of the copy-in operation, and the procedure most directly implicated by the search term. It accepts a populated PARTYMKTSEGTABTYP collection and writes it out to two JTF_NUMBER_TABLE arrays, one holding target segment identifiers and one holding campaign identifiers. If the source collection is null or empty, both output arrays are initialized as empty tables. Numerical sentinel values are again remapped so that Java callers receive the expected representation.
• GET_MKT_SEGMENTS_W — The primary retrieval entry point exposed to callers. It obtains marketing segment data and returns it in the JDBC-compatible format expected by the Rosetta layer.

Tables Accessed

The documented table reference for this package is PLITBLM, accessed through an APPS synonym. This is the standard PL/SQL table storage table used by the Oracle EBS Toolbox/Rosetta infrastructure to hold and transfer TABTYPE and TABTYP collection data between the database and middle-tier Java code. The package therefore does not directly query the AMS marketing segment base tables within these wrapper procedures; segment data originates from AMS_MKT_SEGMENTS_PVT and is materialized into PLITBLM through the generic Toolkit collection persistence mechanism.

Usage Notes

This package is invoked programmatically rather than from an Oracle Forms block or a standard concurrent program. It is called by Java or JSP components within the Marketing module that need to read or write party marketing segment assignments across the JDBC boundary. The ETRM metadata records that the package is referenced by zero other PL/SQL packages, confirming it is a leaf-level wrapper consumed only from the middle tier.

Because the procedures rely on positional JTF_NUMBER_TABLE arguments, customizations should not alter argument ordering or the sentinel mapping behavior. Any extension of the underlying segment structure would require regeneration of the wrapper by the EBS Toolbox to remain synchronized with PARTYMKTSEGTABTYP.