Search Results ak_customizations_pkg




Overview
Explore in AI Chat

Overview

AK_CUSTOMIZATIONS_PKG is a 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 Framework (OAF) / Application Kit (AK) product family, which provides the underlying infrastructure for the Oracle EBS personalization and extensibility framework. Functionally, the package serves as the data-access layer for the AK_CUSTOMIZATIONS entity, the repository that stores user-defined customizations applied to EBS pages, regions, items, and other UI artifacts. Every customization a user saves through the "Personalize Page" or "About This Page" flows in the EBS interface is persisted through this package, which encapsulates the CRUD operations and language-specific maintenance routines required for that entity.

The package is classified as OTHER in the ETRM metadata, reflecting that it is an internal, non-public API. It exposes row-level insert, lock, update, and delete operations, plus a language-addition routine, and it is the canonical mechanism by which callers manipulate the AK_CUSTOMIZATIONS and AK_CUSTOMIZATIONS_TL tables without directly issuing DML against them.

Key Procedures and Functions

The package documents five procedures and functions, each corresponding to a standard table-handler pattern used throughout Oracle Application Kit packages:

  • INSERT_ROW — Creates a new customization record. It populates a row in AK_CUSTOMIZATIONS together with the associated translatable row in AK_CUSTOMIZATIONS_TL, assigning the primary key and audit columns as appropriate.
  • LOCK_ROW — Acquires a row-level lock (typically a SELECT ... FOR UPDATE) on the target customization record, serializing concurrent modification attempts before an update or delete.
  • UPDATE_ROW — Modifies an existing customization record. It updates the base table and the translatable table so that descriptive attributes remain consistent across languages.
  • DELETE_ROW — Removes a customization record and its associated translation rows, ensuring referential integrity for the customization hierarchy.
  • ADD_LANGUAGE — Inserts a translation row for a customization in a newly installed or activated language, supporting the multi-language EBS deployment model.

Per the metadata, parameter lists are not enumerated here; callers should reference the package specification for exact signatures. The procedures follow the canonical AK pattern of pairing a base-table operation with its _TL counterpart.

Tables Accessed

The package references three tables through APPS synonyms:

  • AK_CUSTOMIZATIONS — the primary base table storing customization definitions, including identifiers for the page, region, and attribute to which the customization applies.
  • AK_CUSTOMIZATIONS_TL — the translation table holding language-specific descriptive text for each customization, keyed by LANGUAGE and SOURCE_LANG.
  • FND_LANGUAGES — the Oracle Applications language reference table, read by ADD_LANGUAGE to validate and drive creation of translation rows for installed languages.

Usage Notes

AK_CUSTOMIZATIONS_PKG is invoked internally by the Application Kit runtime and by a small number of dependent packages. The ETRM metadata records that it is referenced by BIS_PMV_PARAMETERS_PUB and EGO_SEARCH_FWK_PUB, indicating that personalization data influences the behavior of the BIS Performance Management Viewer parameter framework and the EGO (Product Information Management) search framework. Direct invocation from custom code is discouraged; customers should use the supported personalization UI, and developers extending AK functionality should call the package procedures rather than issuing direct DML, so that audit columns, translation rows, and locking semantics are handled consistently. In EBS 12.2.2 the package retains the same shape and status VALID, ensuring compatibility with both the 12.1.1 and 12.2.2 code lines.