Search Results delete_attachments

Overview

PVX_ATTACHMENT_INT is a PL/SQL package body owned by APPS in Oracle E-Business Suite. It belongs to the Oracle Procurement product family (the PVX prefix), and its source header identifies the underlying script as pvxatit.pls (version 120.1, dated 2005). The package exposes an integration-layer API for managing attachments associated with procurement documents, in particular quote headers. Rather than driving the standard Oracle Attachment forms directly, it provides a programmatic entry point through which attachments — short text, files, or URLs — can be created and removed against a business entity identified by a quote header identifier.

Under ETRM classification the package is registered as API classification OTHER. It implements two public subprograms: ADD_ATTACHMENT and DELETE_ATTACHMENTS. The package follows the standard Oracle Application Object Library API conventions: a version parameter, an initialization message list flag, a commit flag, and the standard OUT parameters for return status, message count, and message data. This makes it compatible with FND_API callers and with error-handling patterns used throughout the EBS application layer.

Key Procedures and Functions

• ADD_ATTACHMENT — Creates an attachment record and links it to the target entity. Based on the documented comment block, it accepts identifiers and attributes describing the attachment: a sequence number, category, document description, datatype identifier, text content, file name, source URL, calling form function name, quote header identifier, and media identifier. The URL is required so that a back link can be established to the invoking page. The text parameter is declared as LONG to accommodate sizable text attachments. Internally the procedure validates API version compatibility through FND_API.Compatible_API_Call and raises FND_API.G_EXC_UNEXPECTED_ERROR when the caller supplies an incompatible version; it also establishes a savepoint to support partial rollback.
• DELETE_ATTACHMENTS — Removes attachment associations previously created against the entity. The package history records that validation logic was added to this procedure in October 2002 (bug 2633826), indicating that it verifies preconditions — most likely that the attachment exists and belongs to the caller-supplied quote header — before deleting. This is the procedure most commonly referenced by searches on "delete_attachments."

Tables Accessed

• FND_ATTACHED_DOCUMENTS — the central attachment association table, holding the link between an entity (here, the quote header) and a document definition.
• FND_DOCUMENTS_TL — stores the translatable document description and related document metadata.
• FND_LOBS — holds the binary media for file-based attachments; the package contains a cursor selecting FILE_NAME from FND_LOBS by FILE_ID to resolve file names for attachments referenced by media identifier.
• PLITBLM — the PL/SQL integer table type used for message handling in conjunction with the FND message stack.

Usage Notes

The package is an integration API and is not exposed as a concurrent program. It is typically invoked from Oracle Forms event logic, from the Oracle iProcurement or Sourcing attachment UI, or from custom PL/SQL that needs to add or delete attachments on a quote without navigating the standard attachment aferrors forms. Callers must supply a valid API version, request message-list initialization and commit explicitly, and inspect X_RETURN_STATUS plus the message count/data outputs before committing. ETRM records no other packages in the instance as referencing PVX_ATTACHMENT_INT, so dependencies are direct rather than cascading. The package is not designated as a public or private API under the ETRM taxonomy but falls into the OTHER category, which implies limited support expectations for external callers. Because the source has been stable since 2005 and the FND attachment schema is shared across releases, the package behaves consistently in both 12.1.1 and 12.2.2, with no documented 12.2-specific changes.