Search Results amv_category_grp_w




Overview
Explore in AI Chat

Overview

AMV_CATEGORY_GRP_W is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It is classified as an "OTHER" API in the ETRM metadata and forms part of the Oracle Marketing and Advanced Product Catalog foundation layer, operating alongside the AMV_CATEGORY_GRP specification and the AMV_CATEGORY_PVT and AMV_CATEGORY_PVT_W private packages. In 12.1.1 and 12.2.2, this package exposes category grouping and category hierarchy services that support the presentation and navigation of product categories within EBS applications and self-service storefronts. It encapsulates lookups for category parents, category children, channel-to-category relationships, and item counts per category, allowing calling forms and concurrent programs to obtain hierarchical category data without issuing direct SQL against the underlying AMS and MTL category tables.

Key Procedures and Functions

The ETRM documentation records seven callable program units within the package body:

  • REORDER_CATEGORY — Maintains the display or sort sequence of categories, allowing the relative ordering of categories within a group to be updated.
  • FIND_CATEGORIES — Locates and returns categories matching supplied search criteria; it is the primary entry point for category lookup and selection logic.
  • GET_CHANNELSPERCATEGORY — Returns the channels associated with a given category, supporting channel-based merchandising and catalog publication.
  • GET_CATPARENTSHIERARCHY — Retrieves the parent hierarchy for a category, walking upward through the category structure.
  • GET_CATCHILDRENHIERARCHY — Retrieves the child hierarchy beneath a category, walking downward through the category structure.
  • GET_CHNCATEGORYHIERARCHY — Returns the channel-to-category hierarchy, combining channel assignment with category structure for storefront navigation.
  • GET_ITEMSPERCATEGORY — Returns the items assigned to a category, underpinning category-based item browse and drill-down behavior.

Parameter signatures are not documented in the ETRM extract and should not be assumed; the package uses the JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_300, and JTF_VARCHAR2_TABLE_2000 collection types, indicating that these routines accept or return PL/SQL table structures for multi-value inputs and results.

Tables Accessed

The ETRM metadata does not enumerate the base tables referenced by AMV_CATEGORY_GRP_W. Its declared dependencies are limited to the AMV_CATEGORY_GRP specification, AMV_CATEGORY_GRP_W itself, AMV_CATEGORY_PVT, AMV_CATEGORY_PVT_W, FND_API, the JTF collection types, and the SYS STANDARD package. Consistent with its documented procedures, the package indirectly reads and writes category definitions, category group and hierarchy relationships, channel assignments, and item-to-category associations managed by the AMV private packages. No tables are documented as being written directly by this wrapper layer.

Usage Notes

AMV_CATEGORY_GRP_W is a wrapper package: it is not referenced by any other database object, so it is invoked at the top of the call stack rather than being called internally by other PL/SQL units. It is typically executed from Oracle Marketing and iStore / Advanced Product Catalog forms and from Java or JSP storefront components that need to render category navigational trees, resolve channel-specific category hierarchies, or count items in a category. Customizations should call the public routines listed above rather than the private AMV_CATEGORY_PVT layer, since the wrapper isolates callers from changes in the private implementation. Because the package returns JTF collection types, consumers must be prepared to handle nested table or index-by table results rather than scalar values. As with all APPS schema objects, modifications should be confined to the supported API surface and validated against both 12.1.1 and 12.2.2 environments, as the underlying category data model is shared across these releases.