Search Results process_item

Overview

The PL/SQL package body APPS.AHL_DI_FILEUPLOAD_PVT belongs to the Oracle E-Business Suite product family known as AHL (Product Lifecycle Management / Quality, historically the "Advanced Product Catalog" and asset lifecycle modules). It is a private (PVT) API package classified under the Application Programming Interface layer, meaning it is intended to be invoked by other packages, forms, or concurrent programs rather than directly by end users. The package encapsulates the file-upload business logic associated with documents maintained in the AHL document repository, providing controlled insertion, update, and deletion of content items and their file attachments linked to document revisions.

The header comment $Header: AHLVFUPB.pls 115.6 2004/01/21 ... indicates the package dates back to an early release of the AHL file-upload infrastructure and has been carried forward into EBS 12.1.1 and 12.2.2. A single global flag, G_DEBUG, is derived from AHL_DEBUG_PUB.is_log_enabled, allowing diagnostic tracing to be enabled for troubleshooting upload operations.

Key Procedures and Functions

The documented API surface consists of three procedures:

• UPLOAD_ITEM — Inserts or updates a content item for an associated document. It follows the standard EBS API conventions (API version, initialization of the message list, commit flag, validation level, and OUT parameters for return status, message count, and message data), accepting an AHL file-upload record of type ahl_fileupload_rec. It establishes a savepoint, optionally enables debug tracing through AHL_DEBUG_PUB, obtains a new association identifier from the AHL_DOC_FILE_ASSOC_B_S sequence, and verifies whether an attachment already exists for the given revision before persisting the item.
• DELETE_ITEM — Removes a previously uploaded content item or its attachment association, maintaining referential integrity between the AHL document revision and the underlying FND_LOBS file record.
• PROCESS_ITEM — The procedure matched by the user's search term "process_item". It represents the higher-level driver that orchestrates the upload workflow, validating input and delegating to the insert/update or delete logic as appropriate for a given file-upload record.

Tables Accessed

The package operates against the following objects via APPS synonyms:

• AHL_DOC_FILE_ASSOC_B_S — the sequence used to generate the next AHL_DOC_FILE_ASSOC association identifier.
• AHL_DOC_REVISIONS_B — the base table holding AHL document revisions, to which uploaded file content is linked.
• FND_LOBS — the standard EBS table that physically stores uploaded file content; joined against the AHL document-file association view to confirm that an attachment exists for a revision.
• DUAL — used for sequence and scalar reads.

Additionally, the view AHL_DOC_FILE_ASSOC_V is queried in the attachment-existence cursor to retrieve the file identifier and file name.

Usage Notes

Because the package is classified as PVT, it is normally invoked indirectly—either by the public AHL document API layer, by the AHL file-upload form, or by custom code that has been explicitly scoped to the private interface. When the user searches for process_item, they are typically looking for the entry point that drives the upload of a single file record into the AHL document repository. Callers should follow the standard EBS API protocol: pass an initialized message list, choose whether to commit, and inspect x_return_status and the message stack on return. The package is referenced by one other package, confirming its role as a supporting routine within a small dependency chain rather than a widely shared component.