Search Results visible_option_value




Overview
Explore in AI Chat

Overview

The AZ_PROFILEVALUE_CONVERT_PKG package body, owned by APPS and classified as an OTHER API in ETRM, provides the internal conversion and parsing utility layer used by Oracle E-Business Suite when profile option values must be translated between their stored representation and a form suitable for a target column or datatype. It is part of the Applications Technology (AZ) profile-management component that supports the Profile Values setup and migration screens.

The header comment ($Header: azprofcvtb.pls 120.3 2006/02/14) indicates a 2006 baseline that has remained stable across the 12.1.1 and 12.2.2 releases. The user search term visible_option_value reflects the profile-value attribute that this package ultimately supports: profile option values are frequently stored as a concatenated or delimited string, and the package supplies the string-scanning and decomposition routines required before such values can be presented or written back as individual visible option values.

Key Procedures and Functions

  • CONVERT — The principal entry point of the package. It performs the profile value conversion requested by the caller, orchestrating the supporting lookup and parsing logic to return the converted value.
  • GET_TAB_COL_TYPE — Returns the datatype of a column on a given table, allowing the conversion logic to adapt its output formatting to the target column definition.
  • GET_TABLE_OWNER — Resolves the owning schema of a table, used to qualify object names when the conversion must read from or write to a specific table.
  • GET_TABLEVIEW_OWNER — Resolves the owner of a table or view, extending ownership resolution to view-based sources referenced during conversion.

The package also contains internal helper functions defined in the body but not exposed in the documented API list, notably SEARCH_SUBSTR and SEARCH_SUBSTR_REVERSE for locating delimiters and PARSE_COMMA for splitting a delimited profile string into four output segments. These helpers account for quoted substrings so that embedded commas inside a quoted value are not treated as separators.

Tables Accessed

  • FND_PROFILE_OPTIONS — The core profile option definition table, read to resolve the option being converted and its value semantics.
  • FND_ORACLE_USERID — Provides Oracle schema and user identity information used during owner resolution.
  • FND_TABLES — Supplies registered table metadata consulted by the ownership and type lookups.
  • DBA_TAB_COLUMNS and USER_TAB_COLUMNS — Data dictionary views read to determine column datatypes and existence for the target of the conversion.
  • USER_SYNONYMS — Used to resolve synonyms to their underlying base objects when determining table or view ownership.

Usage Notes

AZ_PROFILEVALUE_CONVERT_PKG is an internal, non-public API and is not referenced by any other documented package (referenced-by count of 0). It is invoked indirectly from the profile option maintenance forms and from concurrent or upgrade routines that migrate profile values between releases or between instances. Because the documented signature of CONVERT is not published in the metadata, custom code should not call it directly; developers requiring comparable behavior should instead use supported profile APIs such as FND_PROFILE. The package operates exclusively against APPS synonyms and dictionary views, so it requires an APPS-privileged session and performs no DDL beyond read-only dictionary interrogation.