Search Results amv_category_pvt




Overview
Explore in AI Chat

Overview

AMV_CATEGORY_PVT is a private PL/SQL package in the APPS schema that encapsulates the core business logic for maintaining and querying category definitions within the Oracle E-Business Suite AMV (Content/Digital Asset Management) module. In this context, a "category" is a curated grouping of items, similar in purpose to a folder or taxonomy node, used to organize content, digital assets, and channel-specific merchandise. The "PVT" suffix designates the package as a private implementation layer: it contains the procedural engine invoked by the corresponding public wrapper packages and view objects, rather than an API intended to be called directly by external applications.

The package operates against the AMV_C_* family of tables, which form the AMV content-management schema. It provides the transactional operations — creating, updating, deleting, sorting, and reordering categories — together with the read operations used to enumerate channels, items, and hierarchical relationships. Because it depends on FND_API and AMV_UTILITY_PVT, it conforms to the standard Oracle Application Object Library conventions for error handling and message capture. ETRM documents the object as VALID and classifies its API style as PVT, confirming its role as an internal service component rather than a published integration interface.

Key Procedures and Functions

The documented interface comprises fifteen procedures and functions, grouped by purpose:

Parameter lists are not published in the ETRM excerpt; callers should inspect the package specification in the database for exact signatures.

Tables Accessed

The package reads and writes the principal AMV category tables through APPS synonyms. AMV_C_CATEGORIES_B and AMV_C_CATEGORIES_TL hold the base and translated category definitions; AMV_C_CATEGORIES_B_S supports the sequence used to generate category identifiers. AMV_C_CHANNELS_B and AMV_C_CHANNELS_TL provide channel definitions relevant to channel-scoped hierarchy and enumeration calls. AMV_C_CHL_ITEM_MATCH, AMV_C_CHL_PERSPECTIVES, AMV_C_CONTENT_TYPES, AMV_C_ITEM_TYPES, and AMV_C_KEYWORDS support item and content-type matching, channel perspectives, and keyword tagging. AMV_C_AUTHORS holds authorship data. AMV_U_ACCESS and AMV_U_MY_CHANNELS apply user-level access control and personal channel context. DUAL is used for single-row evaluations, and PLITBLM supports PL/SQL index-by table operations.

Usage Notes

AMV_CATEGORY_PVT is invoked indirectly. The documented dependency list shows that it is referenced by the public packages AMV_CATEGORY_GRP and AMV_CATEGORY_GRP_W and by the private/view counterparts AMV_CATEGORY_PVT_W, and that AMV_SEARCH_PVT and IBU_MES_BIN also call into it. In total five other packages reference the object. Practically, this means categories are created, updated, and reordered through the AMV administrative UI or through the public GRP wrapper rather than by calling the PVT procedures directly. Concurrent programs and custom extensions should likewise target the public layer to preserve the private contract. Because the package manipulates base and translated tables together, callers must be mindful of language and translation handling. Direct invocation is discouraged and may be unsupported across EBS 12.1.1 and 12.2.2 releases.