Search Results rosetta_table_copy_in_p21




Overview
Explore in AI Chat

Overview

The APPS.OKL_POPULATE_PRCENG_RST_PUB_W package is a public wrapper in the Oracle E-Business Suite Contracts (OKL / Oracle Lease and Finance Management) module. Its name indicates its role: it populates Pricing Engine results and exception stream structures returned by the pricing engine back into the application data model. The suffix _PUB_W denotes a public wrapper generated to expose the underlying package OKL_POPULATE_PRCENG_RST_PUB, which encapsulates the business logic for consuming pricing engine output.

The package is characteristic of Oracle's ETRM/Service-oriented integration pattern, in which PL/SQL collections are marshalled to and from Java-based services. The rosetta_table_copy_in_pXX / rosetta_table_copy_out_pXX procedure pairs are machine-generated "Rosetta" conversion routines that translate between database collection types and the nested-table/typed-collection structures expected by the Java Pricing Engine. This is the mechanism referenced when users search for rosetta_table_copy_out_p19.

Key Procedures and Functions

The package exposes six documented procedures:

  • ROSETTA_TABLE_COPY_IN_P19 — Copies an inbound stream table collection (typed as okl_populate_prceng_rst_pub.strm_tbl_type) into the individual JTF_VARCHAR2_* and JTF_NUMBER_TABLE collection parameters used by the pricing engine result stream structure.
  • ROSETTA_TABLE_COPY_OUT_P19 — The inverse operation: expands the individual JTF collections back into the strm_tbl_type stream structure. This is the routine sought under the "rosetta_table_copy_out_p19" search term.
  • ROSETTA_TABLE_COPY_IN_P21 — Converts inbound exception-stream collections into the strm_excp_tbl_type exception structure.
  • ROSETTA_TABLE_COPY_OUT_P21 — Expands the exception collection back into its constituent JTF VARCHAR2 arrays.
  • POPULATE_SIF_RET_STRMS — Writes returned pricing engine stream data (keyed by index number and p_sir_id) into the application structures, returning a status code.
  • POPULATE_SIF_RET_ERRORS — Persists or returns error information from the pricing engine call, capturing tag attribute name/value, description and an identifier.

Tables Accessed

The documented table reference via APPS synonym is PLITBLM, the standard Oracle Applications multi-lingual "message" table used for translated text lookups. In this context the package draws on PLITBLM to resolve language-specific text for error messages and exception descriptions returned by the pricing engine, ensuring messages surfaced to the user are rendered in the session's language.

Usage Notes

These procedures are not intended for direct invocation by end users or forms. They are invoked from the Java pricing engine integration layer, which calls the public wrapper to convert collection payloads across the PL/SQL/Java boundary. In EBS 12.1.1 and 12.2.2 the package remains a server-side integration asset owned by APPS; no other packages reference it directly. Customizations should not modify these generated conversion routines, as they are regenerated when the underlying service interface changes.