Search Results g_load_mode

Overview

APPS.AK_ON_OBJECTS_PUB is a public PL/SQL package that forms part of the Oracle E-Business Suite "AK" (Application Toolkit / Oracle Application Framework extensibility and attribute) module. Its principal business function is to support the loading, uploading, and management of object definitions and their associated attributes for the AK attribute framework — the metadata layer that underpins extensible descriptive flexfields, extensible attributes, and object registration used throughout Oracle EBS.

The package is classified as a public (PUB) API, meaning it is intended to be callable by other Oracle EBS modules and by external custom code. Its package specification establishes a set of global constants that govern loader and messaging behavior, and it exposes loader- and upload-oriented routines that parse and apply flat-file representations of AK object metadata. The presence of constants such as G_MAX_NUM_LOADER_VALUES, G_DATE_FORMAT, and the G_FILE_FORMAT_VER family confirms that a central purpose of the package is the controlled ingestion of loader files whose format has evolved over many releases (from pre-JSP version 110.1 through the current 120.1).

Key Procedures and Functions

The documented ETRM metadata for this package lists no individually catalogued procedures or functions in the specification excerpt provided. The visible portion of the specification is dominated by global constant declarations that define the parameter contract and file-format expectations for the loader and upload routines, including:

• G_PKG_NAME — the package and file name constant used by the package's error and messaging routines when an unexpected exception is raised.
• G_APPEND / G_OVERWRITE — constants for the p_write_mode parameter, distinguishing append semantics ('A') from overwrite semantics ('W') when writing loader output.
• G_MAX_NUM_LOADER_VALUES — the maximum number of values permitted per column in a loader file; all values after the first are ignored by the UPLOAD APIs.
• G_DATE_FORMAT — the single date format ('YYYY-MM-DD HH24:MI:SS') applied consistently across all AK loader routines.
• G_FILE_FORMAT_VER and G_OLD_FILE_FORMAT_VER1 through VER15 — version identifiers that allow the loader and upload routines to recognize and correctly interpret both current (120.1) and legacy (110.1, 115.x) flat-file formats.
• Type definitions — a buffer type used to represent one logical line, where a logical line may span multiple physical file lines.

The procedures and functions themselves are not enumerated in the available metadata, so their exact names and parameter lists cannot be stated without invention.

Tables Accessed

The ETRM metadata documents no tables referenced via APPS synonyms for this package. Based on the framework's purpose, the package is expected to operate against AK object and attribute repository tables, but the specific table list is not confirmed by the supplied metadata and is therefore not enumerated here.

Usage Notes

AK_ON_OBJECTS_PUB is referenced by 20 other packages within Oracle EBS, indicating it is a foundational component of the AK attribute framework rather than a standalone utility. It is typically invoked to load AK object and attribute definitions from flat files whose format version is validated against the G_FILE_FORMAT_VER constants, honoring the p_write_mode (append versus overwrite) contract. Because the package is a PUB API, it may be called directly from custom code, though the date format, value-count limit, and file-format version constants must be respected to ensure compatibility. The reference to "g_load_mode" in the user's search aligns with the loader-mode and write-mode constants exposed in this specification, suggesting the search pertains to configuring how AK object metadata files are loaded — append versus overwrite — during setup or migration activities.