Search Results amw_assessment_components_s

Overview

The APPS.AMW_COMPONENTS_PKG package body is a component of the Oracle Enterprise Asset Management (EAM) assessment framework delivered within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Its principal business function is to evaluate and persist the "components" that make up an assessment record, as stored in the AMW_ASSESSMENT_COMPONENTS and AMW_ASSESSMENT_COMPONENTS_S tables. In practice, the package determines whether components exist for a given assessment or component context and then carries out the processing work needed to create, update, or reconcile those component rows. It therefore underpins the assessment functionality used by EAM and related maintenance workflows, where assessments describe the condition, scoring, or configuration of assets and their associated elements.

The package is owned by the APPS schema and is documented as VALID. It is classified under ETRM with an API classification of OTHER, meaning it is an internal utility package rather than a formally published public API. The package body references the specification AMW_COMPONENTS_PKG and relies on standard Oracle EBS infrastructure packages, including FND_API, FND_GLOBAL, FND_LOOKUPS, and FND_MSG_PUB, which is consistent with an API-style implementation that uses the common message stack, application context, and lookup conventions.

Key Procedures and Functions

Three documented procedures or functions constitute the public surface of this package:

• COMPONENTS_PRESENT — Determines whether components exist for the assessment context in question. This is typically a Boolean-style check that returns a status indicating the presence or absence of component data in AMW_ASSESSMENT_COMPONENTS. It allows calling code to branch on whether component processing is required before performing potentially expensive operations.
• NEW_COMPONENTS_PRESENT — Evaluates whether newly added or unprocessed components are present. Unlike the general presence check, this procedure focuses on components that have not yet been handled, enabling callers to detect incremental changes and avoid redundant reprocessing of components already dealt with.
• PROCESS_COMPONENTS — Performs the substantive processing of assessment components. It is the workhorse routine that reads component data, applies the required business rules, and writes or maintains rows in AMW_ASSESSMENT_COMPONENTS and its _S (sequence/surrogate key) companion table. It may raise or handle errors through FND_MSG_PUB.

Tables Accessed

The package references the following tables through APPS synonyms:

• AMW_ASSESSMENT_COMPONENTS — The primary transactional table holding assessment component records. The package reads from and writes to it to determine component presence and to persist processing results.
• AMW_ASSESSMENT_COMPONENTS_S — The sequence/surrogate-key companion table used to obtain and coordinate unique identifiers for new component rows. This is the table users encounter when searching for "amw_assessment_components_s".
• DUAL — Used for lightweight single-row queries, such as invoking FND_GLOBAL or FND_LOOKUPS functions and validating runtime context.

Usage Notes

As an internal EAM utility package, AMW_COMPONENTS_PKG is not referenced by any other database object according to the documented dependency metadata.