Search Results amw_process_pkg

Overview

AMW_PROCESS_PKG is a PL/SQL package owned by the APPS schema. Within the Oracle E-Business Suite, the AMW prefix associates the object with the Advanced Management Workbench / Enterprise Transaction Management Repository (ETRM) functional area. In ETRM, an "AMW_PROCESS" represents a defined data-processing or migration-related action invoked by the user at runtime. The package AMW_PROCESS_PKG therefore serves as the DML (data manipulation) layer that maintains the underlying AMW_PROCESS repository table.

The package is the row-level processing engine for one core ETRM setup entity: definitions maintained for each process. It provides insert, update, delete, lock, and single-row load operations. Higher-level functionality — such as running processes or validating them — is implemented in separate modules (notably AMW_PROCESS_PVT, which references this package). AMW_PROCESS_PKG stays deliberately thin: it validates and commits row data, coordinates concurrency with LOCK_ROW, and centralizes access to AMW_PROCESS so that all client code uses one consistent code path. Its ETRM API classification is OTHER, and it is valid in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The ETRM metadata documents five procedures. No parameter lists are published; the descriptions below are functional only.

• INSERT_ROW — Creates a new AMW_PROCESS record. It accepts the attribute values for a new process definition and performs the physical insert, applying the standard ETRM WHO-column (audit) conventions and returning the generated identifier for subsequent use.
• UPDATE_ROW — Modifies an existing AMW_PROCESS record identified by its primary key. It applies changed attribute values while preserving audit columns; callers typically hold the row through LOCK_ROW first.
• DELETE_ROW — Removes a single AMW_PROCESS record. It is invoked when a process definition is no longer required and enforces whatever referential or status checks the ETRM data model requires before the row is deleted.
• LOCK_ROW — Acquires a row-level lock on a specified AMW_PROCESS record (typically via SELECT ... FOR UPDATE), serializing concurrent maintenance so that two sessions cannot update the same process definition simultaneously. It is the concurrency-control primitive used before UPDATE_ROW or DELETE_ROW.
• LOAD_ROW — Loads a complete row definition and applies it to AMW_PROCESS, following the standard ETRM pattern for programmatic or bulk data loading (for example during installation, patching, or data migration). It inserts when the record does not exist and updates when it does.

Tables Accessed

The package accesses a single documented table, AMW_PROCESS, through the APPS synonym layer. AMW_PROCESS is the master repository table holding one row per ETRM process definition (identifying attributes, source and target information, and standard WHO audit columns). All five procedures operate on this table: LOAD_ROW and INSERT_ROW write new rows, UPDATE_ROW modifies existing rows, DELETE_ROW removes rows, and LOCK_ROW reads the target row with a locking read. No other application tables are documented as direct references; the only other dependency recorded is on the SYS.STANDARD package, a normal PL/SQL dependency.

Usage Notes

AMW_PROCESS_PKG is an internal DML utility rather than a standalone end-user interface. It is typically invoked from ETRM maintenance pages — such as the Process Definition form in the ETRM Setup responsibility — and from concurrent programs that create or migrate process definitions. The ETRM metadata shows that AMW_PROCESS_PKG is referenced by exactly one other package, AMW_PROCESS_PVT, which encapsulates the business logic layered over this table. Customizations should follow the same pattern: call AMW_PROCESS_PKG rather than issuing direct DML against AMW_PROCESS, so that validation and audit-column handling remain consistent. Because the package is not a public, versioned API, its signature may change across patch levels; implementations should be re-verified after applying ETRM patches or upgrades.