Search Results edr_esignatures_s

Overview

EDR_ADHOC_USER_PVT is a private PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the EDR (Electronic Document Repository / Electronic Records) product family, which underpins the Oracle EBS electronic signature and document management infrastructure. The package operates as an internal implementation unit rather than a public application programming interface; the "PVT" suffix indicates that its procedures are intended to be called only by other EDR packages and not directly by external or customer-written code.

Its business function centers on the maintenance of ad hoc signer lists used during electronic signature and approval workflows. When a document or record requires signatures, EDR components resolve the set of authorized signers; EDR_ADHOC_USER_PVT provides the logic that updates that list — adding, removing, or resequencing signers for a given electronic signature record. This supports compliance-driven processes in which signer assignment is not always fixed by a predefined routing rule but can be adjusted dynamically before or between signature events.

Key Procedures and Functions

ETRM documents a single public-facing program unit within this package body: UPDATE_SIGNERLIST.

• UPDATE_SIGNERLIST — Maintains the signer list associated with an electronic signature record. The procedure persists changes to the set of users who are expected to sign, writing the resulting signer data into the EDR electronic signature tables. Because it is a private package member, it is invoked by sibling EDR packages that control the signature lifecycle rather than called directly from forms or concurrent programs. The documented metadata does not expose a parameter list, and none should be assumed; callers must reference the shipped package specification and source in EDR_ADHOC_USER_PVT for the exact signature.

Tables Accessed

The dependency listing identifies the following objects referenced by the package body:

• EDR_ESIGNATURES — The primary electronic signature table, holding signature records for documents and records. UPDATE_SIGNERLIST interacts with this table to persist signer list changes against the correct signature entity.
• EDR_ESIGNATURES_S — The corresponding sequence (or shadow) object for EDR_ESIGNATURES. The dependency indicates the package body references EDR_ESIGNATURES_S, most likely to obtain a primary key value when new signer rows must be created. This is the object most closely associated with the user's search term "edr_esignatures_s".
• DUAL — Used for single-row PL/SQL SELECT statements and expression evaluation.
• PLITBLM — The Oracle-supplied PL/SQL table/array manipulation package, typically used for bulk collection handling when processing signer lists.
• FND_TABLE_OF_VARCHAR2_255 — An Oracle Application Object Library collection type, consistent with the package accepting or constructing a list of signer names or user identifiers.

Usage Notes

EDR_ADHOC_USER_PVT is not referenced by any other database object recorded in ETRM, and it is not exposed through a public API. It is therefore invoked from within the EDR signature-processing stack — for example, when an EDR electronic signature action is executed and the signer list must be recomputed or refreshed before the corresponding EDR_ESIGNATURES row is updated.

Because the package is private and version-specific, administrators and developers should not call UPDATE_SIGNERLIST from custom code. Customizations that need to alter signer lists should use the supported public EDR APIs or the standard EBS electronic signature configuration, then validate results against EDR_ESIGNATURES. Any direct dependency on this package is vulnerable to change during patching, since private EBS packages may be modified without notice. When troubleshooting missing or stale signers, the practical approach is to review EDR_ESIGNATURES and EDR_ESIGNATURES_S contents and trace the calling EDR package rather than invoke this body directly.