Search Results ams_attachment_pvt




Overview
Explore in AI Chat

Overview

APPS.AMS_ATTACHMENT_PVT is a private (PVT) PL/SQL package belonging to the Oracle Advanced Marketing and Sales (AMS) application family. As stated in the package header comments, it was introduced at release 11.5.6 to serve the attachment requirements of Oracle Sales and Marketing. Its stated purpose is to provide methods to "tamper" with FND Attachments, acting as a bridge between the Java middle-tier layer and the underlying FND table handlers that Oracle Foundation provides. The package is declared with AUTHID CURRENT_USER, meaning that it executes with the privileges of the calling schema rather than as its owner, which is typical for private application-programming-interface packages in EBS.

The package inherits the standard AMS/ETRM API classification of PVT, indicating it is internal implementation logic not intended as a public integration surface. The header explicitly warns that the package makes assumptions about how Sales and Marketing use Attachments and "should not be used by other apps." It is referenced internally by two other packages, confirming its role as a supporting utility rather than a standalone API.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents three procedures, one of which is the DELETE_FND_ATTACHMENT routine that matches the user's search term:

  • CREATE_FND_ATTACHMENT — Creates a new attachment record, inserting the document into the FND document tables and associating it with a source entity via the attached-document tables.
  • UPDATE_FND_ATTACHMENT — Modifies an existing attachment's attributes, such as its description, file name, media, or sequence number.
  • DELETE_FND_ATTACHMENT — Removes an attachment association and its supporting FND document records. This is the procedure users locate when searching for "delete_fnd_attachment" in the context of removing Sales and Marketing attachments.

All three operate against the record type fnd_attachment_rec_type, defined in the package header, which carries fields including document_id, datatype_id, category_id, security_type, publish_flag, description, file_name, media_id, file_size, entity_name, PK1_VALUE, short_text, and audit columns. That record structure is what the procedures accept as they marshal data between Java and the FND handlers.

Tables Accessed

The documented table references reflect the FND Attachments data model:

  • FND_DOCUMENTS and its TL, SHORT_TEXT, and _S variants — store document metadata, translatable descriptions, and short-text content.
  • FND_ATTACHED_DOCUMENTS and FND_ATTACHED_DOCUMENTS_S — link documents to their owning entities (entity_name and PK1_VALUE) and hold sequence and "automatically added" flags.
  • DUAL — used for single-row computations and lookups.

These tables are accessed through APPS synonyms, consistent with the AUTHID CURRENT_USER declaration.

Usage Notes

AMS_ATTACHMENT_PVT is invoked indirectly by Oracle Sales and Marketing forms and by the Java-based attachment UI layers that call into the package through the two dependent packages. It is not a supported entry point for customer-written concurrent programs or custom APIs; the header's explicit restriction means direct calls from custom code risk breaking on patch upgrades. Because it is a PVT package, no public API grant is published in the ETRM repository. Where custom deletion of Sales and Marketing attachments is required, the recommended approach is to use the documented business-layer API rather than this private package, or to coordinate changes with Oracle Support. The DELETE_FND_ATTACHMENT procedure remains the internal mechanism through which attachment removal is performed across EBS 12.1.1 and 12.2.2.