Results for “get_rule_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.AME_UTILITY_PKG package body is a foundational utility library within the Oracle Approvals Management Engine (AME), the rules-based engine that determines approval routing, action types, and authorization chains across Oracle E-Business Suite. Unlike the transaction-specific AME APIs that create and manage approval transactions, this package provides shared helper logic that other AME components, including AME_API, AME_ENGINE, and the AME administrative forms, rely upon for routine data retrieval, validation, and transaction control. Its classification as an OTHER API reflects that it exposes internal housekeeping routines rather than a public integration interface.

The package is heavily reused: it is referenced by 41 other packages and itself depends on core AME tables, several AME base packages, and Oracle foundation utilities such as FND_API, FND_MESSAGE, FND_FLEX_VALUE_SETS, and DBMS_SQL. This dependency footprint confirms its role as a cross-cutting service layer for the AME data model.

Key Procedures and Functions

The package exposes 22 documented procedures and functions. The principal routines fall into several logical groupings:

• Validation routines: VALIDATE_QUERY verifies the syntactically correct and executable form of dynamically constructed SQL, while IS_VALID_ATTRIBUTE and IS_APPROVER_VALID_IN_ACTION confirm that attributes and approvers are properly configured for a given action. IS_RULE_UPDATABLE determines whether a rule may still be modified.
• Description lookups: GET_ACTION_DESCRIPTION and GET_CONDITION_DESCRIPTION resolve identifiers to human-readable text, and GET_ACTION_TYPES retrieves the action type definitions used throughout the engine.
• Identifier resolution: GET_RULE_ID, GET_CONDITION_ID, and GET_ITEM_CLASS_ID return surrogate keys for their respective AME entities.
• Rule metadata: GET_RULE_LAST_UPDATE_DATE, GET_RULE_LAST_UPDATED_BY, GET_RULE_LAST_UPDATE_ACTION, and GET_RULE_END_DATE surface audit and lifecycle information for approval rules.
• Value set support: GET_VALUE_SET_QUERY constructs the query used for flexfield value set validation.
• Transaction control: SET_AME_SAVEPOINT and ROLLBACK_TO_AME_SAVEPOINT provide AME-scoped savepoint management.
• Maintenance routines: PURGE_LOG cleans the AME_EXCEPTIONS_LOG table, GET_ATTRIBUTE_CATEGORY returns attribute category context, and CHECK_SEEDDB verifies the seed database identifier used during setup and cloning.

Tables Accessed

The package reads and writes the core AME configuration tables, several of which are referenced through their translated views such as AME_ACTIONS_VL. The primary tables include AME_ACTIONS, AME_ACTION_TYPES, and AME_ACTION_USAGES for action configuration; AME_CONDITIONS, AME_CONDITIONS_S, and AME_CONDITION_USAGES for condition definitions; AME_RULES, AME_RULES_S, and AME_RULE_USAGES for approval rules; and the supporting tables AME_ATTRIBUTES, AME_ATTRIBUTE_USAGES, AME_MANDATORY_ATTRIBUTES, AME_APPROVER_TYPES with its _S variant, and AME_ITEM_CLASSES with AME_ITEM_CLASS_USAGES. Write activity is concentrated in AME_EXCEPTIONS_LOG, which the purge routine targets.

Usage Notes

AME_UTILITY_PKG is not intended for direct invocation by external applications. It is exercised indirectly when business users configure AME rules through the Approvals Management Administration forms, when the AME engine evaluates approval transactions, and when concurrent programs such as AME data purge or setup validation execute. Customizations that extend AME should prefer the documented public AME APIs, treating this utility package as an internal implementation detail whose signature may change between patch levels. The reference to AME_ACTIONS_VL and its translated counterparts indicates that description routines respect multi-language installations by reading the _VL views rather than base tables.