Search Results authored_date




Overview
Explore in AI Chat

Overview

The APPS.AMW_ORG_PROC_CERT_DATED_SUMM package body is a reporting and summarization utility within the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment. It belongs to the Application Management Workspace (AMW) module, which underpins the Enterprise Risk and Compliance Management (ERM) / Audit Management functionality in EBS. Specifically, this package aggregates risk, control, and certification data at the organizational and process level, filtered by a date range — a design reflected in the "_DATED_SUMM" suffix. The functions return counts of evaluations, total risks, total controls, ineffective controls, unmitigated risks, and process highlights scoped to a certification or organization. The package is classified as OTHER (not a public API), indicating it is intended for internal use by AMW forms, concurrent programs, or dependent PL/SQL logic rather than as a published integration interface.

Key Procedures and Functions

The package exposes 25 documented functions grouped by analytical purpose:

The most recent evaluation per risk or control is determined through a correlated subquery against AMW_OPINIONS_LOG, using MAX(authored_date) — the same column the user searched on, indicating date-bounded evaluation history is central to the package's logic.

Tables Accessed

The package reads from the following APPS synonyms:

Usage Notes

This package is typically invoked from AMW certification and risk-assessment forms and from concurrent programs that produce summary dashboards. Because it is classified as OTHER rather than a public API and is referenced by zero other packages in the documented metadata, it is not a supported integration point. Custom code that calls these functions should treat the interface as unsupported and subject to change across patch levels. When invoking the date-aware functions, callers should supply from_date and to_date bounds to restrict evaluation history; when omitted, the metadata indicates the logic defaults to a wide historical window. The authored_date column in AMW_OPINIONS_LOG is the authoritative timestamp for evaluation sequencing and should be indexed for acceptable performance.