Search Results exec_query

Overview

APPS.AK_RUN_FLOW_PKG is a runtime support package in the Oracle E-Business Suite Application Object Library (AK) module. Its documented purpose is to obtain the list of values displayed for an attribute when a region in the Oracle EBS framework is rendered or queried. The presence of the substring "RUN_FLOW" in the package name and the reference to "flow" parameters passed into AK_QUERY_PKG.exec_query indicate that the package participates in the runtime execution of a region flow — the parent/child page and region navigation model used by the AK frameworks (such as the Oracle EBS personalization and extensibility infrastructure). The package body exposes a single documented procedure, GET_ATTRIBUTE_LIST_VALUES, which resolves the runtime values that populate a list-of-values attribute on a given region.

Key Procedures and Functions

• GET_ATTRIBUTE_LIST_VALUES — The sole documented procedure. It accepts a trace number, a region application identifier, and a region code, and returns the list values associated with that region. Internally, the procedure first validates that the underlying database object for the region exists by querying ALL_OBJECTS joined to AK_REGIONS; if no matching TABLE or VIEW is found, it returns without further processing. When the object exists, the procedure delegates value retrieval to AK_QUERY_PKG.exec_query, forwarding the region application identifier and region code as the parent region context and supplying nulls for all other flow, page, primary-key, and key-value parameters. The results gathered through exec_query populate label and display-value arrays that constitute the attribute list.

Tables Accessed

• AK_REGIONS — Provides the region definition, including the database object name and region application/code, which are matched against ALL_OBJECTS.
• ALL_OBJECTS — Used in the object-existence verification cursor to confirm that the region's database object is a TABLE or VIEW.
• AK_OBJECT_VALUES_TEMP — Referenced through APPS synonyms for the storage of object values encountered during execution.
• PLITBLM — The framework's internal table type used for associative array manipulations supporting the list-value collections.

Usage Notes

This package is invoked at runtime in the Oracle EBS framework, typically when a region with list-of-values behavior is displayed and its attribute values must be resolved. Because it forwards calls to AK_QUERY_PKG.exec_query, it is not intended to be called directly by end users; it operates behind the scenes within the AK region-rendering and personalization infrastructure. The check on ALL_OBJECTS before calling exec_query is a defensive measure noted in the source comments: without it, exec_query can fail with errors when the region's database object does not exist. The package is documented with an API classification of OTHER and is not referenced by any other documented packages, so customizations should treat it as an internal runtime dependency rather than a public API. This behavior is consistent across Oracle EBS 12.1.1 and 12.2.2, where the AK object framework remains fundamentally unchanged.