Search Results g_compare_update

Overview

AK_UPLOAD_GRP is a group-type PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema that coordinates the bulk upload of Oracle Application Object Library (AK) metadata — attribute groups, attribute definitions, and related configuration — into a target instance. It belongs to the family of "GRP" packages that act as orchestration wrappers around lower-level public APIs, and it delegates the substantive object-processing work to AK_ON_OBJECTS_PUB, the public package responsible for reading, validating, and committing the uploaded records.

The package exists primarily to support the Application Object Library upload utility used during upgrades, patches, and discretionary metadata deployment. Its central concern is the selection of an appropriate update strategy, controlled by the p_update_mode parameter and reflected internally in three package globals: G_UPDATE_MODE, G_NO_CUSTOM_UPDATE, and G_COMPARE_UPDATE. The custom search term g_compare_update corresponds directly to this third global, which governs whether the upload logic performs a date/version comparison before applying updates so that locally modified data is not silently overwritten.

Key Procedures and Functions

• UPLOAD — The single documented procedure. It accepts an update-mode selector and returns an overall status flag. Based on the mode, it configures the three package-level globals that drive downstream update behavior: a full update mode that overwrites everything, a non-customized-only mode that preserves customer modifications, a non-seed-data mode with the same protective semantics, and a compare-update mode that overwrites while first comparing data/date values. Each branch sets G_UPDATE_MODE, G_NO_CUSTOM_UPDATE, and G_COMPARE_UPDATE accordingly; any unrecognized mode falls through to a permissive default in which all three flags are FALSE.

The procedure also establishes the session context before processing: it sets the FND message level threshold, places the session in seed-data mode via FND_PROGRAM.SET_SESSION_MODE, and sets AK_ON_OBJECTS_PUB.G_LOAD_MODE to 'UPLOAD'. It then seeds a PL/SQL buffer table with log-file heading text so that a structured upload log can be produced.

Tables Accessed

• PLITBLM — The standard Oracle database table holding PL/SQL library and stored-program source lines (note the source header akgulodb.pls). Access here is incidental to the package's definition and compilation rather than to its business processing.
• V$SESSION — The dynamic performance view; the package initializes and references session information (for example, the local l_session_id variable initialized to -1) to identify and log the current upload session, supporting the session-scoped logging performed by the procedure.

The bulk of the actual data manipulation is performed indirectly through AK_ON_OBJECTS_PUB rather than by this group package itself, which is why the directly documented table list is short.

Usage Notes

AK_UPLOAD_GRP is normally invoked through the Application Object Library upload concurrent program or equivalent administrative utility, not from interactive forms. It is referenced by eight other packages, indicating it forms part of a shared upload framework. Callers supply the update mode — full update, non-customized-only update, non-seed-data update, or compare-update — and rely on the returned status to determine success or failure. Because the update-mode globals are session-scoped in AK_ON_OBJECTS_PUB, the UPLOAD procedure must be called before any dependent upload processing within the same session, and custom code that invokes it must honor the returned status and the FND message stack rather than assuming completion.