Search Results as_utility_pub_w




Overview
Explore in AI Chat

Overview

AS_UTILITY_PUB_W is the package body of the public utility API belonging to the Oracle E-Business Suite Applications Service (AS) module, which underpins field service, depot repair, and related service management functionality. The "_W" suffix denotes that the entry points are thin PL/SQL wrappers, typically generated to expose the argument shapes used by Oracle Forms, Java clients, or XML-based integrations that require weakly typed or overloaded call signatures. In the 12.1.1 and 12.2.2 releases the package is owned by APPS and holds a VALID status in the data dictionary.

The package exists to support bulk transport of tabular data between heterogeneous representations — most notably between declared PL/SQL collections and generic tables — using the "Rosetta" copy convention. It relies on FND_API for the standard API return status and message stack, and on the JTF_*_TABLE collection types defined in the JTF foundation layer, rather than redefining its own structures.

Key Procedures and Functions

The documented interface of AS_UTILITY_PUB_W consists of four public entry points, generated as paired copy-in / copy-out operations at two different maximum sizes:

  • ROSETTA_TABLE_COPY_IN_P6 — Copies positional data into a table structure, using a fixed-width argument pattern with a maximum of six value positions per row.
  • ROSETTA_TABLE_COPY_OUT_P6 — Copies positional data out of a table structure back to the caller, again with a maximum of six value positions per row.
  • ROSETTA_TABLE_COPY_IN_P10 — Identical in purpose to _P6 but supporting up to ten value positions per row.
  • ROSETTA_TABLE_COPY_OUT_P10 — The ten-position copy-out counterpart, returning columnar values from a table structure to the client.

Detailed signatures are deliberately omitted here; the arguments are generated and must be confirmed against the live package specification. No signature may be assumed.

Tables Accessed

The only documented table reference is PLITBLM, reached through an APPS synonym. PLITBLM is a standard Oracle-supplied utility table (the name derives from "PL/I table, long raw, memory") used as a scratch buffer for bulk operations and by standard Oracle packages for DDL and compilation activities. The Rosetta copy routines use this table as the staging area for row-wise data movement, allowing values to be written and read within a single database session without mutating any application-owned transactional schema.

The package also depends on the JTF collection types JTF_DATE_TABLE, JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_300, and JTF_VARCHAR2_TABLE_400, which define the in-memory matrix shapes exchanged with callers.

Usage Notes

AS_UTILITY_PUB_W is a utility package rather than a business API, and is invoked indirectly. Typical callers are other PL/SQL packages within the AS and JTF stack, Oracle Forms service screens, and Java or XML Gateway integrations that need to marshal set-based data into and out of the service module. It is not referenced by any other database object per the dictionary dependency view, confirming its role as a leaf-level utility rather than a shared hub.

Because the package is generated, it should never be modified in place. Any hook, override, or customisation belongs in a supported extension or a custom wrapper package. Note that 8 other packages currently reference this object, so its behaviour is in the live call chain for service-related processing; changes to underlying collection types or the PLITBLM buffer contract would break those dependants and should be treated as a code freeze zone.