Search Results get_desc_flex_all_values

Overview

EDR_ATTACHMENTS_GRP is a PL/SQL group (GRP) package body owned by APPS within the Oracle E-Business Suite environment. It provides the core attachment-handling infrastructure for EDR (Engineering Data Records, associated with Oracle Engineering and the ETRM module). The package encapsulates the logic required to copy, create, and manage file attachments linked to engineering records, including support for the standard EBS FND_ATTACHMENTS document framework and descriptive flexfield value extraction.

The header date (2007) reflects a mature, stable module that ships as part of standard EBS releases 12.1.1 and 12.2.2. It is referenced by three other packages, indicating it acts as a shared service layer rather than a standalone entry point.

Key Procedures and Functions

The package exposes twelve documented procedures and functions:

• COPY_ATTACHMENTS — Copies one or more attachments from a source entity/primary key to a target entity/primary key, carrying forward document, category, and attribute metadata. A large commented-out historical version (Bug 4381237 context) shows the lineage of this routine.
• COPY_ONE_ATTACHMENT — Copies a single attachment between entities, complementing the bulk COPY_ATTACHMENTS routine.
• ATTACH_ERP — Creates an attachment record for an engineering record, binding a file/document to an entity instance.
• ATTACH_ERP_AUT — Variant of ATTACH_ERP that sets the automatically-added flag during creation.
• ATTACH_FILE — Low-level routine to associate a physical file with a document record.
• ATTACH_FILE_AUT — Automatically-added variant of ATTACH_FILE.
• ADD_ERP_ATTACH — Adds an attachment entry for an ERP record, orchestrating document and reference creation.
• EVENT_POST_OP — Post-operation event handler, likely invoked after a business event to propagate attachment changes.
• GET_CATEGORY_NAME — Retrieves the human-readable name of an attachment category.
• GET_DESC_FLEX_ALL_PROMPTS — Returns the prompts (labels) for descriptive flexfield segments.
• GET_DESC_FLEX_ALL_VALUES — Returns the actual descriptive flexfield segment values. This is the routine most relevant to the user's search term, and is commonly used when rendering or validating DFF data on attachment-related forms.
• PARSE_ATTACHMENT_STRING — Parses a concatenated attachment string, likely used to split a multi-token attachment identifier.

Tables Accessed

• EDR_FILES_B — Base table storing EDR file information; read and written when creating or copying attachments.
• EDR_ERECORD_ID_TEMP — Temporary/working table holding engineering record identifiers during copy or attach operations.
• FND_DOCUMENTS — Central repository of document metadata (datatype, security, publish flags); referenced when copying document attributes.
• FND_ATTACHED_DOCUMENTS_S — The intersection table linking documents to business entities; written when creating or copying attachment references.
• DUAL — Used for singleton evaluations and constant selection.
• PLITBLM — The PL/SQL index-by table of long messages utility, typically used for error/message handling.

Usage Notes

This package is typically invoked from Oracle Forms (particularly the Engineering Record and attachment maintenance windows), from concurrent programs that batch-copy or migrate attachments, and from custom code where engineering record attachments must be created or cloned programmatically. Because it is a GRP-classification package, it is not exposed as a public API but is meant for internal/group-level use within the EDR module. Developers searching on get_desc_flex_all_values will find that routine here, where it is used to surface descriptive flexfield values (and prompts via its sibling GET_DESC_FLEX_ALL_PROMPTS) directly to the calling form or program, avoiding redundant FDF queries.