Search Results ame_item_classes_tl




Overview
Explore in AI Chat

Overview

AME_ITL_SHD is a shadow (suffix _SHD) package body in the Oracle E-Business Suite Applications schema (APPS) associated with the Oracle Approvals Management (AME) module. It supports the translation layer for AME item classes, which are the configurable approval-rule categories used by AME to determine how transactions are routed through the approvals engine. Specifically, this package operates against AME_ITEM_CLASSES_TL, the translation table that stores language-specific item class names alongside the base definitions held in AME_ITEM_CLASSES.

The shadow designation indicates that this package is generated and maintained as a mirror of a corresponding core (non-shadow) package, typically used in multi-language and Multi-Org contexts to expose the same API surface without requiring direct modification of the primary object. The header comment ($Header: amitlrhi.pkb 120.0 2005/09/02) places the underlying source squarely within the standard AME release lineage shipped with Oracle EBS 12.1.1 and carried forward into 12.2.2. The package is classified as OTHER in the ETRM repository, meaning it is not exposed as a formal public API but is used internally by the AME translation framework.

Key Procedures and Functions

  • CONSTRAINT_ERROR — Centralised error handler for constraint violations raised during DML against AME item class translation rows. It inspects the failing constraint name; when the violation corresponds to the primary key AME_ITEM_CLASSES_TL_PK, it emits the message HR_6153_ALL_PROCEDURE_FAIL, and otherwise raises HR_7877_API_INVALID_CONSTRAINT with the offending constraint name as a token.
  • API_UPDATING — Predicate function that determines whether a row identified by item class and language is currently being updated. It drives off a cursor selecting from AME_ITEM_CLASSES_TL to compare the incoming key against the stored row, enabling the calling routine to distinguish insert from update paths.
  • LCK — Locking routine used to serialise concurrent access against item class translation records, protecting the integrity of the AME_ITEM_CLASSES_TL row during a translation maintenance operation.
  • ADD_LANGUAGE — Populates translation rows for a newly installed or activated language, propagating item class names into AME_ITEM_CLASSES_TL so that the approval-rule configuration is available in the target language.
  • CONVERT_ARGS — Argument-conversion helper that normalises and prepares the parameters passed into the translation API, ensuring consistent typing and formatting before the underlying DML is executed.

Tables Accessed

  • AME_ITEM_CLASSES_TL — The primary table maintained by this package; holds language-specific item class names keyed by item class ID and language.
  • AME_ITEM_CLASSES — The base (non-translated) item class definition table, referenced to validate the existence and identity of an item class.
  • FND_LANGUAGES — Oracle Application Object Library table of installed languages, used by ADD_LANGUAGE to determine which translations require materialisation.
  • ALL_CONSTRAINTS — Data dictionary view consulted by CONSTRAINT_ERROR to resolve constraint name metadata when raising a user-friendly error.

Usage Notes

AME_ITL_SHD is invoked indirectly rather than called by name from client code. The AME item class setup and translation maintenance screens within the Oracle Approvals Management HTML/Forms interface, along with the AME concurrent programs that install or upgrade language data, are the typical entry points. The object is referenced by four other packages in the ETRM dependency graph, confirming its role as a shared translation utility rather than an isolated routine.

Customisations that add new languages or bulk-load item class translations should route through the parent AME translation APIs so that locking, validation, and error handling performed by LCK, API_UPDATING, and CONSTRAINT_ERROR remain in force. Direct DML against AME_ITEM_CLASSES_TL bypasses this package and is not recommended.