Search Results rrs_attr_pane




Overview
Explore in AI Chat

Overview

RRS_ATTR_PANE is an Oracle E-Business Suite package owned by the APPS schema and classified under the ETRM taxonomy as OTHER (a general-purpose API rather than a public or private interface). It belongs to the Oracle Product Information Management (PIM) / EGO attribute framework and supports the runtime rendering of attribute pages used for capturing and displaying descriptive flexfield-style attribute data on objects such as items, item categories, and other UDA (User Defined Attribute) enabled entities.

The package is declared AUTHID CURRENT_USER, meaning its SQL executes under the privileges of the calling session rather than the package owner. This is significant because callers must therefore have direct access to the underlying EGO attribute views and related tables. Its two central entry points, Get_Primary_Attributes and Get_Attribute_Page, resolve the set of attributes applicable to a given object type and object ID, returning structured records and PL/SQL collection types that forms and other consumers can render. Several helper routines, including GET_DISPLAY_VALUE, GET_DISP_VALUE_WITHOUT_UOM, and TO_CLIENT_TIMEZONE, handle value formatting and presentation-time conversion.

Key Procedures and Functions

  • GET_PRIMARY_ATTRIBUTES — Returns the primary attribute record set for a given object type and object ID, along with any error messages collected during processing.
  • GET_ATTRIBUTE_PAGE — The principal driver that assembles a complete attribute page, including primary attributes, attribute group page entries, attribute groups, and individual attributes for the supplied where-used context and object identifiers.
  • GET_DISPLAY_VALUE — Resolves the display representation of an attribute value, applying display code and display meaning rules so that the UI shows the formatted value rather than the raw stored code.
  • GET_DISP_VALUE_WITHOUT_UOM — Returns the formatted display value of an attribute while suppressing any attached unit-of-measure qualification. This is the routine users most commonly search for, as it is used when the UOM should not appear alongside the value (for example, in summary or comparison views).
  • TO_CLIENT_TIMEZONE — Converts a supplied date/time value into the client timezone, ensuring date attributes render consistently for the end user's locale.
  • RECORD_ERROR — Appends an error message to the package's standard error message table, allowing callers to accumulate and surface validation or retrieval failures.

The package also declares several PL/SQL record and table types, including t_attribute_rec, t_attribute_tab, t_page_entry_rec, t_page_entry_tab, array_of_string, and attr_info_rec, plus named exceptions such as e_no_uda, e_no_page_found, and e_no_attribute_found.

Tables Accessed

  • FND_FLEX_VALIDATION_TABLES — Used to resolve flexfield validation information associated with attribute value sets.
  • MTL_UOM_CONVERSIONS — Referenced when unit-of-measure handling is required, supporting the distinction between GET_DISPLAY_VALUE and GET_DISP_VALUE_WITHOUT_UOM.
  • RRS_ATTR_PAGE_SETTINGS — Supplies page layout and grouping configuration that governs how attributes are presented.
  • RRS_SITE_GROUP_VERSIONS and RRS_SITE_USES — Provide site and group version context, determining which attribute configurations apply to the current object.
  • DUAL, DBMS_OUTPUT, DBMS_UTILITY, PLITBLM — Standard utility and diagnostic references used for internal processing and debugging output.

Usage Notes

RRS_ATTR_PANE is typically invoked from Oracle Forms attribute-rendering blocks and from custom PL/SQL code that needs to display or validate UDA values. Because it is AUTHID CURRENT_USER and referenced by no other packages, it operates as a leaf-level utility rather than a shared framework entry point. Callers should handle its declared exceptions explicitly and inspect the returned error message table. When displaying values without unit-of-measure text, GET_DISP_VALUE_WITHOUT_UOM is the appropriate routine; use GET_DISPLAY_VALUE when the UOM qualifier must be preserved. Date attributes should be passed through TO_CLIENT_TIMEZONE before display to respect the user's timezone.