Search Results jtf_clob_table




Overview
Explore in AI Chat

Overview

OKS_ENTITLEMENTS_PUB_W is a public wrapper package in the APPS schema that fronts the Oracle Service (OKS) entitlements API, OKS_ENTITLEMENTS_PUB. In Oracle E-Business Suite 12.1.1 and 12.2.2, entitlement records define the service coverage, warranty terms, and support agreements that a customer holds against a product or service item. The "_PUB_W" wrapper exists to expose that core business logic to interfaces that cannot call the underlying API directly, and specifically to marshal bulk data through the JTF collection types that Oracle's framework uses for tabular PL/SQL-to-PL/SQL and Java-to-PL/SQL communication.

Its dependency on JTF_CLOB_TABLE, JTF_DATE_TABLE, JTF_NUMBER_TABLE, and the family of JTF_VARCHAR2_TABLE types (100, 200, 300, 500, 600, and 2000) confirms its role as a bulk data bridge. The user search term "jtf_clob_table" maps directly to this object: the package declares a JTF_CLOB_TABLE collection dependency, indicating that it can accept or return large character payloads such as entitlement text, descriptive fields, or serialized structures in addition to the numeric, date, and varchar2 arrays.

Key Procedures and Functions

The package body exposes 59 documented entry points. The documented set is dominated by paired ROSETTA_TABLE_COPY procedures, each with an IN and an OUT variant: ROSETTA_TABLE_COPY_IN_P4 / _OUT_P4, _P16, _P19, _P22, _P26, _P30, _P34, _P38, _P41, and _P44.

  • ROSETTA_TABLE_COPY_IN_Pn — Cop

ies a source JTF collection (for example JTF_NUMBER_TABLE or a JTF_VARCHAR2_TABLE_n) into an entitlement-side table structure for the record group identified by the suffix n. The "_P" number is an internal partition or parameter-group index that allows the same generic copy logic to be reused across differently shaped payloads.

  • ROSETTA_TABLE_COPY_OUT_Pn — Performs the reverse copy, moving entitlement data out into the JTF collection types so a calling layer (typically an OAF/BC4J middle tier or a Java integration) can consume the rows.

The "ROSETTA" naming reflects the conversion of one table representation into another. No parameter lists are documented in the ETRM metadata, so signatures must be inspected in the database before any direct call.

Tables Accessed

The only table recorded as referenced through an APPS synonym is PLITBLM, the PL/SQL Table Management table used by Oracle's collection framework to persist or stage collection data. The JTF_CLOB_TABLE and related JTF_*_TABLE types are not physical tables but in-memory PL/SQL collection definitions; their presence in the dependency list identifies them as the interface contract for this wrapper. Actual entitlement rows are read and written indirectly through OKS_ENTITLEMENTS_PUB, which this wrapper depends on.

Usage Notes

OKS_ENTITLEMENTS_PUB_W is a framework-level wrapper rather than a customer-facing API. It is invoked when a bulk entitlement operation must cross a PL/SQL boundary that requires JTF collection types — for example, an OAF page or Java call passing many entitlement rows in one round trip. The ETRM record shows zero other packages referencing it, so it is not called by standard concurrent programs; invocation is expected from framework-generated code or custom integrations that already use the JTF table types. Because the package is documented as VALID with an OTHER API classification, developers should treat it as internal, confirm each procedure's signature in the database, and prefer the documented OKS_ENTITLEMENTS_PUB procedures for new custom code.