Search Results attach_file

Overview

EDR_ATTACHMENTS_GRP is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as a GRP (group) package within the EDR (Electronic Document Repository / E-Records) module. It is validated and central to attachment handling across the EDR product family. The package provides the shared attachment engine used to associate documents, files, and ERP-generated content with electronic records and electronic signature (e-signature) workflows.

Its central business function is to manage the lifecycle of attachments — copying, parsing, and attaching files and ERP artifacts — and to resolve descriptive flexfield prompts and values and category names that drive attachment presentation. Because e-signature checklists and signature rules frequently need to snapshot supporting evidence at the time a signature is applied, this package is a foundational dependency for those flows.

Key Procedures and Functions

The package exposes twelve documented program units, spanning attachment mechanics, ERP integration, flexfield resolution, and event hooks:

• COPY_ATTACHMENTS — Copies a set of attachments, typically from one record or entity to another, supporting bulk replication of supporting evidence.
• COPY_ONE_ATTACHMENT — Copies a single attachment as a discrete unit, allowing granular control within a copy operation.
• ATTACH_ERP — Attaches an ERP-generated artifact or document to the target record.
• ATTACH_ERP_AUT — The "AUT" (automatic) variant of ATTACH_ERP, invoked as part of an automated processing path.
• ATTACH_FILE — Attaches a physical or referenced file to a record.
• ATTACH_FILE_AUT — Automated variant of ATTACH_FILE for programmatic, non-interactive attachment.
• ADD_ERP_ATTACH — Adds an ERP attachment, complementing the ATTACH_ERP routines in the attachment creation flow.
• PARSE_ATTACHMENT_STRING — Parses a delimited attachment string into its constituent parts, used to interpret encoded attachment references.
• GET_CATEGORY_NAME — Resolves the category name associated with an attachment or document.
• GET_DESC_FLEX_ALL_PROMPTS — Retrieves all descriptive flexfield prompts relevant to attachment display.
• GET_DESC_FLEX_ALL_VALUES — Retrieves all descriptive flexfield values associated with an attachment context.
• EVENT_POST_OP — An event post-operation hook invoked after an attachment-related business event completes.

Tables Accessed

The package references the following tables through APPS synonyms:

• FND_DOCUMENTS — The core document definition table in Oracle's attachment framework.
• FND_ATTACHED_DOCUMENTS_S — The intersection of documents and the entities they are attached to; the primary target of attach and copy operations.
• EDR_FILES_B — The EDR files base table, storing file-level records for EDR-managed content.
• EDR_ERECORD_ID_TEMP — A temporary staging table for electronic record identifiers, used during copy and attachment processing.
• DUAL — Used for scalar evaluations and PL/SQL-safe single-row queries.
• PLITBLM — The PL/SQL integer table type, supporting array-based processing inside the package rather than a persistent store.

Usage Notes

EDR_ATTACHMENTS_GRP is not a standalone entry point; it is invoked by higher-level EDR packages. The documented reverse dependencies confirm this: the package is referenced by EDR_ISIGN_CHECKLIST_PVT, EDR_PSIG, and EDR_PSIG_RULE, in addition to being self-referenced. These are the e-signature checklist and signature rule packages, meaning attachment creation and copying occur in direct support of signature and checklist processing. The package also depends upward on the SYS.STANDARD package.

In practice, the automatic variants (ATTACH_ERP_AUT, ATTACH_FILE_AUT) and the EVENT_POST_OP hook indicate invocation from workflow, concurrent programs, or event-driven processing rather than only interactive forms. The flexfield prompt and value retrieval functions support UI rendering. Custom code should not call this package directly without validating signature compatibility for the target release (12.1.1 or 12.2.2), since it is internal EDR infrastructure intended for use by the EDR and e-signature modules.