Search Results set_document_identifier

Overview

FND_WEBATTCH is the Oracle E-Business Suite package responsible for rendering and managing the Attachments user interface in the HTML-based (OA Framework) self-service applications. Its stated header indicates it is compiled with AUTHID CURRENT_USER, so it executes with the privileges of the calling database user rather than its owner. The package supplies the server-side logic that the Attachments button and its associated "summary" region use to display, add, update, and remove attachments tied to a web function and a specific entity identified by up to five primary key values. In this way FND_WEBATTCH bridges the generic attachment data model in the FND_ATTACHED_DOCUMENTS / FND_DOCUMENTS tables with the runtime needs of any OA Framework page that offers attachments.

Key Procedures and Functions

The documented 21 procedures and functions fall into several functional groups:

• Summary derivation: GETSUMMARYSTATUS determines whether an entity's attachment set is EMPTY, FULL, or DISABLED, taking a web function name, entity name, and up to five primary key values. GETSUMMARYLIST and SUMMARY assemble the rendered list of attachments for display, with support for a back-link URL, query-only mode, and a configurable package name.
• Attachment maintenance: ADDATTACHMENT, UPDATEATTACHMENT, and DELETEATTACHMENT provide the core create/modify/remove operations, with ADD_ATTACHMENT_GFM_WRAPPER and UPDATE_ATTACHMENT_GFM_WRAPPER acting as wrapper entry points for the attachment framework.
• Content viewing and printing: VIEWTEXTDOCUMENT and VIEWFILEDOCUMENT render stored text and file attachments; PRINTSUMMARY, PRINTTEXTDOCUMENT, PRINTADDATTACHMENT, PRINTUPDATEATTACHMENT, and PRINTBLANKPAGE support printable output.
• Page and utility helpers: HEADER, RELOADSUMMARY, and SET_DOCUMENT_IDENTIFIER assist with page framing, refresh, and document identification.

Tables Accessed

The package reads and writes the core attachment schema through APPS synonyms:

• FND_ATTACHED_DOCUMENTS and its sequence FND_ATTACHED_DOCUMENTS_S store the association between an entity and its attachments.
• FND_DOCUMENTS, FND_DOCUMENTS_TL, FND_DOCUMENTS_SHORT_TEXT, and FND_DOCUMENTS_LONG_TEXT hold the document definition and its textual content.
• FND_DOC_CATEGORY_USAGES and FND_ATTACHMENT_FUNCTIONS govern which document categories and functions are valid for a given entity.
• FND_LOBS and FND_TEMP_FILE_PARAMETERS manage binary large-object storage and upload/download parameters.
• Utility objects DUAL, HTF, HTP, and OWA_UTIL generate the HTML output and print buffers.

Usage Notes

FND_WEBATTCH is not normally called directly by end users; it is invoked by OA Framework attachment regions and by any of the 14 other packages that reference it. Typical invocations include the Attachments button handler on a web page, the attachment summary region on a detail page, and concurrent or print workflows that require attachment output. Because the procedures accept the web function name, entity name, and up to five primary key values, custom OA Framework pages that follow the standard attachment model can reuse this package for consistent rendering. Developers extending it should respect the AUTHID CURRENT_USER declaration and the HTML-generation conventions of HTP and HTF.