Results for “amw_load_proc_data”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• CREATE_PROCESSES — Orchestrates creation of process records from staged interface data.
• POPULATE_INTF_TBL — Loads incoming data into the process interface table.
• INSERT_AMW_PROCESS — Inserts validated rows into AMW_PROCESS.
• UPD_AMW_PROCESS — Updates existing process records.
• UPDATE_INTERFACE_WITH_ERROR — Writes error messages back to the interface table.
• FIND_PARENT_PROCESS / FIND_PARENT_PROCESS_V — Locate parent process references.
• NEW_PARENT_PROCESSES_CHECK — Validates parent process definitions.
• PROCESS_CODE_EXISTS — Checks for duplicate process codes.
• INV_HIERARCHY_EXISTS — Verifies hierarchy existence.
• GET_INV_PRC_CODE_ROW — Retrieves invalid process code rows.
• PRC_APPR_CHK_FAILS — Tests approval check outcomes.
• CHECK_FUNCTION / CHECK_FUNCTION_SECURITY — Enforce function-level security.
• ADD_OWNER_PRIVILEGE / PRE_PROCESS_ROLE_GRANT — Apply owner and role privileges.
• A VARCHAR2-returning helper (documented by type) supporting the above.

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.