Search Results ak_queryobj_pvt




Overview
Explore in AI Chat

Overview

AK_QUERYOBJ_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Oracle Application Object Library (AK) product family, the layer that underpins the configurable search and query functionality used across the EBS application modules. The package implements the internal business logic for moving query object definitions — the saved search criteria that allow users to define, name and reuse attribute-based data retrieval patterns — between the database and the file system.

Because the package is classified as PVT, its procedures are not intended for general customer use. It provides the server-side execution engine behind the public APIs in AK_QUERYOBJ_PUB, handling the heavy extraction, creation and loading work for both the download and upload directions of the query object lifecycle. The package header declares AUTHID CURRENT_USER and identifies itself as G_PKG_NAME, with private redo collections and indexes that buffer query object headers and their child lines during multi-record operations.

Key Procedures and Functions

  • DOWNLOAD_QUERY_OBJECT — Extracts query objects from the database into an output loader file. Selection may be driven either by an application identifier, which writes all query objects belonging to that application, or by explicit key values, which restricts output to specific records. Whenever a query object is written, all of its child AK_QUERY_OBJECT_LINES records are written as well, preserving the parent-child integrity of the definition. The procedure accepts an optional NLS language parameter, defaulting to the session language, and returns the standard p_return_status indicating success, error or unexpected error.
  • CREATE_QUERY_OBJECT — Creates a query object header record. This is the internal counterpart used when loading query objects into a target environment.
  • CREATE_QUERY_OBJECT_LINE — Creates the individual line records that constitute the body of a query object, linking the object to its component attributes or search criteria.
  • UPLOAD_QUERY_OBJECT — Reads loader file content and writes query object headers and lines into the database, completing the transfer cycle begun by DOWNLOAD_QUERY_OBJECT. Note that this procedure name is the closest match to the reported search term "upload_query_object", which is the documented entry point for importing saved query objects.

Tables Accessed

  • AK_QUERY_OBJECTS — The header table holding each query object's identifying information, application ownership and descriptive attributes. It is read during download and written during upload or creation.
  • AK_QUERY_OBJECT_LINES — The child detail table containing the individual query lines that make up each object. It is always processed in conjunction with its parent header to maintain consistency.
  • PLITBLM — A generic OAF/application utility table used by the loader mechanism, typically for storing or staging the uploaded file lines before they are parsed and inserted.

Access is performed through APPS synonyms, so the package does not hard-code schema-qualified names.

Usage Notes

AK_QUERYOBJ_PVT is invoked indirectly through the public AK_QUERYOBJ_PUB APIs rather than called directly by customer code. The header explicitly states that the download API should only be called by APIs owned by the Core Modules Team, reflecting its internal status. In practice it is exercised during environment migration and setup tasks — for example when query objects must be moved from a development or test instance into production. The package is referenced by two other packages in the ETRM inventory, confirming that its callers are internal AK framework components. Custom developers requiring similar functionality should call the corresponding public procedures in AK_QUERYOBJ_PUB and rely on the standard success, error and unexpected error return statuses.