Search Results process_amw_risk_assoc

Overview

AMW_PROC_ORG_HIERARCHY_PVT is a private (PVT) PL/SQL package in the APPS schema of Oracle E-Business Suite, belonging to the Enterprise Risk Management (ERM) / Application Management Workbench (AMW) product family. Its purpose is to maintain and process the organizational hierarchy mapping that underpins the ERM Process Organization model. In ERM, business processes, risks, controls, accounts, and audit procedures are associated with one or more organizations in the enterprise hierarchy. This package encapsulates the programmatic logic that builds, validates, and stores those process-to-organization associations.

The package carries an API classification of PVT, meaning it is an internal, private API not intended for direct external consumption. It is called by the public ERM packages and workflow components rather than by customers or external integrations. Its status is VALID in the documented ETRM repository.

Key Procedures and Functions

The documented package exposes twelve procedures and functions. The core hierarchy processing routine is PROCESS_PROCESS_HIERARCHY, which drives the overall traversal and population of the process organization hierarchy. It is complemented by PROCESS_HIERARCHY_COUNT, which returns a count of hierarchy nodes processed. The function GET_PARENT_PROCESS_ID resolves the parent identifier for a given process, supporting upward traversal of the process tree.

A set of association-oriented procedures populate the linkage tables: ASSOCIATE_PROCESS_ORG associates a process with an organization; PROCESS_AMW_PROCESS_ORG, PROCESS_AMW_RCM_ORG, PROCESS_AMW_ACCT_ASSOC, PROCESS_AMW_RISK_ASSOC, PROCESS_AMW_CONTROL_ASSOC, and PROCESS_AMW_AP_ASSOC each handle the corresponding entity-to-organization assignments for processes, RCM organizations, accounts, risks, controls, and audit procedures respectively.

Validation is handled by VALIDATE_APO_TYPE and CHECK_APO_ROW, which verify that the association type is valid and that a candidate row satisfies the structural requirements before it is written. Together these routines enforce the integrity of the process-organization association model.

Tables Accessed

The package reads and writes the principal ERM association tables through APPS synonyms. AMW_PROCESS holds the master process definitions; AMW_PROCESS_ORGANIZATION and its _S (sequence/child) table store the process-to-organization mappings maintained by this package. AMW_ACCT_ASSOCIATIONS, AMW_RISK_ASSOCIATIONS, AMW_CONTROL_ASSOCIATIONS and AMW_AP_ASSOCIATIONS, together with their _S variants, hold the corresponding entity associations. AMW_RCM_ORG_INTERFACE provides the inbound organization records used when processing RCM organizations. The workflow tables WF_ACTIVITIES and WF_PROCESS_ACTIVITIES are consulted because ERM process hierarchies are frequently modeled as workflow processes, and DUAL is used for single-row utility queries.

Usage Notes

As a private API, AMW_PROC_ORG_HIERARCHY_PVT is invoked indirectly. It is referenced by AMW_WF_HIERARCHY_PKG, the workflow hierarchy package that orchestrates ERM process hierarchy generation, and it is self-referenced for internal recursion. Typical invocation occurs when an ERM administrator submits a concurrent program or performs a hierarchy refresh action in the ERM setup forms; at that point the public workflow package delegates the association and validation work to this private package. Custom code should not call the PVT package directly, because its signature and behavior are not guaranteed across releases. Any integration should target the supported public ERM APIs and workflow packages instead. This guidance applies equally to EBS 12.1.1 and 12.2.2, where the ERM data model is substantially unchanged.