Search Results get_author_name




Overview
Explore in AI Chat

Overview

EDR_FILE_UTIL_PUB is a public PL/SQL utility package in the Oracle E-Business Suite (12.1.1 and 12.2.2) that supports the Engineering Document Repository (EDR) / ETRM product family. Its documented purpose is to expose small, single-purpose accessor routines that return descriptive metadata about files registered in the EDR repository. Rather than requiring calling code to join directly against repository tables, the package provides a stable public API for retrieving attributes such as the file name, version label, attribute category, author name, a user-designated attribute column, and the underlying binary file data. The package header version string (EDRFUTLB.pls 120.0.12000000.1, dated 2007/01/18) indicates the body predates the 12.2 uplift but remains valid; documentation lists it as an APPS-owned public API with six procedures and references from three other packages.

Key Procedures and Functions

  • GET_FILE_NAME — Returns the physical file name stored for a given file identifier; returns NULL when no record is found.
  • GET_VERSION_LABEL — Returns the version label associated with the file, used to identify revision context; NULL when not found.
  • GET_CATEGORY_NAME — Returns the descriptive flexfield attribute category for the file record, enabling the caller to interpret the attribute columns.
  • GET_AUTHOR_NAME — Returns the display user name of the creating user by joining the file record to FND_USER; NULL when not found.
  • GET_ATTRIBUTE — This is the procedure matched by the search term "get_attribute". It accepts a file identifier and a caller-supplied attribute column name and returns the value of that column. Implementation uses dynamic SQL (EXECUTE IMMEDIATE) with the column name and file identifier concatenated into the statement string. It handles only NO_DATA_FOUND, setting the output to NULL.
  • GET_FILE_DATA — Returns the binary content of the file as a BLOB, joining FND_LOBS, FND_DOCUMENTS_VL, and EDR_FILES_VL through the document media relationship.

Tables Accessed

  • EDR_FILES_B — The base repository table. It supplies file_name, version_label, attribute_category, the flexfield attribute columns addressed by GET_ATTRIBUTE, and the created_by reference used in the author lookup.
  • FND_USER — Joined to EDR_FILES_B in GET_AUTHOR_NAME to resolve the creating user's name from the stored user identifier.
  • FND_LOBS — Read by GET_FILE_DATA when the file is stored as a media object, joined to the document and file views to locate the stored LOB.
  • Supporting views referenced within the body include EDR_FILES_VL and FND_DOCUMENTS_VL, which supply the document linkage used to reach the LOB record.

Usage Notes

The package is a read-only utility API and is typically invoked from ETRM forms, from concurrent programs that generate repository listings or export file metadata, and from custom PL/SQL that needs a supported interface to the EDR repository rather than direct table access. Because it is classified PUB and referenced by three other packages, it should be treated as a stable integration point; direct queries against EDR_FILES_B should be avoided in favor of these procedures. GET_ATTRIBUTE warrants particular care: its use of concatenated dynamic SQL means the caller must supply a valid, expected attribute column name, and because the file identifier is concatenated as a numeric literal rather than bound, callers should never pass unvalidated string input. Callers should also expect NULL — not an exception — when a record does not exist, and should use the companion routines for the standard file name, version, category, and author fields instead of passing those column names to GET_ATTRIBUTE.