Search Results new_objective_present
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:
- Presence-check functions: OBJECTIVE_PRESENT, NEW_OBJECTIVE_PRESENT, PREVENTIVE_CONTROL_PRESENT, ASSERTION_PRESENT, NEW_ASSERTION_PRESENT, COMPONENT_PRESENT, and NEW_COMPONENT_PRESENT each return a VARCHAR2 indicator that tells the calling page whether the referenced entity is already linked to the control revision. The "NEW_" variants support the duplicate-check behavior applied when a user adds a fresh row on the controls page.
- Lookup and retrieval functions: GET_OBJ returns the objective text associated with a control revision and tag number; GET_LOOKUP_VALUE resolves a lookup code against a lookup type; GET_CONTROL_SOURCE returns the source of a control; GET_POLICY returns the governing policy; GET_UOM_TL returns the translated unit-of-measure description; IS_CONTROL_EFFECTIVE and IS_WKFLW_APPR_DISBLD return status flags for effectiveness and workflow-approval disabling.
- DML and maintenance procedures: PROCESS_OBJECTIVE, PROCESS_ASSERTION, and PROCESS_COMPONENT create or update the respective association rows for a control revision. ASSOCIATION_EXISTS tests whether a process objective is already linked. DELETE_CONTROL_ASSOCIATION removes a control-level association, while DELETE_OBJ_ASSERT_COMP removes the higher-granularity objective/assertion/component linkage — the object referenced by the user's search.
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.