Search Results populate_org_cert_sum_spec




Overview
Explore in AI Chat

Overview

AMW_ORG_CERT_EVAL_SUM_PVT is a private PL/SQL package in the Oracle E-Business Suite environment, owned by the APPS schema and classified as a PVT (private) API within Oracle's Enterprise Risk Management (ETRM) and Oracle Application Management product family. Its name reflects its core responsibility: evaluating and summarizing organization certification data. The package controls how certification records, associated risk and control structures, opinions, entity hierarchies, and execution scope information are consolidated into a summarized evaluation result set stored in the AMW_ORG_CERT_EVAL_SUM table.

The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the calling user rather than the defining APPS user, a common convention for internal packages that are not intended to be called directly by external applications. The $Header line indicates the source file is amwocerts.pls, last updated in 2005, consistent with the long-standing code base that has been carried forward to EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package exposes three documented procedures:

  • populate_org_cert_summary — A concurrent-program-oriented entry point that accepts error buffer and return code output parameters along with a certification identifier. It writes status information back to the concurrent manager, making it suitable for scheduled or ad hoc background processing of a single certification's summary.
  • populate_org_cert_sum_spec — The specific procedure the user searched for. It accepts a certification identifier and drives the population of the organizational certification summary for that certification. In practice it encapsulates the core summarization logic invoked by the broader wrapper procedures, focusing on a single certification scope.
  • populate_summary — A fully formed API-style procedure following the standard Oracle FND_API signature conventions, including API version number, initialization message list, commit flag, validation level, organization ID, and certification ID as inputs, with return status, message count, and message data as outputs. This procedure represents the formal, controlled interface for populating summary records and supports the standard EBS API error-handling framework.

Tables Accessed

The package reads and writes the following documented application tables through APPS synonyms:

  • AMW_ORG_CERT_EVAL_SUM — The primary destination table where the summarized organization certification evaluation results are written.
  • AMW_CONTROL_ASSOCIATIONS — Provides control-to-entity associations used to determine which controls apply within the certification scope.
  • AMW_RISK_ASSOCIATIONS — Supplies risk association data linking risks to entities and controls during evaluation.
  • AMW_ENTITY_HIERARCHIES — Defines the organizational hierarchy used to roll up or aggregate certification evaluation results across entities.
  • AMW_EXECUTION_SCOPE — Determines the scope of the certification execution, ensuring only in-scope elements are summarized.
  • AMW_OPINIONS — Holds opinion records that feed into the summarized evaluation output.

Usage Notes

As a PVT-classified package, AMW_ORG_CERT_EVAL_SUM_PVT is not intended for direct invocation by end users or external integrations. It is invoked internally by other EBS components, and the ETRM metadata confirms it is referenced by one other package. The populate_org_cert_summary procedure is structured to run under the concurrent manager, indicating that summary regeneration is typically triggered through a concurrent program or a scheduled process. The populate_summary API accepts organization and certification identifiers, allowing callers to scope summarization to a specific operating unit and certification. Customizations should avoid calling the private procedures directly; instead, the public wrapper that references this package should be used to preserve upgrade safety across EBS 12.1.1 and 12.2.2.