Search Results ame_itl_shd




Overview
Explore in AI Chat

Overview

AME_ITL_SHD is an Oracle Applications (APPS) schema PL/SQL package belonging to the Oracle Approvals Management Engine (AME) product family. The suffix SHD conventionally denotes a shadow package — a generated, mirror-image copy of a corresponding transactional package. In Oracle EBS 12.1.1 and 12.2.2, AME uses shadow packages to support the Oracle Applications "audit shadow" pattern, whereby the shadow package carries the same interface as its base counterpart but performs no business logic beyond argument conversion, language handling, and constraint validation. AME_ITL_SHD is the shadow for AME_ITL, which manages the item classes used by AME to categorize the transactional entities (for example, purchase orders, requisitions, and HR records) that participate in approval routing. The package is classified as OTHER in the AME API taxonomy, meaning it is not part of the public, customer-facing AME API surface and is intended strictly for internal use by the AME engine and the generated audit infrastructure.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within AME_ITL_SHD:

  • CONSTRAINT_ERROR — A handler that raises or reports constraint violations encountered while processing item class records, ensuring integrity errors surface consistently to the calling package.
  • API_UPDATING — A status flag procedure used to signal that the package is executing within the context of an API-driven update, allowing downstream logic to distinguish API operations from direct data manipulation.
  • LCK — A locking routine that acquires the necessary row locks on AME item class data to serialize concurrent access and prevent lost updates.
  • ADD_LANGUAGE — Handles the insertion or registration of translated item class rows for a given language, supporting the multilingual (TL) model used by AME.
  • CONVERT_ARGS — Converts arguments between the internal representation used by the shadow package and the form expected by the base AME_ITL package, a standard responsibility of generated shadow code.

No parameter lists are documented for these units, and none should be assumed.

Tables Accessed

AME_ITL_SHD references four tables through APPS synonyms. AME_ITEM_CLASSES is the primary base table storing item class definitions; AME_ITEM_CLASSES_TL holds the translated (language-specific) descriptions for those classes. FND_LANGUAGES provides the list of installed languages used by ADD_LANGUAGE to determine valid translation targets. ALL_CONSTRAINTS is queried for constraint metadata, supporting the CONSTRAINT_ERROR routine's validation of integrity rules. These accesses are consistent with an AME shadow package that mirrors item class CRUD operations while remaining language-aware.

Usage Notes

AME_ITL_SHD is not intended for direct invocation by end users, forms, or concurrent programs. It is referenced by four other packages — AME_ITL_BUS, AME_ITL_DEL, AME_ITL_INS, and AME_ITL_UPD — which represent the generated insert, update, delete, and business-rule layers of the AME_ITL object family. In practice, the shadow package is exercised indirectly whenever those packages perform audit-enabled operations on AME item classes, for example during configuration of AME setup data in Oracle EBS 12.1.1 or 12.2.2. Because the package depends on STANDARD, SYS, and PUBLIC objects and carries an APPS owner with VALID status, it follows the standard EBS schema deployment model and must never be modified or patched independently of its generating framework. Custom code should call the AME_ITL base or public APIs rather than AME_ITL_SHD.