Search Results insert_document

Overview

APPS.PO_ATT is a PL/SQL package within the Oracle E-Business Suite Purchasing (PO) module that manages the relationship between attachments, media records, documents, and note information. Its primary business function is to coordinate how transactional attachments and notes are stored, marked for processing, and mapped to their underlying document, category, and usage identifiers. The package operates across the attachment infrastructure used by Oracle Purchasing, providing routines that translate between entity names, table names, column names, media identifiers, and document identifiers. It supports both short and long text attachments, distinguishes document sources from note sources, and handles insert and update operations across defined source versions such as PO_10SC and PO_R10. This makes PO_ATT a foundational utility for maintaining the integrity and traceability of purchasing-related attachment data.

Key Procedures and Functions

The package exposes a set of procedures and functions organized around attachment metadata resolution and record lifecycle management.

• mark_record and clear_mark — set and reset processing flags on attachment records, distinguishing between short and long text, document versus note sources, insert versus update operations, and the applicable source version.
• get_table_name and get_column_name — overloaded functions that return the associated table or column name given either an entity name or a document identifier.
• get_entity_name — returns the entity name corresponding to a supplied table name.
• get_category_id and get_usage_id — resolve the category identifier from a usage identifier and vice versa, supporting attachment categorization and usage tracking.
• get_media_id and get_document_id — convert between document identifiers and media identifiers, with get_media_id also returning the datatype identifier.
• get_note_info — the routine referenced in the user search. It accepts a media identifier and a short/long indicator, returning the related document identifier, category identifier, usage identifier, and note type ('O' for one type and 'S' for another). This procedure centralizes the resolution of note metadata for a given media record.
• insert_document, update_document, and delete_document — manage the document record lifecycle tied to a note identifier or document identifier and its application source version.
• insert_atta — initiates insertion of attachment data, as implied by the documented declaration.

Tables Accessed

The provided ETRM metadata does not enumerate the specific base tables referenced through APPS synonyms, and no referenced-by or table dependency list was captured. Based on the package's documented operations, it logically interacts with attachment, document, and note storage structures within the Purchasing schema, including the entities that map media identifiers to document identifiers and that hold category and usage classifications. Because the documented metadata lists no explicit table references, the precise table list should be confirmed through dependency analysis of the package body in a given environment.

Usage Notes

PO_ATT is an internal utility package invoked by Oracle Purchasing forms and related attachment-processing logic rather than being exposed directly to end users. Custom code that needs to resolve note or document identifiers from a media identifier, or that needs to mark attachment records for processing, may call its procedures directly while respecting the same source-version and short/long conventions. As with most Oracle EBS internal APIs, direct invocation should be limited to cases where no supported public API exists, and the package should be treated as version-sensitive across 12.1.1 and 12.2.2, since internal signatures and dependencies can change between releases.