Search Results field_name_properties




Overview
Explore in AI Chat

Overview

The APPS.GR_FIELD_NAME_PROPERTIES_PUB package body is the public API layer of the Process Manufacturing (OPM) Field Name Properties maintenance facility, part of the Oracle E-Business Suite (EBS) Process Manufacturing/Quality module stack. It is classified as a PUB (public) API, which designates it as a supported, externally callable interface intended to be used by other Oracle applications, forms, and customer extensions rather than being restricted to internal framework use. The package exposes a single entry point, FIELD_NAME_PROPERTIES, which drives the maintenance of field-name metadata — including property identifiers, property type indicators, length, precision, numeric range limits, language attributes, descriptions, and label/property value rows — for configurable fields used within the OPM data model.

Because the object is a package body, it contains the implementation of the specification's public contract plus private helper logic. The header comment declares the package's contents as FIELD_NAME_PROPERTIES and describes it as "the public layer for the FIELD_NAME_PROPERTIES API." The package was written and later maintained by P A Lowe / Peter Lowe in 2008–2009 (header revision 120.1.12010000.2).

Key Procedures and Functions

  • FIELD_NAME_PROPERTIES — the sole documented public procedure. It is the multipurpose transactional entry point for creating, updating, and otherwise maintaining field-name property definitions and their associated label/property values. It accepts API-standard control parameters (p_api_version, p_init_msg_list, p_commit), an action indicator (p_action), an object qualifier (p_object), property identity and attribute parameters (p_property_id, p_property_type_indicator, p_length, p_precision, p_range_min, p_range_max, p_language, p_source_language, p_description), a PL/SQL collection of label/property values (p_label_prop_values_tab), and standard output parameters (x_return_status, x_msg_count, x_msg_data). Parameters are intentionally not repeated here beyond naming; callers should reference the specification for the authoritative signature.
  • Private helper set_debug_flag — returns a debug indicator based on the current FND_LOG runtime level; it is internal to the body and is used to populate the global l_debug variable.

Tables Accessed

  • GR_PROPERTIES_B — base table holding property definitions; the API reads and writes property header rows.
  • GR_PROPERTIES_TL — translation table for property attributes such as descriptions and language-specific text.
  • GR_PROPERTY_VALUES_TL — translation table for property value / label rows.
  • FND_LANGUAGES — used to validate language codes and drive translated content.
  • PLITBLM — an OPM/PLI staging table referenced by the API's processing logic.

Usage Notes

The package is a PUBLIC API and is therefore safe to invoke from custom PL/SQL, Oracle Forms-based setup screens, and concurrent programs that need to programmatically manage OPM field-name properties. Typical callers set p_commit to FND_API.G_TRUE to control the transaction boundary, and inspect x_return_status and the standard message stack (x_msg_count, x_msg_data) for error handling. Because the metadata records zero referencing packages, it has no in-tree dependents registered, but downstream applications and customer extensions remain the primary consumers. As with all PUB APIs in EBS 12.1.1 and 12.2.2, callers should always pass p_api_version and must not rely on undocumented internal procedures.