Search Results pvx_utility_pvt_w




Overview
Explore in AI Chat

Overview

APPS.PVX_UTILITY_PVT_W is the package body of a private PL/SQL utility package that belongs to the Oracle E-Business Suite Process Manufacturing (Process Manufacturing / ETRM, formerly OPM) product family. The PVX prefix identifies the module as part of the Process Execution / process utility layer, and the _PVT_W suffix denotes a private wrapper package generated or maintained to expose utility logic to other components of the same module. Its status in ETRM 12.2.2 is documented as VALID, meaning the compiled body resolves all of its dependencies without error.

The package provides a set of low-level helper routines that support process manufacturing transactions: timezone conversion for date-sensitive processing, business day calculation for scheduling, history logging for audit and traceability, and structured table copy operations used when moving data between internal PL/SQL collections and the database. Because the API is classified as OTHER (a private/internal API rather than a public or open API), it is intended for consumption by other PVX packages and standard Oracle EBS code rather than by general integrations.

Key Procedures and Functions

The documented interface exposes five procedures and functions:

  • ROSETTA_TABLE_COPY_IN_P11 — Copies data from an externally supplied table or collection into the internal PL/SQL table structure used by the process utility layer. The _P11 naming convention indicates a private variant keyed to a specific internal staging pattern.
  • ROSETTA_TABLE_COPY_OUT_P11 — The inverse operation, copying data from the internal PL/SQL table structure back out to the caller-supplied structure.
  • CONVERT_TIMEZONE — Converts a date or timestamp value between timezones, allowing process manufacturing transactions to be evaluated consistently regardless of the operating unit or user session timezone.
  • CREATE_HISTORY_LOG — Writes an audit/history record for a process manufacturing operation, capturing the event details required for traceability.
  • GET_BUSINESS_DAYS — Calculates the number of business days between two dates (or derives a business-day offset), supporting lead-time and scheduling logic that must observe the manufacturing calendar.

Tables Accessed

The only table referenced by the package through APPS synonyms is PLITBLM. This is the standard Oracle EBS table used to store temporary PL/SQL tables (index-by tables) referenced by the PL/SQL Interactive Table Manager, PLITBLM. It is used here to persist intermediate results during the ROSETTA_TABLE_COPY_IN_P11 and ROSETTA_TABLE_COPY_OUT_P11 operations, enabling a collection to be accessed across call boundaries as though it were a database-resident table. No application data tables are directly read or written by this package; all business data manipulation is delegated to the parent package PVX_UTILITY_PVT.

Usage Notes

PVX_UTILITY_PVT_W is not referenced by any other database object, which confirms its role as a leaf-level private helper invoked only from within the PVX_UTILITY_PVT package body and from the wrapper package PVX_UTILITY_PVT_W's specification. It is not exposed through Oracle Forms, concurrent programs, or public APIs, and should not be called directly from custom code. When extending or debugging process manufacturing functionality around timezone handling, business day calculations, or history logging, developers should trace through PVX_UTILITY_PVT rather than this package. Dependency analysis shows the body relies on FND_API, the JTF_VARCHAR2_TABLE_100 and JTF_VARCHAR2_TABLE_2000 collection types, and the PLITBLM synonym, reflecting a standard Oracle EBS utility design pattern.