Search Results amw_process_objectives

Overview

AMW_LOAD_RC_DATA is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema and classified as an "OTHER" API within the ETRM (Enterprise Risk and Compliance Management) module. Its principal business function is to load risk and control data into the ETRM repository from a staging area, specifically the AMW_RISK_CTRL_INTERFACE table. The package reads pending interface rows and materializes them as fully formed risk and control records, including the associated linking structures that tie risks to controls, objectives, assertions, and assessment components.

The header comment block is explicit about the scope of work. The package inserts or updates against AMW_RISKS_B and AMW_RISKS_TL, AMW_CONTROLS_B and AMW_CONTROLS_TL, and the association tables AMW_CONTROL_ASSOCIATIONS, AMW_RISK_ASSOCIATIONS, AMW_CONTROL_OBJECTIVES, and AMW_CONTROL_ASSERTIONS. It also updates AMW_RISK_CTRL_INTERFACE with error messages and, subject to a profile option setting, deletes successfully processed interface rows. This design makes the package a bulk data-conversion and integration utility rather than a user-facing transaction API.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions. The central driver is CREATE_RISKS_AND_CONTROLS, which processes interface rows and orchestrates the creation of risk and control records. UPDATE_INTERFACE_WITH_ERROR writes failure diagnostics back to the interface table so that rejected rows remain auditable. RISK_TYPES supports resolution or validation of the risk type value carried on each interface record.

The remaining procedures build the subsidiary structures attached to a risk or control. CONTROL_OBJECTIVES and CONTROL_ASSERTIONS create the objective and assertion links for controls, while CONTROL_COMPONENTS associates controls with assessment components. CREATE_PROCESS_OBJECTIVES establishes process-level objectives. The association-building procedures — CREATE_AMW_CTRL_ASSOC, CREATE_AMW_AP_ASSOC, CREATE_AMW_OBJ_ASSOC, and CREATE_AMW_RISK_ASSOC — populate the respective relationship tables. ADD_OWNER_PRIVILEGE grants the appropriate access rights to the owner of newly created records, and CHECK_FUNCTION performs an authorization or function-security validation before processing proceeds.

Tables Accessed

The package reads from the AMW_RISK_CTRL_INTERFACE staging table and writes to the base and translation tables AMW_RISKS_B, AMW_RISKS_TL, AMW_CONTROLS_B, and AMW_CONTROLS_TL. Relationship data is persisted in AMW_CONTROL_ASSOCIATIONS, AMW_RISK_ASSOCIATIONS, AMW_CONTROL_OBJECTIVES, AMW_CONTROL_ASSERTIONS, AMW_AP_ASSOCIATIONS, and AMW_OBJECTIVE_ASSOCIATIONS. Assessment-related writes target AMW_ASSESSMENT_COMPONENTS. Several of these tables have companion _S sequences or alternate-key tables referenced in the metadata, notably AMW_AP_ASSOCIATIONS_S, AMW_ASSESSMENT_COMPONENTS_S, AMW_CONTROL_ASSERTIONS_S, AMW_CONTROLS_TL_S1, and the association sequence tables used to generate primary keys.

Usage Notes

AMW_LOAD_RC_DATA is typically invoked from a concurrent program or a scheduled batch job that processes accumulated rows in the interface table, since its delete-on-success behavior and error writeback are characteristic of bulk loaders rather than interactive forms. The package depends on FND_GLOBAL for user and login context, confirming that it executes within an authenticated EBS session and applies function-security checks through CHECK_FUNCTION. It is referenced by zero other packages, indicating it is a top-level entry point called directly by the loader program or custom conversion code. Implementations performing data migration of risks and controls should populate AMW_RISK_CTRL_INTERFACE and then submit this package; the profile-controlled deletion option determines whether successfully processed staging rows are retained for reconciliation.