Search Results insert_amw_process
Overview
AMW_LOAD_PROC_DATA is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It forms part of the Audit Management Workbench (AMW) application, which supports the definition, approval, certification, and control of business processes within the internal controls and audit-management framework. The package is declared with AUTHID CURRENT_USER, meaning that its unqualified SQL statements execute under the privileges of the invoking user rather than the package owner. This design allows the package to respect the security profile and responsibility privileges of the session that calls it.
Functionally, AMW_LOAD_PROC_DATA acts as a load and validation layer between interface staging data and the core AMW process definition tables. It moves process records from the interface table into the production process tables, validates process codes and hierarchy relationships, confirms approval status, and manages the assignment of owner-level privileges. It is classified as OTHER in the ETRM metadata, reflecting that it is an internal application programmatic interface rather than a published open API.
Key Procedures and Functions
The package exposes seventeen documented procedures and functions. The load path centers on POPULATE_INTF_TBL, which stages records into the interface table, and CREATE_PROCESSES, which drives the creation of process definitions. INSERT_AMW_PROCESS and UPD_AMW_PROCESS perform the physical insert and update against the process entities. GET_INV_PRC_CODE_ROW retrieves a specific process-code row from the interface or process data.
Validation logic is concentrated in several routines. PROCESS_CODE_EXISTS confirms whether a given process code is already defined, while INV_HIERARCHY_EXISTS verifies the presence of hierarchy information. NEW_PARENT_PROCESSES_CHECK and FIND_PARENT_PROCESS, together with its variant FIND_PARENT_PROCESS_V, resolve and validate parent-child relationships in the process hierarchy. PRC_APPR_CHK_FAILS evaluates whether approval checks have failed for a process.
Security and privilege routines include CHECK_FUNCTION and CHECK_FUNCTION_SECURITY, which verify function-level access, and ADD_OWNER_PRIVILEGE, which grants owner privileges on a process. The user's search term, PRE_PROCESS_ROLE_GRANT, corresponds to a dedicated routine within this package that performs role-grant preparation or execution as part of the process load sequence. Supporting utilities include VARCHAR2 and UPDATE_INTERFACE_WITH_ERROR, which marks interface rows with error status during failed loads.
Tables Accessed
The package references AMW_PROCESS, AMW_PROCESS_S, and AMW_PROCESS_NAMES_TL through APPS synonyms for the base, secure, and translated process definition data. AMW_PROCESSES_INTERFACE is the staging table populated by POPULATE_INTF_TBL and updated by UPDATE_INTERFACE_WITH_ERROR. Hierarchical relationships are read from AMW_PROC_HIERARCHY_DENORM. Process classification draws on AMW_WORK_CATEGORIES_B and AMW_WORK_TYPES_B. Approval and security references include FND_RESPONSIBILITY, FND_RESP_FUNCTIONS, FND_FORM_FUNCTIONS, and FND_COMPILED_MENU_FUNCTIONS, with FND_USER resolving owner identities. FND_LANGUAGES and FND_ATTACHED_DOCUMENTS support translation and attachment handling.
Usage Notes
AMW_LOAD_PROC_DATA is typically invoked indirectly by the Audit Management Workbench forms and concurrent programs during process import, hierarchy maintenance, and approval cycle processing. Because it is an internal package and is referenced by zero other documented packages, it should not be called directly by custom code without confirming compatibility. Customizations that require process loading should preferably use supported AMW interfaces or seed data mechanisms, and any direct invocation must account for the AUTHID CURRENT_USER privilege model.