Search Results get_attribute_list_values




Overview
Explore in AI Chat

Overview

AK_RUN_FLOW_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM taxonomy as an "OTHER" API rather than a standard public interface. Its name and the single documented entry point indicate that it belongs to the Oracle Application Framework's underlying "AK" (Application Kit) family of components, which supports the runtime behavior of attribute-driven regions and descriptive flexfield-like value lists within the EBS framework layers. The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling session rather than with the definer's rights, a common pattern for framework utility code that must respect the caller's security context when reading metadata and temporary data.

The header comment ($Header: akdrunfs.pls 115.2 99/07/17) shows the source was last revisioned in 1999 and has remained stable through the 12.1.1 and 12.2.2 releases. This longevity is characteristic of low-level framework packages that are effectively frozen: they are relied upon by the runtime engine but rarely modified. In 12.2.2 the package is documented with a single procedure, reflecting its narrow, internal scope.

Key Procedures and Functions

  • GET_ATTRIBUTE_LIST_VALUES — The only documented procedure in the package. Based on its name and the parameters it accepts (a trace number, a region application identifier, and a region code), it is responsible for materializing the list of values associated with the attributes of a specified region. Invocation is scoped to a particular application and region, allowing the framework to resolve which attribute values apply for a given runtime context. The trace number parameter supports diagnostic tracing during execution, a pattern used widely in Application Kit routines to correlate runtime activity with debug logs. No other procedures or functions are documented; the ETRM record lists exactly one entry point.

Because the documented parameter list is limited to the signature shown in the source excerpt, no additional parameters or overloads should be assumed. The procedure is a runtime helper, not a public API intended for direct customer invocation.

Tables Accessed

The package references four objects through APPS synonyms:

  • AK_OBJECT_VALUES_TEMP — A temporary/staging table holding attribute or object value records. The procedure likely populates or reads this table as part of building the attribute value list.
  • AK_REGIONS — The Application Kit metadata table defining regions. It supplies the region definition corresponding to the supplied region application identifier and region code.
  • ALL_OBJECTS — The Oracle data dictionary view, typically queried to validate or resolve object existence as part of framework metadata resolution.
  • PLITBLM — A standard Oracle EBS PL/SQL index-by table (associative array) type used for passing and manipulating collections of values within PL/SQL.

Read/write granularity is not separately documented; the primary interaction is expected to involve writing to AK_OBJECT_VALUES_TEMP and reading from AK_REGIONS.

Usage Notes

AK_RUN_FLOW_PKG is an internal framework package. It is not referenced by any other documented package in the ETRM repository, and it is not exposed as a public API. Invocation occurs from within the Application Kit runtime—typically in response to rendering or value-list resolution activity for attribute-enabled regions—rather than from forms, concurrent programs, or customer-developed code. Because it is declared AUTHID CURRENT_USER, callers must have appropriate privileges on the referenced AK tables and the ALL_OBJECTS view. Customizations should not call this package directly; any dependency on its behavior should be treated as unsupported and subject to change without notice across patch levels, even though the implementation has historically been stable since the 11i era.