Search Results key_to_ids

Overview

The APPS.AME_STRING_VALUES_API package body is a seeded dictionary-style API within the Oracle Approvals Management (AME) module of Oracle E-Business Suite, present in both 12.1.1 and 12.2.2. Its role is to encapsulate the definition, loading, and maintenance of AME approval rules and, more broadly, the rule-building data structures that determine how transactions are routed to approvers. The package follows the standard EBS "seed data" architecture, where a descriptive language layer (identifying records by owner, key, and condition) is mapped onto the integer-based primary keys and audit columns required by the underlying tables. In this framework the package serves as the programmatic bridge between human-readable rule definitions and the physical rows that the AME rule engine evaluates at runtime.

Key Procedures and Functions

The package exposes a small, focused set of procedures oriented around row lifecycle management for AME string-value records. The documented procedures are:

• INSERT_ROW — Creates a new record in the target AME table, accepting the identifying keys together with the full set of standard audit columns (created by, creation date, last updated by, last update date, last update login) plus the date-range and object-version attributes that EBS seed data requires.
• DELETE_ROW — Removes an existing record by its identifying key. Used during reload or de-installation processing to keep seed data consistent with the delivered definition.
• LOAD_ROW — The upload routine that inserts or updates a definition in a single call. It is the interface normally invoked by the AME loader to reconcile delivered seed data with what already exists in the database.

The package body additionally contains the OWNER_TO_WHO helper (translating an owner identifier into the standard WHO audit columns) and KEY_TO_IDS, the routine corresponding to the search term key_to_ids. KEY_TO_IDS accepts a condition identifier and a string value and returns a count of matching rows from AME_STRING_VALUES; it is used to test whether a given condition/value pair already exists before an insert is attempted, thereby preserving uniqueness and avoiding duplicate seed rows.

Tables Accessed

The single documented table referenced through the APPS synonym is AME_STRING_VALUES. This table stores the string operand values associated with AME conditions — the literal values against which transaction attributes are compared during rule evaluation (for example, the specific status code or segment value that triggers an approval path). The package reads this table in KEY_TO_IDS to count existing matches, and writes to it through INSERT_ROW, DELETE_ROW, and LOAD_ROW. Columns touched include the condition identifier and string value, the WHO audit columns, the effective date range (START_DATE, END_DATE), and OBJECT_VERSION_NUMBER for optimistic concurrency control.

Usage Notes

This is an internal, seed-data-oriented API rather than a general-purpose business service. It is not referenced by other documented packages, so it is normally invoked by the AME seeding and upgrade infrastructure, by the AME setup loader, and by concurrent programs that refresh or migrate approval rule definitions between environments. Custom code should treat it as a low-level loader: direct calls are appropriate when seed string values must be created or removed programmatically, and KEY_TO_IDS is useful as a pre-check to avoid duplicate-condition errors. Because the API manipulates audited seed rows, calls should be made only by users with the appropriate AME administrator or applications schema privileges.