Search Results update_org_cert_aggr_rows

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:

• AMW_EXECUTION_SCOPE — Defines the scope of entities over which certification evaluation is executed.
• AMW_FULL_ENTITY_HIER and AMW_FULL_ENTITY_HIER_S — Store the full entity hierarchy and its corresponding sequence/identifier table, used by populate_full_hierarchies.
• AMW_ORG_CERT_AGGR_SUM and AMW_ORG_CERT_AGGR_SUM_S — The organization certification aggregation summary tables written by the populate and update routines.
• AMW_ORG_CERT_EVAL_SUM — Provides the underlying evaluation summary data that feeds aggregation.
• FND_FLEX_VALUES — Supplies flexfield value validation and descriptive information for key flexfield segments.
• HR_ORGANIZATION_INFORMATION — Supplies organization-level attributes used to classify or group organizations during aggregation.

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.