Search Results fnd_doc_category_usages_s

Overview

APPS.SO_ATT is a PL/SQL package body in the Oracle E-Business Suite APPS schema responsible for managing Oracle Order Management order attachments and their underlying document categories, usage assignments, and note records. In both EBS 12.1.1 and 12.2.2 it provides the programmatic interface that links order headers to the Oracle Attachments Framework (FND_ATTACHED_DOCUMENTS, FND_DOCUMENTS, and related category tables), while also managing order notes stored in the SO_NOTES structure. The ETRM classification for this package is "OTHER" with a VALID status, indicating a supported internal utility rather than a formally published public API.

The object dependency metadata confirms that SO_ATT is a leaf node: it references numerous Attachments Framework and Order Management tables, but is not referenced by any other database object. This confirms its role as an internal helper package invoked by Order Management forms or concurrent processing rather than a widely re-entered library.

Key Procedures and Functions

The ETRM metadata documents 23 procedures and functions. Their purposes fall into several groups:

• Marking and error handling: MARK_RECORD and CLEAR_MARK manage record-level status flags, while GET_NOTE_ERROR and GET_NOTE_INFO return error and diagnostic information for note processing.
• Lookup utilities: GET_NOTE_NAME, GET_NOTE_TYPE_CODE, GET_DOCUMENT_USAGE_TYPE, GET_ENTITY_NAME, GET_CATEGORY_ID, GET_USAGE_ID, GET_MEDIA_ID, GET_DOC_CAT_APPLICATION, and GET_CAT_APPLICATION retrieve descriptive attributes, identifiers, and application context for documents, categories, and usage assignments.
• Document DML: INSERT_DOCUMENT, UPDATE_DOCUMENT, and DELETE_DOCUMENT perform create, update, and delete operations against FND_DOCUMENTS and its translated and long/short text tables.
• Attachment DML: INSERT_ATTACHED_DOCUMENT, UPDATE_ATTACHED_DOCUMENT, and DELETE_ATTACHED_DOCUMENT maintain the association records in FND_ATTACHED_DOCUMENTS.
• Category management: INSERT_CATEGORY creates document category records and their usage assignments.

Tables Accessed

The dependency list documents references to the core Attachments Framework tables — FND_DOCUMENTS and its _TL, _LONG_TEXT, and _SHORT_TEXT variants for document definitions and text; FND_ATTACHED_DOCUMENTS and _S for entity-to-document associations; FND_DOCUMENT_CATEGORIES along with its _TL and _S variants; FND_DOC_CATEGORY_USAGES and FND_DOC_CATEGORY_USAGES_S for category-to-entity usage mappings; and FND_ATTACHMENT_FUNCTIONS. It also references Order Management structures: SO_HEADERS for the order header entity, SO_NOTES for note text, SO_NOTE_REPLICATION, and SO_NOTE_USAGES with its _S sequence table. The user search term "fnd_doc_category_usages_s" corresponds directly to the FND_DOC_CATEGORY_USAGES_S table, which supplies primary keys for usage assignment inserts.

Usage Notes

SO_ATT is typically invoked by Order Management forms and internal processing routines when a user or process attaches a document to an order header, or when note records must be created, updated, or queried. The presence of GET_MEDIA_ID, GET_CATEGORY_ID, and GET_USAGE_ID supports form-driven attachment dialogs that require resolving IDs before performing DML. Because the package is not referenced by any other database object and is classified as OTHER, custom code should generally use the documented Oracle Attachments public APIs (such as FND_ATTACHED_DOCUMENTS_PKG) rather than calling SO_ATT directly; SO_ATT remains an internal implementation detail that may change between releases, and no committed interface contract should be assumed for extensions.