Search Results ec_code_conversion_pvt




Overview
Explore in AI Chat

Overview

APPS.EC_CODE_CONVERSION_PVT is a private PL/SQL package body in the Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2, owned by the APPS schema. It forms part of the Oracle Trading Community / E-Commerce (EC) infrastructure and provides the low-level conversion engine that translates code values between their internal representations and their external (displayed) representations. The package is classified as a PVT (private) API, meaning it is intended to be consumed by other packages within the EC module rather than called directly by end users or external integrations. Its principal role is to resolve cross-reference (XREF) mappings stored in the trading community model so that internal codes may be presented externally, and external codes received from interfaces may be translated back to the internal values used by the application. Dependencies confirm that the body relies on EC_UTILS, EC_DEBUG, ECE_FLATFILE_PVT, FND_API, FND_MSG_PUB, ECE_XREF_CATEGORIES, ECE_XREF_DATA, and PLITBLM.

Key Procedures and Functions

The documented interface exposes six procedures and functions, of which four are principally responsible for the conversion behavior:

  • CONVERT_FROM_INT_TO_EXT — Converts one or more internal code values into their corresponding external values by resolving the appropriate cross-reference mapping for the supplied category or context.
  • CONVERT_FROM_EXT_TO_INT — Performs the inverse operation, translating externally supplied code values back into the internal values expected by the application.
  • POPULATE_PLSQL_TBL_WITH_EXTVAL — Populates a PL/SQL table (index-by table typed through PLITBLM) with external values, typically as a preparatory step for bulk conversion or downstream consumption.
  • POPULATE_PLSQL_TBL_WITH_INTVAL — Populates a PL/SQL table with internal values, supporting the reverse direction of the same bulk conversion pattern.

Together these subprograms allow both single-value and set-based conversion, with the PL/SQL-table population routines designed to avoid repeated context switches during multi-row processing.

Tables Accessed

The package reads from and, where mappings may be maintained, operates against the following documented tables via APPS synonyms:

  • ECE_XREF_CATEGORIES — Defines the cross-reference categories that group a set of related code mappings. It establishes the context in which a conversion request is resolved.
  • ECE_XREF_DATA — Stores the actual cross-reference pairs (internal value and external value) belonging to each category. This is the principal lookup source for both INT-to-EXT and EXT-to-INT conversions.
  • PLITBLM — A public PL/SQL index-by table type used to hold the internal or external value collections populated by the POPULATE_PLSQL_TBL_WITH_INTVAL and POPULATE_PLSQL_TBL_WITH_EXTVAL routines.

Usage Notes

As a PVT API, EC_CODE_CONVERSION_PVT is not intended for direct invocation. It is referenced by approximately thirteen other packages within the EC and trading community modules, which call its conversion routines whenever a code must cross the boundary between internal storage and external presentation — for example, when formatting data for outbound flat-file interfaces or when interpreting inbound interface records. Because it depends on FND_API and FND_MSG_PUB, callers can expect standard EBS error handling and message-stack integration. Developers extending or debugging EC conversions should therefore favor the public APIs that wrap this package rather than calling EC_CODE_CONVERSION_PVT directly, and should verify that the relevant ECE_XREF_CATEGORIES and ECE_XREF_DATA mappings exist before expecting a successful conversion.