Search Results process_amw_rcm_org




Overview
Explore in AI Chat

Overview

AMW_PROC_ORG_HIERARCHY_PVT is a private PL/SQL package in the APPS schema that supports Oracle EBS Enterprise Transaction Risk Management (ETRM) — marketed as Oracle Advanced Controls and Oracle Risk Management. Its principal business function is to process and maintain the hierarchical relationship between a process and its associated organizations, so that the risk, control, and audit structures used in continuous monitoring and audit reporting are correctly scoped to the right organizational units. The package is classified as PVT, meaning it is an internal implementation body whose public entry point is exposed through a companion public wrapper; it is referenced directly by one other package. The body header (amwvpohb.pls, version 120.0, last shipped in the 2005 timeframe) confirms it was maintained under bug fix 3191406. ETRM metadata documents twelve procedures and functions within the package.

Key Procedures and Functions

  • PROCESS_PROCESS_HIERARCHY — The main driver API. Its documented parameters include p_process_id, p_organization_id, p_mode (default 'ASSOCIATE'), p_apo_type, p_commit, p_validation_level, and p_init_msg_list, with the standard FND_API x_return_status, x_msg_count, and x_msg_data outputs. It orchestrates the downstream processing calls.
  • ASSOCIATE_PROCESS_ORG and PROCESS_AMW_PROCESS_ORG — Establish and then persist the association between a process and an organization.
  • PROCESS_AMW_RCM_ORG — Handles organization records flowing through the RCM interface.
  • PROCESS_AMW_ACCT_ASSOC, PROCESS_AMW_RISK_ASSOC, PROCESS_AMW_CONTROL_ASSOC, PROCESS_AMW_AP_ASSOC — Derive and write the corresponding account, risk, control, and action-plan associations that hang off the process/organization hierarchy.
  • PROCESS_HIERARCHY_COUNT — This is the procedure associated with the search term "process_hierarchy_count." It computes and maintains hierarchy count values used to track how many organizational nodes or associations exist beneath a given process. Controllers and forms consume this count to validate hierarchy completeness and to drive activity-level logic; the module-level globals G_RISK_COUNT and G_CONTROL_COUNT track related cumulative totals.
  • VALIDATE_APO_TYPE, CHECK_APO_ROW, GET_PARENT_PROCESS_ID — Supporting utilities that validate the association type, verify row existence, and resolve the parent process in the hierarchy.

Tables Accessed

The package touches twelve ETRM base and interface tables via APPS synonyms. AMW_PROCESS, AMW_PROCESS_ORGANIZATION, and AMW_PROCESS_ORGANIZATION_S hold the process and process-to-organization definitions and their translations. AMW_ACCT_ASSOCIATIONS_S, AMW_RISK_ASSOCIATIONS_S, AMW_CONTROL_ASSOCIATIONS_S, and AMW_AP_ASSOCIATIONS_S (with their non-translation counterparts) store the account, risk, control, and action-plan associations the package creates. AMW_RCM_ORG_INTERFACE is the staging table for organization data entering through the RCM interface. WF_ACTIVITIES and WF_PROCESS_ACTIVITIES are Oracle Workflow tables, reflecting the integration between ETRM hierarchies and Workflow-based process definitions. DUAL is used for singleton lookups.

Usage Notes

AMW_PROC_ORG_HIERARCHY_PVT is invoked programmatically rather than directly by end users. It is called by its public wrapper package, by Oracle EBS ETRM forms when users maintain processes, organizations, and their associations, and by concurrent programs or bulk-load routines that import organizations through AMW_RCM_ORG_INTERFACE. Because it performs commit-controlled DML with FND_API error handling, callers should supply a meaningful p_mode, set p_commit only when the calling transaction is complete, and inspect x_return_status along with x_msg_count and x_msg_data on return. Customizations should not call the _PVT body directly; use the public API wrapper to preserve supportability across EBS 12.1.1 and 12.2.2.