Search Results ak_flow_grp




Overview
Explore in AI Chat

Overview

AK_FLOW_GRP is a PL/SQL package in the APPS schema that belongs to the Oracle E-Business Suite Application Object Library (AK) product family, commonly associated with the Oracle EBS Diagnostics and "Flow" configuration infrastructure. The package is classified under the GRP API classification, indicating that it serves as a group-level utility package rather than a public transactional API. Its documented status is VALID in both 12.1.1 and 12.2.2 environments.

Functionally, AK_FLOW_GRP provides the programmatic layer used to create, maintain, and delete logical "flow" definitions that describe the sequence and layout of pages, regions, and region items within Oracle Application Framework-style user interface metadata. Each flow is composed of pages, each page is composed of regions, and each region is composed of region items, forming a hierarchical navigation model. The package also supports defining relationships between regions, which allow the UI runtime to understand how one region relates to another during rendering or navigation. Collectively, these procedures allow the application to define the structural skeleton of a guided business process or configuration flow without direct DML against the underlying repository tables.

Key Procedures and Functions

The package exposes 16 documented procedures and functions organized around four object types (flow, page, page region, page region item) plus region relationships. No parameter lists are documented in the ETRM metadata, so their signatures should be obtained from the package specification in a live instance.

Tables Accessed

ETRM documents only two table references for this package: DUAL, the standard Oracle single-row utility table used for evaluating expressions and return values, and PLITBLM, an internal Application Object Library table that provides a buffer or temporary storage structure used during flow assembly operations. The package also depends on AK_FLOW_PUB, which is the public flow API, and FND_API, the foundation-layer API used by nearly all EBS PL/SQL APIs. This pattern suggests AK_FLOW_GRP is a group-level wrapper that delegates core work to AK_FLOW_PUB and uses FND_API for standard error handling, message stacking, and savepoint management.

Usage Notes

AK_FLOW_GRP is an internal implementation package rather than a customer-facing API. It is referenced by one other package, AK_DOWNLOAD_GRP, which is consistent with its DOWNLOAD_FLOW procedure being part of a broader download and extraction mechanism. It also references itself recursively, indicating internal helper routines within the package body. Typical invocation is from Oracle Forms-based administrative utilities, concurrent programs that publish or migrate flow definitions, and Oracle Diagnostics setup tooling, rather than from end-user transactional forms. Custom code should not call these procedures directly; developers requiring flow functionality should use AK_FLOW_PUB or the appropriate public APIs, since the signatures and behavior of AK_FLOW_GRP may change between patch levels.