Search Results find_parent

Overview

AMW_SCOPE_PVT is a private PL/SQL package body in the Oracle E-Business Suite (EBS) Audit Management module (product code AMW), part of the Enterprise Governance, Risk, and Compliance (EGRC) application family. The package encapsulates the internal business logic used to define, populate, and maintain audit scope — the set of organizations, business processes, subsidiaries, lines of business, projects, and related entities that an audit engagement is authorized to cover. Because it is classified as a PVT (private) package, its procedures are not intended to be called directly by external consumers; instead they are invoked by the public AMW APIs, Oracle Forms, and concurrent programs that manage audit scope.

The package also generates Workflow events when scope definitions change. The raise_scope_update_event helper, for example, raises the events oracle.apps.amw.proccert.scope.update for business process certifications and oracle.apps.amw.engagement.scope.update for projects, passing parameters such as MODE, ORGANIZATION_ID, CERTIFICATION_ID, or AUDIT_PROJECT_ID through the Workflow parameter list. A sequence, amw_scope_event_s, supplies the event key.

Key Procedures and Functions

The package exposes 21 documented procedures and functions. Their roles are:

• ADD_SCOPE — Adds entities to the audit scope.
• REMOVE_FROM_SCOPE / REMOVE_ORGS_FROM_SCOPE — Remove entities or specific organizations from scope.
• POPULATE_SCOPE — Main driver that materializes the scope definition.
• POPULATE_CUSTOM_HIERARCHY, POPULATE_PROCESS_HIERARCHY — Build custom and process hierarchies used for scope expansion.
• GENERATE_ORGANIZATION_LIST, GENERATE_SUBSIDIARY_LIST, GENERATE_LOB_LIST — Produce scoped lists of organizations, subsidiaries, and lines of business.
• INSERT_PROCESS — Inserts process records into scope.
• BUILD_PROJECT_AUDIT_TASK — Constructs audit tasks for a project.
• POPULATE_DENORMALIZED_TABLES, POPULATE_PROJ_DENORM_TABLES, POPULATE_ASSOCIATION_TABLES — Populate flattened/denormalized scope and association tables for performance.
• MANAGE_PROCESSES — Coordinates process-level scope management.
• FIND_CHILD_ORGS, FIND_CHILD_OBJECTS — Recursively resolve child organizations and child objects within a hierarchy (relevant to the "find_parent"-style scope navigation queries).
• GET_ASSOC_TASK_ID — Retrieves the association task identifier.
• GET_ACCESSIBLE_ROOT_ORGS — Returns root organizations the user may access.
• HAS_ORG_ACCESS_IN_HIER — Boolean check of organization access within a hierarchy.

Tables Accessed

The package reads and writes AMW scope and association tables, including AMW_AP_ASSOCIATIONS and AMW_AP_ASSOCIATIONS_S, AMW_AP_TASKS, AMW_AUDIT_PROCEDURES_B, AMW_AUDIT_PROJECTS, AMW_AUDIT_SCOPE_ORGANIZATIONS, AMW_AUDIT_SCOPE_PROCESSES, AMW_CONTROLS_B, AMW_CONTROL_ASSOCIATIONS and its _S variant, AMW_ENTITY_HIERARCHIES and AMW_ENTITY_HIERARCHIES_S, AMW_EXECUTION_SCOPE and AMW_EXECUTION_SCOPE_S, and AMW_ORG_CERT_EVAL_SUM. These tables store the scope definition, hierarchy structure, associations, and summarized evaluation data.

Usage Notes

AMW_SCOPE_PVT is referenced by three other packages and is normally invoked indirectly through public AMW APIs, Oracle Forms for audit engagement setup, and concurrent programs that populate scope. Developers should not call these private procedures directly; they should use the supported public interfaces, which in turn delegate to this package.