Search Results amw_org_cert_aggr_pkg




Overview
Explore in AI Chat

Overview

AMW_ORG_CERT_AGGR_PKG is an Oracle EBS PL/SQL package owned by the APPS schema and classified as OTHER within the ETRM (Enterprise Transaction/Reference Model) repository. It supports the Oracle Quality / Advanced Product Catalog certification aggregation subsystem, where organization-level certification evaluations are rolled up and summarized across the enterprise hierarchy. The package operates under AUTHID CURRENT_USER, meaning that privilege resolution and unqualified object references are evaluated against the calling schema at runtime rather than the definer, consistent with the header signature $Header: amwocags.pls 120.0 2005/09/30 15:54:33 appldev noship $. Its documentation in ETRM 12.1.1 identifies three public procedures forming the aggregation lifecycle: building the full hierarchy, populating aggregation rows, and updating those rows when scoped to a specific organization. The package is referenced by one other package in the E-Business Suite, indicating that it is invoked programmatically rather than exposed directly to end users through a standalone form.

Key Procedures and Functions

Three documented procedures comprise the public interface of AMW_ORG_CERT_AGGR_PKG:

  • populate_full_hierarchies — Accepts a certification identifier and returns the standard concurrent-program interface parameters (x_errbuf and x_retcode), which signals that it is designed to run as a concurrent program entry point. It constructs or refreshes the complete hierarchy structure used for certification aggregation.
  • populate_org_cert_aggr_rows — Takes a certification identifier and populates the organization certification aggregation rows for that certification. This is the procedure most relevant to the search term the user entered and is the primary row-generation routine for aggregation summaries.
  • update_org_cert_aggr_rows — Takes both a certification identifier and an organization identifier, updating the aggregation rows for the specified organization within the given certification. This granular procedure allows targeted recalculation instead of a full rebuild.

Tables Accessed

The package interacts with the following APPS-synonymed tables:

Usage Notes

Because populate_full_hierarchies follows the FND concurrent program convention (x_errbuf and x_retcode OUT NOCOPY parameters), it is typically invoked as a concurrent program from the Oracle EBS request submission interface or via FND_REQUEST.SUBMIT_REQUEST. The other two procedures are more likely called from within the referencing package or from custom PL/SQL that orchestrates certification processing. In 12.1.1 and 12.2.2 the package continues to reside in the APPS schema, and the ONLINE/USER calling context reflects standard EBS database conventions. Developers integrating with this package should note its AUTHID CURRENT_USER behavior, execute only within a properly authenticated EBS session, and avoid modifying the aggregation tables directly.