Search Results amw_controls_page_pkg




Overview
Explore in AI Chat

Overview

APPS.AMW_CONTROLS_PAGE_PKG is a PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking session rather than the package owner. In the Oracle EBS 12.1.1 and 12.2.2 releases, this package belongs to the ETRM (Enterprise Tax, Risk, and Management) product family — specifically the Application Management Workspace / Audit Management module used for internal controls, assessments, and risk evaluation. The package implements the server-side logic that supports the Controls page and related maintenance pages within the ETRM HTML interface.

Its primary business purpose is to answer structural questions about a control revision: whether a given objective, assertion, or component is present; whether a preventive control exists; whether an association already exists between a process objective and a control; and whether a control is effective. In addition, the package exposes a small set of data-processing routines that persist control, objective, assertion, and component associations, and one routine that removes them. The user search term delete_obj_assert_comp corresponds to the documented procedure DELETE_OBJ_ASSERT_COMP, which deletes the association rows joining an objective, assertion, and component record.

Key Procedures and Functions

The 24 documented entry points group into three functional clusters:

Tables Accessed

The package reads and writes a focused set of ETRM base and translation tables through APPS synonyms. Control definitions are held in AMW_CONTROLS_B, while AMW_CONTROL_OBJECTIVES, AMW_CONTROL_OBJECTIVES_S, AMW_CONTROL_ASSERTIONS, AMW_CONTROL_ASSERTIONS_S, AMW_CONTROL_PURPOSES, and AMW_CONTROL_PURPOSES_S store the objective, assertion, and purpose relationships (the _S tables are the translation/snapshot counterparts). AMW_CONTROL_ASSOCIATIONS and AMW_OBJECTIVE_ASSOCIATIONS persist the higher-level linkages tested by ASSOCIATION_EXISTS and removed by DELETE_CONTROL_ASSOCIATION and DELETE_OBJ_ASSERT_COMP. AMW_ASSESSMENT_COMPONENTS and AMW_ASSESSMENT_COMPONENTS_S supply component-scoring data used by the component presence checks. AMW_PROCESS and AMW_OPINIONS support process context and opinion records, and BIS_APPLICATION_MEASURES and BIS_INDICATORS provide the BIS (Business Intelligence System) metric definitions referenced by the effectiveness logic.

Usage Notes

AMW_CONTROLS_PAGE_PKG is invoked almost exclusively from the ETRM Controls and Assessment JSP/HTML pages rather than from Oracle Forms or standalone concurrent programs. The presence-check functions fire on page rendering and on user actions such as adding an objective, assertion, or component, to prevent duplicate associations. The PROCESS_* procedures execute when the user saves changes to a control revision, and the DELETE_* procedures execute when associations are removed. Because the package is documented as referenced by one other package, customizations should avoid altering its AUTHID behavior or its public signatures; integrators typically call these routines from custom ETRM extensions rather than replacing them. Validation of control effectiveness and workflow-approval state should always be delegated to IS_CONTROL_EFFECTIVE and IS_WKFLW_APPR_DISBLD to remain consistent with seeded behavior across 12.1.1 and 12.2.2.