Search Results get_amerule_varvalues

Overview

EDR_STANDARD_PUB is a public PL/SQL package in the Oracle E-Business Suite EDR (Electronic Document and Record / Electronic Signature) product family, owned by APPS and classified as a Public API. It serves as the utility layer of Oracle EBS electronic signature and electronic record functionality, exposing a stable, FND_API-compliant interface that other EDR packages, Oracle Forms, and customer extensions call to determine whether signature or record capture is required, to retrieve signature status, to resolve approval-management rule variables, and to format and return descriptive flexfield, lookup, and notification data.

The package body is a thin, defensive wrapper: it validates the caller's API version through fnd_api.Compatible_API_Call, initializes the message stack when requested via FND_MSG_PUB.initialize, delegates the substantive work to the EDR_STANDARD package or to local private helpers, and then populates the standard x_return_status, x_msg_count, and x_msg_data out parameters using FND_MSG_PUB.Count_And_Get. The body carries the $Header revision marker 120.0.12000000.1 dated 2007/01/18, indicating it shipped early in the 12.x line and has remained largely stable through 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented interface comprises eighteen procedures and functions. The signature and record control group includes GET_PSIGSTATUS, which returns the signature status for a given event and event key (with a documented example of the oracle.apps.gmi.item.create event and an item-number event key); IS_ESIG_REQUIRED and IS_EREC_REQUIRED, which evaluate the EDR configuration to determine whether a signature or an electronic record must be captured for the transaction at hand. GET_ERECORD_ID returns the identifier of the electronic record associated with an event, and IS_AUDITVALUE_OLD supports audit comparison against a previous value.

The query and view-helper group supports Oracle Forms and OAF pages: GET_QUERYID_ONEVENTS and GET_QUERYID_ONPARAMS resolve a saved query identifier from an event or from parameter values. The approval-management group contains GET_AMERULE_VARVALUES and GET_AMERULE_VARIABLEVALUES, which extract the variable values referenced by approval-management rules so that rule evaluation and notification text can be rendered; these are the routines most frequently sought by developers searching for "get_amerule_varvalues," and they operate as a matched pair of overloaded-style accessors. Presentation helpers include DISPLAY_DATE, DISPLAY_DATE_ONLY, and DISPLAY_TIME_ONLY for consistent date and time formatting, GET_DESCFLEX_ONEPROMPT and GET_DESCFLEX_ALLPROMPTS for descriptive flexfield prompt retrieval, and GET_LOOKUP_MEANING for translating a lookup code to its displayed meaning. GET_NOTIF_ROUTING_INFO resolves workflow notification routing, and USER_DATA_XML assembles user-entered data into XML form for downstream processing.

Tables Accessed

The package body accesses two tables through APPS synonyms. EDR_PSIG_DOCUMENTS stores the signature document records that underpin signature-status and esignature-requirement checks; GET_PSIGSTATUS and IS_ESIG_REQUIRED read from it to determine existing signature state. PLITBLM is the standard PL/SQL integer table used for message and list handling within the FND message framework. All other data is obtained by delegating to the EDR_STANDARD package.

Usage Notes

EDR_STANDARD_PUB is invoked from Oracle Forms and OAF pages in the EDR and approval-management flows, from workflow notification and routing logic, and from custom PL/SQL that needs to check signature or record requirements before committing a transaction. It is referenced by seven other packages. Callers should pass a compatible p_api_version, observe the returned x_return_status, and drain the message stack via FND_MSG_PUB when the count exceeds one.