Search Results fnd_documents_long_raw_s

Overview

FND_DOCUMENTS_PKG is the core PL/SQL package body in the APPS schema responsible for managing the Oracle EBS Documents (Attachments) framework. It exposes the low-level data manipulation routines that underpin the standard "Attachments" feature available throughout Oracle Applications. Every attachment an end user creates, updates, or deletes through the Attachments block or the paperclip icon ultimately passes through this package. In Oracle EBS 12.1.1 and 12.2.2, the package abstracts the physical storage model of attachments, which spans several related tables (FND_DOCUMENTS, FND_DOCUMENTS_TL, and the SHORT_TEXT, LONG_TEXT, and LONG_RAW detail tables), so callers do not need to touch those tables directly. The metadata classifies this object as API classification OTHER, meaning it is an internal infrastructure package rather than a public, documented business API, and it is referenced by 24 other packages in the EBS schema.

Key Procedures and Functions

ETRM documents eight procedures in the package body:

• INSERT_ROW — Creates a new document definition row in FND_DOCUMENTS (and the associated _S sequence-keyed row), establishing the base record for a new attachment or document entity.
• INSERT_TL_ROW — Inserts the translated (language-specific) name and description for a document into FND_DOCUMENTS_TL, keyed by the language from FND_LANGUAGES.
• LOCK_ROW — Obtains a row-level lock on the FND_DOCUMENTS record, enforcing concurrency control before an update or delete.
• LOCK_TL_ROW — Takes the equivalent lock on the translated row in FND_DOCUMENTS_TL.
• UPDATE_ROW — Modifies attributes of an existing document record, such as the document type, usage type, and media identifier.
• UPDATE_TL_ROW — Updates the language-specific name/description text in FND_DOCUMENTS_TL.
• DELETE_ROW — Removes a document record, typically coordinating deletion of the base row and its dependent detail rows.
• ADD_LANGUAGE — Populates translation rows for a document across languages, supporting the multilingual requirements of the EBS installation.

These routines are the building blocks invoked by higher-level attachment and document-management logic rather than being called individually by typical form code.

Tables Accessed

The package reads and writes the central attachment schema, all via APPS synonyms:

• FND_DOCUMENTS / FND_DOCUMENTS_S — the master document definition and its sequence-based primary key source.
• FND_DOCUMENTS_TL — translated document names and descriptions.
• FND_DOCUMENTS_SHORT_TEXT / _S, FND_DOCUMENTS_LONG_TEXT / _S, FND_DOCUMENTS_LONG_RAW / _S — the short text, long text, and long raw detail stores that hold the actual attachment content according to the document's type.
• FND_LOBS / FND_LOBS_S — the large-object store used when an attachment is held as a file or URL/file reference.
• FND_ATTACHED_DOCUMENTS — links a document to the specific entity (form, record, or business object) it is attached to.
• FND_LANGUAGES — supplies the installed and enabled languages used when creating translated rows.
• DUAL — used for single-row PL/SQL expressions; APP_EXCEPTION, FND_MESSAGE, and STANDARD support error raising and message retrieval.

Usage Notes

FND_DOCUMENTS_PKG is a server-side infrastructure package and is not intended as a supported public integration point; Oracle does not expose it in the standard API documentation, and its classification is OTHER. It is invoked indirectly by the Attachments framework, by forms that embed attachment blocks, and by the 24 documented dependent packages that manage documents and attachments. Custom code should avoid direct calls to its row-level procedures and instead use the supported attachment APIs (such as FND_ATTACHED_DOCUMENTS manipulation routines) to preserve integrity across the master/detail table set. Because the package performs its own LOCK_ROW and LOCK_TL_ROW concurrency checks, any custom invocation must commit or roll back within the same transaction boundary and never bypass the translation handling. When attachments misbehave in 12.1.1 or 12.2.2, this package and its dependent tables are a standard starting point for investigation.