Search Results p_data_type

Overview

IEU_WP_UI_COMP_DATATYPES_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It belongs to the Interaction Tracking / Internet Expenses User Interface (IEU) product family, which underpins the "iExpenses" and related web-based interaction components. In the Oracle EBS 12.1.1 and 12.2.2 releases, this package functions as a low-level data manipulation API for the IEU_WP_UI_COMP_DATATYPES table, which stores the mapping between user interface components and the data types they accept or emit.

The package is classified in the ETRM documentation as an "OTHER" API, meaning it is not a fully supported public interface. It exists primarily to provide controlled insert, update, delete, and bulk-load operations against its underlying table, likely invoked by internal IEU seeding utilities, concurrent programs, or upgrade loaders rather than by external customizations. Its header comment dates to 2005, indicating the package has been stable across multiple EBS releases and was carried forward essentially unchanged into the 12.2.x code line.

Key Procedures and Functions

• INSERT_ROW — Inserts a new mapping row into IEU_WP_UI_COMP_DATATYPES. It accepts the primary key map identifier, the associated UI component identifier, object version number, standard WHO audit columns, and the p_data_type value that names the data type being mapped.
• LOCK_ROW — Acquires a row-level lock on an existing mapping record for the specified map identifier, UI component, and data type, using the object version number for optimistic concurrency control.
• UPDATE_ROW — Modifies the data type or audit columns of an existing mapping row identified by the map identifier and UI component.
• DELETE_ROW — Removes a mapping row based solely on the primary key map identifier.
• LOAD_ROW — Performs a bulk-style load of a mapping row, accepting the map identifier, UI component, data type, and an owner parameter. It is intended for programmatic or setup-data ingestion rather than interactive entry.
• LOAD_SEED_ROW — A seed-data variant of LOAD_ROW that adds an upload-mode parameter, allowing callers to distinguish seeding or upgrade scenarios from ordinary loads.

Tables Accessed

The package reads and writes the IEU_WP_UI_COMP_DATATYPES table, accessed through an APPS synonym. This table holds the association between UI component definitions and their corresponding data types, forming part of the metadata that drives the IEU web user interface. All insert, lock, update, delete, and load operations target this single table. The ETRM metadata records no additional tables, and the package is not referenced by any other documented package, confirming its role as a leaf-level DML layer rather than a shared utility.

Usage Notes

Because IEU_WP_UI_COMP_DATATYPES_PKG is documented as an OTHER API, Oracle does not guarantee its signature or behavior across releases; customers should avoid calling it directly from custom code unless no supported alternative exists. In practice the package is invoked internally by IEU setup, seeding, and upgrade processes and possibly by concurrent programs that load UI component metadata. The p_data_type parameter appearing across INSERT_ROW, LOCK_ROW, UPDATE_ROW, LOAD_ROW, and LOAD_SEED_ROW is the central business attribute: it records the data type associated with each UI component mapping. When troubleshooting the search term "p_data_type", note that it is a VARCHAR2 column value, not a key, and it participates in locking and update matching. Developers tracing issues should verify the map identifier and UI component combination, the object version number for concurrency, and the WHO audit columns required by the insert and update routines.