Search Results ak_custom_grp




Overview
Explore in AI Chat

Overview

AK_CUSTOM_GRP is a PL/SQL package in the APPS schema that provides the programmatic "group" (GRP) layer for Oracle E-Business Suite's extensibility and customization framework. It is a core component of the Application Object Library foundation that supports the Oracle Application Framework (OAF) personalization and customization infrastructure.

Its purpose is to encapsulate the creation, maintenance, and retrieval of customization definitions — the metadata that records how a standard EBS page, region, or region item has been modified for a specific deployment. The package body wraps and exposes the lower-level business logic of AK_CUSTOM_PUB, which the package directly references, so that forms, OAF pages, and concurrent programs can invoke customization operations through a stable, well-defined API rather than against the underlying public package directly.

Key Procedures and Functions

The ETRM metadata documents nine procedures and functions in AK_CUSTOM_GRP. They fall into two functional groups — whole-customization operations and regional/component operations — and each is paired as create/update:

  • CREATE_CUSTOM — Creates a new customization definition record for an EBS entity.
  • UPDATE_CUSTOM — Modifies an existing customization definition.
  • CREATE_CUST_REGION — Creates a customization region, a named area within a customization where modified components are grouped.
  • UPDATE_CUST_REGION — Updates an existing customization region.
  • CREATE_CUST_REG_ITEM — Creates a customization region item, i.e., a single modifiable component attached to a region.
  • UPDATE_CUST_REG_ITEM — Updates an existing customization region item.
  • CREATE_CRITERIA — Creates the criteria that determine when and for whom a customization applies.
  • UPDATE_CRITERIA — Updates an existing set of customization criteria.
  • DOWNLOAD_CUSTOM — Retrieves and returns customization metadata for a customization, supporting the download behavior.

Tables Accessed

The documented table references for AK_CUSTOM_GRP are minimal: DUAL and PLITBLM, accessed through APPS synonyms. DUAL is the standard single-row query target used for expression evaluation and calls to package constants/defaults. PLITBLM is an Oracle Application Object Library PL/SQL table used for parameter passing, supporting the array-style interfaces the procedures expose. The actual customization data is persisted through the AK_CUSTOM_PUB public package referenced by AK_CUSTOM_GRP, which in turn manages the underlying AK customization tables.

Usage Notes

AK_CUSTOM_GRP is an internal framework package rather than an end-user API. It is referenced by only one other package, AK_DOWNLOAD_GRP, and is self-referenced. It depends directly on AK_CUSTOM_PUB and FND_API.

Customizations are typically created and maintained through the standard EBS personalization and customization user interfaces; those interfaces call down through the AK_CUSTOM_GRP layer into AK_CUSTOM_PUB. Custom code should generally invoke AK_CUSTOM_PUB directly, as documented, rather than the internal GRP package, which exists primarily to support the framework's own forms and concurrent download processing. There is no documented concurrent program or public interface for AK_CUSTOM_GRP, and it should not be treated as a supported extension point.