Search Results is_supported_by_cz

Overview

APPS.CZ_APC_GRP is a helper package body in the Oracle E-Business Suite (12.1.1 and 12.2.2) that supports the Configuration Workbench / Advanced Product Catalog attribute population logic associated with the CZ (Customization) application, whose application ID is 708. The package carries the header czapcgb.pls 120.0, dated 2005, indicating it belongs to an older generation of EBS code that remains present in the 12.x code lines. Its central role is to determine whether a given EGO (Oracle Product Information Management) extensibility attribute usage is eligible to be processed by the CZ attribute power-copy (APC) mechanism.

The package declares constants that anchor its logic to two EBS applications — CZ (CZ_APPLICATION_ID := 708) and EGO (EGO_APPLICATION_ID := 431) — along with data-type codes (DECIMAL_TYPE := 2, TEXT_TYPE := 4, TL_TEXT_TYPE := 8), a batch size of 10,000, and several collection types used for bulk processing of attribute values. This design reflects an extensibility filter that restricts processing to item-management attribute groups only.

Key Procedures and Functions

The documented interface exposes a single function:

• IS_SUPPORTED_BY_CZ — a boolean predicate that accepts one attribute usage metadata record and returns whether that attribute is supported by the CZ processing logic. It enforces four exclusion rules: the attribute must belong to EGO application 431 (item attributes only); it must not be a multi-row attribute group (is_multi_row = 'Y'); its attribute group type must equal EGO_ITEMMGMT_GROUP (user-defined attribute groups only); and its data type must not be a date or date/time type. Any attribute failing one of these conditions returns FALSE; all others return TRUE.

The function therefore acts as a guard or gatekeeper, invoked before the package performs any CZ-specific attribute processing, ensuring that date values, non-item attributes, and multi-row groups — which the CZ mechanism cannot handle — are excluded at the outset.

Tables Accessed

The package body as documented does not reference any base tables through APPS synonyms. It operates entirely on the EGO_EXT_FWK_PUB.EGO_ATTR_USG_METADATA record type passed in as a parameter, together with the package-level constants and collection types declared within the package. Because the metadata and attribute group checks are performed against the supplied record rather than against database tables, no SELECT, INSERT, UPDATE, or DELETE operations are attributed to this object in the ETRM documentation. The absence of table references is consistent with a purely evaluative package whose inputs are supplied by a calling program.

Usage Notes

CZ_APC_GRP.IS_SUPPORTED_BY_CZ is typically invoked from PL/SQL code or Oracle Forms logic that iterates over EGO extensibility attribute usages — for example, during setup of item attribute groups, attribute population, or configuration-related processing. A caller fetches the relevant EGO_ATTR_USG_METADATA record and passes it to the function; the boolean result determines whether the attribute is included in CZ processing. Because the documented dependency list shows zero other packages referencing this object, it is likely called by forms-level triggers, concurrent program PL/SQL, or custom extensions rather than by core CZ processing routines. Implementers extending item attribute behavior should treat this function as the authoritative filter for CZ-supported attributes and must honor its constraints — item (EGO application 431) attributes only, EGO_ITEMMGMT_GROUP groups only, no multi-row groups, and no date or date/time data types.