Search Results sort_category

Overview

AMV_CATEGORY_GRP is a private PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified as a GRP (group) API. Its purpose is to manage the channel category hierarchy used by Oracle Channel Manager and related interaction-center and e-commerce modules. The header comment in the source identifies the file as amvgcatb.pls (revision 120.1, dated 2005/06/21) and records that the package was originally created in December 1999. The package exposes a set of programmatic interfaces for creating, updating, deleting, and repositioning (sub)categories, and for querying the category hierarchy and the relationships between categories, channels, and items. It relies on the standard Oracle EBS PL/SQL API conventions, including an API version parameter, initialization of the message list, commit control, validation level, and the standard x_return_status, x_msg_count, and x_msg_data out parameters.

Key Procedures and Functions

ETRM documents fourteen callable units within this package body. They fall into three functional groups:

• Category maintenance: ADD_CATEGORY creates a new (sub)category with a unique name, optional description, required parent category, and an optional ordering value. UPDATE_CATEGORY modifies an existing category. DELETE_CATEGORY removes a category. REORDER_CATEGORY and SORT_CATEGORY change the sequence in which categories are presented or stored; SORT_CATEGORY is the entry point referenced by the search term "sort_category" and is the routine used to apply or recompute display ordering across sibling categories.
• Hierarchy and parent management: ADD_CATEGORYPARENT and REMOVE_CATEGORYPARENT maintain parent-child associations between categories. GET_CATPARENTSHIERARCHY, GET_CATCHILDRENHIERARCHY, and GET_CHNCATEGORYHIERARCHY return hierarchical views of a category's ancestors, descendants, and its channel-to-category structure, respectively.
• Query and lookup: FIND_CATEGORIES supports search over the category set. FETCH_CATEGORYID resolves a category identifier from supplied key values. GET_CHANNELSPERCATEGORY returns the channels associated with a given category, while GET_ITEMSPERCATEGORY returns the items assigned to a category.

No parameter lists are reproduced here; the package follows the documented EBS API parameter signature pattern described in the source comments for Add_Category.

Tables Accessed

The ETRM metadata for this object does not enumerate underlying tables, and the excerpt provided does not include the body's SQL. Based on the functional scope of the procedures above, the package operates on the channel category entities and their intersection tables — category definitions, category-parent relationships, channel-to-category assignments, and item-to-category assignments — accessed through APPS synonyms. Because the package is classified as a GRP API, direct table access is encapsulated so that callers interact only through the documented procedures rather than manipulating the base tables directly.

Usage Notes

As a GRP-classified group API, AMV_CATEGORY_GRP is not intended for direct end-user invocation. It is called by Oracle Channel Manager forms and by other PL/SQL packages; ETRM records that at least two other packages reference it. Typical invocation patterns include category maintenance screens within the interaction center or channel manager UI, concurrent programs that rebuild or sort category ordering (the SORT_CATEGORY path), and custom extensions that need to create or query channel categories programmatically. Because the procedures accept p_api_version, p_init_msg_list, p_commit, and p_validation_level, callers should pass FND_API constants, inspect x_return_status for FND_API.G_RET_STS_SUCCESS or error, and read the message stack via x_msg_count and x_msg_data. The package is available in both Oracle EBS 12.1.1 and 12.2.2; the 12.2.x online patching model does not alter its calling contract.