Search Results amw_load_proc_data




Overview
Explore in AI Chat

Overview

The APPS.AMW_LOAD_PROC_DATA package body is a core data-loading and validation component of the Oracle E-Business Suite Process Manufacturing / ETRM (Enterprise Transaction Management) module. Its primary business function is to load, stage, validate, and commit process definition data into the AMW process repository from the staging interface table AMW_PROCESSES_INTERFACE. It orchestrates the transformation of raw interface rows into valid AMW_PROCESS records, resolves parent-child process hierarchies, enforces function-level security, applies approval rules, and propagates hierarchy information into the denormalized hierarchy table. The object resides in the APPS schema, is classified as an OTHER-type API, and is marked VALID. It is a standalone package, referenced by no other database objects, which indicates it is invoked directly by concurrent programs or forms rather than being called programmatically by peer packages.

Key Procedures and Functions

The package exposes seventeen documented procedures and functions:

Tables Accessed

Via APPS synonyms, the package interacts with process definition tables AMW_PROCESS, AMW_PROCESSES_INTERFACE, AMW_PROCESS_NAMES_TL, AMW_PROCESS_NAME_S, AMW_PROCESS_S, AMW_PROC_HIERARCHY_DENORM, AMW_WORK_CATEGORIES_B, and AMW_WORK_TYPES_B. It also reads Foundation tables including FND_ATTACHED_DOCUMENTS, FND_COMPILED_MENU_FUNCTIONS, FND_FORM_FUNCTIONS, FND_LANGUAGES, FND_RESPONSIBILITY, FND_RESP_FUNCTIONS, and FND_USER to support attachment handling, function security, and responsibility-based access checks.

Usage Notes

This package is typically invoked by the ETRM concurrent process that imports process definitions, and by setup forms that manage process hierarchies. It relies on AMW_UTILITY_PVT, AMW_SECURITY_PUB, AMW_PROC_APPROVAL_PKG, AMW_RL_HIERARCHY_PKG, and FND_API/FND_MSG_PUB for validation and error propagation. Custom code should call it only after staging valid interface rows, since it assumes the AMW interface table is populated.