Search Results amv_category_pvt_w




Overview
Explore in AI Chat

Overview

AMV_CATEGORY_PVT_W is the private wrapper package body for the Oracle E-Business Suite category management API in the Applications (APPS) schema. It belongs to the AMV family of packages that support catalog and category functionality, most commonly associated with Oracle iStore, Oracle Advanced Product Catalog, and the category hierarchy used across selling and merchandising applications. The "_W" suffix denotes a public wrapper that sits on top of the underlying private package AMV_CATEGORY_PVT, delegating the substantive business logic to the private implementation while exposing a stable, callable interface. The dependency list confirms that the body references AMV_CATEGORY_PVT as well as the FND_API foundation package and the standard JTF collection types (JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100 through JTF_VARCHAR2_TABLE_4000), which is characteristic of EBS APIs that follow the standard API programming model using table-based parameter passing for bulk operations.

Key Procedures and Functions

The documented API classification is OTHER, and the package exposes sixteen procedures and functions. The bulk of these are Rosetta table copy utilities, which are internal helper routines used to marshal data between PL/SQL collection types in both directions. They are organized as paired IN and OUT routines across several numbered variants: ROSETTA_TABLE_COPY_IN_P2 and ROSETTA_TABLE_COPY_OUT_P2, ROSETTA_TABLE_COPY_IN_P3 and ROSETTA_TABLE_COPY_OUT_P3, ROSETTA_TABLE_COPY_IN_P7 and ROSETTA_TABLE_COPY_OUT_P7, and ROSETTA_TABLE_COPY_IN_P10 and ROSETTA_TABLE_COPY_OUT_P10. These routines move data into and out of the various JTF_VARCHAR2_TABLE and JTF_NUMBER_TABLE structures, allowing callers to pass differently shaped arrays without rewriting the core logic.

The business-facing entry points include REORDER_CATEGORY, which repositions a category within its hierarchy; FIND_CATEGORIES, which searches for categories matching supplied criteria; GET_CHANNELSPERCATEGORY, which returns the channels assigned to a given category; GET_ITEMSPERCATEGORY, which returns the items associated with a category; and three hierarchy retrieval routines — GET_CATPARENTSHIERARCHY, GET_CATCHILDRENHIERARCHY, and GET_CHNCATEGORYHIERARCHY. The GET_* functions provide read access to the parent, child, and channel-oriented views of the category tree, supporting navigation and display requirements in the calling applications.

Tables Accessed

The only table directly referenced through an APPS synonym is PLITBLM, the standard EBS PL/SQL index-by table used by the Rosetta conversion routines as an intermediate structure. Because this is a private wrapper package, the underlying persistent category, channel, and item tables are accessed by the delegated private package AMV_CATEGORY_PVT rather than directly by this body. The dependency footprint therefore reflects a design in which AMV_CATEGORY_PVT_W is responsible for parameter conversion and interface stability, while the private package owns the SQL against the base category schema.

Usage Notes

AMV_CATEGORY_PVT_W is not intended for direct invocation by end users. It is invoked by the parent package AMV_CATEGORY_PVT and is referenced by one other database object within the EBS codebase. It is typically called from Oracle iStore merchandising flows, category administration forms, and custom extensions that need to search, reorder, or traverse the category hierarchy, including parent and child relationships and channel assignments. The package is valid against both Oracle EBS 12.1.1 and 12.2.2, and custom code should call the public AMV_CATEGORY_PVT wrapper rather than this private body to preserve upgrade compatibility. The Rosetta copy routines should be treated as internal utilities.